SAP Knowledge Base Article - Preview

2591691 - SAP MEINT Scheduled Job QueueMessageCleaner fails

Symptom

SAP Manufacturing Execution Integration (MEINT) scheduled job QueueMessageCleaner fails with errors like:

  • Error processing command for template Visiprise/ERPShopFloorIntegration/MessagePurging/DELETE_REQ_FILE_CMD
  • Error in command: DELETE FROM SAPMEINT_FILES WHERE  ID IN ( SELECT REQ_FILE_CONTENT_ID FROM SAPMEINT_MESSAGE_QUEUE WHERE RECEIVED_DATE_TIME <= TO_DATE('2017-12-01 01:00:00','MM/DD/YYYY HH24:MI:SS') AND  STATUS NOT IN ('QUEUED', 'RETRY', 'IN_CORRELATION'))
  • SQL error during query [303]: invalid DATE, TIME or TIMESTAMP value: Error while parsing '2017-12-01 01:00:00' in format 'MM/DD/YYYY HH24:MI:SS' as DATE/TIME at function to_date() (at pos 125)  
    OpenSQLExceptionCategories: [NON_TRANSIENT, DATA].


Read more...

Environment

SAP Manufacturing Execution Integration (MEINT), SAP Manufacturing Execution (ME), SAP Manufacturing Integration and Intelligence (MII)

Product

SAP Manufacturing Execution 15.0 ; SAP Manufacturing Execution 15.1 ; SAP Manufacturing Execution 6.1 ; SAP Manufacturing Integration and Intelligence 14.0 ; SAP Manufacturing Integration and Intelligence 15.0 ; SAP Manufacturing Integration and Intelligence 15.1

Keywords

KBA , MFG-ME-INT , Integration , 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.