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":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 5.0;PowerPlay Transformer 7.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

85699

Document Information

Modified date:
15 June 2018

UID

swg21373081

Page Feedback