Print Page - Getting the following error while running report

Title: Getting the following error while running report
Post by: mark123 on 23 Feb 2016 09:10:58 AM

Hi,

Can anyone tell me the cause of the following error in cognos while running report
Found an internal error:
d != java.lang.String

Thanks

Title: Re: Getting the following error while running report
Post by: mark123 on 23 Feb 2016 09:23:37 AM

When i am trying to union two queries i am getting the error while running the report with the union query.
Its relational model.

Title: Re: Getting the following error while running report
Post by: BigChris on 23 Feb 2016 09:28:17 AM

Have you got any javascript in your report?

Title: Re: Getting the following error while running report
Post by: mark123 on 23 Feb 2016 09:43:13 AM

no i dont have any javascript

Title: Re: Getting the following error while running report
Post by: mark123 on 23 Feb 2016 09:45:05 AM

I am getting the same error if i use this query in dataitem

case

when

[PromptDate] <[July 1(current)]
and

[Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[ACTV_SDU_RCVD_DT] >=[July 1(current-2)]
and
[Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[ACTV_SDU_RCVD_DT] < _add_months ( _make_timestamp( ?Year?, ?Month?, 1 ) ,- 11)

then

([Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[LGC_COLL_TRANS_AMT])

when

[PromptDate] >[July 1(current)]
and

[Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[ACTV_SDU_RCVD_DT] >=[July 1(current-1)]
and
[Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[ACTV_SDU_RCVD_DT] < _add_months ( _make_timestamp( ?Year?, ?Month?, 1 ) ,- 11)

then

([Financial_p].[LOGICAL_COL_TXN--PARTICIPANT].[LGC_COLL_TRANS_AMT])

end

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mark123 on 23 Feb 2016 09:10:58 AM