Kbase P147097: Running a CREATE TRIGGER SQL statement results in a "Table/View/Synonym not found (7519)" error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
SYMPTOM(s):
The CREATE TRIGGER SQL statement fails.
Table/View/Synonym not found (7519)
The SYSPROCTEXT and SYSPROCBIN tables are missing from the database.
PROUTIL UPDATESCHEMA does not add the missing tables.
FACT(s) (Environment):
The database was created using OpenEdge 10.1B
The SYSPROCTEXT and SYSPROCBIN tables are needed to create a trigger.
All Supported Operating Systems
OpenEdge 10.1x
CHANGE:
Upgraded from 10.1B to 10.1C
CAUSE:
Bug# OE00185539.
FIX:
Upgrade to OpenEdge 10.2B.
Two workarounds are:
1. With the database offline, run the following command:
proutil db-name -C enablestoredproc
2. Alternatively, dump and load the database into an empty 10.1C (or higher) database. A database created using the prostrct create command will include the SYSPROCTEXT and SYSPROCBIN tables.