[Vertica][Support] (40470) Conversion error at column 5 and row 1: Numeric value out of range..

mpedroso

Hello!

I am using the Vertica Database with Oracle BI and some of my panels are returning the following error:

[Vertica] [Support] (40470) Conversion error at column 5 and row 1: Numeric value out of range ..

Has anyone ever experienced this? Can you help me?

Ps .: The connection between OBIEE and Vertica is performed via ODBC DataDirect

Jim_Knicely

What version of Vertica are you using? I think that you are seeing an error from the OBIEE side.

Similar:
http://support.sas.com/kb/59/581.html

Make sure to heed the limitations of OBIEE data types listed here:

https://www.vertica.com/kb/Vertica-Integration-with-OBIEE-Connection-Guide/Content/Partner/Vertica-Integration-with-OBIEE-Connection-Guide.htm

Also, check out this doc titled "Configuring OBIEE for Optimal Performance with Vertica":

https://www.vertica.com/kb/Configuring-OBIEE-for-Optimal-Performance-with-Vertica/Content/Partner/Configuring-OBIEE-for-Optimal-Performance-with-Vertica.htm

marcothesane

Hi mpedroso -
As Jim put it - [nQSError] suggests it's an OBI EE error (OBI EE was Siebel Analytics before that, and NQuire even before Siebel). So all that contains NQ is OBI EE ...
You might want to dig in the nqserver.log file or nqquery.log file to find the exact SQL statements: a) the one that the OBI EE Presentation server sent to the OBI EE Database server; b) the one that the OBI Database server sent to Vertica. In those two, check the expression used for the 5th column in the SELECT list; more probably than not, you will find a self-explanatory situation just from that.

Good luck