Invalid data type for Julian date function

Troubleshooting

Problem

After using KB document 83901 to create a Julian-to-date function the user sees this function on the Query panel but when he creates a calculated column with it the report fails with the following

Symptom

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.
[Microsoft][ODBC SQL Server Driver][SQL Server]Operand data type numeric is invalid for modulo operator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is incompatible with void type
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

The datatype in the profile is packed decimal. This problem only happens when the report is run against a replica of the database on an MS SQL server. It runs fine against the original database on an AS400. Trying to force the issue by multiplying the field by numeric '1' made no difference. The report runs OK with a calculated column using the packed field multiplied by an interger number.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Cognos 8 BI Framework Manager 8.1;Impromptu 6.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Framework Manager","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1002628

Was this topic helpful?

Document Information

Modified date:
09 May 2025

UID

swg21349612

Tips