IBM Support

[IBM][CLI Driver] CLI0165E Error in a row

Troubleshooting


Problem

When opening a report you get the following message:[

Error number -51:

[IBM][CLI Driver] CLI0165E Fehler in einer Zeile.
SQLSTATE=01S01
DMS-E-MATHEXCEPTION, An arithmetic exception was detected.
[IBM][CLI Driver] CLI0111E Der numerische Wert liegt außerhalb des gültigen Bereichs.
SQLSTATE=22003

]If Client Enabler 5.0 is used you get the message above.

Resolving The Problem

Use Client Enabler 5.2 (=Fixpack 12) to solve this problem.
This worked in the following environment: DB2 on MVS 6.1, Gateway 5.2

Translation of the German messages:
[IBM][CLI Driver] CLI0165E Error in a row.
SQLSTATE=01S01
DMS-E-MATHEXCEPTION, An arithmetic exception was detected.
[IBM][CLI Driver] CLI0111E The numeric value is not in a valid range.
SQLSTATE=22003

[{"Product":{"code":"SSTQPQ","label":"Cognos Series 7"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 5.0;PowerPlay Transformer 7.1","Edition":""},{"Product":{"code":"SSTQPQ","label":"Cognos Series 7"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

Historical Number

85699

Document Information

Modified date:
15 June 2018

UID

swg21373081