About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
This technote identifies a possible solution to the error, SP2-0310, which might occur when running the IBM® Rational® RequisitePro® configuration scripts for Oracle.
Cause
When running the Oracle configuration scripts for RequisitePro for the following error occurs when using SQL*PLUS to specify the path to the create_reqpro.sql file:
SQL> @C:\Documents and Settings\user\Desktop\Oracle scripts\create_reqpro.sql
The user receives the following error message:
SP2-0310: unable to open file "C:\Documents.sql"
This error is caused by the spaces contained in the path to the create_reqpro.sql script.
Resolving The Problem
To resolve this issue you need to specify the path to the create_reqpro.sql using the 8.3 DOS Naming convention:
Converting the path to the script to match the 8.3 Naming Convention.
For example:
C:\Documents and Settings\user\Desktop\Oracle scripts\create_reqpro.sql
8.3 Naming Convention:
C:\Docume~1\user\desktop\Oracle~1\create_reqpro.sql
Once you have converted the path to the 8.3 Naming Convention you will be able to rerun the create_reqpro.sql script in SQL*PLUS successfully.
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: Oracle","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002.05.20;2003.06.00;2003.06.01;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15;7.0;7.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Historical Number
151035317
Was this topic helpful?
Document Information
More support for:
Rational RequisitePro
Software version:
2002.05.00, 2002.05.20, 2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 7.0, 7.0.1
Operating system(s):
Windows
Document number:
328571
Modified date:
16 June 2018
UID
swg21131726
Manage My Notification Subscriptions