If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Recent posts

#91
Forum suggestion box / MOVED: running total cognos
Last post by MFGF - 26 Mar 2025 01:59:48 PM
#92
Reporting / Re: Filter multiple words in o...
Last post by MFGF - 26 Mar 2025 01:58:27 PM
Quote from: Warm on 14 Mar 2025 10:45:59 AMThank you for the advice. We're using IBM Cognos Analytics 11.2.4.

Couldn't load the XML script into a report. Will look into possibilities to make it work.

You can use the "Open report from clipboard" option to load the XML into a report.

Cheers!

MF.
#93
Administration and Security / Re: Impact Analysis
Last post by MFGF - 26 Mar 2025 01:55:20 PM
Quote from: dougp on 21 Mar 2025 02:45:01 PMI knew about that (, said Doug, sheepishly) because I have used it before.

You know, at my age the hearing is the second thing to go.  I can't remember what the first thing was.


Welcome to my world, sir! :-D

Thanks for the further updates also - useful info!

Cheers!

MF.
#94
ChatGPT / MOVED: Newbie
Last post by MFGF - 26 Mar 2025 01:50:05 PM
#95
Administration and Security / Re: Impact Analysis
Last post by dougp - 21 Mar 2025 06:24:38 PM
Selecting a query subject or query item and using Tools | Find Report Dependencies will also work.

One thing to watch out for:

Both Analyze Publish Impact... and Tools | Find Report Dependencies identify things that you would see in places like Data Items or Detail Filters.  But since the relationships between query subjects are technically not in the reports, removing something like a bridge or grouping table (used only for relationships) won't be identified as something that has an impact.  I suppose that database changes should not be harming how logical relationships work, so maybe that's OK.

For example Report X includes parts that require the SQL to look like
FROM factA INNER JOIN bridgeB INNER JOIN dimC
and I remove table bridgeB and make the relationship work directly between tables factA and dimC, there technically should not be a problem.  But what if I got it wrong?  What reports should I watch to see if I messed this up?  FM won't tell me.  I suppose that, logically, I can assume that anything using dimC must be checked.
#96
Administration and Security / Re: Impact Analysis
Last post by dougp - 21 Mar 2025 02:45:01 PM
I knew about that (, said Doug, sheepishly) because I have used it before.

You know, at my age the hearing is the second thing to go.  I can't remember what the first thing was.
#97
Administration and Security / Re: All reports stop working w...
Last post by dougp - 21 Mar 2025 02:41:31 PM
So that we don't post things you have already tried...
What have you already tried to troubleshoot or resolve this?
#98
Administration and Security / Re: All reports stop working w...
Last post by Mast - 21 Mar 2025 12:49:05 PM
Hi

I have been facing this error please help


Quote
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.   DetailsCCLThreadResourceError:-1:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(774): CCLThreadResourceError: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(254): CCLThreadResourceError: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(887): CCLThreadResourceError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(331): CCLThreadResourceError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(932): CCLThreadResourceError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(585): CCLThreadResourceError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(339): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLThreadResourceError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): CCLThreadResourceError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): CCLThreadResourceError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSSingletonAssembly.cpp(126): CCLThreadResourceError: CCL_RETHROW: RSSingletonAssembly::assembleAssembly/RSAssembly.cpp(699): CCLThreadResourceError: CCL_RETHROW: RSAssembly::createListIteratorRSResultSetIterator.cpp(1513): CCLThreadResourceError: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): CCLThreadResourceError: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmSqlResultSet.cpp(1942): CCLThreadResourceError: CCL_RETHROW: QESource/QEDMSqlCursorScroll.cpp(449): CCLThreadResourceError: CCL_RETHROW: Source/AQE_UDAFacade.cpp(980): CCLThreadResourceError: CCL_RETHROW: AQE_UDAFacade::sqlOpenResult CCLErrorapicursr.cpp(552): CCLThreadResourceError: CCL_RETHROW: sqlOpenResult CCLErrorapigbl.cpp(3927): CCLThreadResourceError: APICursorOpenThread::joinsgiWrapper.cpp(989): CCLThreadResourceError: CCL_RETHROW: sgiAOpen CCLThrowablesgiCursor.cpp(275): CCLThreadResourceError: CCL_RETHROW: SgiCursor::asyncOpen CCLThrowablecommon/sgiOdbcCursor.cpp(330): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::doOpen CCLThrowablecommon/sgiOdbcCursor.cpp(1050): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::openForNonMetaRqst CCLThrowableThreads/CCLThread.cpp(176): CCLThreadResourceError: CCL_THROW: CogThread interface or unknown error
#99
Administration and Security / Re: All reports stop working w...
Last post by Mast - 21 Mar 2025 11:17:06 AM
Hi Gollapudi

Have you cracked this error facing same here please help on this ASAP
#100
Reporting / Re: Wrapping Colums in Double ...
Last post by dougp - 20 Mar 2025 07:08:57 PM
So you may want to investigate that, but... You probably shouldn't be trying to using Cognos Analytics to produce that specific output format.


Quotesomething like this PowerShell script would work.

$fileIn = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book1.csv"
$fileOut = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book2.csv"

Import-Csv -LiteralPath $fileIn | Export-Csv -LiteralPath $fileOut -UseQuotes Always

But if you're going that route, you should also have PowerShell (or your script runtime of choice) run the query to get the data to begin with.