COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Yasser on 26 Jan 2017 06:23:41 AM

Title: Dynamic Filtering Problem
Post by: Yasser on 26 Jan 2017 06:23:41 AM
Hello,

I've a problem in drill through dynamic filtering for a multi select parameter

An unexpected exception occurred:
MFW-UT-1002 An internal problem has occurred. Please contact your system administrator.
MFW-UT-1003 Details: "Expecting a valid CRN Id"

Anyone faced the same issue before ?

Thanks,
Title: Re: Dynamic Filtering Problem
Post by: CognosPaul on 26 Jan 2017 09:07:00 AM
Is your data source an Excel file by any chance? Check if there are any nulls in the CRN Id column.
Title: Re: Dynamic Filtering Problem
Post by: Yasser on 26 Jan 2017 11:30:13 AM
Quote from: CognosPaul on 26 Jan 2017 09:07:00 AM
Is your data source an Excel file by any chance? Check if there are any nulls in the CRN Id column.

Thanks for your response,

No, My data source is Oracle DB,  What is CRN ?
Title: Re: Dynamic Filtering Problem
Post by: CognosPaul on 26 Jan 2017 02:00:10 PM
It looks like CRN Id is a Cognos internal thing when performing a drill. It looks like the dynamic drill is passing a null value somewhere. If you can isolate that, the issue should (hopefully) be resolved.