2551119 - Item connector error out for a particular Item type with error Unexpected Error.SQLException could not add Component

SAP Knowledge Base Article - Public

2551119 - Item connector error out for a particular Item type with error Unexpected Error.SQLException could not add Component

Symptom

We have encountered the error when  trying to upload item with a particular into our test environment.

For all other item types the connector is working fine.

Just with the specific item type connector throws error in the view results section and does not process the record.

The error comes in view results section, connector not fail completely only error out for this particular item/s with the specific item type.

Error Screenshot (complete error is attached) :-

 connector error.png

 

Environment

SAP SF Learning Management System

Cause

Redundant cost formula or a custom cost formula is added at the item type level in the references.

 

Resolution

The fact the error is related to the formula there is a possibility redundant cost formula or a custom cost formula is added at the item type level in the references.
To resolve this, go to the references section of the Learning admin and search for the item type

Navigation ->

Learning admin - > References - > Learning - > Item Type

Edit the item type and go to cost calculation tab, and check if there is a cost or a custom cost added. (cost can be seen in the default cost section).

If yes please remove it from the item type and then run the connector again.

The connector is throwing error as addition of cost with this item is wrong and hence creating data issues.

2017-10-26_11-31-50.png

Keywords

Cost formula Unexpected Error SQLException could not add Component SQLException Item type Connector Error Item connector not working Item type cost formula , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors Learning all versions

Attachments

conn_err.txt