You are not logged in.
I have successfully built and ran a sync job in the TOS designer. After exporting the job to run via the .BAT I get the error shown on the screen shot. It appears to be because of the ODBC connection to MS SQL. I have not been able to get the native MS SQL connection to work properly but ODBC works fine in the TOS designer.
The error indicates some insert data may be longer than the length of field you defined.
Where do you deploy this job? In the same machine where TOS installed?
Yes this export job is running on the same machine that is was created and ran in the interface from.
When running from the interface there is no errors and the job runs perfectly.
any thoughts on where I should start trouble shooting?
Presumably your system is 64-bit? Have you installed both 32-bit and 64-bit Java? Which Talend studio are you running? Which Java are you running in the exported job (go to command line and type "java -version")? Have you created your DSN under 32-bit or 64-bit?
Basically, make sure all are using the same.
I have tried to use JDBC for my connection, but it is not working. I get the error "Connection failure. You must change the Database Settings.
Impossible to initialize the connection !"
Note: Trying to connect to SQL Azure.
The ODBC connection works fine within talend and I am able to run the job just fine. The error is just when it is exported and tried to run. I am on a 64-bit machine. Using 64-bit Java, running Talend 5.1.1. I have tried creating DSN's in both 32-bit and 64-bit with no success. Getting the Invalid string or buffer length error.
I'm having the same problem.
I am using generic jdbc connections for database connectivity. The job runs fine in Talend Studio but doesn't run when exported.
java - version gives me:
java version "1.6.0_31"
Java(TM) SE Runtime Environment (build 1.6.0_31-b05)
Java HotSpot(TM) Client VM (build 20.6-b01, mixed mode, sharing)
I'm running TOS DI 5.1.1 on Windows server standard SP2.
OS is 4 bit.
Last edited by jesa_l (2012-09-10 05:23:09)