topic Re: Invalid string or buffer length error when using Access DB in Talend Studio

Invalid string or buffer length error when using Access DB

Anonymous — Mon, 13 Jan 2014 20:34:52 GMT

Talend Platform for Data Management 5.4.1
Java
Access 2010
Hi,
I'm receiving the following error when I attempt to output to an access database (and it occurs periodically when I attempt to read from an Access database.
Exception in component tAccessOutput_1
java.sql.SQLException: Invalid string or buffer length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(Unknown Source)
at redcap_integration.pedsql_0_1.PedSql.tAccessInput_1Process(PedSql.java:2025)
at redcap_integration.pedsql_0_1.PedSql.tOracleInput_1Process(PedSql.java:4624)
at redcap_integration.pedsql_0_1.PedSql.runJobInTOS(PedSql.java:4890)
at redcap_integration.pedsql_0_1.PedSql.main(PedSql.java:4713)
The error is not consistent. Any help would be greatly appreciated.

Re: Invalid string or buffer length error when using Access DB

Anonymous — Tue, 14 Jan 2014 02:13:28 GMT

Hi,
What's your OS version 64 bit/32 bit? And your odbc driver?
Best regards
Sabrina

Re: Invalid string or buffer length error when using Access DB

Anonymous — Wed, 15 Jan 2014 20:52:45 GMT

I'm using Windows 7 64 bit with the 64-bit driver (%systemdrive%\Windows\System32\odbcad32.exe) according to Microsoft (see http://support.microsoft.com/kb/2721825/EN-US ).

Re: Invalid string or buffer length error when using Access DB

Anonymous — Mon, 20 Jan 2014 07:31:14 GMT

Hi,
Could you open a ticket on Talend Support Portal so that our colleagues from support team can give you a remote assistance so see if it is a bug.
Best regards
Sabrina

Re: Invalid string or buffer length error when using Access DB

Anonymous — Tue, 05 Aug 2014 13:48:19 GMT

I am interested in the resolution of this issue. I am experiencing the same issue. The job will error out in TAC but when I run in TIS, even on the same box, it runs fine. Rerun in TAC and it might run, might error.

Re: Invalid string or buffer length error when using Access DB

Anonymous — Wed, 06 Aug 2014 09:28:13 GMT

Hi,
Can you allocate more memory for one job to see if it is OK with you? You can modify it in TAC->Job Conductor->JVM parameters.
Best regards
Sabrina

Re: Invalid string or buffer length error when using Access DB

Anonymous — Thu, 07 Aug 2014 13:23:38 GMT

I have never done that but am able to navigate there in TAC. What does the JVM entry look like?
Thank you in advance for any help.
Amy

Re: Invalid string or buffer length error when using Access DB

Anonymous — Thu, 07 Aug 2014 13:44:15 GMT

I was able to search and find what I think was the entries I needed. The job still fails in TAC, but not TIS. I will attach a screen shot of the entries I created. I am not sure what each is doing as I do not know Java but based on what I saw on the Talend page I found, I think I did it right?

Re: Invalid string or buffer length error when using Access DB

Anonymous — Thu, 07 Aug 2014 14:20:06 GMT

I tried larger values too. Same result. I can run the job in TIS on that same server without issue. It's just when run in TAC that it is inconsistent. Sometimes it works, sometimes it does not. Here is my last attempt.

Re: Invalid string or buffer length error when using Access DB

Anonymous — Fri, 08 Aug 2014 04:37:18 GMT

Hi,

We would suggest you to connect to the Support portal: https://support.talend.com/otrs/customer.pl and log your request, so that we treat it with priority, through the support cycle.

Best regards
Sabrina