SAP Knowledge Base Article - Preview

3349722 - Error "some Decimal(p,s) columnexceeds the maximum precision of Decimal(p,s) datatype during UNION ALL operation. Please consider adding explicit conversion, i.e. TO_DECIMAL()." after upgrade to HANA 2.0

Symptom

After upgrade to HANA 2.0, a SQL that has a calculated column without length defined explicitly fails execution with error:

"some Decimal(p,s) columnexceeds the maximum precision of Decimal(p,s) datatype during UNION ALL operation. Please consider adding explicit conversion, i.e. TO_DECIMAL()."


Read more...

Environment

SAP HANA, platform edition 2.0

    Product

    SAP HANA, platform edition 2.0

    Keywords

    explicit conversion, decimal, to_decimal , KBA , HAN-DB-ENG , SAP HANA DB Engines , Product Enhancement

    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.