Jderrick: Recommended identifying users and installing the new IBM CMOD Client software.

2018-03-25T11:01:20Z

Recommended identifying users and installing the new IBM CMOD Client software.

← Older revision		Revision as of 11:01, 25 March 2018
Line 26:		Line 26:
	Check the OnDemand System Log for the login associated with the error message. It will contain the version number of the client used to log in at the very end of the message.		Check the OnDemand System Log for the login associated with the error message. It will contain the version number of the client used to log in at the very end of the message.
	Login: client.example.com 10.11.12.13 non-SSL (Windows) (CLIENT GUI) '''(8.5.0.0)'''		Login: client.example.com 10.11.12.13 non-SSL (Windows) (CLIENT GUI) '''(8.5.0.0)'''
			You can use this method to find users (by IP address or login name) to correct the issue by installing the latest fixpack for the IBM CMOD Client. Links to the latest versions of Content Manager OnDemand Clients can be found [[Main_Page#IBM_CMOD_Fixpacks_.26_Security_Bulletins\|in the IBM CMOD Fixpacks section.]]

	== Articles Related to this message ==		== Articles Related to this message ==

Jderrick: Initial edit of IBM CMOD ARS238W

2017-02-13T12:24:04Z

Initial edit of IBM CMOD ARS238W

New page

{{TOCright}}
== What was the error? ==
'''Message Number''': 238

'''Message Severity''': Warning (A warning was returned, your request has likely failed. You may need to try your request again.)

'''Message Name''': ARS0238W

'''Message Text''': The tokenized query string has a nonnumeric value at marker position (2), value (17211). Use a numeric value instead.

== Example ==
ARS0238W The tokenized query string has a nonnumeric value at marker position (1), value (16384). Use a numeric value instead.
ARS0238W The tokenized query string has a nonnumeric value at marker position (2), value (17211). Use a numeric value instead.

== Related Errors ==
The message [[ARS0013E]] may accompany this error.
ARS0013E DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect.

== What were you doing? ==
Performing a query with an outdated IBM CMOD Client on a recently upgraded server. The Application Group on the new server is using the new database date format, and the old client doesn't know how to properly format a query for the more modern CMOD server version.

== What happened? ==
The old client software wasn't aware of how to query a new data type, like the new date format introduced on Content Manager OnDemand v9.0.

== Troubleshooting ==
Check the OnDemand System Log for the login associated with the error message. It will contain the version number of the client used to log in at the very end of the message.
Login: client.example.com 10.11.12.13 non-SSL (Windows) (CLIENT GUI) '''(8.5.0.0)'''

== Articles Related to this message ==

ARS0238W - Revision history

Jderrick: Recommended identifying users and installing the new IBM CMOD Client software.

Jderrick: Initial edit of IBM CMOD ARS238W