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

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

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 << host >> -p << port >> -r << basedn >> -n << namespace >> -D << username >> -w << password >> -f all -o << path to filename.xml >> 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

BME-EX-0047 Unable to read preferences for the requested interface..

Issue When opening or creating a Framework Manager project the following error message is shown. Additionally, when attempting to create or open a report based on a package is made in Report Studio or Query Studio, the same error message is shown. Error BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface. Resolving the problem This happens due to a corrupt bmt.ini file in <Install Location>/c8/configuration directory. This issue can be resolved by extracting bmt.ini from last known good backup or even from installation files.
Read more