Troubleshooting
Problem
An error appears when running the database creation scripts for SQL Server.
Symptom
The following are the errors that are displayed.
For tables and indexes.sql the following error appears.
Server: Msg 4902, Level 16, State 1, Line 158
Cannot alter table 'RqRequirementHistory' because this table does not exist in database 'RequisitePro'.
If you continue with the rest of the scripts, the following error appears for initial data.sql.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'rqrequisite'.
Cause
The cause has been confirmed to be case-sensitivity. This issue has been identified as a product defect and has been logged under APAR PK81029.
Resolving The Problem
By default a SQL Server Database should not be case sensitive. The problem can be resolved by using one of the two methods below.
- Have your database administrator create a new database that is not case sensitive.
- Modify the scripts to correct the case.
Intables and indexes.sqlthe following is the section that needs to be updated. Make sure that the table names are all upper case.
/* New objects for 7.1 */
ALTER TABLE RqRequirementHistory ADD FLAGS INT NOT NULL DEFAULT 0 ;
ALTER TABLE RqDocumentHistory ADD FLAGS INT NOT NULL DEFAULT 0 ;
ALTER TABLE RqProjectHistory ADD FLAGS INT NOT NULL DEFAULT 0 ;
ALTER TABLE RqProjects ADD WEBSERVER VARCHAR(255);
Ininitial data.sqlupdate the occurrences of@Replaceto@replace.
Was this topic helpful?
Document Information
More support for:
Rational RequisitePro
Software version:
7.1
Operating system(s):
Windows
Document number:
621325
Modified date:
16 June 2018
UID
swg21376123