Cognos Analytics

 View Only

 Bursting 11.1 Visualizations to PDF in Cognos Analytics 12.1.2 IF1

Richard Meyer-Eppler's profile image
Richard Meyer-Eppler posted 06/03/26 04:27 AM

So Cognos Analytics 12.1.2 has finally, after many years of waiting, added support for master detail relationships for 11.1 visualizations. However, I am having trouble bursting to PDF, whereas bursting to HTML works just fine.

I have a report consisting of a single very simple line chart with 'Retailer Region' as the link key between the same query:

Similarly, I have created a very simple burst recipient query with 'Retailer Region' and a static mail address:

Now the following happens:

  • Running this report in HTML or PDF works just fine and will show a single line chart for the Americas (this is expected).
  • Running this report in the background, with "burst the report", "HTML format" and "save report" selected works just fine (and will save a HTML report for each Retailer region, as expected).
  • Running this report in the background, with "burst the report", "PDF format" and "save report" errors with both "RSV-SRV-0040" and "RSV-SRV-0042".

The "Run as" options described above:

Error Messages "RSV-SRV-0040" and "RSV-SRV-0042" result:

Can anyone confirm this behavior in Cognos Analytics 12.1.2 IF1? Any suggestions on how to resolve it? I really need bursting to PDF to work, converting HTML output to PDF later is not a viable option.

Thanks!

Patrick Neveu's profile image
Patrick Neveu IBM Champion

Hi @Richard Meyer-Eppler

Is it the same issue with another visualization? Are you able to reproduce this issue with samples data?

Do you have specific setup for your PDF output (size, password, embedded fonts, and so on)?

In your cognosserver.log, do you see any other errors around the timeframe for "RSV-SRV-0040" and "RSV-SRV-0042"? I'm thinking it might be a memory issue (PDF and Burst mode). If you could share a few lines from your cognosserver.log, we could have a look.

Best regards,

Patrick Neveu

Richard Meyer-Eppler's profile image
Richard Meyer-Eppler

Hi Patrick,

Thanks for your ideas!

IBM has acknowledged the issue and logged the defect as DT473202. The link is not publicly available yet.

This means that bursting 11.1 visualizations to PDF simply does not work. Neither the IBM support nor we were able to figure out a solution or workaround.

The example above uses the Great Outdoors data module and should be easily reproducible. I tried changing server paramters (e.g. with respect to PDF output and bursting), to no effect.

If anyone manages to avoid this error, please let me know! For now, it seems we are still stuck with the old charts when bursting, which is rather unfortunate.

Patrick Neveu's profile image
Patrick Neveu IBM Champion

Hi @Richard Meyer-Eppler,

Would you be able to share the report spec (based on Cognos samples data)?

Best regards,

Patrick Neveu

Richard Meyer-Eppler's profile image
Richard Meyer-Eppler

Sure, please fine the code below. As explained below, you should see the following behavior (in Cognos 12.1.2 IF 1  / 12.1.2-2604231709):

  1. Running this report in HTML or PDF works just fine and will show a single line chart for the Americas (this is expected).
  2. Running this report in the background, with "burst the report", "HTML format" and "save report" selected works just fine (and will save a HTML report for each Retailer region, as expected).
  3. Running this report in the background, with "burst the report", "PDF format" and "save report" errors with both "RSV-SRV-0040" and "RSV-SRV-0042".
  4. If you put the same data in a crosstab (with a master detail relationship defined), bursting to PDF works fine. 

So we know that a) rendering this visualization in PDF works in principle (because I can individually run the report in PDF format), b) bursting to PDF works in principle (because I can burst a crosstab to PDF) and c) bursting visualizations works in principle (because bursting to HTML works).

The issue described here ONLY occurs when bursting 11.1 visualizations to PDF.

<report xmlns="http://developer.cognos.com/schemas/report/17.5/"           useStyleVersion="latest" expressionLocale="de-de">
				
				<drillBehavior/>
				<layouts><layout><reportPages><page name="Seite1" refQuery="Abfrage1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style><pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style><contents><vizControl type="com.ibm.vis.line" name="Liniendiagramm"><vcDataSets><vcDataSet idDataSet="data" refDataStore="Data-Store"><vcSlots><vcSlotData idSlot="categories"><vcSlotDsColumns><vcSlotDsColumn refDsColumn="Year"/></vcSlotDsColumns></vcSlotData><vcSlotData idSlot="series"><vcSlotDsColumns><vcSlotDsColumn refDsColumn="Retailer region"/></vcSlotDsColumns></vcSlotData><vcSlotData idSlot="values"><vcSlotDsColumns><vcSlotDsColumn refDsColumn="Gross profit" rollupMethod="total"/></vcSlotDsColumns><vcSlotDomain><vcScalarComputed rangeData="all"/></vcSlotDomain></vcSlotData></vcSlots><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Retailer region"/></masterContext><detailContext><dataItemContext refDataItem="Retailer region"/></detailContext></masterDetailLink></masterDetailLinks></vcDataSet></vcDataSets><vizPropertyValues><vizPropertyLengthValue name="vcWidth">50%</vizPropertyLengthValue><vizPropertyLengthValue name="vcHeight">500px</vizPropertyLengthValue></vizPropertyValues></vizControl></contents></pageBody><XMLAttributes><XMLAttribute output="no" name="RS_legacyDrillDown" value="0"/></XMLAttributes></page></reportPages></layout></layouts>
			<XMLAttributes><XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/><XMLAttribute output="no" name="listSeparator" value=";"/><XMLAttribute output="no" name="decimalSeparator" value=","/><XMLAttribute output="no" name="RS_modelModificationTime" value="2024-08-27T17:31:05.853Z"/></XMLAttributes><queries><query name="Abfrage1"><source><model/></source><selection><dataItem aggregate="none" rollupAggregate="none" name="Retailer region"><expression>[C].[C_Fred_Data_Module].[Retailers_Base].[Retailer_region]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="3"/><XMLAttribute output="no" name="RS_dataUsage" value="0"/></XMLAttributes></dataItem><dataItem aggregate="none" rollupAggregate="none" name="Year"><expression>[C].[C_Fred_Data_Module].[Time_Base].[Year_]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="1"/><XMLAttribute output="no" name="RS_dataUsage" value="0"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Gross profit"><expression>[C].[C_Fred_Data_Module].[Sales].[Gross_profit]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="2"/><XMLAttribute output="no" name="RS_dataUsage" value="2"/></XMLAttributes></dataItem></selection></query><query name="Abfrage2"><source><model/></source><selection><dataItem aggregate="none" rollupAggregate="none" name="Retailer region"><expression>[C].[C_Fred_Data_Module].[Retailers_Base].[Retailer_region]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="3"/><XMLAttribute output="no" name="RS_dataUsage" value="0"/></XMLAttributes></dataItem><dataItem name="Static Mail Address"><expression>&apos;dummy@dummy.com&apos;</expression></dataItem></selection></query></queries><modelPath type="module">/content/folder[@name=&apos;Beispiele&apos;]/folder[@name=&apos;Nach Feature&apos;]/folder[@name=&apos;Hauptkomponenten&apos;]/folder[@name=&apos;Daten&apos;]/module[@name=&apos;Abenteuer und Freizeit - Datenmodul&apos;]</modelPath><reportDataStores><reportDataStore name="Data-Store"><dsSource><dsV5ListQuery refQuery="Abfrage1"><dsV5DataItems><dsV5DataItem dsColumnType="indexed" refDataItem="Retailer region"/><dsV5DataItem dsColumnType="indexed" refDataItem="Year"/><dsV5DataItem dsColumnType="value" refDataItem="Gross profit"/></dsV5DataItems></dsV5ListQuery></dsSource></reportDataStore></reportDataStores><reportName>2026-06-03 Master Detail Great Outdoors</reportName><burst refQuery="Abfrage1"><burstGroups><burstGroup refDataItem="Retailer region"/></burstGroups><burstLabel refDataItem="Retailer region"/><burstRecipient refQuery="Abfrage2" refDataItem="Static Mail Address"><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Retailer region"/></masterContext><detailContext><dataItemContext refDataItem="Retailer region"/></detailContext></masterDetailLink></masterDetailLinks></burstRecipient></burst></report>
Patrick Neveu's profile image
Patrick Neveu IBM Champion

Hi @Richard Meyer-Eppler,

The only workaround is to use v11.0 visualizations. I did the test with a pie and it is working as expected.

Best regards,

Patrick Neveu