Kbase P98576: Oracle DataServer does not pull the table or the sequence name ends with _SEQ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/10/2010 |
|
Status: Verified
SYMPTOM(s):
Oracle DataServer does not pull the table or the sequence name ends with _SEQ
The pre-selection criteria screen also does not list the table or sequence name ends with _SEQ
FACT(s) (Environment):
During the protoora the tables and the sequences are created in the oracle database.
The table can be seen when describe the table in the Oracle's SQL*PLUS
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
CAUSE:
The ORACLE DataServer product uses ORACLE sequences whose name end with _SEQ for RECID support. The table or sequence names end with _SEQ will be filtered out by the oracle DataServer engine. Therefore, it will not be pulled to the schema holder nor will it be visible in the pre-selection screen during Update/add schema holder.
FIX:
Rename the progress tables and sequence names those end with either -seq or _seq before performing the protoora