Problem in IWR:

[susheeltips]

Hi,
I am using 7.0 and I have four report sets published as newsitems in one newsbox. All of them have some reports in them, three of the news items work well but fourth gives the error stated below. Can someone help me out with this.

Page generation error while preparing a page based on template: iwr_modifyprompts.utml.
The content request 'DescribeNewsItem' has failed.
The Cognos BI provider (IWR) failed with these messages: Failure occurred while executing prompt job for report
drive:\xyz\pqr\abc.imr.

Reason: drive:\xyz\pqr\abc.imr. Reason Error: 0, Generic;
Process ID: 3540; Thread: 4580; Host: server_name; Text: Unexpected Error.
Please contact your System Administrator.
Caught an SE_Exception in CImpDoc::GetPromptDetails, nSE = 0xc0000005 Report:
\\?\drive:\xyz\pqr\abc.imr;
BackTrace Info: 1. File Name: Y:\src\impromptu\ImpromptuServer\app.exe\ole.lib\APPAUTO.CPP;Line#:8308; Desc.:CAppAuto::GetPromptsDetailForSpecificReport; ..

Thanks in advance.

 

[noordoar]

On the support-site of cognos I found the following text:

Description:

Unable to run an IWR report in Upfront.

Error Message -

GeTemplate iwr_modifyprompts.utml failed. Reason: The content request
'DescribeNewsItem' has failed. The Cognos BI provider (IWR) failed with
these messages: Failure occurred while executing prompt job for report
D:\xxx\xxx\apps\xxx.imr.
Reason Error: 0,
Generic; Process ID: 2944; Thread: 4380; Host: ITSQL-2; Text: Could not
connect database due to wrong or insufficient information provided.;
BackTrace Info: 1. File Name:
Y:\src\impromptu\ImpromptuServer\app.exe\ole.lib\APPAUTO.CPP;
Line#:3545; Desc.:CAppAuto::ConnectDatabase; 2. File Name:
Y:\src\impromptu\ImpromptuServer\app.exe\ole.lib\APPAUTO.CPP;
Line#:7986; Desc.:CAppAuto::GetPromptsDetailForSpecificReport; ...


Solution:

Ensure that the report set is not corrupt and that the reports are synched up with the catalog in the report set. This error will occur when the reports were created against a catalog with a different datasource.

I hope this is helpfull

Greetings Arno

 

[RVLF]

try to open and execute it with impserver (Ctrl+O to have file open menu).

If it's good modify your timeout on the gateway of IWR.

 

[BeckyBoop]

I have received the same error. I took the following steps then republished:

1. Verified prompt report opened correctly in Impromptu
2. Verified database signon
3. Verified the "Map All User Classes to:" was checked and the correct user class was identified in the catalog. (In my case, I do not have user classes in my catalog. Therefore, 'Map All User Classes to:' is 'Creator'.

Hope this helps,
If you need additional instructions, please let me know.
~Becky