SAP Knowledge Base Article - Preview

3441613 - "invalid number: exception 71000339: SQL Error" is raised for function TO_BIGINT

Symptom

You get following error message when running a query.

SAP DBTech JDBC: [339]: invalid number: exception 71000339: SQL Error

You find following exception in HANA indexserver traces.

e join_eval        JEPlanOperation.cpp(00348) : exception  1: no.70006930  (QueryOptimizer/Evaluate.cpp:1283) TID: XXXXX
    attribute value is not a number;[here]fixed("<column>", 18, 0) = fixed(XXXXXXXXXX, 18, 0), <column>= '<string>'[string],docid 452,<SID>::<schema name>:<table name>


Read more...

Environment

  • HANA 1.0
  • HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB , SAP HANA Database , How To

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.