3721120 - Connector error and exception log tables in SAP SuccessFactors Learning

Which database tables store information about connector completion status, errors, exceptions and messages? 

SAP SuccessFactors Learning

The tables "PA_CONN_LOG" and "PA_CONN_EXCEPTIONS" store information regarding connector completion status, errors, exceptions and messages. 

• The error message displayed in the LMS UI under Connector -> View Errors, can be located in the database table "PA_CONN_LOG" within the MSG_DATA field. This table also contains information such as the connector's STATUS, STATUS_CODE, EXCEPTION count, and more.
• The message and exception displayed in the LMS UI under Connector -> View Results -> View Details and View Logs can be located in the database table "PA_CONN_EXCEPTIONS" table under the ADDL_TEXT field. 

For further insights, we recommend reviewing the Learning Data Dictionary. More table information can be found in the KBA 2318341.

• 2326249 - SAP SuccessFactors Learning Data Dictionary
• 2318341 - LMS Connectors Knowledge Support and Tips

connector exceptions, connector logs, PA_CONN_LOG, PA_CONN_EXCEPTIONS, PA_SCHEDULED_JOB_RESULT, PA_SCHEDULED_JOB, LMS database dictionary, SAP SuccessFactors Learning, runtime logs, error messages, exception logs, database tables, automation project, connector execution logs, job scheduling information, connector troubleshooting, LMS error analysis, database troubleshooting, connector error resolution, SAP Learning connectors , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-DSE , Data Service Extracts , LOD-SF-LMS-CON , Connectors , How To