Hi all, I am new to the company and I am taking the OpenEdge Database Administration course online. What I am trying to do is creating a new void database but first validating my .st file for correct syntax. All instructions for creating the .st file are correct and placed in the right directory but when I go to run the prostrct create devdb devdb.st -validate command in Proenv, I get an error saying the file could not be read (6918). Please help!
I am on OpenEdge Enterprise RDBMS
My ST:
#
b . f 320
b . f 320
b .
#
d "Schema Area":6,32;1 .
#
d "Employee":7,32;8 . f 320
d "Employee":7,32;8 . f 320
d "Employee":7,32;8 .
#
d "Inventory":8,32;8 . f 640
d "Inventory":8,32;8 . f 640
d "Inventory":8,32;8 .
#
d "Cust_Data":9,32;8 . f 320
d "Cust_Data":9,32;8 . f 320
d "Cust_Data":9,32;8 .
#
d "Cust_Index":10,32;8 . f 320
d "Cust_Index":10,32;8 . f 320
d "Cust_Index":10,32;8 .
#
d "Order":11,32;8 . f 1280
d "Order":11,32;8 . f 1280
d "Order":11,32;8 .
#
d "Misc":12,32;8 . f 320
d "Misc":12,32;8 . f 320
d "Misc":12,32;8 .
#
a . f 320
a . f 320
a . f 320
Command:
proenv>prostrct create devdb devdb.st -validate
OpenEdge Release 11.6 as of Fri Oct 16 19:02:26 EDT 2015
PROSTRCT CREATE: cannot read file devdb.st, command ignored. (6918)
It's a read permission on .st file:
[george@localhost tmp]$ ls -l test.st -rw-rw----. 1 root root 575 Jul 4 09:31 test.st [george@localhost tmp]$ prostrct create test test.st -validate PROSTRCT CREATE: cannot read file test.st, command ignored. (6918)
and
[george@localhost tmp]$ ls -l test.st -rw-rw-r-x. 1 root root 575 Jul 4 09:31 test.st [george@localhost tmp]$ prostrct create test test.st -validate /usr/wrk/tmp/test.db: Permission denied PROSTRCT CREATE: unable to create file /usr/wrk/tmp/test.db. (6923)
Cutting and pasting the content of your ST, the command and the exact error message will go a long way towards helping. It's also a good idea to always mention the platform and Progress version.
For example, if the O.S. errno associated with the (6918) was 2, then this signifies "File not found". 13 means "Permission denied'.
Your .st file is correct. I think the directory where you placed the .st file is not correct. I would try placing the .st file in the current directory (from the directory where you are running PROSTRCT command) first and see what happens.
It's a read permission on .st file:
[george@localhost tmp]$ ls -l test.st -rw-rw----. 1 root root 575 Jul 4 09:31 test.st [george@localhost tmp]$ prostrct create test test.st -validate PROSTRCT CREATE: cannot read file test.st, command ignored. (6918)
and
[george@localhost tmp]$ ls -l test.st -rw-rw-r-x. 1 root root 575 Jul 4 09:31 test.st [george@localhost tmp]$ prostrct create test test.st -validate /usr/wrk/tmp/test.db: Permission denied PROSTRCT CREATE: unable to create file /usr/wrk/tmp/test.db. (6923)