PROSTRCT CREATE: cannot read file devdb.st, command ignored.

Posted by Michael Cawthon on 01-Jul-2016 11:18

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)

Posted by George Potemkin on 04-Jul-2016 00:40

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)

All Replies

Posted by Paul Koufalis on 01-Jul-2016 11:40

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'.

Posted by Dileep Dasa on 04-Jul-2016 00:17

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.

Posted by George Potemkin on 04-Jul-2016 00:40

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)

This thread is closed