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
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"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
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.