Hello, i tried to perform some insert within ICE in Java using the lib infobright-core-3.4.jar and the related windows dll.
Everything works fine, but for some reason, i tried the same on an other system and it did not work.
On both systems, ICE is installed in localhost, the DB agent is running.
Here is the Java error that occured on second system :
INFO: Thu Feb 16 09:38:58 CET 2012: Column: customernumber INT(11)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: customername VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: contactlastname VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: contactfirstname VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: phone VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: addressline VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: city VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: state VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: postalcode VARCHAR(15)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: country VARCHAR(50)
INFO: Thu Feb 16 09:38:58 CET 2012: Column: salesrepemployeenumber INT(11)
DEBUG: Thu Feb 16 09:38:58 CET 2012: exec sql: set @bh_dataformat=‘txt_variable’
;
DEBUG: Thu Feb 16 09:38:58 CET 2012: exec sql: set @bh_pipemode=‘server’;
DEBUG: Thu Feb 16 09:38:58 CET 2012: exec sql: set @bh_timeout=15;
DEBUG: Thu Feb 16 09:38:58 CET 2012: ID#0 starting TXT_VARIABLE load thread via
named pipe bhnamedpipe_09_38_58_344-0
DEBUG: Thu Feb 16 09:38:58 CET 2012: ID#0 executing sql: load data infile ‘\\\\.
\\pipe\\bhnamedpipe_09_38_58_344-0’ into table pbe_cust fields terminated by ‘,’
optionally enclosed by ‘“’ escaped by ‘\\’ lines terminated by ‘
‘;
DEBUG: Thu Feb 16 09:38:58 CET 2012: SQL load started in 203 ms
DEBUG: Thu Feb 16 09:38:58 CET 2012: creating named pipe client “bhnamedpipe_09_
38_58_344-0”
ERROR - new InfoBrightInjector error when starting pipeLoaded
java.io.IOException: Could not open client pipe for writing: AccÞs refusÚ.
: Confirm that table engine=brighthouse!!!
at com.infobright.io.WindowsNamedPipe.clientCreate(Native Method)
at com.infobright.io.WindowsNamedPipe.<init>(WindowsNamedPipe.java:89)
at com.infobright.io.NamedPipeFactory$WindowsHelper.createClientPipe(Nam
edPipeFactory.java:91)
at com.infobright.io.NamedPipeFactory.createClient(NamedPipeFactory.java
:120)
at com.infobright.io.NamedPipeOutputStream.<init>(NamedPipeOutputStream.
java:66)
at com.infobright.io.WindowsPipeCallStrategy.afterExecuteCreate(WindowsP
ipeCallStrategy.java:81)
at com.infobright.io.InfobrightNamedPipeLoader.start(InfobrightNamedPipe
Loader.java:465)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.createJdbc
Resources(RunInfobright.java:38)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.init(RunIn
fobright.java:59)
at bpm.gateway.runtime2.RuntimeEngine$RuntimeThread.run(RuntimeEngine.ja
va:242)
java.io.IOException: Could not open client pipe for writing: AccÞs refusÚ.
: Confirm that table engine=brighthouse!!!
at com.infobright.io.WindowsNamedPipe.clientCreate(Native Method)
at com.infobright.io.WindowsNamedPipe.<init>(WindowsNamedPipe.java:89)
at com.infobright.io.NamedPipeFactory$WindowsHelper.createClientPipe(Nam
edPipeFactory.java:91)
at com.infobright.io.NamedPipeFactory.createClient(NamedPipeFactory.java
:120)
at com.infobright.io.NamedPipeOutputStream.<init>(NamedPipeOutputStream.
java:66)
at com.infobright.io.WindowsPipeCallStrategy.afterExecuteCreate(WindowsP
ipeCallStrategy.java:81)
at com.infobright.io.InfobrightNamedPipeLoader.start(InfobrightNamedPipe
Loader.java:465)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.createJdbc
Resources(RunInfobright.java:38)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.init(RunIn
fobright.java:59)
at bpm.gateway.runtime2.RuntimeEngine$RuntimeThread.run(RuntimeEngine.ja
va:242)
ERROR - error during initing new InfoBrightInjector
java.io.IOException: Could not open client pipe for writing: AccÞs refusÚ.
: Confirm that table engine=brighthouse!!!
at com.infobright.io.WindowsNamedPipe.clientCreate(Native Method)
at com.infobright.io.WindowsNamedPipe.<init>(WindowsNamedPipe.java:89)
at com.infobright.io.NamedPipeFactory$WindowsHelper.createClientPipe(Nam
edPipeFactory.java:91)
at com.infobright.io.NamedPipeFactory.createClient(NamedPipeFactory.java
:120)
at com.infobright.io.NamedPipeOutputStream.<init>(NamedPipeOutputStream.
java:66)
at com.infobright.io.WindowsPipeCallStrategy.afterExecuteCreate(WindowsP
ipeCallStrategy.java:81)
at com.infobright.io.InfobrightNamedPipeLoader.start(InfobrightNamedPipe
Loader.java:465)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.createJdbc
Resources(RunInfobright.java:38)
at bpm.gateway.runtime2.transformations.outputs.RunInfobright.init(RunIn
fobright.java:59)
at bpm.gateway.runtime2.RuntimeEngine$RuntimeThread.run(RuntimeEngine.ja
va:242)
For the records, i checked the DB engine used for the table, and it is BRIGHTHOUSE.
I just cannot figure out where the issue come from.
Does someone have any idea about this?
Regards
