Symptom
After upgrading the SAP Mobile Platform Server 3.0 from SP 12 to SP 14 PL03 the following error is seen (in the SMP server logs) after connecting/syncing the client device to the SMP server and changing a Work Order:
- ERROR :java.sql.SQLException: No primary key value for foreign key 'FK_SMP_CLUSTER_CONFIG_PROP_COMPONENT' in table 'SMP_CLUSTER_CONFIG_PROP'
- ERROR#com.sap.mobile.platform.server.agentry.console###Agentry SAPWM_MM_TEST Worker 139666880120576 Thread#na#######Exception: 15:46:47 07/13/2018 : 29 (Java Exception), javax/persistence/RollbackException (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.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (MPSMOBILE.SMPCLUSTERCONFIG_PROPCOMPONENT) violated - parent key not found |
2018 07 13 15:46:47#0-500#ERROR#com.sap.mobile.platform.server.agentry.console###Agentry SAPWM_MM_TEST Worker 139666880120576 Thread#na#######Exception: 15:46:47 07/13/2018 : 29 (Java Exception), javax/persistence/RollbackException (), /build/ablack/AgSrvrel171164/src/com.sap.mobile.platform.server.agentry/Syclo/ag3/agent/ClusteredUserTransactionStorage.cpp#99:putData |
Read more...
Environment
- SAP Mobile Platform 3.0 SP14 PL 03
- SAP Work Manager 8.1
- Mobile Add-On version/patch : SMERP,SMFND and SMISU 620_700 with SP01
Product
SAP Mobile Platform 3.0 ; SAP Work Manager all versions
Keywords
SMP 3.0, SMP Cluster Prop Value Error, cluster config prop component, parent key , KBA , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview