IBM Support

Error SP2-0310 when trying to execute the create_reqpro.sql script in SQL*PLUS

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

Document Information

Modified date:
16 June 2018

UID

swg21131726

Page Feedback