SAP Knowledge Base Article - Public

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

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

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

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

Product

SAP SuccessFactors Learning all versions