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.