Differences between running a 32 and 64 bit Report Server with IBM Cognos 10.1 RP1 (10.1.1)

Besides the difference in size of addressable memory space, what are the other considerations of running a 32-bit vs 64-bit report server?

Why is a "QFS-ERR-0141: This report service is configured as 64-bit and only supports packages published with the dynamic query mode" error message being returned when trying to run a report with a 64-bit report service?

Answer

- A 64-bit Application Tier install of 10.1.1 (RP1) will by default be running a 32-bit report server.
- A 64-bit install of 10.1.1 (RP1) running a 32-bit report server will launch a 64-bit java process for Dynamic Query Mode (DQM) enabled packages and will also launch a 32-bit BIBUS processes for CQM packages.

- A 64-bit install of 10.1.1 (RP1) running a 64-bit report server can only launch a DQM java process. It cannot launch BIBUS processes hence it is only to be used with DQM packages and not CQM packages.

- If an environment has a 64-bit report server and Compatible Query Mode (CQM) packages, you must configure package routing to ensure that none of the requests for CQM packages go to the 64-bit report server. In RP1, a 64-bit report server will accept a request it receives for a CQM package even though it cannot launch a process that can handle it. QFS-ERR-0141 errors will occur unless package routing has been configured to route CQM requests, like those for reporting off PowerCubes, to 32-bit report servers only.

Comments

Post a Comment

Popular posts from this blog

Cognos 10 Active Report - Swipe Gesture

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...
Read more

How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it?

The AM_NamespaceReport Utility allows you to extract the namespace to an XML file. 1. Use the AM_NamespaceReport Utility to extract all users from the namespace to an XML file. am_namespacereport -h > -p > -r > -n > -D > -w > -f all -o > e.g am_namespacereport -h cognoscamsevr -p 4004 -r o=cognos.com –n devcam -D admin -w admin -f all -o c:\temp\usrlst.xml 2. This will extract all user information to an XML file 3. Import the xml file into XLS spread sheet 4. Create ODBC connection using the ms-excel spread sheet driver 5. Create Data Source Connection and proceed creating FM Model & Publish 6. Create Report using Report Studio. 7. Save & Share the report The Access Manager Administration Guide (Appendix A) contains further information on this functionality.
Read more

RSV-VAL-0032 expression is not valid. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'.

Image
Problem: RSV-VAL-0032 The following expression is not valid: [AdjRowsReturned] = 0. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[AdjRowsReturned]' is invalid Resolution: You might have used the calculated data item in the variable, which needs to be added in the page properties. - Click on the page and go to properties. Make sure you see 'page' on the top of the properties. - Click on properties icon under data section, you'll get pop up icon - Check mark the data item which is used for variable calc. You are good to go.Find the snapshot. .
Read more