SAP Knowledge Base Article - Public

2395253 - SF User Connector error - ORA- 12003 : materialized view "*****_STAGE_TMS"."PV_AP_STUD_USER" does not exist ORA- 06512 : at "***_STAGE_TMS.PKG_CONN", line 153 ORA- 06512

Symptom

SF user connector is not getting failed it's getting error out with below error. com.plateausystems.connector.api.ConnectorException: ORA- 12003 : materialized view "EMAMILTD_STAGE_TMS"."PV_AP_STUD_USER" does not exist ORA- 06512 : at "****_STAGE_TMS.PKG_CONN", line 153 ORA- 06512 : at line 1

**Complete error is attached in the attachement section**

Environment

Learning Management System

Cause

This is a Database issue - some of the student table views are either invalid or ot created.

Resolution

If you run the Assignment profile synchronization APM - it will automatically rebuilt the views and you can run the connector fine.

If in case it is already running or even after running the connector is failing with the same error, plese contact support team via incident.

 

 

Keywords

materialized view error, ORA- 12003 , ORA- 06512, ORA-12034 , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1402 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1411 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508

Attachments

materialized.txt