RRDI and RPTUSER problem - Cannot get past
I am having a problem with installing RRDI on Windows 2008 Server. I have tried this with both DB2 and SQL Server and cannot get past the issue. Can someone please expand in the instructions for creating the RPTUSER account. The instructions have a gap - they state that it is a OS user ID and then state what permissions it should have on the DW database. How are those permissions applied ? The instruction I have are :
Create an “RPTUSER” user account on the system hosting the data warehouse. Cognos will use this account for reports to query the DW, so you’ll need its password. This user must have sufficient rights in the database to connect and query all the tables and views in the DW. It does not need insert, update, or delete privileges. I have created the OS user, I have then created a SQL Server user ID that is 'linked' to the OS user and assigned the db_datareader permission to it but all I get is : CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4785E: The report user RPTUSER does not exist. Create the user account with the required privileges (if any) before running the setup utility. Error Code: 4785'. In the tomcat Window for the setup process I get this : 22:16:56,871 [http-bio-10443-exec-9] INFO rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0123I: Start to validate the database. 22:16:56,871 [http-bio-10443-exec-9] INFO rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0123I: Start to validate the database. 22:16:57,116 [http-bio-10443-exec-19] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0137I: Loading the model 22:16:57,116 [http-bio-10443-exec-19] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0137I: Loading the model 22:16:57,122 [http-bio-10443-exec-19] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0139I: Loaded the model 22:16:57,122 [http-bio-10443-exec-19] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0139I: Loaded the model 22:16:57,138 [http-bio-10443-exec-9] INFO ibm.rational.rrdi.setup.db.common.RRD IDBConnection - Database connection URL: jdbc:sqlserver://rational-srv-08:1433; databaseName=dw;integratedSecurity=true 22:16:57,138 [http-bio-10443-exec-9] INFO ibm.rational.rrdi.setup.db.common.RRD IDBConnection - Database connection URL: jdbc:sqlserver://rational-srv-08:1433; databaseName=dw;integratedSecurity=true 22:17:07,202 [http-bio-10443-exec-9] ERROR .ibm.rational.rrdi.setup.db.common.RR DIDBException - CRRRD4785E: The report user RPTUSER does not exist. Create the user account with the required privileges (if any) before running the setup uti lity. Error Code: 4785 22:17:07,202 [http-bio-10443-exec-9] ERROR .ibm.rational.rrdi.setup.db.common.RR DIDBException - CRRRD4785E: The report user RPTUSER does not exist. Create the user account with the required privileges (if any) before running the setup uti lity. Error Code: 4785 22:17:07,207 [http-bio-10443-exec-9] ERROR rdi.setup.steps.EnterpriseDataWarehou seStepService - com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD478 5E: The report user RPTUSER does not exist. Create the user account with the re quired privileges (if any) before running the setup utility. Error Code: 4785 22:17:07,207 [http-bio-10443-exec-9] ERROR rdi.setup.steps.EnterpriseDataWarehou seStepService - com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD478 5E: The report user RPTUSER does not exist. Create the user account with the re quired privileges (if any) before running the setup utility. Error Code: 4785 22:17:07,208 [http-bio-10443-exec-9] ERROR rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0131E: An error happened when validating the database. 'co m.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4785E: The report user RPTUSER does not exist. Create the user account with the required privileges ( if any) before running the setup utility. Error Code: 4785'. 22:17:07,208 [http-bio-10443-exec-9] ERROR rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0131E: An error happened when validating the database. 'co m.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4785E: The report user RPTUSER does not exist. Create the user account with the required privileges ( if any) before running the setup utility. Error Code: 4785'. 22:17:07,211 [http-bio-10443-exec-9] INFO rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0124I: Exit to validate the database. 22:17:07,211 [http-bio-10443-exec-9] INFO rdi.setup.steps.EnterpriseDataWarehou seStepService - CRRRA0124I: Exit to validate the database. The installation instructions are confusing and don't help. There are pre-requisite steps, jump off points etc. Why cannot we have simple instructions in a single straight through document for each scenario - there cannot be that many ? |
6 answers
Have you tried entering "rptuser" in the Configure the Data Warehouse Setup page, rather then "RPTUSER"? Even though the user shows as "RPTUSER" on my Win 7 machine, I got an error from Setup with that and "rptuser" worked. I don't remember if it was the same error as you are showing.
I'm using DB2, so I can't say anything about SQL Server. |
Hi Kunal,
Please check the below information on creating the rptuser on a sql server.
Remember to create the userid using the lowercase letters 'rptuser'.
If you are using Microsoft SQL Server with Windows authentication, create a namespace.
Before you create a namespace:
|
Hi,
I was able to over come issue by following the below steps.
Created rptuser under Local Users and Groups>User
From Groups>DB2ADMINs>Add rtpuser
and from user>DB2USERS>Add rptuser
Then try validating,this should solve the issue
|
Can someone help us :) |
Can someone help us :) |
Has anyone been able to resolve this issue on SQL Server? I am installing Rational Insight 1.1.1.2 and have run into this issue. Unable to move past this. Thanks.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.