APAR status
Closed as program error.
Error description
Using Process Task Manager for Case Analyzer, when adding a data field of datetime data type as a dimension and defined ranges for the dimension, adding the data field failed with error message. Below exception is reported in the pesvr_trace.log RPCHandler WebContainer : 2 [Trace] CA_PUB, [CAStore] UDFAdmin::updateDimRanges-Executing: INSERT INTO dbo.D_DMDataField_datetime_dim1 ([datetime_dim1], [Floor]) VALUES ('09/01/2016 12:00:00 ?? +', '09/01/2016 12:00:00 ??') RPCHandler WebContainer : 2 [Error] [CAS1] UDFAdmin::exposeDataField:datetime_dim1 - Encountered exception while updating pa database. ; Exception: com.microsoft.sqlserver.jdbc.SQLServerException: ????????????????????????????????????? at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase Error(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQ LServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStateme nt(SQLServerStatement.java:775) ...... The SQL exception indicates Conversion failed while converting string to date and / or time. Datetime formats in SQL issued by CPE might be invalid in Japanese environments.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Customers using Content Platform Engine * * 5.2.1.6-P8CaseFoundation-FP006 and prior defining ranges for * * a user defined datetime field in Case Analyzer Process Task * * Manager. * **************************************************************** * PROBLEM DESCRIPTION: * * Defining ranges for a user defined datetime field in Case * * Analyzer Process Task Manager will not function correctly * * when user adds a datetime data field. * **************************************************************** * RECOMMENDATION: * * Upgrade to 5.2.1.7-P8CaseFoundation-FP007 or later. * ****************************************************************
Problem conclusion
Fixed in 5.2.1.7-P8CaseFoundation-FP007 and later. Defining ranges for a user defined datetime field in Case Analyzer Process Task Manager was resolved by handling date time formats based on locale.
Temporary fix
Comments
APAR Information
APAR number
PJ44566
Reported component name
CONTENT ENGINE
Reported component ID
5724R8101
Reported release
521
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-03
Closed date
2017-06-27
Last modified date
2017-06-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
CONTENT ENGINE
Fixed component ID
5724R8101
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSC2W3B","label":"Content Engine"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 June 2017