{"id":251,"date":"2009-07-29T10:35:00","date_gmt":"2009-07-29T10:35:00","guid":{"rendered":"http:\/\/asgaur.com\/wp\/?p=251"},"modified":"2009-07-29T10:35:00","modified_gmt":"2009-07-29T10:35:00","slug":"cognos-reportnet-installation-procedure","status":"publish","type":"post","link":"http:\/\/www.asgaur.com\/wp\/cognos-reportnet-installation-procedure\/","title":{"rendered":"Cognos: ReportNet Installation Procedure"},"content":{"rendered":"

Pre Installation Requirements<\/strong>
\nThe following Software’s must be installed and running before installing and configuring Cognos ReportNet <\/p>\n

<\/p>\n

  • Database (Oracle\/DB2\/SQL Server) for Content Store<\/li>\n
  • Web Server (IIS\/Apache) <\/li>\n

    Note: This document will focus on Oracle Database and Internet Information Services (IIS) Web Server only. <\/p>\n

    Oracle <\/strong>\n <\/p>\n

  • For creation of Content store, the database must support Unicode Character set. Ensure that Oracle is installed with a Unicode Character set.<\/li>\n
  • To check whether the installed Oracle database supports Unicode Character set, type the following SQL Select * from NLS_DATABASE_PARAMETERS;<\/li>\n
  • \nCreate a user and grant ‘Create’ & ‘Drop’ privileges for the content store to the user account<\/li>\n
  • Ensure the user account is granted ‘CONNECT’ and ‘RESOURCE’ roles.<\/li>\n

    IIS <\/strong> \n <\/p>\n

  • Internet Information Services should be installed and running. <\/li>\n

    \nInstallation <\/strong>
    \nThe steps guide the user to install Cognos ReportNet on a single computer. This installation takes the default path of Cognos. The components that gets installed are
    \n1. ReportNet Server
    \n2. Content Manager
    \n3. Dispatcher <\/p>\n

    Note: Components can be installed in different systems. For configuration of such installations refer Cognos Documentation.
    \nPost Installation Configuration
    \nThe following points must be taken care of before accessing the Cognos ReportNet tools and must follow the same order. <\/p>\n

    1.\tSet-up of JDBC Client for Cognos Applications to Content store.
    \n2.\tSet-up database connection properties.
    \n3.\tConfigure Web Server <\/p>\n

    Note: This document will focus on Oracle Database and Internet Information Services (IIS) Web Server only. <\/p>\n

    Set-up of JDBC Client for Cognos Applications to access Content store <\/strong> <\/p>\n

    Cognos Applications interact with Content store only through JDBC Client. Hence ensure that proprietary JDBC client of Oracle is made available in Cognos default libraries path. Follow the below steps to ensure the same. <\/p>\n

    <\/p>\n

    1.\tRename the classes12.zip file to classes12.jar file (Note: Ensure that the file extension option in explorer window is enabled)
    \n2.\tCopy the classes12.zip file from Oracle home directory and paste the same under Cognos Default location.<\/p>\n

    Set-up of Database Connection properties <\/strong> <\/p>\n

    ReportNet. Hence in order for Cognos applications to work, Cognos ReportNet needs to be configured with Content Store. The following steps guide you to configure content store using Cognos Configuration tool.<\/p>\n

    For all installations, the database server information must be provided to ensure that ReportNet can connect to the database to use the content store. <\/p>\n

    Note: The following steps guide to configure only for Oracle Database. For other databases please refer Cognos manual. <\/p>\n

    1.\tOpen Cognos Configuration from Start -> Cognos ReportNet -> Cognos Configuration
    \n2.\tRight Click on Content Store under Data Access-> Content Manager and Delete.
    \n3.\tRight Click, Content manager, and then click New Resource, Database. The following window shows the same.<\/p>\n

    \"\"<\/p>\n

    4.\tEnter the Name, Type of Database and Click OK<\/p>\n

    \"\"<\/p>\n

    5.\tEnter the Database Server name, Port Number and Service Name.<\/p>\n

    \"\"<\/p>\n

    6.\tEnter the User Id and Password. <\/p>\n

    \"\"<\/p>\n

    7.\tSave the configuration \"\" <\/p>\n

    \"\"<\/p>\n

    8.\tStop \"\" the services.<\/p>\n

    \"\"<\/p>\n

    9.\t Start \"\" the services<\/p>\n

    \"\"<\/p>\n

    Configure Web Server (IIS) The following virtual directory needs to be created Cognos Applications to run over Web. <\/p>\n

    a) Alias Name: crn \n <\/p>\n

  • Path: crn_locationwebcontent<\/li>\n
  • Permission: Read <\/li>\n

    b) Alias Name: crn\/cgi-bin \n <\/p>\n

  • Path: crn_locationcgi-bin <\/li>\n
  • Permission: Execute <\/li>\n

    c) Alias Name: crn\/help \n <\/p>\n

  • Permission: Read <\/li>\n

    \nNote: The names of the virtual directories presented in this document are default. The names can be changed but ‘cgi-bin’ and ‘help’ names CANNOT be changed and must remain the same. <\/p>\n

    Test Installation and Configuration <\/p>\n

    Test the installation by starting the services using Cognos Configuration. Once started open browser and type the following URL http:\/\/hostname\/crn<\/a> <\/p>\n

    The following Cognos Portal on the browser will ensure that your installation and configuration is correct.<\/p>\n

    \"\"
    \nImportant Files to look for <\/p>\n

    The following files are important to look for in case of any configuration problems<\/p>\n<\/p>\n

  • Crnserver.log (crnlogs) <\/drive><\/li>\n
  • log (crnconfiguration)<\/drive><\/li>\n

    Potential Problems & Solutions <\/p>\n<\/p>\n

  • trying to initialize. <\/li>\n

    Problem 1: The database does not support Unicode Character Set
    \nSolution 1:
    \n1. Check whether the database installed supports UTF-8 Encoding. If not migrate to UTF8 from the current Character set.
    \n2. Re-install database with UTF 8 Encoding
    \nProblem 2: The database connection parameters might be wrong
    \nSolution 2: Ensure the database parameters furnished in Content manager is correct. Test the same through the Client of RDBMS vendor. \n <\/p>\n

  • Cognos BI is not available <\/li>\n

    Problem: The ReportNet service is stopped.
    \nSolution: The ReportNet services should be started. Go to Cognos configuration and start the services. <\/p>\n<\/p>\n

  • Problem: Insufficient Privileges <\/li>\n

    Solution: Ensure that the User to connect to Content Store has the Create and Drop Privileges and Connect and Resource Roles .<\/p>\n

    \"\"<\/p>\n

    \"\"\n <\/p>\n

  • \nProblem: Oracle 9i tables are not getting created. <\/li>\n

    \nDPR-ERR-2058 – The dispatcher cannot service the request at this time. The dispatcher is still initializing
    \nSolution: In Cognos Connection in the Content Store node, ensure the Service Name Property (the SID) is not fully qualified. <\/p>\n

    The JDBC Driver uses the SID, not the fully qualified name. \n <\/p>\n

  • Problem: DPR-CMI-4007 An request to perform an active content manager election failed <\/li>\n

    \nSolution: Delete the existing content store connection and recreate the same. \n <\/p>\n

  • Problem: Unable to log into Cognos Connection.<\/li>\n

    \nDPR-ERR-2058 – The dispatcher cannot service the request at this time. The dispatcher is still initializing
    \nSolution: In this case, the problem was that the Content Manager host and port number were accidentally modified and the port number was incorrect. \n <\/p>\n

  • Problem: Tables are locked. <\/li>\n

     CM-SYS-5007 Content Manager build 1.1.162.0 failed to start! Review the Content Manager log files and then contact your system administrator or customer support.  CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. <\/p>\n

    Solution: The tables are locked due to previous improper configuration. Solution is to drop the tables manually, save the configuration in Content manager and restart the services. <\/p>\n

    \"\"<\/p>\n

  • Problem: Unable to save the configuration in the Cognos Configuration <\/li>\n

    \"\"<\/p>\n

    Solution: Read the below advisory notice from Cognos. <\/p>\n

    Dear Cognos Customer or Partner:
    \nThis is a product advisory regarding the expiry of the JCE Certificate in Cognos ReportNet and Cognos Metrics Designer (Advisory Reference: ADVCRN04_0405).
    \nIn June and updaed in july, Cognos posted a product advisory on     http:\/\/support.cognos.com<\/a> to notify Cognos ReportNet and Cognos Metrics Manager customers and partners of a potential problem caused by the expiry of the JCE certificate in Sun’s Java Runtime Environment (JRE).<\/p>\n

    Recommended Action(s) To eliminate the potential for failure in Cognos ReportNet or Cognos Metrics Designer operation, we recommend that you determine if your Cognos ReportNet or Cognos Metrics Designer installation relies on JCE version 1.2.1 and if so, download and install the updates for the product applicable to you. Please note that Cognos will not be liable for any loss or damages arising from the failure to implement these recommended action(s). Customers who have a current support contract can view the full JCE product advisory and download and install the updates using their Cognos Support Web account login. <\/p>\n<\/p>\n

  • Problem: Database configuration of schema problem <\/li>\n

    \n\"\"<\/p>\n

    Solution: Read the below below script and make fresh schema using it. <\/p>\n

    CREATE TABLESPACE TBS_content_store
    \nDATAFILE '\/abcd04\/sso432\/data\/content_store_df.dbf'
    \nSIZE 2048 M
    \nAUTOEXTEND ON
    \n;<\/p>\n

    CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
    \n'\/abcd04\/sso432\/data\/temp01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 100M MAXSIZE 10240M
    \nTABLESPACE GROUP ''
    \nEXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;<\/p>\n

    \nCREATE USER content_store
    \nIDENTIFIED BY content_store123
    \nDEFAULT TABLESPACE TBS_content_store
    \nTEMPORARY TABLESPACE temp
    \n;<\/p>\n

    grant create session to content_store;
    \ngrant connect,resource to content_store;
    \ngrant create table to content_store;
    \ngrant create view to content_store;
    \ngrant create synonym,create public synonym to content_store;
    \ngrant create procedure to content_store;
    \ngrant create trigger to content_store;
    \ngrant create sequence to content_store;<\/p>\n

    <\/code><\/p>\n

    \n

    Original post<\/a> blogged on b2evolution<\/a>.<\/small><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Pre Installation Requirements The following Software’s must be installed and running before installing and configuring Cognos ReportNet Database (Oracle\/DB2\/SQL Server) for Content Store Web Server (IIS\/Apache) Note: This document will focus on Oracle Database and Internet Information Services (IIS) Web Server only. Oracle For creation of Content store, the database must support Unicode Character set. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-251","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":0,"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.asgaur.com\/wp\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}