COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: cccschip on 08 Feb 2012 11:10:20 AM

Title: Renaming drill-through target breaks link
Post by: cccschip on 08 Feb 2012 11:10:20 AM
Per the following doc from IBM (for v8.2, I know):
http://www-01.ibm.com/support/docview.wss?uid=swg21341623

I should be able to rename the target report of a drill-through relationship without breaking that relationship.

However, that is not my experience.

We just upgraded to v10.1 and are seeing the following problem.  I cannot tell whether the problem occurred in v8.4 as we don't have that version available to us any longer.

Report A drills to Report B.
Report B drills to Report C.

All reports work fine, including the drill-throughs.

We then rename "Report C" to "Report CC" by using the Set Properties dialog.

Report A and Report B work fine, except when we try to drill-through to Report CC.

We get the following error:

RSV-SRV-0040

The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.

CCLRuntimeError:1:Fatal: CCL-PLG-0001 Failed to load the pluggable shared library. /u01/app/cognos10/./bin/RSAOMPackageAuthoredReportGenerator.cpi: cannot open shared object file: No such file or directory RSV-SRV-0042 Trace back:RSReportService.cpp(762): CCLRuntimeError: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): CCLRuntimeError: CCL_RETHROW: RSReportServiceMethod::process(): parameterGetParameters_RequestRSASyncExecutionThread.cpp(808): CCLRuntimeError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): CCLRuntimeError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): parameterGetParameters_RequestPlugIns/CCLPluginLibraryLoader.cpp(99): CCLRuntimeError: CCL_THROW: CCLPluginLibraryLoader::load

Am I doing something wrong?  Or might this be a problem in our installation?

Title: Re: Renaming drill-through target breaks link
Post by: Grim on 08 Feb 2012 11:57:16 AM
It depends where you configured your drill through. By the sounds of it you created the drill in the report itself via Report Studio. In this case you would have to edit the report "B" so that it references the renamed report "CC" as it will still try to go to report "C" which effectively no longer exists.

The case where renaming would not affect drill throughs is when the drill through was created via Drill Definitions.
Title: Re: Renaming drill-through target breaks link
Post by: cccschip on 09 Feb 2012 10:46:12 AM
Grim is correct...the drills are defined in the report def.  We had not understood that these would not be maintained, but that makes some sense.

Now for the (kinda) newbie question...what's the alternative?  You mention "Drill Definitions".  I recall seeing this ability in the Launch drop-down in C8.3, but it is not there in our C10 install.  Maybe it moved?  Maybe my perms are wrong (I am supposed to be a Sys Adm).
Title: Re: Renaming drill-through target breaks link
Post by: cccschip on 09 Feb 2012 11:05:20 AM
My admin just told me that, though I am in the System Administrator group, there appears to be a problem that prevents me from accessing the Drill Definitions.  So that's a different issue...and one we'll tackle. 

Thanks, Grim, for the answer.
Title: Re: Renaming drill-through target breaks link
Post by: Grim on 09 Feb 2012 12:17:33 PM
Glad to help.
*cough*<-applaud*cough*  ;)
Title: Re: Renaming drill-through target breaks link
Post by: MFGF on 22 Feb 2012 10:19:22 AM
You seem to have a nasty and recurring cough!  ::) I hope it gets better soon!!  ;D
Title: Re: Renaming drill-through target breaks link
Post by: Grim on 22 Feb 2012 11:50:08 AM
Quote from: MFGF on 22 Feb 2012 10:19:22 AM
You seem to have a nasty and recurring cough!  ::) I hope it gets better soon!!  ;D

ApplaudSyrup?   ???
Title: Re: Renaming drill-through target breaks link
Post by: Suraj on 22 Feb 2012 12:48:09 PM
Quote from: MFGF on 22 Feb 2012 10:19:22 AM
You seem to have a nasty and recurring cough!  ::) I hope it gets better soon!!  ;D
ROFL!  ;D ;D ;D
Title: Re: Renaming drill-through target breaks link
Post by: Lynn on 22 Feb 2012 02:07:34 PM
Quote from: Grim on 22 Feb 2012 11:50:08 AM
ApplaudSyrup?   ???

I had to applaud just for that!
Title: Re: Renaming drill-through target breaks link
Post by: MFGF on 23 Feb 2012 10:51:04 AM
Quote from: Grim on 22 Feb 2012 11:50:08 AM
ApplaudSyrup?   ???

;D ;D ;D That made me laugh!