Symptom
The background delete/archive jobs are failing in PO.
The below errors can be found in the default traces:
"com.sap.sql.log.OpenSQLException: The SQL statement "SELECT MSG_ID, DIRECTION FROM BC_MSG WHERE (STATUS='DLVD' OR STATUS='FAIL') AND PERSIST_UNTIL < ? AND VERS_WAS_EDITED IS NULL AND SUB_SEQ <> 1 AND NOT ( ( FROM_PARTY_NAME <> ? and FROM_PARTY_NAME <> ? and FROM_SERVICE_NAME <> ? and FROM_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and ACTION_TYPE <> ? and and ACTION_TYPE <> ? and FROM_SERVICE_NAME <> ? and ACTION_TYPE <> ? and FROM_SERVICE_NAME <> ? and FROM_SERVICE_NAME <> ? and FROM_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and TO_SERVICE_NAME <> ? and FROM_SERVICE_NAME <> ? ) )" contains the syntax error[s]: - 1:356 - SQL syntax error: "AND" is a reserved keyword that was not expected here
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.parse(StatementAnalyzerImpl.java:58)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:115)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:92)
at com.sap.sql.jdbc.common.AbstractCommonStatement.parseStatement(AbstractCommonStatement.java:555)
at com.sap.sql.jdbc.common.CommonPooledStatement.<init>(CommonPooledStatement.java:238)
at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(CommonConnectionImpl.java:1659)
..
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:302)
Caused by: com.sap.sql.sqlparser.CommonSQLParserException: - 1:356 - SQL syntax error: "AND" is a reserved keyword that was not expected here
at com.sap.sql.sqlparser.CommonSQLStatement.parse(CommonSQLStatement.java:80)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.parse(StatementAnalyzerImpl.java:53)"
Read more...
Environment
- SAP NetWeaver 7.5
Product
Keywords
Process Integration, PI, Process Orchestration, PO, NetWeaver, XI, AEX, Background Jobs, Archive Job, Delete Job, CommonSQLParserException, rule , KBA , BC-XI-CON-MSG , Messaging System , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview