Troubleshooting
Problem
All DataStage and Information Server clients log in attempts fail due to a server error. The corresponding WebSphere log shows the following error during login attempts:
" Unexpected runtime error: Unhandled type 2011 for column 23"
This problem can occur after installing Fix Pack 3 for Information Server 11.7.1.
" Unexpected runtime error: Unhandled type 2011 for column 23"
This problem can occur after installing Fix Pack 3 for Information Server 11.7.1.
Resolving The Problem
When installing Fix Pack 3 or later onto Information Server 11.7.1, the database.properties file is updated to append 2 new properties to the jdbc connection string:
However, in cases where the jdbc url already contains an existing property after the database names, for example:
Then, the new properties are separated by incorrect character combinations ";:" or ";\:", for example:
To resolve the problem, the database.properties file must be updated in 3 locations to remove the extra ":" or "\:" characters in front of the "useJDBC4DataType" property, for example:
:useJDBC4DataType=2;useJDBC4ColumnNameAndLabelSemantics=2;
However, in cases where the jdbc url already contains an existing property after the database names, for example:
url=jdbc:db2://hostname:50000/xmeta:sslConnection=true;
Then, the new properties are separated by incorrect character combinations ";:" or ";\:", for example:
url=jdbc:db2://hostname:50000/xmeta:sslConnection=true;:useJDBC4DataType=2;useJDBC4ColumnNameAndLabelSemantics=2;
url=jdbc\:db2\://hostname\:50000/xmeta\:sslConnection=true;\:useJDBC4DataType=2;useJDBC4ColumnNameAndLabelSemantics=2;
To resolve the problem, the database.properties file must be updated in 3 locations to remove the extra ":" or "\:" characters in front of the "useJDBC4DataType" property, for example:
url=jdbc:db2://hostname:50000/xmeta:sslConnection=true;useJDBC4DataType=2;useJDBC4ColumnNameAndLabelSemantics=2;
The database properties file exists on service tier machine in the following 3 locations:
<IS Home>/ASBServer/apps/lib/iis/classes/database.properties
<IS Home>/ASBServer/conf/database.properties
<WAS Home>/AppServer/profiles/InfoSphere/classes/database.properties
Restart the WebSphere Application Server after correcting these files.
<IS Home>/ASBServer/conf/database.properties
<WAS Home>/AppServer/profiles/InfoSphere/classes/database.properties
Restart the WebSphere Application Server after correcting these files.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m0z000000GmyeAAC","label":"DataStage-\u003EDataStage Designer Client-\u003ELogin Errors"},{"code":"a8m500000008XHSAA2","label":"Web Console for Information Server-\u003ELogin Issues"}],"ARM Case Number":"TS012989310","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.1"}]
Was this topic helpful?
Document Information
Modified date:
11 May 2023
UID
ibm16991167