After figuring out how to install the tInfobrightOutput component and remote capability java program (infobright-core-3.0-remote.jar) in both TOS client and Infobright server, we created a very small job just to make sure that it works.  The job involves loading a dimension table of fiscal years from Oracle to a MySQL-Brighthouse table.  I will attach screenshots of the job.

Here is what TOS results in after running the job:
<<<<<<<<<<<<<<<<<
Starting job test at 19:41 08/04/2010.

[statistics] connecting to socket on port 3569
[statistics] connected
Exception in component tInfobrightOutput_2
java.net.ConnectException: Connection timed out: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:525)
    at java.net.Socket.connect(Socket.java:475)
    at java.net.Socket.<init>(Socket.java:372)
    at java.net.Socket.<init>(Socket.java:186)
    at com.infobright.io.ClientProxy.<init>(ClientProxy.java:55)
    at com.infobright.io.InfobrightNamedPipeLoader.<init>(InfobrightNamedPipeLoader.java:132)
    at infobrighttestproject.test_0_1.test.tOracleInput_1Process(test.java:1012)
    at infobrighttestproject.test_0_1.test.runJobInTOS(test.java:1802)
    at infobrighttestproject.test_0_1.test.main(test.java:1696)
[statistics] disconnected
Job test ended at 19:41 08/04/2010. [exit code=1]
>>>>>>>>>>>>>>>>>>>>>>>

Here are the relevant entries in the infobright/data/general_query.log:
<<<<<<<<<<<<<<<<<<<<<<<<<<
100408 18:41:15   60 Query    SET character_set_results = NULL
           60 Query    SET autocommit=1
           60 Query    SET sql_mode='STRICT_TRANS_TABLES'
           60 Query    SET autocommit=0
           60 Query    SHOW FULL TABLES FROM `lmdprototype_production` LIKE '%'
           60 Query    DROP TABLE `lmd_years`
           60 Query    CREATE TABLE `lmd_years`(`id` INT(10)  ,`fiscal_year` INT(10)  ,`fiscal_year_start_date` DATE ,`fiscal_year_end_date` DATE ,`plan_start_year` INT(10)  ,`plan_end_year` INT(10)  ) engine=brighthouse
>>>>>>>>>>>>>>>>>>>>>>>>>>

Can anyone help diagnose what we are doing wrong or what is causing the timeout?

Thanks.

Edmund

Last edited by evdios (2010-04-09 02:06:34)