Symptom
The Item Connector fails returning:
- "com.plateausystems.connector.api.ConnectorException: SqlMapClient operation; uncategorized SQLException; SQL state [HY000]; error code [1300]".
- Cause: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1300]: fetch returns more than requested number of rows: "LEARNING_SCHEMA_TMS"."PKG_CONN_CUSTOM_CPNT_PROCESS_DELTA".
Environment
SAP SuccessFactors Learning
Cause
Resolution
Review the file generator to ensure that it doesn't create files with any repeated item IDs and remove the repeated item IDs before having the file consumed by the connector.
It's recommended to engage the SAP team that delivers services or an SAP Certified Partner to implement, review and perform adjustments in the connectors.
See Also
Keywords
item, connector, fail, failure, error, fetch returns more than requested number of rows, id, repeated, PKG_CONN_CUSTOM_CPNT_PROCESS_DELTA, uncategorized SQLException, SQL state [HY000], error code [1300] , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem