IBM Support

Invalid object name 'RqProjects', when creating a Project Template in RequisitePro

Troubleshooting


Problem

This technote identifies the cause of the error, [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'RqProjects', which is displayed when trying to create a Project Template using IBM® Rational® RequisitePro®.

Symptom

The full error message is as follows:


RqDbUpgradeWiz.frmWizard:cmdNav_Click -> Microsoft OLE DB Provider for ODBC Drivers
3639

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'RqProjects'.

OR


RqDatastoreServices.Template::Save ->RqDatastoreServices.modVersioningUtilities:: DownloadTemplate ->Microsoft OLE DB Provider for ODBC Drivers ->frmWizard:cmdNav_Click
3639

[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ‘RqProjects’.

Cause

This error has two known causes:

  1. The RequisitePro user in SQL server does not have the correct permissions to the RequisitePro tables.
  2. The RequisitePro Login/User to the SQL server does not own all of the tables in the RequisitePro database.

Resolving The Problem

Important notes:

  • When configuring the project, do not use the SA account, use the ReqPro user account to Validate the database.
  • Make sure that the ReqPro user is not set to db_owner

Resolution to Cause 1:

Perform the following to validate the correct permissions have been set on the RequisitePro tables for the RequisitePro user:
Note: This script should only be run by a DBA and should only be done if you have an understanding of what the script does.

Running the login and user.sql script will validate that the ReqPro user has the correct permissions.
Note: If you RequisitePro user is not named ReqPro you will need to modify the login and user.sql script prior to execution which is located at:

C:\Program Files\Rational\RequisitePro\database\sqlserver  

  • If the login and user.sql script runs successfully the ReqPro user has the correct permissions set.
  • If the login and user.sql script does not run successfully you will need to validate that the ReqPro user is configured as specified in the RequisitePro Installation and Upgrade Guide.

Resolution to Cause 2:

If the RequisitePro User does not own all of the tables in the RequisitePro database you can perform one of two options to generate your template.

  1. You can use the Userid that owns the RequisitePro tables when you are creating the template.
  2. You can change the ownership of all the RequisitePro objects to one be owned by a specific user.
    This link from Microsoft shows you how to change the ownership of multiple objects. SQL Server Procedure to Change Object Owner

[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Project Templates","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.01;2003.06.12;2003.06.13;7.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
Rational RequisitePro

Software version:
2003.06.00, 2003.06.01, 2003.06.12, 2003.06.13, 7.0.1

Operating system(s):
Windows

Document number:
80585

Modified date:
16 June 2018

UID

swg21191130

Manage My Notification Subscriptions

Page Feedback