SAP Knowledge Base Article - Preview

3531762 - Incorrect SQL query in PO Delete and Archive job

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

SAP NetWeaver 7.5

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.