SAP Knowledge Base Article - Public

2670213 - SF User Connector - ORA-02291: integrity constraint (CUSTOMER_STAGE_TMS.FK_STUD__REGION) violated - parent key not found

Symptom

  • JAVA Error below is thrown while records from BizX are loaded into LMS via SF User Connector

Unexpected Error.retrieveDeletedStudentRecord(): Could not get deleted student record. 
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (CUSTOMER_STAGE_TMS.FK_STUD__REGION) violated - parent key not found 
ORA-06512: at "CUSTOMER_STAGE_TMS.PKG_STUDENT", line 3383 
ORA-06512: at line 1 

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) 
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) 
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) 
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) 
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) 
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) 
 at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204) 
 at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1041) 
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) 
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) 
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) 
 at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4739) 
 at oracle.jdbc.driver.T4CCallableStatement.executeUpdate(T4CCallableStatement.java) 
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) 
 at oracle.jdbc.driver.OracleCallableStatementWrapper.executeUpdate(OracleCallableStatementWrapper.java) 
 at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
 at java.lang.reflect.Method.invoke(Method.java:606) 
 at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:272) 
 at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:138) 
 at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke(CallableStatementProxyFactory.java:104) 
 at com.sun.proxy.$Proxy924.executeUpdate(Unknown Source) 
 at com.plateau.common.db.oracle.impl.AbstractOracleCallableStatementWrapper.executeUpdate(AbstractOracleCallableStatementWrapper.java:452) 
 at com.plateau.common.db.oracle.impl.PlateauOracleCallableStatement.executeUpdate(PlateauOracleCallableStatement.java) 
 at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
 at java.lang.reflect.Method.invoke(Method.java:606) 
 at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:146) 
 at com.sun.proxy.$Proxy925.executeUpdate(Unknown Source) 
 at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
 at java.lang.reflect.Method.invoke(Method.java:606) 
 at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71) 
 at com.plateau.common.db.api.Interru 

Environment

  •  Learning Management System

Cause

  • In this case, the Region ID set to the deleted user does not exist in LMS anymore. Hence, the error above is thrown in the connector results.

Resolution

  • The fix for this issue is:
  1. Create the missing Region in LMS.
  • In case you need to find out what Region ID is missing, it will be required a custom report that brings data from deleted users.

select * from ph_student where action = 'D'

  • If further assistance to build a custom report is required, you may engage a Partner or SAP Professional Services.

See Also

 2149831 - To contact Professional Services, Partner and Account/Finance Team

Keywords

SF User connector error, parent key not found, integrity constraint (CUSTOMER_STAGE_TMS.FK_STUD__REGION), ORA-02291 , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions