SAP Knowledge Base Article - Preview

2821028 - Work Manager/Inventory Manager: violation occurred: table name = 'SMP_CLUSTER_CONFIG_PROP', constraint name = 'SMPCLSTRCNFGPROPCMPNNT'

Symptom

  • Agentry Application like Work Manager or Inventory Manager or other custom application
  • Example: We upgraded this SMP sever 3.0 to SP17 and have some failures on transmitting with an Agentry application like SAP Work Manager
    • When we synchronize our devices to get the work orders to execute, everything is going well. We get all the informations needed
    • But when we synchronize back to register informations from the field in our backend, it fails
  • Error:

    ~~~~~~~~~~~~~Start Here~~~~~~~~~~~~~

    07/26/2019 14:26:52, 1, 29, 1, Thr 5016, javax/persistence/RollbackException, javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException

    Internal Exception: java.sql.SQLException: Foreign key constraint violation occurred, dbname = 'XXX', table name = 'SMP_CLUSTER_CONFIG_PROP', constraint name = 'SMPCLSTRCNFGPROPCMPNNT'.

    Error Code: 546
    Call: INSERT INTO SMP_CLUSTER_CONFIG_PROP (PROP_ID, CLUSTER_ID, COMPONENT, CONTEXT, PROP_NAME, PROP_TYPE) VALUES (?, ?, ?, ?, ?, ?)
    bind => [6 parameters bound]

    ~~~~~~~~~~~~~~end~~~~~~~~~~~~~~~~~

  • Special note: The error with SMPCLSTRCNFGPROPCMPNNT may show differently depending on the backend data type - Example Oracle or MSSQLServer.  So one data type may show a different rendition of the error above versus the other database type.

Read more...

Environment

  • SAp Inventory Manager 4.3
  • SAP Work Manager 6.4, 6.5
  • SAP Mobile Platform 3.0 SP17
  • SAP Mobile Platform SDK 3.0 - 70.16.8.1

Product

SAP Inventory Manager 4.3 ; SAP Mobile Platform 3.0 ; SAP Mobile Platform SDK 3.0 ; SAP Mobile Platform SDK 3.1 ; SAP Work Manager 6.4 ; SAP Work Manager 6.5.0

Keywords

"SMPCLSTRCNFGPROPCMPNNT","javax/persistence/RollbackException","Work Manager org.eclipse.persistence.exceptions.DatabaseException" , KBA , MOB-ONP-AGS , SAP Mobile On Premise Agentry Server , MOB-SYC-SAP , Syclo Mobility for SAP backend , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.