MetaManager - Administrative Tools for IBM CognosPricing starting at $2,100Download Now Learn More
Started by Universe1418, 07 Sep 2016 03:15:13 AM
Quote from: Universe1418 on 08 Sep 2016 12:31:55 AMYes, The report is running after disabling the said detail filter (to_date(?End Date?, 'YYYY-MM-DD HH24:MI:SS') + 1).
Quote from: Universe1418 on 09 Sep 2016 06:58:42 AMHi,by removing + 1 the issue still remains, it seems that the issue is related in the to_date function because after modifying the code to something like this it run:From:to_date(?End Date?, 'YYYY-MM-DD HH24:MI:SS') + 1To:_add_days(?End Date?, 1)However modifying all reports is really risky to don in this point and I know it is working in 10.1.1 how come not in 10.2.2I've raised a PMR in IBM but even them is having a hard time to give me solutions that does not require modifications in the report.
Quote from: Universe1418 on 13 Sep 2016 02:44:12 AMHi,I tried the suggested test and got the error below as response:RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function "to_date" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported. Hoping that you can give more insights, your suggestions are really helpful. Thank You!
Quote from: Universe1418 on 13 Sep 2016 09:30:09 AMHi Jay,By adding another data item which came from the package, The test did run successfully.It is weird that it shows error when run from the migrated reports.