Proxy to JDBC scenario....enexpected behaviour...while inserting into table...

[Former Member]

HI

I am working on Proxy to JDBC scenario........

All the objects are created....but sometimes it looks like it is success and sometimes it is failing saying as below.....

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','.  The correct syntax is: INSERT INTO tablename [(column {, ... })]   [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })]     [OVERRIDING {SYSTEM | USER} VALUE] subselect

Error when executing statement for table/stored proc. MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','.  The correct syntax is: INSERT INTO tablename [(column {, ... })]   [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })]     [OVERRIDING {SYSTEM | USER} VALUE] subselect

Error processing request in sax parser: Error when executing statement for table/stored proc. 'MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','.  The correct syntax is: INSERT INTO tablename [(column {, ... })]   [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })]     [OVERRIDING {SYSTEM | USER} VALUE] subselect

Do we need to take care any Database table level tuning activities like index......because database level just created a table ...that;s it.

Some times for few records it is working fine.....but some times if we get around 100 rows also it is failing as above.

Please help.......

Thanks

[former_member518917]

On advanced tab set configure the parameter "logSQLStatement" as described on SAP Note [801367|https://service.sap.com/sap/support/notes/801367] ,  with this parameter you would be able to see the sql statement generated by PI in audit log.

[iaki_vila]

Hi Sabu,

Have you checked that INSERT clausule is entire when the INSERT is with a lot of rows?

Enable the audit SQL log: http://saptechnical.com/Tips/XI/SQL/Log.htm

Regards.