SAP Knowledge Base Article - Preview

3528151 - The value for ProductFeature is set to type String but it always try to cast it to big decimal

Symptom

Though the value for ProductFeature is set to type String it always try to cast it to big decimal and following error could be seen in logs.

 [impex result worker [cj:00001S1L]] [ImpExImportReader] line 3 at main script: dumped unresolved line ValueLine[unresolvable:org.springframework.dao.DataIntegrityViolationException: query; SQL []; One or more values is out of range of values for the DECIMAL SQL type.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: One or more values is out of range of values for the DECIMAL SQL type.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • Product version: All SAP Commerce Cloud versions

Product

SAP Commerce Cloud all versions ; SAP Commerce all versions

Keywords

DataIntegrityViolationException,SQLServerException,DECIMAL , KBA , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.