Problems with tInfobrightOutput

One Star

Problems with tInfobrightOutput

Hello all,i really need your help, i download the component tInfobrightOutput for TOS, and i try to upload data from a csv file to my table in MySql (of course using brighthouse as engine) and i have an error.

table script:
DROP TABLE IF EXISTS `test1`.`customer`;
CREATE TABLE `test1`.`customer` (
`id_c` int(11) DEFAULT NULL,
`name` varchar(20) COLLATE latin1_bin DEFAULT NULL,
`lname` varchar(20) COLLATE latin1_bin DEFAULT NULL,
`address` varchar(200) COLLATE latin1_bin DEFAULT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

CSV file structure :
id_c;name;lname;address

I'm using:
ICE 3.5.2.0
TOS 4.1.0
connector for talend : infobright-core-v3.4

Error in TOS:
connecting to socket on port 3859
connected
Contents of columnList: <IMetadataColumn>:
original col name: id_c
column type: INT
Talend type: id_Integer
Mapped: INT
original col name: name
column type: VARCHAR
Talend type: id_String
Mapped: VARCHAR
original col name: lname
column type: VARCHAR
Talend type: id_String
Mapped: VARCHAR
original col name: address
column type: VARCHAR
Talend type: id_String
Mapped: VARCHAR
Contents of stmtStructure: <Column>
col name: id_c
data type: null
col name: name
data type: null
col name: lname
data type: null
col name: address
data type: null
Create SQL = CREATE TABLE `customer`(`id_c` INT(0) ,`name` VARCHAR(0) ,`lname` VARCHAR(0) ,`address` VARCHAR(0)
INFO: Tue Feb 15 15:46:52 CET 2011: Column: id_c INT(11)
INFO: Tue Feb 15 15:46:52 CET 2011: Column: name VARCHAR(20)
INFO: Tue Feb 15 15:46:52 CET 2011: Column: lname VARCHAR(20)
INFO: Tue Feb 15 15:46:52 CET 2011: Column: address VARCHAR(200)
DEBUG: Tue Feb 15 15:46:52 CET 2011: exec sql: set @bh_dataformat='txt_variable';
DEBUG: Tue Feb 15 15:46:52 CET 2011: exec sql: set @bh_pipemode='server';
DEBUG: Tue Feb 15 15:46:52 CET 2011: exec sql: set @bh_timeout=30;
DEBUG: Tue Feb 15 15:46:52 CET 2011: ID#0 starting TXT_VARIABLE load thread via named pipe bhnamedpipe_15_46_52_776-0
DEBUG: Tue Feb 15 15:46:52 CET 2011: ID#0 executing sql: load data infile '\\\\.\\pipe\\bhnamedpipe_15_46_52_776-0' into table customer fields terminated by ',' optionally enclosed by '"' escaped by '\\' lines terminated by '
';
DEBUG: Tue Feb 15 15:46:53 CET 2011: SQL load started in 239 ms
DEBUG: Tue Feb 15 15:46:53 CET 2011: creating named pipe client "bhnamedpipe_15_46_52_776-0"
Exception in component tInfobrightOutput_1
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(NamedPipeFactory.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(WindowsPipeCallStrategy.java:81)
at com.infobright.io.InfobrightNamedPipeLoader.start(InfobrightNamedPipeLoader.java:465)
at test.toto_0_1.toto.tFileInputDelimited_1Process(toto.java:574)
at test.toto_0_1.toto.runJobInTOS(toto.java:1000)
at test.toto_0_1.toto.main(toto.java:871)
disconnected
DEBUG: Tue Feb 15 15:46:55 CET 2011: ID#0 SQL statement cancelled

I load data from my csv file with infobright command line and it's work but i can not doing with Talend component.
Any help ?
tks a lot.
One Star

Re: Problems with tInfobrightOutput

Hi smt09,
I assume you're loading this data onto a local Infobright server. Is this accurate?
If you're running remotely, then you'll need to setup the pipe to accept connections. There are instructions in the README.txt file for the Infobright connector.
Let me know if this doesn't work -- jeff@infobright.com.
Jeff