rvalyi/ooor — Issue #80: socket connection closes when creating products or other entities in openerp
Author: kredl
Created: 2012-01-27 15:12:24+00:00
State: open

When trying to create a large number of data of a certain entity for example products... in openerp , (im testing it with more than 1000 row lines....)

Row script code example in ruby scripting

ProductProduct.create(:default_code => $row["ItemCode"],
:name => $row["Description"],
:sale_ok=> true,# $row["IsSalesItem"] ,
:purchase_ok=> true, # $row["IsPurchaseItem"] ,
:weight_net => $row["NetWeight"] ,
:type => "product",
:procure_method=>"make_to_order",
:supply_method=>"buy",
:weight_net=> $row["NetWeight"],
:state=>"sellable",
:uom_id=> uom_id,
:uom_po_id=> uom_id,
:uos_id=> uom_id,
:standard_price => $row["CostPriceStandard"],
:volume=> $row["VOLUME"],
:track_incoming => true, # $row["Lote"],
:track_outgoing => true, #$row["Lote"],
:cost_method => "average",
:categ_id => categ_id,
:categ_ids => categorias,
:taxes_id => tax_id
)

Ketle OOOR connector gives me an error:

unexpected error

org.pentaho.di.core.exception.KettleException:
org.jruby.embed.EvalFailedException: (SocketError) Address already in use: no further information
(SocketError) Address already in use: no further information

at org.typeexit.kettle.plugin.steps.ruby.execmodels.SimpleExecutionModel.onProcessRow(SimpleExecutionModel.java:575)
at org.typeexit.kettle.plugin.steps.ruby.RubyStep.processRow(RubyStep.java:32)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Unknown Source)
Caused by: org.jruby.embed.EvalFailedException: (SocketError) Address already in use: no further information
at org.jruby.embed.internal.EmbedEvalUnitImpl.run(EmbedEvalUnitImpl.java:127)
at org.typeexit.kettle.plugin.steps.ruby.execmodels.SimpleExecutionModel.onProcessRow(SimpleExecutionModel.java:518)
... 3 more
Caused by: org.jruby.exceptions.RaiseException: (SocketError) Address already in use: no further information

however if i add to the row line script a sleet(1) for example... so delaying to processing.. the error will not appear...
what can be the cause of this?

xml rpc of openerp cant handle so manny requests???

thano you for your help

Kind regards
Ricardo