APAR status
Closed as program error.
Error description
Filtering date field from Access data source is not consistent. This works: [Date] = current_date This does not work: [Date] = _first_of_month(current_date) Error is returned: UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0093 The operation "_first_of_month" is invalid for the data type "varchar". From Trakker bug 528680.1 there is fix comment that states: Access datetime function "curdate" and "curtime" return varchar rather than datetime. This is also stated in the cogdmod.ini file. It seems that this is the case: The Access function curdate() which returns varchar, has been mapped to the common function current_date - this probably should not be the case for Access. If Access is returning curdate() as varchar, we should cast it internally to date for use for the current_date common function. curdate() would remain the same as in Access. BTW current_timestamp works but requires local processing. Also the latter function worked in 8.2 (the first fails in 8.2, though).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Cognos BI Server 10.2 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PK89604
Reported component name
COG8 BI REPORT
Reported component ID
5724W12RS
Reported release
840
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-23
Closed date
2012-09-11
Last modified date
2012-09-11
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
COG8 BI REPORT
Fixed component ID
5724W12RS
Applicable component levels
RA20 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 September 2012