text:
This action might not be possible to undo. Are you sure you want to continue?
Cognos Tool Known Errors and its Resolution Document
Table Of Content
1.1 Batch report and report service error................................................................2 1.2 Content Manager Service Errors........................................................................7 1.3 Delivery Service Errors....................................................................................12 1.4 Event Management Service Errors..................................................................15 1.5 Job Service Errors............................................................................................17 1.6 Monitoring Service Errors................................................................................18 1.7 Agent Service Errors........................................................................................19 1.8 Report Data Service Errors..............................................................................23 2. PowerPlay Transformer......................................................................................26 3. Cube generation................................................................................................28 4. Café tool............................................................................................................ 31 5. Framework manager.........................................................................................33 6. Configuration.....................................................................................................38 7. Other Errors.......................................................................................................46
Page 1
Cognos Tool Known Errors and its Resolution Document 2
Cognos 8 services, Cognos reporting studios 8.3 except metric studio , Framework manager 8.3, PowerPlay Transformer 8.3, Café tool 8.3 plug-in and Cognos connection 8.3.
Cognos Tool Known Errors and its Resolution
1.1 Batch report and report service error
S. No
Cognos Service/ Compon ent
Batch report and report service error
Error Code
Recommended Resolution/Action
The given report specification is not a valid XML document. The specification is not valid XML. Provide a valid specification.
Resolving the problem Report specification seems to be corrupted due to incorrect deployment or any invalid change in the report or any change in content store. Replace the report specification with the last deployed version from configuration management tool or with the last working back-up copy.
Batch report and report service error
There are no sessions currently available. Please contact your Administrator. The server is busy. Wait and try again or get the administrator to increase the number of requests that can be handled by the system.
Resolving the problem This is related to Cognos configuration. Contact administrator and report the problem, this error has occurred due to the fact that no. of user request for a particular service has increased beyond the limit set for that service. Workaround: Try after sometime (approximately 30 minutes later).
Page 2
Cognos Tool Known Errors and its Resolution Document 3
3. Batch report and report service error RSV-BBP0029 Failed to cancel the request: CAM-CRP0026 An error was returned from the underlying socket implementation. RSV-BBP-0029 Failed to cancel the request: CCL-BIT-0005 A socket reported a communication error. or CM-SYS-5144 While processing your request, Content Manager locked some objects for 703.491 seconds. This lock may have caused some other requests to be abandoned. 4. Batch report and report service error RSV-CM0004 Error 'RSV-CM-004 ... capabilities required to execute the 'runSpecification'' running adhoc reports Resolving the problem Ensure that the relevant user(s) are members of both "Controller Administrators" and "Controller Users" security groups, inside Cognos Connection. http://www01.ibm.com/support/docview.wss? uid=swg21371052 5. Batch report and report service error RSV-DST0012, RSVDST-0013 or CM-REQ4315 An error occured while saving the output for the burst instance <param index="1" type="string"/> with the recipients (<param index="2" type="string"/>). Here are the details: <param index="3" type="string"/> The most likely cause is that the burst recipient list contains an invalid recipient. For more information, see the details. If the problem Resolving the problem Change //group to //role in the burst key expression definition. Steps: 1. Open the report in Report Studio. 2. In the Query Explorer pane, select the particular query. 3. In the Data Items pane, select the burst key. 4. In the Properties pane, select Expression and click the ellipsis. 5. In the Data Item Expression window, change //group to //role. 6. Click OK. 7. Save the report. http://www01.ibm.com/support/docview.wss? uid=swg21341475 Resolving the problem Contact network administrator to reduce the MTU size (a networking parameter) from 1500 to 1400 http://www01.ibm.com/support/docview.wss? uid=swg21342486
Page 3
Ensure that the user in question has Execute and Traverse permissions (either explicitly. 4. 2. http://www01. Steps: 1.wss? rs=3442&context=SS9RTN&context=SSW GNW&uid=swg21402602&loc=en_US&cs= UTF-8&lang=en Workaround: Reduce the amount of data in the report. hyperlink or HTMLItem objects.com/support/docview. The list of subcapabilities is displayed. correct the report or update the data in the database to generate valid recipients 6. you must also have "Read" and "Traverse" permissions on the "Report Studio" capability.Cognos Tool Known Errors and its Resolution Document 4 is recipient related. Batch report and report service error RSV-RND0017 This report has been truncated since it exceeds the Excel spreadsheet row limit. Click Tools and select Capabilities. 7.ibm. http://www01. 3. or by being a member of a group or role that has this permission) Note: In Cognos 8. Resolving the problem In the report specification-Set "Rows per Page" property to default. Go to the Cognos Connection portal. Click the Set Properties button beside the HTML Items in Reports capability.wss? uid=swg21344861 Page 4 . The list of available capabilities is displayed. 5. Click Report Studio (not the settings button). Batch report and report service error RSV-RND0079 The user does not have the capabilities required to execute a report that contains button. Resolving the problem You must have Execute and Traverse permissions on the HTML Items in Reports capability (a sub capability under Report Studio).ibm. Log in as a user with administration rights.com/support/docview.
modify the firewall settings for the Cognos 8 ports. Details: RSV-SRV0042 Trace back Cause This error typically indicates a timing condition in long-running reports. In this mode. Ensure that the minimum hardware requirements for Cognos 8 have been met. RSV-UPG0014 Can't find Java class "<param index="1" type="string" usage="The name of the Java class. RSV-BBP-0022 The absolute affinity request 'asynchWait_Request' failed. If this request isn't received for over 30 seconds (the default async timeout) due to delays in the architecture. Reports that run for more then 7 seconds enter an "asynchronous communication" mode.com/support/docview.ibm. Ensure that settings for a local firewall are not interfering with Cognos 8. the requested session does not exist. If the same report is run again it may run with no error message. Resolving the problem Possible environmental causes and solutions of this error: 1. or if that is not an option. http://www01. RSVUPG-0004. 2. 9.Cognos Tool Known Errors and its Resolution Document 5 8. This error is generated when the dispatcher then receives the "wait" request for the closed session. as this may interfere with the communications. Ensure that multiple browsers (more then 2) aren't being used on the workstation.wss? uid=swg21340994 Workaround: Page 5 . the session sends periodic "wait()" requests to retrieve the data. Either disable the local firewall. the dispatcher closes the session. Batch report and report service error RSV-BBP0022 and RSV-SRV0042 Unable to run reports: RSV-BBP-0022 and RSV-SRV-0042 When a report is run. an error message occurs. Resolving the problem Ensure that the JAVA_HOME environment variable points to the Java Runtime Environment (JRE) supported by this version of Cognos 8."/>". Batch report and report service error RSV-UPG0003.
there is a poor-quality wireless network or WAN connection See IBM Technote #1344573. If this request is not received for over 30 seconds (= the default async timeout) due to delays in the architecture.The report server is overloaded. Typically the error is because a longrunning report has timed out. refer to separate IBM Technote #1340993. and they include the following: Scenario #1 . Please contact your administrator.Network connection between client device and Report server is slow For example.Three (3) or more browser sessions are being used on the client device simultaneously See IBM Technote #1340994 Scenario #4 .702#4 Cause 'standard reports' are powered by a Cognos 8 BI reporting engine. 10. the dispatcher closes the session.Firewall is interfering with communication between the client and the report server See IBM Technote #1340994 Scenario #3 . There are several potential root causes for this timeout. MORE INFO Reports that run for more then 7 seconds enter an "asynchronous communication" mode. For a full explanation of this process. the session sends periodic "wait()" requests to retrieve the data. This error is generated when the dispatcher then receives the "wait" request for the closed session. Page 6 . The complete error has been logged by CAF with SecureErrorID:200905-08-10:19:27. Batch report and report service error RSV-BBP0022 RSV-BBP-0022 The absolute affinity request 'asynchWait_Request' failed. because the recommended hardware specifications have not been met See separate IBM Technotes #1340994 & 1339581 for more details Scenario #2 . In this mode. the requested session does not exist. DPR-ERR-2082 An error has occurred. The error message is triggered because there is a problem with this Cognos 8 BI reporting engine communicating to the end user's Microsoft Internet Explorer session.Cognos Tool Known Errors and its Resolution Document 6 Try scheduling the report.
Oracle 10g Resolving the problem Replace the JDBC-driver in Cognos with the one from the DB-client. Steps: 1. Close all the instances of the browser.Try scheduling the report.Cognos Tool Known Errors and its Resolution Document 7 Resolving the problem Solution #1 . 1. Solution #2 . 3. Navigate to your Oracle DB-Client <OracleClient_ROOT>/jdbc Page 7 . For other scenarios: 1. to reduce the chance of a timeout For example. Environment System Z. increase the timeout from the default (30 seconds) to something larger (for example 60 or 90 seconds) See IBM Technote #1344573 for complete details.2 Content Manager Service Errors S. 2. No Cogno s Servic e/Com ponent Content manager service error Error Code Description Recommended Resolution/Action 1. Re-login and Try re-running the report. 4.log Corruption of the JDBC-driver. http://www01.wss? uid=swg21385378 Workaround for Scenario #3: 1.Increase the Cognos 8 async timeout parameter. Resolve any issues that are found with your system.Review the Technotes referred to inside the scenarios above.com/support/docview.ibm. Delete cookies and temp files. CM-SYS-5007 CM-SYS-5007 when trying to start Cognos 8 service in cogserver.
3. These users also have sufficient permissions on all the report's ancestors including the report's package. http://www01.Cognos Tool Known Errors and its Resolution Document 8 2. This change will make it so that the layout from the other report is copied to this report then and only then.jar or classes12. Copy the JDBC-driver (ojdbc14.zip .com/support/docview.ibm. Log in as System Administrator if necessary. 3) Select the Layout Component Reference that is in the report. Steps:1) Log in as someone who can run the report.ibm.depends on your Cognos 8 / JRE version) to the following directory: <C8_ROOT>/webapps/p2pd/WEB-INF/lib http://www01. 2) Open up the report in Report Studio. Users are getting permission errors like the one below when attempting to run a report for which they have Execute and Traverse (and maybe more) permissions for.wss? uid=swg21343265 2. Content manager service error CM-REQ-4193 and CM-CFG5049 Package Export Fails with CM-REQ-4193 and CM-CFG-5049 Cause A package in the deployment definition no longer exisits in Cognos Connection. Content manager service error CM-REQ-4011 4. 4) In its properties window. rather than every time the report is ran.wss? uid=swg21342718 Workaround: Have someone who does have appropriate permissions change the Layout Component Reference's Embed property from Reference to Copy. Resolving the problem Remove the non-existant package from the deployment export definition. change the Embed property from Reference to Copy permissions. Cause The report that was to be run contained a Layout Component Reference that was referencing a report for which the user did not have adequate Resolving the problem Provides appropriate permissions on the report that report that is being run's Layout Component Reference is using. CM-REQ-4011 errors even though sufficient permissions defined for a report and its ancestors.com/support/docview. Content manager service CM-REQ-4023 CM-REQ-4023 You cannot create an object at the location Cause A folder name was changed within Cognos Page 8 .
. Environment Windows 2003 Server Oracle Server 9.0. Content manager service error CM-REQ-4159 Error logging into Cognos Connection CM-REQ-4159 Content Manager has returned an error in the response header..2.2.. Cause Scenario where the end user's Cognos 8 BI Reporting Service user profile (located in the content store) is invalid/corrupt.6.> when scheduled reports execute.6. but it need not be the primary key. Resolving the problem Disable the scheduled task. This will recreate the association to the new folder location.PK_CMOBJE CTS) violated • create a new content store and make a full deployment from the old content store Steps: Page 9 . http://www01.> when scheduled reports execute CM-REQ-4023 You cannot create an object at the location <. The originally scheduled report referenced a location that no longer exists or no longer matches the original path. This error will also be generated if an existing record is updated to generate a duplicate (unique) key.doc 6.com/support/docview.Cognos Tool Known Errors and its Resolution Document 9 error <. Typically this is a duplicate primary key. Connection.0. Content manager service error CM-SYS-5100 CM-SYS-5100 Content Manager internal error occurred • • error appears while trying to open or to execute a report system hangs after the error appears Cause This error means that an attempt has been made to insert a record with a duplicate (unique) key.0 UTF-8 instance of database Resolving the problem CM-SYS-5001 Interner Content ManagerFehler ist aufgetreten. This only affects previously scheduled reports new schedules execute without error.0 JDBC 9. Resolution Refer embedded document: CM-REQ-4159. ORA-00001: unique constraint (COGNOS8.wss? uid=swg21340398 5.0 Oracle Client 9.ibm.2. and then reenable it..
com/support/docview. Content manager service error DPR-ERR2058 Content Manager Error When Starting IBM Cognos 8 In the cogserver.com/infocenter/c 8bi/v8r4m0/index.4.im.0. When connecting to http://computer name/cognos8.ibm.doc/inst_cr_winux_id25040Cont entManagerErrorWhenStartingCog. Will retry periodically.8. IBM Cognos Configuration can no longer locate it.swg.inst_cr_wi nux.jsp? topic=/com.log file.ibm. To correct the problem.ibm. http://publib. If this user ID is moved to another group. The dispatcher is still initializing • SoapSocketExc eption: Connection Refused Page 10 .cognos.wss? uid=swg21340367 7. the following error appears: An attempt to register the dispatcher in Content Manager was unsuccessful.boulder.Cognos Tool Known Errors and its Resolution Document 10 • • • • • • create a new schema in your oracle db server for the new content store open Cognos Connection -> Tools -> Content Administration use the export functionality to make a full deployment open Cognos Configuration and enter under Data Access -> Content Manager -> Content Store the new content store restart the server make an import of the full deployment http://www01. the following error messages appear in the browser: Resolution: IBM Cognos Configuration uses a user ID to bind to the LDAP database.html • DPR-ERR-2058 The dispatcher cannot service the request at this time. move the user ID back to the original group.
wss? uid=swg21341492 9. http://www01. the deployment directory is on a NFS mounted drive which is available to all distributed servers. In addition.ibm. the deployment directory should be accessible by all distributed servers e. UNC will require that the Service run as a Domain Account [which is required anyway for integration with Print Spoolers or access to MSAS].com/support/docview. Cause The deployment location should be accessible from all Content Manager hosts so that it is available regardless of any failover of the Content Manager. It can be on a generic File server. Prod) to refer to the same Deployment Location. Environment This is a multi-server install. Content manager service error CM-REQ-4132 CM-REQ-4132 The existing deployment archive 'Package Name' could not be removed from the file system. and this would provide the facility to migrate content from one Environment to another without any need for direct access to the hosts. Open Cognos Configuration 2. Under Environment.g. Error when exporting a package using Cognos 8 deployment. with one active Content Manager and one stand-by content manager. MSG_NOT_FOUND=cm CannotUpgradeInStand ByMode Cause Incorrect signon specified for the account used to connect to the content store Resolving the problem Verify that the correct username and password for the database user account is specified in Cognos Configuration for the content store settings. Deployments file Page 11 . Content manager service error CM-CFG-5063 CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. Test. We recommend that all Content Managers and Application tier hosts access the same shared Deployment location using NFS on UNIX or UNC on Windows. Configure the multiple environments (Dev. Steps: 1. Resolving the problem Use absolute instead of relative path to define the deployment directory in Cognos Configuration. Error occurs when the stand-by content manager becomes active.Cognos Tool Known Errors and its Resolution Document 11 8.
Unix Resolving the problem 1) Enable Delivery service. Delivery service can be enable in IBM Cognos Page 12 . Delivery service CNC-BAL-0509 and CNC-DS-0001 When trying to run scheduled report which send output by email. This is to prevent any unauthorized sender to send messages through that server. 2. If we check the status of the report in Cognos Cause Delivery service was disabled. specify a UNC (Windows) or NFS (Unix) path 3. http://www01. Scheduled reports fail to send by e-mail even though the SMTP server tests fine in Cognos Configuration. 5.com/support/docview. SMTP servers are configured to block any relay messages from servers which are not on the authorized list. CNC-SDS-0335 CNC-SDS-0335 Error returned from SMTP server. A. Repeat steps 1-3 on each Cognos 8 server.wss? uid=swg21340924 Workaround: Copy the content of deployment folder from the location defined for active CM to the deployment folder location defined for stand-by CM. 1. Environment Windows. 4. add the IP of the Cognos application server(s) to the authorized sender list. we encountered the below error message.Cognos Tool Known Errors and its Resolution Document 12 location. Resolving the problem On the SMTP server.ibm. Restart Cognos 8. Save the Configuration.3 Delivery Service Errors S. Cognos Service/Compo nent Delivery service Error Code Description Recommended Resolution/Action By default.N o 1. Multiple error messages are generated.
when the same report will be add to an event with option save more than once. In the file cogserver. port: 25</trace> Problem with mail server. Environment IBM Cognos 8 BI Event Studio Resolving the problem In Cognos Connection.com/support/docview. increase the number of occurrences or set the duration at least to one day. in the properties of the attached report.under status section. http://www01. It is required to be up and running in order to forward report or report link to the intended recipients.under Environment. Cognos configuration (require a restart of Cognos 8) .log under the logs folder where Cognos 8 is installed. the first output will be removed as soon the second output is created. its status is unavailable in the "run by" column. Open Cognos Page 13 . The below error message was logged <trace>CNC-DS0001 The following Delivery Service general error occurred: Could not connect to SMTP host: mailserver. only one report output version will be kept. Steps: 1. port: 25Could not connect to SMTP host: mailserver. Delivery service CNC-DS-0008 Same report attached twice (or more) to an event result in a HTML file with error: CNC-DS0008 CNC-DS-0008 No output available for: < >c Cause By default. Your request could not be fully processed.ibm. This means.w ss?uid=swg21343405 administration. CNC-BAL-0509 One or more errors have occurred.Cognos Tool Known Errors and its Resolution Document 13 Administration . Cognos 8. or B. 2) Check if SMTP server is up and running. will test again in 10 seconds 3.
ensure that Adobe Reader is installed in the path of the user that starts IBM Cognos 8. • Ensure that the IBM Cognos 8 server is started using an account that has access to the network printer.com/support/docview.0. To correct the problem. Unable to Print PDF Reports There may be no error messages and the status of the print job is Succeeded. system accounts may not have access to network printers.Cognos Tool Known Errors and its Resolution Document 14 Connection In the properties of the report.ibm. • When you define the Page 14 . http://www01. Sometimes.w ss?uid=swg21342404 4.5 or later is installed on each computer where IBM Cognos 8 servers are installed. ensure that the lpstat -v command returns a configured printer and that a printer variable is defined. Delivery service CNC-GEN-2107 CNC-GEN-2107: An unexpected error has occurred. • If IBM Cognos 8 is installed on UNIX. increase the number of occurrences or set the duration at least to one day. under Report output versions. • If IBM Cognos 8 is installed on UNIX. try the following: • Ensure that Adobe Reader version 5.
com/i nfocenter/c8fpm/v8r4m0/index .cognos .ht ml 1. try using the IP address of the printer instead of the computer name.doc/ug_cra_id375 63UnabletoPrintPDFReports.8. Page 15 . Cognos Service/Compo nent Event management service Error Code Description Recommended Resolution/Action Resolving the problem Ensure that the Notification Database in Cognos Configuration on the Application Tier Cognos 8 servers point to the same CNC-EVE-3102 Unable to persist the event status record. use the following syntax: • For Windows: \ \server_name\printe r_name • For UNIX: printer_name • When you define the network address for the printer.swg.4.im.boulder.jsp? topic=/com. • Ensure that IBM Cognos 8 users have the correct access permissions for the printer.Cognos Tool Known Errors and its Resolution Document 15 network address for the printer in IBM Cognos Connection.ug_cra.0. http://publib.ibm.ibm.4 Event Management Service Errors S.N o 1.
2. 4.then point the notification database on the application tier only install to the content store database that is defined in cognos configuration on the content manager install. http://www01. CNC-BAL0509 One or more errors has occured. Open the report specification from the clipboard 5. 6. DB2 and Sybase databases ensure that the relevant database client/JDBC driver is set up in the c8/webapps/p2pd/WEB-INF/lib directory on the Application Tier servers. Reschedule the report. Create a new report in Report Studio. Reschedule the report http://www01.w ss?uid=swg21339351 Page 16 . CNC-EVE-3105 Unable to update the event status record Resolving the problem Recreate the report using the existing report specification. Open the existing report in Report Studio. If there is NO notification database in cognos configuration on the content manager Cognos 8 server .com/support/docview. 3.Cognos Tool Known Errors and its Resolution Document 16 database defined as the Notification Database in Cognos Configuration on the Content Manager Cognos 8 servers. Copy the report specification to the clipboard. If no notification database is defined on the content store database then it gets built in the content store database and a multserver installation of cognos 8 can only have 1 notification database For Oracle.w ss?uid=swg21339360 2.ibm. Event management service CNC-EVE-3105 CNC-BAL-0509 error when trying to cancel long running reports.com/support/docview. Save the report under a new name.ibm. Save the report with a new name. Your request could not be fully processed. Steps: 1.
Overnight scheduled jobs fail in a multiserver environment. make sure there is a sufficient amount of time between server reboots so that the distributed components are brought back up properly. with gateway servers restarted last. CNCJOB-0025 Encountered an error updating the event status.Cognos Tool Known Errors and its Resolution Document 17 1. the application tier servers (report servers in ReportNet) are next.5 Job Service Errors S. Once the primary content manager is active and running. 2.ibm. In addition. For example. CNC- Resolving the problem Ensure that the Notification Database in Cognos Configuration on the Application Tier Cognos 8 servers point to the same database defined as the Notification Database in Cognos Configuration on the Content Manager Cognos 8 servers. it is unlikely that a multiserver environment (or a slower single server) will be up and ready to process those requests in such a short time frame. Job service CNC-JOB-0025 Unable to schedule or save report: CNCJOB-0025 Encountered an error updating the event status. This is especially true for the content manager server which must be up and fully running before any of the other servers are restarted.com/support/docview.N o 1. Cognos Service/Compo nent Job service Error Code Description Recommended Resolution/Action Cause timing of server reboots Resolving the problem Change the time of night that Cognos servers are restarted so that there are no active schedules.w ss?uid=swg21340925 CNC-JOB-0004 CNC-JOB-0004 An error has been encountered in one of the steps associated to the job. If there is NO Page 17 . http://www01. if reports are scheduled to kick off at 5:05 AM.
Consult the log files.client/JDBC driver is set up in the c8/webapps/p2pd/WEB-INF/lib directory on the Application Tier servers.N o 1. Job service CNC-JOB-3300 Unable to retrieve the Job details from Content Manager. http://www01.6 Monitoring Service Errors S. ensure that the relevant database directory on the Application Tier servers. Unable to add a Job. More than one Job exists in Content Manager for the given search path. 1.com/support/docview. Job service CNC-JOB-3302 5.Cognos Tool Known Errors and its Resolution Document 18 EVE-3102 Unable to persist the event status record. DB2 and Sybase databases. Cognos Service/Compo nent Monitoring service Error Code Description Recommended Resolution/Action Cause The system had 4 content CNC-MON-0024 Using Cognos Administration on a Page 18 . Resolving the problem Ensure that the path is correct and the user has the necessary permissions. notification database in cognos configuration on the content manager Cognos 8 server .w ss?uid=swg21339360 3. Job service CNC-JOB-3306 Resolving the problem Correct the searchPath so that only one job is run. 4. If no notification database is defined on the content store database then it gets built in the content store database and a multserver installation of cognos 8 can only have 1 notification database For Oracle. The JobService is currently disabled.then point the notification database on the application tier only install to the content store database that is defined in cognos configuration on the content manager install. Resolving the problem Enable the job service.ibm.
Monitor Service paging error: Failed Logon:com.ibm. Then add the notification database to the configuration again.N o 1. Cognos Service/Compo nent Agent service Error Code Description Recommended Resolution/Action Resolving the problem The error is caused by an CNC-ASV-0001 CNC-ASV-0001 Agent Service general error: Page 19 . This should allow correct access to the Cognos Administration Page.com/support/docview. managers.ibm. Save and restart.w ss?uid=swg21343394 1. save and restart.com/support/docview. Alternatively. the notification code on the servers that don't know about that content manager won't know to use their local content manager database connection information.jnetdirec t. http://www01.Cognos Tool Known Errors and its Resolution Document 19 multi-node system is showing errors sporadically in logs and in the gui.configurations.w ss?uid=swg21371582 2. Monitoring service CNC-MON-0024 CNC-MON-0024 Monitor Service Paging Error: invalid arguments in call Resolving the problem Delete the Notification Database from the Cognos Configuration / Data Access / Notification. ensure that a Notification Database is added and configured on the dispatcher.7 Agent Service Errors S.jsql. If the active content manager fails over to one of the content managers that isn't configured in all the is added and configured on the dispatcher. Resolving the problem Ensure that all dispatchers contain a complete list of all the content managers in the system. but several of the installations only referenced two or three of them. http://www01.
Resolving the problem Enhance the event condition with a boolean condition that provokes at least one database access and where the result is always true. If you limit the results to fewer values the email sends correctly.w ss?uid=swg21339566 2. maximum([Introduction date])) > 0 and sysdate() = 2008-0327' example 2 : Instead of '1=1' use ' caption of [xxx] = 'xxx' ' http://www01.ibm. not even on March. For example the following event condition 'sysdate() = 2008-03-27' is never met.Cognos Tool Known Errors and its Resolution Document 20 Exception occurred: java. event returning too many results. http://www01. Agent service CNC-ASV-0050 'CNC-ASV-0050 Event condition not met' although conditional expression is true Event conditions are never met as long as there is no direct transaction on any data base table or the cube. When trying to send an email from Event Studio through the preview window or through Scheduling it fails after about 10 minutes with the following error: CNC-ASV-0001 Agent Service general error: Exception occurred: java. example 1 : Instead of 'sysdate() = 2008-03-27' use ' 'extract(day.com/support/docview.OutOfMem oryError.lang.lang.com/support/docview.ibm.w ss?uid=swg21342900 Cause 3. 27th of 2008. Agent service CNC-ASV-0025 CNC-ASV-0025 Page 20 . The same behaviour can be investigated when the '1=1' condition is used.OutOfMem oryError. Cause An event condition does not cause any transaction on any of the database's tables or to the cube as long as the result can be calculated.
those should stay as true.js p? topic=/com.rdm_cmm.wsif.apache.8. Resolving the problem Change all the cognos8 services from true to false on all jobservers except for Dispatcher and Planning Jobserver.0. Agent service CNC-ASV-0025 CNC-ASV-0025 Agent Condition invalid: DPR-ERR2056 The Report Server is not responding.Cognos Tool Known Errors and its Resolution Document 21 Agent Condition invalid CNC-ASV-0025 Agent Condition invalid: RSV-SRV0040 An application error has occurred.html Cause The event condition was using a calculation that did not account for dividing by zero.WSI FException: CloneNotSupported Exception cloning context.cognos . 5. Resolving the problem The original condition was: [Difference] > 0 For the [Difference] calculation. 1 appserver with all cognos8 service set to true and 10 jobservers with cognos8 service set to true except for Presentation.ibm.doc/rdm_cmm _id242Error_When_Calling_Rep ort_Trigger.ibm.im.w ss?uid=swg21348047 This problem is related to the replacement of the Sun Java Runtime Environment (JRE) by IBM Java Runtime Environment (JRE) in this release of IBM Cognos 8.boulder. modify the bootstrap_win32. http://www01.swg. org.xml file in the c8_location\bin directory by adding the following line of code for the spawn element under <process name="catalina"> : <param condName="$ {java_vendor}" condValue="IBM">Xss128m</param> http://publib.4.good()). To avoid this problem. Report and Planning Administration Console service were set to false.ibm.CNC-ASV-0007 An error occurred with the agent Web service task. Running event studio agent fails and causes report server to shut down. Save and restart the cognos configuration. Page 21 .com/i nfocenter/c8bi/v8r4m0/index. you must use the following expression: 4. Contact your Administrator. CCLAssertError:0:Fa tal: CCL_ASSERT(config Stream. Agent service CNC-ASV-0007 CNC-ASV-0007 Error When Calling a Report Trigger From a Web Service Task.com/support/docview. The operation failed.
for the service: http://www.ibm. Resolving the problem Append the URL with ?wsdl to retrieve the XML description of the web service. Restart Cognos services after the file is placed at the appropriate location. The specified module could not be found.com/support/docview.ibm.so: open failed: No such file or directory. WSDL cannot be parsed. Agent service CNC-ASV-0025. CCL-PLG-0001 Failed to load the pluggable shared library. (D:/Program Files/cognos/c8\. It was either moved or deleted by a user. If it's a distributed system you can copy it from the other server or else you would need to copy it from backup of file system.so to <install Dir>/c8/bin directory.so was not existing at location <install Dir>/c8/bin .ibm. BIBusTKServerMain: fatal: libcrxapi.asmx?wsdl http://www01. CCL-PLG0001 CNC-ASV-0025 Agent Condition invalid: CCL-PLG0001 Failed to load the pluggable shared library.w ss?uid=swg21380306 6.cpi) CCL-SRV-0501 The server process caught an unexpected exception.com/support/docview.ws/hndcap. Agent service CNC-ASV-0022 CNC-ASV-0022: Agent web service task error. 7. For example.pliant software./bin \AuthoredReportGe nerator. Resolving the problem To resolve this issue you would need to copy libcrxapi.ws/hndcap.com/support/docview. http://www01. CCLSRV-0501.asmx instead use: http://www.Cognos Tool Known Errors and its Resolution Document 22 if ([YesterdayUnits] <> 0) then ((([TodayUnits] [YesterdayUnits])/ [YesterdayUnits])*100) else (0) The original expression for the [Difference] calculation was [TodayUnits] [YesterdayUnits]/ [YesterdayUnits])*100 http://www01.pliantsoftw are.w Page 22 .w ss? uid=swg21410532&myns=swg imgmt&mynp=OCSS9RTN&my nc=R Cause The libcrxapi.
8.com /infocenter/caapps/v8r4m0/in dex. RDS-ERR-1000 Report Data Service Could Not Process the Response from the Content Provider. In WebSphere.cogn os. The WebSphere documentation tells the administrator how to do this. Cognos Service/Compo nent Report data service Error Code Description Recommended Resolution/Action Set the Class Loader Policy in WebSphere For WebSphere. • Cut the layout object from the conditional block into a new conditional block.Cognos Tool Known Errors and its Resolution Document 23 ss?uid=swg21339645 1. this error occurs if another XML parser.im. or table. Edit the Report To avoid problems with report layout. you must modify the report by performing one of the following: • Take the repeater or repeater table out of the block or table.4.doc/ug_cra_id 38106Troubleshooting. such as Xalan is colliding with the one RDS uses.ug_cra.swg.html 2.0.boulder. Report data service RDS-ERR-1022 The Request Received by Report Data Service Is Not Valid Resolving the problem This error message could indicate that someone is trying to externally access RDS.ibm. block. the best solution is to set the Class loader policy to PARENT_LAST.jsp? topic=/com. http://publib.8 Report Data Service Errors S. Page 23 .N o 1.ibm.
0. such as IBM Cognos 8 or PowerPlay is not responding.jsp? topic=/com.ibm. this error occurs when trying to log on to the 3. There may be iterations to get complete date and then try merging it into one output format manually.doc/ug_cra_id381 06Troubleshooting.ug_cra. Report data service RDS-ERR-1005 The Logon Requirements for IBM Cognos 8 Could Not Be Obtained.cognos .jsp? topic=/com.boulder.Cognos Tool Known Errors and its Resolution Document 24 Stop and restart RDS.4.ibm. http://publib. Increase the size limit for report data by changing the Governor limit setting.8.swg.ibm.swg.com/i nfocenter/caapps/v8r4m0/inde x.ibm.com/i nfocenter/caapps/v8r4m0/inde x. lesser prompt values to reduce the data volume fetched by the report. Check the server log for error messages related to these providers. You May Already Be Page 24 .ibm.0.ug_cra.4.cognos .doc/ug_cra_id381 06Troubleshooting. Resolving the problem The provider.boulder.ibm.8.html Resolving the problem Generally. http://publib. http://publib.8.4.0.im.im. Ensure that IBM Cognos 8 or PowerPlay is running.html Resolving the problem A report fails because it exceeds the data size limit set by the administrator.ug_cra.com/i nfocenter/caapps/v8r4m0/inde x.boulder.jsp? topic=/com.cognos .doc/ug_cra_id381 06Troubleshooting.html Workaround: Re-run the report with smaller date range.swg.im. Report data service RDS-ERR-1031 Report Data Service was unable to retrieve the metadata for Name 5. Report data service RDS-ERR-1023 The Report Name Could Not Be Run Because It Exceeds the Report Data Service Data Size Limit Set by the Administrator 4.
specified burst key.jsp? topic=/com. http://publib. does not exist • the requested version does not have any outputs that meet any of the accepted formats.0. • you do not have sufficient access permissions to retrieve this output To run the report. such as XML. or burst ID.ibm. you must have execute permission for the report and traverse permissions for the folder that Page 25 . Report data service RDS-ERR-1044 The Output for the Requested Version for Object NameCould Not be Retrieved • the requested report version name.boulder.doc/ug_cra_id381 06Troubleshooting.ibm. This problem can be caused by one or more of the following: 6. or HTML The report author did not specify a default format to be used when the report is run. In some cases. it may indicate a problem with a security setup such as SiteMinder.swg.8.im.ug_cra.html Resolving the problem The report output version that you want to run cannot be retrieved from the content store. Ensure that you are not already logged in.com/i nfocenter/caapps/v8r4m0/inde x. PDF.Cognos Tool Known Errors and its Resolution Document 25 Logged into this Namespace. or the Target Namespace Does Not Exist same namespace twice.4.cognos .
http://www01.com/support/docview.ibm.html Resolving the problem This error occurs if a user (or administrator) tries to cancel an RDS request. http://publib.ug_cra. This can happen if the user clicks Cancel after the administrator has already restarted RDS.N o 1.html 7.cognos .swg. PowerPlay Transformer S.jsp? topic=/com.0.com/i nfocenter/caapps/v8r4m0/inde x.doc/ug_cra_id381 06Troubleshooting.cognos .im. http://publib.8.ibm. Wait for RDS to restart.4. Logon Window pops up with the Page 26 .ibm. but the request no longer exists.4. Transformer reprompts for the security after 60 minutes.jsp? topic=/com.ibm.boulder. The Request is No Longer Running 2.8.im.0.w ss?uid=swg21343193 No error code During cube build process.ibm.swg.boulder. During cube build process. Report data service RDS-ERR-1039 The Request Could Not Be Cancelled.doc/ug_cra_id381 06Troubleshooting.ug_cra.com/i nfocenter/caapps/v8r4m0/inde x.Cognos Tool Known Errors and its Resolution Document 26 contains the report. Cognos Service/Compo nent PowerPlay Transformer Error Code Description Recommended Resolution/Action Cause Namespace timeout was occurring. Transformer reprompts for the security after an hour. Resolving the problem Increase Inactivity Timeout in seconds for Authentication from 3600 to 7200 in Cognos Configuration.
The effect is an incorrect generation of category codes. Open Transformer configuration and save. Be aware that the identical error can be generated by different reason http://www01.ibm. that is not consistent between two cube generations. Page 27 . the positiion of the Cognos Package is systematically placed at the top of the data sources list whereas. PowerPlay Transformer Unable to access service at URL.cgi? b_action=xts. Environment The Transformer model is based on some text files as structural data sources. This solution is only applicable when incorrect URIs used.run& m=portal/close.w ss?uid=swg21343119 Cause When using the MDL format in Transformer 8.Cognos Tool Known Errors and its Resolution Document 27 followning: Please type in your credentials for authentication. and a 3. check Dispatcher URIs for gateway property 3. Save configuration 5.3. Here. the order of data sources is not kept (the reason is unknown at present). Cause Additional/incorrect dispatcher URI in gateway's cognos configuration Resolving the problem Delete the additional/incorrect dispatcher URI from gateway's cognos configuration Steps:1. After each cube build.xts& h_CAM_action=logo nAsPlease check that your gateway URI information is configured correctly and that the service is available. When going to Log On As (to add security to the model).3.Open cognos configuration on gateway server 2. error from transformer Installed Transformer 8.com/support/docview. Unable to access service at URL:http://xxxxx:80/ cognos8/cgibin/cognos. Delete incorrect dispatcher URI 4. it should always be placed at the end. as a fact table. some categories disappear from the report and even from the left "Insertable Objects" pane. 2. getting the below error message. PowerPlay Transformer Opening a cube in Report Studio : some categories do not appear Some Report Studio reports connect to a powercube that was generated by batch.
Then use this PYJ in the cogtr command-line instead of the MDL. Resolving the problem There are at least 2 ways to resolve this: In your datasource connection for the cube on your cognos server. PDSPCT-0020 Unable to open the PowerCube: (Open Data Cache).com/support/docview.w ss?uid=swg21343121 Cause The cube file is not accessible from the system where Transformer is installed. make sure the connection is a shared network directory that the transformer system can access. Cube generation Page 28 .com/support/docview. http://www01.Cognos Tool Known Errors and its Resolution Document 28 Cognos Package as the fact data source. you may continually receive a Data Source Signon window.ibm. Even if you enter in the correct credentials.3 'New Model' wizard errors with Cognos cube packages: PDS-PCT-0020 or BMT-MD-6003.w ss?uid=swg21343154 Workaround for option 1 above: If the above is not viable due to security concerns you can copy the cube locally to the transformer system and place it in the same file system path that is listed in the datasource connection on the Cognos server. If you click cancel you may get the following error: BMT-MD-6003 No connection to the data source could be established. Alternatively. http://www01. the signon window will appear again once you click "OK". 3. 4. PowerPlay Transformer PDS-PCT-0020 or BMT-MD-6003 Transformer 8. cube may be corrupt or may not be a PowerCube. Resolving the problem Always save categories in the model after each cube build OR Place the fact data source at the end of the list and save the model as PYJ. Cube path/name may be incorrect.ibm. The only caveat for option 2 is if the original cube is updated you will need to copy it over to the transformer system again so it has the latest version.
the cube build succeeds.Restart Transformer.N o 1.Save the file . When the amount of data is reduced in that data source.3. then a folder named CS7Gateways should exist under /cognos/c8.ini . the Cognos 8 service is started with the "Local System" account which is unable to access network resources.com/support/docview.ini. This file replace the old cer*. Resolving the problem With older versions of Transformer.Cognos Tool Known Errors and its Resolution Document 29 S. If this is the case. and to increase SortMemory in the file cer*. 2. TR0109 .ibm. a solution would be to redirect TEMPFILEDIRS to another disk with enough available space.TR3312 Building a cube : errors TR0109 TR3312 . Cube generation PDS-PCT-0020 PDS-REC-0021 Cannot test datasource connection to secured powercube on Cannot test datasource connection to secured powercube on. Cannot test datasource connection to secured powercube http://www01. but this file does not exist anymore in version 8. Steps: .w ss?uid=swg21343222 Symptom PDS-PCT-0020 Unable to open the PowerCub PDS-REC-0021 (Open Data Cache).ini files.ini can be found. Cube path cube may be corrupt or may not be a PowerC Cause By default. In that directory.Open cs7g. Page 29 . The first thing to do is to verify that "Series 7 IQD Bridge" has been installed with Transformer 8. there is a /bin directory where a file named cs7g.DMS-EGENERAL during open cursor.Add the following variables under the [Services] section : TEMPFILEDIRS=D:\TEMP SortMemory=8192 (the values here are just examples) .3. Cognos Service/Compo nent Cube generation Error Code Description Recommended Resolution/Action Cause There is not enough disk space to create the UDA temporary files. Unable to generate a cube : a data source cannot be read.
cognos. Steps:Following was the scenario: MDL script[updatecube.C8Adm. Cube generation TR1102.util.util.ses sion. Environment Windows. Refer to the embedded document: PCConn fails in a distributed environm ent.exe command] using a mdl script.Cognos Tool Known Errors and its Resolution Document 30 on Environment Windows installation Resolving the problem Change the Cognos 8 service to start with a named user account that has the appropriate permissions on the shared drive. We can also get the above error if the correct cube name is not provided. TR0701 Cause In the mdl script for CUBEUPDATE statement customer had given the path of the mdc file instead of Cube name.mdl] which was used :- Page 30 .ConsoleConnec tionContext.connect( Unknown Source) at com.lang.com/support/docview.doc 4. Cube generation PCConn fails in a distributed environment when the -f option is used and Anonymous access disabled ===== Cognos 8 PowerCube Connection Admin Command Console ===== Exception in thread "main" java.c8a dm.ArrayInde xOutOfBoundsExcep tion: 2 at com.main(Un known Source) Getting error(TR1102) and (TR0701) while updating a cube using a mdl script. While updating a cube through command line[cogtr.<init>( Unknown Source) at com.C8Adm. the below mentioned error was received. Unix Resolving the problem Put proper cube name in the CUBEUPDATE statement of mdl script.c8a dm.util.cognos.cognos. http://www01.ibm.w ss?uid=swg21370888 3.
w ss?uid=swg21343187 4.mdc" SAVEPY "D:\Transformer\XYZ. Cognos Service/Compo nent CAFÉ tool Error Code Description Recommended Resolution/Action Cause Corrupt CAFE installation.N o 1. Café tool S.mdl The correct script should be as below :SignonAdd "signonname" UserId "user name" password "password" AutoLogon {True} SignonNamespace "namespace name" SignonType "Cognos OPENPY "D:\Transformer\XYZ.pyj" EVENTSTART "Build Monthly Powercube" CUBEUPDATE "D:\Transformer\XYZ.com/support/docview.3 Exploration View not working in Excel 2007.exe -mupdatecube. Environment Windows XP.pyj" EVENTEND SignonDelete "signonname" http://www01.3 Page 31 .pyj" EVENTSTART "Build Monthly Powercube" CUBEUPDATE "CubeXYZ" SAVEPY "D:\Transformer\XYZ.ibm.pyj" EVENTEND SignonDelete "signonname" Command used was :cogtr. Microsoft Office No error code CAFE 8.Cognos Tool Known Errors and its Resolution Document 31 SignonAdd "signonname" UserId "user name" password "password" AutoLogon {True} SignonNamespace "namespace name" SignonType "Cognos OPENPY "D:\Transformer\XYZ. After loading the Cognos Analysis for Excel (CAFE) 8.
8.boulder.im. http://www01.Cognos Tool Known Errors and its Resolution Document 32 Plugin in Excel 2007.500 rows and you are not using Microsoft Excel 2007. Therefore making CAFE unusable.doc/ug_cra_id38106Troubleshoot ing.cognos .w ss?uid=swg21343229 Resolving the problem IBM Cognos 8 BI Analysis for Microsoft Excel does not support prompts. 2007.swg. You receive this message to make you aware of the truncation.ug_cra. limit your data selections.4.jsp? topic=/com.ibm.com/i nfocenter/caapps/v8r4m0/inde x. You receive this error message when a package that contains prompts loads or when selecting or expanding members in the source tree of a package with prompts.ibm.ug_cra. http://publib.com/infocent er/caapps/v8r4m0/index.0.8. CAFÉ tool COR-ERR-2011 COR-ERR-2011 Prompted Metadata Is Not Supported 3.4.ibm.jsp? topic=/com.ibm.boulder.html Workaround: To avoid this limitation. http://publib. CAFÉ tool COR-ERR-2014 COR-ERR-2014 Due to Excel worksheet limitations the results may be truncated Resolving the problem If the data that you receive back has more than 250 columns or more that 65. Microsoft Excel 2007 Resolving the problem Deinstall CAFE.doc/ug_cra_id381 06Troubleshooting.swg.html 2.cognos.ibm.im. You must choose a package that does not have prompts. the hyperlink to create an exploration view is inactive. Reinstall CAFE. Page 32 .com/support/docview.0. the result is truncated.
Steps: In Framework Manager. go to the View menu and click Properties. a number such as 20080401 in framework manager would be displayed as 428408580343 in Cognos Viewer.Save and re-publish the package. http://www01. Invoke Cognos Configuration. select Attribute.If the Properties pane is not already visible.com/support/docview.ibm. Cognos Service/Compo nent Framework manager Error Code Description Recommended Resolution/Action Cause The Usage property for the query item is set to Fact in Framework Manager. Resolving the problem Define the required content locale under the 'Edit Global Configuration' option in Cognos Connection on all machines with Cognos8 installed.N o 1.Change the Usage property to Attribute. 2. The following error message occurs when attempt to publish a report from CAFE to Cognos Connection. Goto 'Actions .w ss?uid=swg21343101 5. Restart the Cognos8 service.Under the Usage property in the Properties pane. 3. 4. select the query item. Resolving the problem 1. Café tool CM-REQ-4179 CM-REQ-4179 The locale 'nb-no' is not one of the configured content locales. Framework manager S. but not in Cognos Viewer. For example. Enter the required content locale definitions into the 'Content Locales' and 'Content Locale Mapping' tabs.Edit global configuration' 3. Cause The required locale is missing from content locale in Cognos Configuration. http://www- Numbers display properly in Framework Manager but not in Cognos Viewer A numeric query item displays properly in Framework Manager. Steps: 1. 4.Cognos Tool Known Errors and its Resolution Document 33 4. Page 33 . 2.
Cognos Tool Known Errors and its Resolution Document 34 01. Open a Command Prompt. 3. Steps:1.CPF) is located.exe to recover the project from the logs (steps below).com/support/docview. http://www01.not just the model. locate the logs directory and sort the files in that directory by date. enter in the correct gateway URI Log in to a valid namespace. 2.com/support/docview.w ss?uid=swg21340902 Cause The model is corrupt or missing some of the relevant files. When restoring a model from backup. BMT-MD-2036 Error validating a converted model or creating new project: BMT-MD3999 An unknown error occurred. restore the model from backup to a different directory. This is reflected in the second error message as FrameWork Manager cannot read the model.xml file which stores most of the model metadata.CPF file must reside in the project directory with all the relevant XML files. Resolving the problem If the model is corrupt.w ss?uid=swg21343167 Cause Gateway URI on the server was incorrectly configured User has not logged in to a valid namespace Resolving the problem Correct the Gateway URI entry on the server. The .xml. restore the entire model folder to get all model files . The earliest (oldest) file is the first file and most recent file is the 2.exe file. Framework manager BME-EX-0071 and BME-EX-0073 BME-EX-0071 and BME-EX-0073 Error opening Framework Manager Model. From the directory where the project file (. OR Use bmtscriptplayer. 3. Framework manager BMT-MD-3999.ibm. Page 34 . Unable to open a Framework Manager model. Go to the ReportNet_installation or Framework_Manager_Installati on\crn\bin directory. Error occurs when validating a converted model or creating new project. Ensure the directory contains the bmtscriptplayer.ibm.
cpf -a d:\My Projects\logs\newproj20050217083318-log. You can also use the command . Note that if authentication is enabled.cpf -a old_project_dir\logs\oldest_file. xml for example Example : Bmtscriptplayer -c d:\My Projects\newproj.dir /OD project_dir\logs 4.c pf -a <Old_Project_dir>\logs\%i Example: for /F "usebackq delims==" %i in (`dir /B /OD d:\temp\Old_Project1\logs`) do "BmtScriptPlayer. "-u <username> -p <passwd>" Page 35 . the newly created project file should be a copy of the old project. Delete the newly added transaction log file from the logs directory. 6. Use the following command to apply the rest of the transaction logs to the project for /F "usebackq delims==" %i in (`dir /B /OD Old_Project_dir\logs`) do "BmtScriptPlayer. using the username and password for the BmtScriptPlayer.xml The above command will create a new project file and apply the transactions from the oldest (first) transactions file.Cognos Tool Known Errors and its Resolution Document 35 last file. type Bmtscriptplayer -c new_project_dir\newproject. 5.cpf -a D:\temp\Old_Project1\logs\%i If the application of all the logs is successfull. At the Command Prompt.exe" -m New_Project_dir\NewProject1.exe might be needed.exe" -m d:\temp\NewProject1\NewProje ct1.
http://www01. UDA-SQL0564.com/support/docview. so you must make this change in the SQL of the underlying Data Source Query Page 36 . UDA-CUR-0000 Cause This is caused by values larger than 2147483647 in the float field.ibm. Framework manager BME-EX-0125 Unable to open existing FM project: BME-EX-0125 The Document Object Model (DOM) parser failed.w ss?uid=swg21341395 Cause Database was not available after server reboot. Framework manager/Configurat ion UDA-SQL-0432 UDA-SQL-0432 Unable to locate the gateway. http://www01.ibm. Datasources not available and reports will not run.w ss?uid=swg21342616 Cause The model.w ss?uid=swg21340059 Refer embedded document 4. UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Arithmetic overflow error for Unable to open existing FM project. UDA-CUR0000. A signed. 4-byte integer datatype only allows for values up to positive (2^31) . RQP-DEF0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'. Resolving the problem From Cognos Configuration save Configuration settings and then restart the Cognos service. Unable to cast a Float field as an Integer: RQP-DEF0177.ibm. The expression editor for a field in a Model Query Subject will not allow you to use bigint as a datatype.com/support/docview. This occurs regardless of whether the model is opened from the workstation it was originally created upon or from other workstations.doc 6.1. Environment Reporting Database: Microsoft SQL Server Resolving the problem You can cast the field as a bigint datatype instead.Cognos Tool Known Errors and its Resolution Document 36 Refer to the FrameWork Manager Users Guide for more details. UDA-SQL-0564. "UDA-SQL-0432 Unable to locate the gateway "cogudaor" 5.xml file is corrupted (easily verified by opening the file within Internet Explorer or any other XML validator) Resolving the problem http://www01.com/support/docview. Framework manager RQP-DEF-0177. Unable to open a previously created Framework Manager model.
http://www01. 3. Locate the underlying Data Source Query Subject in your FM model which is bringing back the float field in question. Subject instead.ibm. Steps: 1. If you want all your old reports to still work fine after changing a model.ibm. Right-click it. value = 2210000101. 8. ReportNet (or Cognos 8) will create a new version of the model for this package in the content store.00000 0. and all new reports Page 37 .CBmt EENodeHandler' failed error Could not load plugin 'E:\Program Files\cognos\c8\bin\ BmtEEPlugin. 2. I get the following error message when I try to load a project. and choose Properties. you need to enable model versioning when you publish the package in Framework Manager. SQLERRORCODE=2 32) UDA-CUR-0000 Unable to fetch the row.w ss?uid=swg21340946 7.dll' How to publish a package after modifying the model without impacting existing reports based on that package. copy the DLL 'BmtEEPlugin. edit the SQL so that instead of selecting floatField. Creating 'bmtEEPlugin.dll' When I run Framework Manager.Cognos Tool Known Errors and its Resolution Document 37 type int. instead of overwriting the existing model.com/support/docview.dll' from another installation. the published package will have multiple versions of the model in the content store.com/support/docview. With this option checked. On the SQL tab. Framework manager No error Resolving the problem This is essentially a question about how model versioning works. (SQLSTATE=22003. you are selecting cast(floatField AS bigint) as "intField" http://www01. All old reports will automatically link to the old model. Once done. Framework manager Error: Could not load plugin 'drive:\Program Files\cognos\c8\bin \BmtEEPlugin.w ss?uid=swg21340969 Resolving the problem Workaround.
com/support/docview. Steps:1. click on Environment 3.w ss?uid=swg21340910 Resolving the problem Ensure Framework Manager's Cognos Configuration has the correct Gateway and Dispatcher URI. that if you open an existing report from within the Studios. Steps:1. Open Framework Manager Cognos Configuration 2. it will run against the newest model.N o 1. 2. Check Enable model versioning in Framework Manager in the package publishing wizard. There may be a validation prompt. Cognos Service/Compo nent Configuration Error Code Description Recommended Resolution/Action Resolving the problem Decrease the "Maximum CAM-AAA-0027 Cannot login to Cognos 8: CAM- Page 38 . Configuration S.w ss?uid=swg21340857 9. http://www01.com/support/docview. Please be aware. Framework manager CAM-CRP-0287 CAM-CRP-0287 error is thrown when opening a project in Framework Manager. however. In the Explorer Pane. Opening Model Failed error-13 CAM-CRP0287 Unable to read the CRYPTO section of the 'cogstartup. and it may result in error messages becasue the old report may not match the metedata of the newest model. Publish the package.Cognos Tool Known Errors and its Resolution Document 38 will be created against the new model.xml' configuration file.ibm. http://www01. Loading Project Failed 6. If unsure what the Gateway URI and Dispatcher URI needs to be set to.ibm. Ensure Gateway URI and Dispatcher URI for external applications has the correct IBM Cognos 8 BI Server URI's. you can check it in the Cognos 8 BI Server's Cognos Configuration.
Cognos Tool Known Errors and its Resolution Document 39
AAA-0027 The function call to 'CAM_AAA_Authenti cate' failed. Intermittent problem, users not able to login to Cognos Connection and service restart is required to resolve. memory in MB" setting in Cognos Configuration. Try default 768 Mb or 512 Mb. Steps: 1. Open Cognos Configuration and navigate to Environment->Cognos 8 service->Service name. Decrease the Maximum memory value. Restart Cognos 8 service. http://www01.ibm.com/support/do cview.wss? uid=swg21343228
2. 3.
Workaround: Try after some time. 2. Configuration CAM-CRP-1095 CAM-CRP-1095 Unable to find the encryption certificate with alias 'encryption' in the keystore. Unable to generate the cryptographic keys in a multiserver installation. Resolving the problem Ensure that the dispatcher and controller URI's point to the correct application server. Steps: 1. Under Environment in Cognos Configuration, change the Dispatcher and Controller URI's to point to the proper application server. Right click on Environment and click Test http://www01.ibm.com/support/do cview.wss? uid=swg21343186 3. Configuration 403: Access Forbidden Due to the presence of characters known to be used in Cross Site Scripting attacks, access is forbidden. This web site does not allow Resolving the problem IBM Cognos ReportNet supports the Netegrity Siteminder CSS checking filter. By default, the Siteminder filter rejects any requests that contain greater than (>) or less
Page 39
Cognos Tool Known Errors and its Resolution Document 40
Urls which might include embedded HTML tags. than(<) symbols, or single quotation marks (') that are passed as content in parameters in GET requests. Cognos Application Firewall (CAF) analyzes and validates HTTP and XML requests before they are processed by ReportNet Application Servers. Cognos Application Firewall may modify these HTTP and XML requests. CAF is actually the Cognos ReportNet component which does the replacing of the XSS characters that SiteMinder checks for. To protect ReportNet from SiteMinder-prohibited characters, the following must be done on each Cognos ReportNet server to enable the XSS checking feature: Enable CAF validation Add the gateway and application server name(s) to the valid domains or hosts list in your Cognos Application Firewall settings. Ensure that the third party XSS checking is enabled on each server. The XSS property can be used only if CAF is enabled because it's actually a feature of CAF. Activating this property without CAF being activated will lead to errors in Cognos Connection. Steps: 1. Start Cognos Configuration. 2. From the Security menu, click Cognos Application Firewall. 3. Set Enable CAF validation option to True. 4. Add the gateway and application server name(s) to Valid Domains or Hosts. 5. Set the Is third party XSS checking enabled? option to True. 3. Save the configuration and
Page 40
Cognos Tool Known Errors and its Resolution Document 41
restart services. http://www01.ibm.com/support/docview.w ss?uid=swg21339001 Cause JAVA_HOME was pointing to Java 1.4 Environment In this case multiple versions of Cognos 8 were installed on a Windows machine. Resolving the problem Set JAVA_HOME variable to Cognos 8.3 location/bin/jre and use 1.5. Or remove the JAVA_HOME variable completely and each installation will pick up their own Java. Steps:1. Go to the Windows Control Panel 2. System icon 3. Advanced tab 4. Environment Variables button 5. Under the system variables, not user, section you can modify the JAVA_HOME. http://www01.ibm.com/support/docview.w ss?uid=swg21342788 Cause Invalid credentials specified for the Cognos 8 service. Resolving the problem Re-enter the credentials for the Cognos 8 service in Windows Services. Steps: 1.Go to the START menu, click "Run...", type in "SERVICES.MSC" and click OK. 2.Windows Services should appear. Double-click the Cognos 8 service and click the "Log On" tab. 3.Re-enter the account name and password to be used by the Cognos 8 Service and click OK. http://www-
Unable to start Cognos BI 8.3: CFGERR-0106 Cognos Configuration did not receive a response. Error CFG-ERR-0106 Cognos Configuration did not receive a response from the Cognos 8 service within the time alotted. Check that the Cognos 8 service is available and properly configured
Cannot start Cognos 8: CFG-ERR-0103 Unable to start Cognos 8 service. CFG-ERR-0103 Unable to start Cognos 8 service. Execution of the external process returns an error code value of '-1' Cognos 8 cannot be started from Cognos Configuration or from Windows Services but it can be started from the command line via STARTUP.BAT.
Page 41
A standby Content Manager computer may be configured incorrectly. The ServiceWaitInterval property represents the time interval. its value is 360. Configuration CFG-ERR-0106 CFG-ERR-0106 Error When Starting the IBM Cognos 8 Service in IBM Cognos Configuration. you can change the amount of time that IBM Cognos Configuration waits to receive a response from the IBM Cognos 8 service. CFGERR-0106 Cognos Configuration received no response from the Cognos 8 service in the allotted time. Page 42 .ibm. IBM Cognos Configuration checks the progress of the start request every half second for three minutes. its value is 500. If IBM Cognos Configuration does not receive a response within this time. By default. Content Manager Is 6. You do this by configuring the ServiceWaitInterval and ServiceMaxTries properties in the c8_location/configuration/cogc onfig. To avoid this error.w ss?rs=0&uid=swg21370764 There are two possible causes for this problem: The IBM Cognos 8 service needs more time to start. Check that Cognos 8 service is available and properly configured. The IBM Cognos 8 Service Needs More Time By default. The ServiceMaxTries property represents the number of times that IBM Cognos Configuration checks the progress of the start request. which is equivalent to half a second.Cognos Tool Known Errors and its Resolution Document 42 01. in milliseconds. By default. at which IBM Cognos Configuration checks the progress of the start request.prefs file.com/support/docview. the error message appears.
ibm.0.8. Open the c8_location/configuration/cogc onfig. Using IBM Cognos Configuration. Add the following code to the file: ServiceWaitInterval=number of milliseconds ServiceMaxTries=number of times Tip: Add the numeric values that correspond to your configuration needs.im. Steps to Change the Wait Time Using IBM Cognos Configuration. To avoid this problem.boulder.ibm.js p? topic=/com.4.swg.html Page 43 . configure the standby Content Manager computer to store the symmetric keys locally. This file is created automatically the first time you open IBM Cognos Configuration. http://publib. Save the file.cognos . start the IBM Cognos 8 service. the setting for storing the symmetric keys may be incorrect.Cognos Tool Known Errors and its Resolution Document 43 Configured Incorrectly If the error message appears on a standby Content Manager computer.ug_cra. stop the IBM Cognos 8 service.prefs file in an editor.com/i nfocenter/c8bi/v8r4m0/index.doc/ug_cra_id311 97CFG-ERR0106ErrorWhenStartingtheCog nos8Se.
w ss?uid=swg21340944 Cause This error can occur due to a memory limitation within the configuration.ibm. PRS- PRH-0252 The response received is invalid.log file No logging for certain amount of time in Cogserver. Correcting the configuration may correct the problem. DPRDPR-1013. Failed Log Server socket error <parameters><ite m name="Port"><! [CDATA[9362]]></it em><item name="Error"><! [CDATA[Address already in use: Cannot bind]] Cause Unknown Environment Cognos 8 single server or multi-server installation Resolving the problem Change "Enable TCP?" to True in C8 configuration Steps: 1. An XML result was expected from Page 44 . Configuration QE-DEF-0285. QEDEF-0068 Problem creating Oracle data source in Cognos 8 FM. In system environment variables your path should be for 10g. Restart Cognos 8 service http://www01. Note that the actual settings will vary from one server to another. Launch C8 configuration 2. Configuration No logging to Cogserver. Configuration PRS-PRH-0252. set "Enable TCP?" to True 3.log file until restarting Cognos 8 service.com/support/docview. C:\Oracle\ora101\network\admi n (pointing to tnsnames. DPR-DPR-1013 Running reports occasionally generates errors: PRSPRH-0252. Resolving the problem Modify the sort size and the number of processes for each of server in the installation. QEDEF-0285 The logon failed for the following reason QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceCon nection UDA-SQL-0432 Unable to locate the gateway "cogudaor" 8. depending on hardware specifications Resolving the problem Check whether Oracle client (9i or 10g) is installed or not. Click logging.ora file) or for 9i C:\oracle\ora92\network\ADMIN 9.Cognos Tool Known Errors and its Resolution Document 44 7.
http://www01. Select the appropriate level. CPUs). and click the "Set Properties" button. Larger values may cause resource shortages. values over 32 are not advised. In the "Environment" window. Click on the "Settings" tab to open up the settings. Steps:To modify the sort size: Launch Cognos Configuration on your application tier server In the "Explorer" window. To modify the number of proceses Launch a browser and log into Cognos Connection as a user with access to the Server Configuration Click on Tools->Server Administration Process settings can be set at either the global.Cognos Tool Known Errors and its Resolution Document 45 "dispatcher" HTTP Status 500 DPR-DPR-1013 Unable to parse response envelope.ibm. find and modify the setting "Sort buffer size in MB". The number of processes should typically not exceed 2 times the number of CPU's (or 1. CAM-AAA-0036 Error CAM-AAA0134 occured upon Page 45 . smaller values may cause additional local processing of large data sets. but this may vary by system depending on the architecture and the type of reporting being done. The response does not contain a valid XML document (memory. select "Environment". There are different settings for Interactive processes and Batch processes. dispatcher or service level. The default is 4.w ss?uid=swg21340908 Cause When CAM initially binds to the LDAP the Binding Credentials 10. Configuration CAM-AAA-0134. Restart the services and re-run the reports. Settings at the lower level will override settings at a higher level. Find and modify the setting for "Maximum Number of processes for the batch report service" or "Maximum number of processes for the Interactive report service" as appropriate.com/support/docview.5 times the number of cores).
ibm. Resolving the problem The user (or a Group or Role that the user is a member of) needs the following Page 46 . Resolving the problem Refer below link: http://www01.w ss?uid=swg21343378 11. Configuration CAM-AAA-0172 CAM-AAA-0134 Unable to retrieve information for the user. Cognos Service/ Compon ent Other Error Code/Mess age PRS-OBJ-0617 Description Recommended Resolution/Action Unable to Publish PowerCube as Data Source and Package from Transformer: PRS-OBJ-0617 Cause The user that is logged into Transformer is missing permissions. Cause During Phase 2 of the authentication process.w ss?uid=swg21343393 7.com/support/docview. If the BCs are empty anonymous bind is used. the provider was unable to read attributes for the user entry or one of the parent entries using the provided Binding Credentials (BCs) when running Single Sign-On (SSO) or User Credentials when running Basic Sign-On.com/support/docview.Cognos Tool Known Errors and its Resolution Document 46 authentication (BCs) specified in Cognos Configuration will be used.ibm. If no entry is found the authentication will fail with CAM-AAA-0036 . Once the bind succeeded an LDAP search for the user entry is sent. The number of results returned must be equal to one. N o 1. CAM-AAA-0172 The main identity returned by the provider is invalid. Other Errors S . Resolving the problem Refer below link: http://www01.
2.wss? uid=swg21343239 Resolving the problem Add 'Read' permission to the report for all Page 47 . Click on the Personal tab .under Credendials click on Renew the credentials 4.ibm. A dialog box should confirm that credentials have been renewed successfully . the following permissions are required by the user that is logged into Transformer: • • • Execute and Traverse for the Administration capability Execute and Traverse for the Data Source Connections capability (note that this is child of the Administration capability) Write for the Data Source Connections area in Cognos Administration To be able to create the package. 3.com/support/docview. Trigger or have the schedule run and test for the error.Cognos Tool Known Errors and its Resolution Document 47 permissions: To be able to create the data source. http://www01. the following permissions are required: • Traverse and Write permissions for the Public Folders area or folder where the package is to be located. Click on My Area . Other No error code Prompted report hangs when invoked Resolving the problem Renew the credentials Steps:1. Workaround: Delete the cookies and temp files using browser options and try with a fresh instance of the browser. Other CNC-SDS-0413 Error for Scheduled Reports: CNC-SDS0413 There was a problem in executing the task 4.ibm. Other No error code Blank Internet Explorer page remains open after saving report output in Microsoft Excel 2007 format http://www01.com/support/docview.My Preferences 3. Have the user log into Cognos Connection 2.click ok 5.wss? uid=swg21343277 Cause Internet Explorer 6 Resolving the problem It was noted that after upgrading to IE 7 the issue disappeared.
2.X network that users are not able to load the metadata for certain large packages. 2..X. then 'Ok'. Open the properties sheet for the report. this appears to just affect Internet Explorer 7 users trying to open Excel reports. 5.' ensuring that Trusted Sites is highlighted. 6. Steps:1.ibm. Whenever a user tries to open a report in any Excel format within Cognos Connection the page reopens as an HTML document.Cognos Tool Known Errors and its Resolution Document 48 by non-administrator user users who can use the 'Run with options' option. Click 'Custom Level.X for their client machines. Go to the 'Permissions' tab. http://www01.1.1. From the 'Reset to:' drop down menu select 'Medium-low' and then click 'Reset' 6.wss? uid=swg21343237 Resolving the problem When client machines are on the same network with the BI Server's Netowork(10. Other formats appear to work (such as PDF).com/support/docview.. Go to the 'Control Panel'. ensure that Cognos is a 'Trusted Site' 4.X). after ensuring that Internet Explorer is closed. and lower the security for trusted sites to Medium-Low. Customer should direct this to their network administrator at investigating it in the proxy server. then restart Internet Explorer and try Page 48 .X. Steps: 1. http://www01.X. Other No error code Getting 'XML HTTP Error' while accessing certain packages in Report Studio from client machines Add 'Read' permission to the required users or user groups. they are able to download metadata for all packages. Resolving the problem Add Cognos to Trusted Sites in internet Explorer 7. Environment Windows XP with Internet Explorer 7 and Cognos 8.com/support/docview. A possible root cause of this issue can be traffic is being filter in the proxy server. 5.3.10. 'Ok'. Other No error code Cannot View Reports in Excel Format with Internet Explorer 7.wss? uid=swg21343232 Workaround: A possible work around is to bypass the proxy server to use 10. Cause This issue is due to the increased security in Internet Explorer 7.ibm. Go to the 'Security' tab. Open 'Internet Options' 3. Its only when the client machines are on the 10. Click 'Yes' if prompted.
Page 49 .. packet dropping. Open Cognos Configuration Stop the Services (black square on the tool bar) Start the Services (green arrow on the tool bar) NOTE: if you have a distributed environment you need to ensure the services on the Content Manager machine are stopped last and started first.cognos.Cognos Tool Known Errors and its Resolution Document 49 again. This will not work as the cookie information is only valid for the environment initially authenticated against. If multiple Cognos environments are secured against the same security authentication source.com/cog nos8 Install 2: http://server2.. 8. network drop. Possible causes (but not all) would be server reboots. Sign on CAM-AAA0203 CAM-AAA-0203 Unable to generate or validate a userSessionID. http://www01. http://www01.cognos. network traffic. 3.com and path is /cognos8). Sign on CAM-AAA0071 Unable to login to Cognos Connection: CAM-AAA-0071 Cause The connection to the LDAP server was dropped/lost for some reason Resolving the problem With the help of your IT team see if there is something going on within the network that would be causing the connection to be dropped.wss? uid=swg21343208 Cause The browser is trying to pass the cookie information from one install to the other.wss? uid=swg21343225 7.com/support/docview. this error will appear.com/support/docview.cognos. 2. Restart the Cognos Services Steps: 1. and you move between them within the same browser session.com/cog nos8 The cookies from both installs will have the same settings (domain is .ibm. etc. In the case where the installs are like below: Install 1: http://server1.ibm.
(in pogo_.l og) DPR-CMI-4007 A request to perform an active content manager election failed. Ensure that the database collation sequence for the content store is Page 50 . (in cogserver/crnserver.wss? uid=swg21343190 Cause Excel security in Office 2007 Resolving the problem Solution came from forums. Enter a value into the Domain option such as server1. including: • • unsupported database collation sequence used for the content store insufficient permissions for the user configured to connect to the content store modifications made to key system files Resolving the problem 1.com Steps:Add new registry key as below. so that the browser understands the cookie is only valid for a certain install. Excel 2007 No error code Warning message in Excel 2007. 'xyz'.com/support/docview.0\EXCEL\SECURITY Rightclick --> new>DWORD> add key ExtensionHardening value = 0 make sure the key word without any spaces.Cognos Tool Known Errors and its Resolution Document 50 Resolving the problem Add Domain and (if applicable) Path information into Cognos Configuration Global Settings. Open Cognos configuration 2. When running a report to Excel 2007 you might receive a warning . Dispatcher DPR-DPR-1035 Cause There are several possible root causes for these errors.ibm.Edit Global Configuration .com/support/docview.ibm.cognos. is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.wss? uid=swg21342407 9.microsoft. Navigate to Actions . Do you want to open the file now?" DPR-DPR-1035 Dispatcher detected an error.com and Path information such as /c8 http://www01.log) 10 . Steps:1. http://www01.General tab 3. HKEY_CURRENT_USER\SOFTWARE\MICROS OFT\OFFICE\12. "The file you are trying to open.
e.properties 2. The response does not contain a valid XML document or error message below in cogserver. 3. Ensure that the above user account is a member of the db_ddladmin role. and that no customizations have been performed (a file comparison utility could be used to compare each system.Uncomment the second entry. case-insensitive. Dispatcher DPR-ERR-2101 Getting DPR-DPR1013 Unable to parse response envelope.log when accessing security or configuration tab in cognos connection.Cognos Tool Known Errors and its Resolution Document 51 2. Dispatcher DPR-ERR-2058 DPR-ERR-2058 Error Appears in Web Browser When Starting IBM Cognos Page 51 . To help you determine the specific cause.ibm. I.Find the following lines: #set this to true to wrap the input stream so that Oracle Application Server will parse the XML properly #wrap_input_stream=true 3.com/support/docview.ibm. If modifications have been done. http://www01.wss? uid=swg21343136 These error messages usually occur when the dispatcher cannot communicate with Content Manager.xml files were modified in any way.xml against those present in a new base install). 12 . Grant create and drop table privileges for the content store to the user who will be specified in Cognos Configuration.Then create a WAR or EAR file using Cognos 8 configuration tool http://www01. the lines will be as shown below: #set this to true to wrap the input stream so that Oracle Application Server will parse the XML properly wrap_input_stream=true 4. Verify that none of the system. look in the 11 .com/support/docview.wss? uid=swg21339758 Cause Oracle application server does not parse the XML property Environment Oracle 10g3 application server Resolving the problem Set wrap_input_stream=true before creating WAR or EAR Steps: 1. undo these by restoring the original files and restarting the service.Locate <C8_location>/webapps/WEBINF/p2pd_deploy_defaults.
configured.:.log file in the c8_location/logs directory. Using a report column that contains special characters in a report.swg. The most common causes are listed below.jsp? topic=/com. Content Manager is Not Available In a distributed installation.doc/c8pp_inst_id18142DPR-ERR2058ErrorAppearsinWebBrowserWh. which have been identified as: !#$%().wss? uid=swg21341099 Cause 14 Dispatcher DPR-ERR-2082 After launch of IBM Page 52 .ibm. The User Does not Have Appropriate Permissions Ensure that the user has the appropriate permissions. DPR-ERR-2058 The dispatcher cannot service the request at this time. IBM Cognos Services are Not Done Initializing After you start the services in IBM Cognos Configuration and the configuration tool shows that the services are running.c8pp_inst. wait a few minutes for all services to start before you open the portal.com/infocenter/c8 bi/v8r4m0/index. XTS handler must be initialized before being invoked. The ones most likely to be problematic are: &<>"' There are a number of other characters that can similarly cause trouble. Ensure also that the other IBM Cognos computers are configured with the correct Content Manager URI.cognos.1.=[]\^`{|}?~ Any character that is not considered a valid XML 1.ibm.im. http://www01.Cognos Tool Known Errors and its Resolution Document 52 8.ibm. Dispatcher DPR-ERR-2065 Error accessing column: DPR-ERR2065 The response from Report Server is not well formed. and running.html 13 . a Unicode control character) can cause issues. Refer for more at: http://publib. Please try again or contact your administrator.4. with solutions. cogserver. Resolving the problem Removing the characters from the source data can eliminate this issue. DPR-ERR-2058 The dispatcher encountered an error while servicing a request.8 . The dispatcher is still initializing. Cause There are several special control characters that can cause conflicts if they exist in the reporting data source.boulder. ensure that Content Manager is installed.com/support/docview.0 character (for example.
http://www01. The complete error has been logged by CAF with SecureErrorID Other Resolving Oracle connection errors QE-DEF-0285 Logon failure. All other objects tables. Resolving the problem Launch IBM Cognos Configuration and restart the IBM Cognos 8 Service. Please contact your administrator. 15 . Other Unable to create query subject using synonyms Client has synonyms on Oracle database user.doc Page 53 . Refer embedded document: Resolving Oracle connection errors.wss? When Cognos 8 service was starting. User wants to create query subject in Framework Manager using those synonyms. Cognos 8 Connection the following error message appears: Cognos 8 Help DPR-ERR-2009 A request to authenticate the user in Content Manager failed. User used to connect to the datasource does not have permissions to view synonym. there was a problem with the server network connection. QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConn ection UDA-SQL-0432 Unable to locate the gateway "cogudaor".com/support/docview. 16 . Resolving the problem Please cross check if the user schema for synonyms and the data source connection is the same and the user has the permission to view the synonyms. Cause Following might be the reasons when user is not able to see synonyms: Synonyms are created under a different schema user than the one trying to access the data source. using the Restart icon at the top. But the user can't see any synonyms while creating query subject in FM.procedures and functions are visible. If the user schema for synonyms and the data source connection are not the same then grant approprite access rights to the user accessing the datasource connections on the synonyms defined in the other user schema.ibm. The only issue is with synonyms.Cognos Tool Known Errors and its Resolution Document 53 . Details: DPR-ERR-2082 An error has occurred. views.
Unknown URL: /cognos/cgibin/cognosisapi. Navigate to the msxml3. Locate the msxml3. Under Settings navigate to the ActiveX controls and plug-ins 4. 6. Resolving the problem Restore the connection with the Cognos 8 server by opening a new Report Studio session. 4. All other studios open without problems.ibm. Environment Windows XP/2000 IE 6 Resolving the problem Check the ActiveX controls settings in your browser. 5.com/support/docview. You will get a windows message that the dll has been registered. In the Security tab click on Custom Level 3._8H6() must be called in the HTML body Page 54 .wss? uid=swg21343169 18 .dll Cause A network failure may have occured during the Report Studio session and/or the session may have timed out. change the settings to Enable. Click on the Tools menu and select Copy report to clipboard. Type the following command: regsvr32 msxml3. 3. Check the setting 'Script ActiveX controls marked safe for scripting' and make sure that is enable. a user receives the following The web request failed Details: 12002 .Cognos Tool Known Errors and its Resolution Document 54 uid=swg21343157 Cause ActiveX controls settings disabled or misconfigured. Steps: 1. From the machine go to Start -> Run. Steps:To keep your current work and open a new Report Studio window: 1. re register the associated dll file: 1. Other User trying to save in Report Studio receives "The web request failed" error When trying to save a report in Report Studio. Type cmd and press Enter. Restart your browser and test. http://www01. Keep this window open. Test Report Studio. In your browser go to Tools -> Internet Options 2. Click OK to close the Internet Options window 7. 17 .dll.dll and press enter. If the settings for ActiveX are set to Enable. Other HAL errors when opening Report Studio A user gets a HAL error when opening Report Studio.dll 2. If it is disable. 6. you may need to re register the associated dll files. HAL ERROR:_6K8. Click OK to save changes.dll location. 7. By default is located in <Windows>\system32\msxml3. If ActiveX controls are enabled. 5.
wss? uid=swg21343190 Cause Each Image Viewer portlet must also be configured to reference an absolute URL in order for images to be displayed properly Resolving the problem Modify the Image URL address within each Image Viewer portlet that contains an image.cognos.com and path is /cognos8). 3. this error will appear. Sign on CAM-AAA0203 CAM-AAA-0203 Unable to generate or validate a userSessionID. 19 .wss? uid=swg21343172 Cause The browser is trying to pass the cookie information from one install to the other.cognos. In the case where the installs are like below: Install 1: http://server1. Resolving the problem Add Domain and (if applicable) Path information into Cognos Configuration Global Settings. click on Tools and Open report from clipboard. This will not work as the cookie information is only valid for the environment initially authenticated against.General tab 3. Navigate to Actions . ensuring that an absolute URL is used 20 .com/support/docview. so that the browser understands the cookie is only valid for a certain install.cognos. Steps:1. Open Cognos configuration 2. Enter a value into the Domain option such as server1. If multiple Cognos environments are secured against the same security authentication source. and you move between them within the same browser session. 4.Cognos Tool Known Errors and its Resolution Document 55 2.ibm.Edit Global Configuration . Navigate to the Cognos Connection portal and open a new Report Studio session. The images do appear when accessing the portal on the same server Page 55 .com and Path information such as /c8 http://www01.com/cog nos8 The cookies from both installs will have the same settings (domain is . In the new Report Studio window. Close the problematic Report Studio window http://www01.cognos.com/support/docview.com/cog nos8 Install 2: http://server2.ibm. Other Images not appearing within Cognos Connection portal tab portlet Images do not appear within a Cognos Connection portal tab Image Viewer portlet when accessing by a remote machine.
com/support/docview. http://www01.com/support/docview. SQLERRORCODE=53 Page 56 .wss? uid=swg21343111 22 . If the email size exceeds the permissible limit of the exchange/SMTP server. and not localhost http://www01. click the Edit icon in the top right corner 2.3 introduces the ability to compress the attachment based on the size of the report output. However. Under the Image section. there would preferably be restrictions set on the exchange/SMTP server on the permissible size limit for the email. UDA-SQL0114 UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResul t" is inactive.wss? uid=swg21343120 Cause This error indicated incorrect data type casting. 1.ibm. The property is called 'Maximum size of an uncompressed email attachment' and is measured in MB. but a red 'x' icon placeholder appears where the image should be 21 . (SQLSTATE=42000.ibm. the email would not reach the intended recipient. UDA-SQL0115 Inappropriate SQL request. make sure that the Image URL specified contains an absolute URL. basically invalid data item expression.Cognos Tool Known Errors and its Resolution Document 56 Steps: where Cognos 8 is installed. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. Resolving the problem Validate the expression using cognos validation in the reporting studio and correct the expression as per the description of error generated by the validation function. Within affected portlets. Cognos Configuration is configured with fully qualified domain names (FQDN) and not localhost references Images appear properly in reports output to all formats No error messages. Other Maximum size limit for report attachments which can be sent through email in Cognos 8 What is the maximum size limit for report attachments which can be sent through email in Cognos 8? Ideally speaking there is no size limit for the report attachment in Cognos 8 which can be sent through email. UDASQL-0564 [Microsoft SQL Native Client]Invalid length parameter passed to the SUBSTRING function. Cognos 8. usage of unsupported function in the data item expression.
http://www01.3. other reports within the same package runs perfectly no matter it is interactive or batch process.com/support/docview.ibm.wss? uid=swg21343132 The framework manager model which the report base on does not have the with clause setting enable. instead of re-computing the repeating sub queries. Both the BI server and the data base server have plenty of resources. Other Schedule management page items greyed out Report's schedule management page options greyed out when trying to schedule a report. Other Report completes with interactive view. ORA00997 ORA-00997 error message with SELECT DISTINCT statements Running a Report Studio report fails with an Oracle error message. 4) Grant the user orgroup read/write/execute/traverse permissions. assign a name to the resulting data and refer to it. Although. the design of the failing report is pretty simple.Cognos Tool Known Errors and its Resolution Document 57 6) 23 . user can check the setting by 24 . Environment Cognos 8.ibm. Steps:1) Click the "Set Properties" icon for the report. Resolving the problem By default the with Clause setting is being enable when a new model is created. it only Page 57 . AIX 5. Resolving the problem Give read/write/execute/traverse permission to the user/group that need to schedule the report. but runs forever when we save it into the content store. By enabling with clause setting. Cause The issue is a known Oracle problem and is documented in the internet and on the official Oracle sites: Resolving the problem Remove the LONG value from the function or clause or avoid the SELECT DISTINCT http://www01.3.wss? uid=swg21343130 Cause Write permission was not set on the report for the user/group trying to schedule the report. this allow reuse of sub queries. Design of the failing report is also pretty simple. However. 25 . However. but runs forever when save into content store. 2) Click the Permissions tab. it will query or aggregate once. A report (normally finishes within 5 minutes) completes when it is being run interactively.com/support/docview. Oracle data source. 3) Click the "Override the access permissions acquired from the parent entry" checkbox and add the user or group to the list. but it generates SQL statement which contains few identical sub queries.
htm files are being attached in emails from scheduled reports. 28 . Page 58 . Resolving the problem Free space in your Content store database server. external mail recipients do not see these extra files. 27 . Excel will show error: HTTP 404 . click Edit Governors. Environment This only affects email recipients using Microsoft Outlook. CM-SYS-5092 Content Manager failed while returning the query results. Resolving the problem CMPARSEIDS is a stored procedure so grant a user the execute permission on it. 3) Click 'OK' and send the report http://www01.com/support/docview.txt and ATT00002.txt ATT00002. HTML works fine.Cognos Tool Known Errors and its Resolution Document 58 contains few queries. http://www01. From Cognos Connection cannot render reports in PDF or Excel.com/support/docview.txt and ATT00002. From the Project menu.The requested resource() is not available. can be dimensionally modeled. Other Importing deployment package fails: The EXECUTE permission was denied on the object Importing deployment package fails with an error. Adobe Acrobat error message: The file is damaged and could not be repaired. http://www01.com/support/docview. Steps:1) Open the Schedule properties for any affected reports. Resolving the problem Adding text to the main body of the scheduled report run avoids these extra files from being attached. 3. Cause Login used to connect to the content store does not have sufficient permissions on the database to execute the object. Click OK. Check the enable with clause setting.ibm.wss? uid=swg21343137 Cause This issue stems from problems with Microsoft Outlook and/or Microsoft Exchange Server. choose 'Edit the options' 3) Ensure that there is some text in the Body section of the email.ibm. Search Google on "ATT00001.htm Outlook" for more information. Other Cannot render report in PDF.wss? uid=swg21343144 Cause Content Store database run out of space.ibm.wss? uid=swg21343147 The data source is relational. Displays a blank page. 26 . following the below steps Steps:1.htm files attached in email of scheduled reports Unwanted ATT00001. 2. 2) Next to 'Send a link to the report by email'. Other ATT00001.
http://www01.com/support/docview.ibm.Cognos Tool Known Errors and its Resolution Document 59 'CMPARSEIDS' The EXECUTE permission was denied on the object 'CMPARSEIDS'. Ensure that the CRN_ROOT/templates/ps/portal/system./cognos/c8. Cognos Connection doesn't show up.com/support/docview. This happens for all Browsers and all computers and users..ORA00942: table or view does not exist UDASQL-0196 The table or view F_CHARGES" was not found in the dictionary. This requires parsing the templates and configurations made in system. database '<databasename>'.com/support/docview.wss? uid=swg21343152 30 . http://www01.xts Runtime model error when running Cognos 8 Report. Resolving the problem RTM files are local copies of the Run Time Model which are created when the first user has accessed the published package./bin\..wss? uid=swg21343148 29 .xml is valid and correct. PRS-TPR-0352 Failed to open template file /cc.ibm.wss? uid=swg21344278 Cause RTM file corrupted after exporting and importing the package. schema <schemaname>.ibm. UDA-SQL0107 A general exception has occurred during the operation "columns". 31 . Other Runtime model error when running Cognos 8 Report Page 59 . Make sure the user running the Application Server has read access to CRN_ROOT/templates/ and all subdirectories../d Or make a user the owner of the database. Compare it against an original file and check carefully for any additions. The following error occurs in Report Viewer on attempt to run an existing report when a table is drop and recreated in Oracle. PRS-TPR-0352 when accessing Cognos Connection. http://www01. ORA-00942: table or view does not exist. Resolving the problem Add the required permission Grants back to the table.xml for Cognos Connection. Other ORA-00942 Cause The permission Grants for the table was not replicated to put it back to the original state. Error: 1006 occurred while opening runtime model file: '. Environment Oracle database all versions. See the Oracle user guide for details. Other PRS-TPR-0352 Resolving the problem The Presentation Service eventually needs to read templates and generate Cognos Connection HTML from those streamed to the browser. When accessing Cognos Connection an error is returned in the Browser.
delete it and access the package again. http://www- 33 .xml file located in the .ibm.ibm.com/support/docview. Resolving the problem Set the audit logging levels in Server Administration to Basic (the 2nd level) http://www01.xml file 4. Restore valid system.Cognos Tool Known Errors and its Resolution Document 60 ata/cqe/RTModels/UR LID1d1XNjQ0NToxMT Y5ODUyODUzMjkyOj M1OTQ1o1X1e20071 i011i26T181l071l331 j4490000Z.xml file from a new install Steps:1.log files fill up quickly with Request level audit logging enabled Cogserver. 34 . Find related RTM file 3.wss? uid=swg21340911 Cause All report objects are in the Page Header and/or Page Footer sections of the report as opposed to the Page Body.ibm. Log in Cognos connection and access to the package again 5. Other Cogserver.log files fill up quickly with Request level audit logging enabled in Server Administration. Backup the file and delete it 4. Navigating to a portal page returns an error. 32 .com/support/docview. the audit logging levels in Server Administration need to be set at Basic (the 2nd level) and not Request which includes SOAP communications (Service requests and responses) which can fill up a log file very quickly depending on the type of activity in the portal. Resolving the problem Move some of the report objects into the Page Body of the report. Run the report and check if the error still occurs. Navigate to "<c8_install_directory>\cognos\c8\datacqe \RTModels folder 2.wss? uid=swg21371002 Cause Corrupt/Invalid system.xml file 3. Other CPS-PAG-4801 CPS-PAG-4801 Operation failed with consumer component. where audit logging levels need to be set to 3 (mid) the same levels do not apply in Cognos 8." Details: "Error: 1006 The volume for a file has been externally altered so that the opened file is no longer valid. Locate the corrupted RTM file under the directory. To enable logging. Other Running report as PDF gives error: Unable to save this document because it has no pages Attempting to run a report as PDF gives the following: Unable to save this document because it has no pages Page 60 . http://www01.rtm'. Restart services and test http://www01. Backup existing system. A new RTM file will be recreated Steps:1.com/support/docview../template/ps/portal folder Resolving the problem Restore from backup or copy system.wss? uid=swg21340920 Unlike ReportNet. Stop Cognos 8 services 2.
com/support/docview.Cognos Tool Known Errors and its Resolution Document 61 01.wss? uid=swg21340876 Page 61 .ibm.
This action might not be possible to undo. Are you sure you want to continue?
We've moved you to where you read on your other device.
Get the full title to continue listening from where you left off, or restart the preview.