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 ?
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.
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:
- If the system that Rational Reporting for Development Intelligence is installed on is on a domain, the RPTUSER user ID must be a domain user.
- If the Rational Reporting for Development Intelligence system is not in a domain, create a local RPTUSER user ID with the same user name and password on both the Rational Reporting for Development Intelligence and the RIDW database systems.