Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
billby
billby
1 Post
ACCEPTED ANSWER

Pinned topic IWR Reports failing when created from new folders

‏2014-04-03T13:26:30Z |

Hello everybody,

I am having a problem where all reports generated from new folders will not run from our IWR site.

I created a new view recently and added it to a catalog. I then created a new report with Impromptu using the new folder in the catalog. The report runs fine inside Impromptu, and it publishes to IWR without any warnings or errors, but when I try to run it from IWR it crashes after a few seconds with the message "The report request failed.

The execution of this report at 04/04/2014 00:11:05 failed due to the following reason:
Unable to execute report."

So I looked in the iwr.log, and there was not much more detail, the trace is at the bottom of this message. No real reason is given for the failure, just 'Unable to execute report', with a few cpp files  and line numbers added in, which is no good to me as I don't have the source. 

Googling turned up a few similar errors, but most had additional reasons such as login failure etc.

One blamed prompts with white space in them, but I got rid of  the prompts altogether and it made no difference.

After much experimenting I realise I can successfully run new reports if I use existing folders in their creation, but any reports created from folders I have created recently fail, even if they are from existing views in the database.

If anyone has a clue on what the problem is I'd really appreciate your input.

Regards

Bill

Trace from iwr.log

IWRcer4:IWIRSDISP:ErrorHandlerError:  SWID=20140402133137287DFRGSCOGAPV02PID53744TID53416 - DFRGSCOGAPV02, 64528(fb74), 2014/04/02 13:31:39.959; Error: 0, Generic;
Process ID: 62712; Thread: 63612; Host: DFRGSCOGAPV02; Text: Error: 0, Generic;
Process ID: 62712; Thread: 63612; Host: DFRGSCOGAPV02; Text: Multiple errors have occured with Impromptu Web Reports.;
BackTrace Info: 
1. File Name: H:\7.3\mr3\win32\src\iwr\impromptuserver\app.exe\ole.lib\APPAUTO.CPP; Line#:8333; Desc.:CAppAuto::ExecuteRunReport;
;
BackTrace Info: 
1. File Name: y:\src\iwr\iwr\Dispatchers\irsdispatchers\irsinstance.cpp; Line#:512; Desc.:IRSInstance::executeRunReport;
 
IWRcer4:IWIRSDISP:ErrorHandlerError:  SWID=20140402133137287DFRGSCOGAPV02PID53744TID53416 - DFRGSCOGAPV02, 64528(fb74), 2014/04/02 13:31:40.037; Error: 0, Generic;
Process ID: 64528; Thread: 64372; Host: DFRGSCOGAPV02; Text: Failure occurred attempting to load the report Medical Specialist Report TEST2. Reason: Unable to execute report D:\Data\Cognos\IWR\ReportStore\dfr_1.6_assess\apps\Medical Specialist Report TEST2.imr. Reason: Error: 0, Generic;
Process ID: 62712; Thread: 63612; Host: DFRGSCOGAPV02; Text: Multiple errors have occured with Impromptu Web Reports.;
BackTrace Info: 

1. File Name: H:\7.3\mr3\win32\src\iwr\impromptuserver\app.exe\ole.lib\APPAUTO.CPP; Line#:8333; Desc.:CAppAuto::ExecuteRunReport;