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

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**

Learning Management System

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

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 case.

 

 

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

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