3507835 - Item Connector failure > "fetch returns more than requested number of rows"

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

SAP SuccessFactors Learning

The "fetch returns more than requested number of rows" error occurs when the file has more than one row with the same item ID.

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.

• Engage Certified Partner to Import Data to SAP SuccessFactors Learning
• 2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud]
• 2404463 - SAP SuccessFactors Learning Connector Workbooks FAQs

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

SAP SuccessFactors Learning all versions