Kbase P142819: Loading .dfsql file generated by the sqlschema utility results in syntax errors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2009 |
|
Status: Unverified
SYMPTOM(s):
Loading .dfsql file generates syntax errors
.dfsql file contains entries for a blank user name such as:
GRANT SELECT ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
GRANT INSERT ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
GRANT DELETE ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
GRANT INDEX ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
GRANT ALTER ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
GRANT UPDATE ON ?PUB?.?TABLENAME? TO ?? WITH GRANT OPTION;
FACT(s) (Environment):
Windows
OpenEdge 10.1C
CAUSE:
Bug# OE00182028
FIX:
The workaround at the moment is to either remove the lines related to the blank user name or replace the blank user name with an existing user name and attempt to re-load the .dfsql again.