Kbase P107927: Trying to use the dump sequence option from Data Admin Dump Definitions Tool for a foreign data sour
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2005 |
|
Status: Unverified
FACT(s) (Environment):
DataServers
SYMPTOM(s):
trying to use the dump sequence option from Data Admin Dump Definitions Tool for a foreign data source
Utility issuing error "You tried to perform some PROGRESS operation on a MSS database."
Tried using regular dump definition utility but no tables to select
only user object in schema holder is a sequence
CAUSE:
The Data Administration->Dump Definitions->Sequence Definitions is written for the Progress Database only so will check to see what database type is the working database. If it is not Progress then an error is issued and the utility is closed. Since the schema holder has only a sequence definition there are no tables to select so the Data Administration->Dump Definitions->Data Definitions will not work.
FIX:
There are actually hidden table definitions contained in the schema holder that are added by the DataServer Utilities. Follow the following steps to get your sequence definition dumped:
1. Select the "Show Hidden" box to display all the hidden files.
2. Select all files.
3. Select OK.
4. The name of the df file will be <database name>.df and Select OK and generate the df file.
5. Remove the ADD DATABASE, ADD TABLE, ADD FIELD and ADD INDEX syntax from the df leaving only the ADD SEQUENCE syntax.
Another workaround would be to pull just one table definition from the foreign data source and then follow steps 2 - 5.
The modified definition file can now be loaded into any schema holder which needs the sequence definition.