Kbase P104722: Can't define temp-table with HANDLE or ROWID field in TEMP-DB Maintenance Tool
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/09/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
SYMPTOM(s):
Using TEMP-DB maintenance tool to manage temp-tables
Adding definition of temp-table with HANDLE, WIDGET-HANDLE or ROWID field
Trying to save new definitions to temp-db
The following error occurs:
Error occurred during load. Press OK to back out transaction.
CAUSE:
This is a product limitation due to the way the Temp-db maintenance tool is designed.
Traditionally, the definitions of the tables in the TEMP-DB is maintained using the Data Dictionary tool. The temp-db maintenance tool was designed on top of this, with the purpose of keeping an include file in sync with the definitions in the TEMP-DB database.
As a result, when trying to write modifications in the include file back to the TEMP-DB database the schema of that database will be updated. The database itself does not support the affected datatypes, which is why the errors occur.
FIX:
No fix is available.
The product is working as designed