SAP Knowledge Base Article - Preview

2738158 - Error occurs in Information Design Tool when paring SQL Expression on @Prompt function without default value on database

Symptom

 SAP DBTech JDBC:[339]:invalid number:not a valid number string 'Valu' at function to_int()


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1 (BI4.1)
  • SAP BusinessObjects Business Intelligence platform 4.2 (BI4.2)
  • Information Design Tool (IDT)
  • HANA

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

valu, to_int, to_date, to_int(), validate, SQL, prompt, @prompt, default value, hana, derived, table, invalid, number, string, function, 4.2, idt, universe, 4.1, bi, bo , KBA , BI-BIP-IDT , Information design tool , 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.