It's all about the answers!

Ask a question

RRDI and RPTUSER problem - Cannot get past


Mark Roberts (1205338) | asked Jun 20 '12, 5:20 p.m.
JAZZ DEVELOPER
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



permanent link
Michael Fox (61643) | answered Jun 25 '12, 9:46 a.m.
JAZZ DEVELOPER
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.


permanent link
Prasad Annamdasu (15453643) | answered Dec 19 '13, 11:42 p.m.
 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.
  1. Start IBM® Cognos® Configuration, expand the Security node, right-click Authentication, and click New resource > Namespace.
  2. Specify the following details:
    • Type:  NTLM
    • Namespace ID:  Local NT ID
  3. Save the changes and restart WebSphere® Application Server



permanent link
Prakash Havargi (211) | answered Jan 29 '14, 10:32 a.m.
 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

permanent link
Prasad Annamdasu (15453643) | answered Jun 25 '12, 1:12 a.m.


HI, I too have the same problem.

Can someone help us :)


permanent link
Prasad Annamdasu (15453643) | answered Jun 25 '12, 1:12 a.m.


HI, I too have the same problem.

Can someone help us :)


permanent link
Kunal Bajaj (26810) | answered Dec 19 '13, 11:45 a.m.
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


Register or to post 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.