Tasks for WebSphere Lombardi Edition fail with a "Error converting data type decimal to decimal" message

Technote (troubleshooting)


If you run WebSphere Lombardi Edition Versions 7.1, 7.1.0 Fix Pack 1 or 7.2 using Microsoft SQL as the system database, you might encounter a random failure of tasks.

Resolving the problem

The following error message exists in the WebSphere Lombardi Edition log file:

Error converting data type decimal to decimal.; nested exception is
com.jnetdirect.jsql.JSQLNonFatalException: Error converting data type decimal to decimal.

The cause of the problem has been identified as the version of the JNetDirect driver that is shipped with WebSphere Lombardi Edition 7.1, 7.1.0 Fix Pack 1 and 7.2. An updated version of the driver is available through IBM Fix Central. To download it from IBM Fix Central, click Download Hot Fix 110129710

In IBM Fix Central, place a check in the box in front of the fix. For example:

The correct Microsoft SQL driver version is v5.97, which will be listed in the SystemOut.log file.

Product Alias/Synonym

WLE Lombardi

Rate this page:

(0 users)Average rating

Document information

More support for:

WebSphere Lombardi Edition

Software version:

7.1, 7.2

Operating system(s):

AIX, HP-UX, Linux, Linux zSeries, Linux/x86, Solaris, Windows

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation