Consultor Eletrônico



Kbase P86503: Error importing a table
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Unverified

FACT(s) (Environment):

Dynamics

SYMPTOM(s):

Error importing a table

The following error has occurred while processing (AF:40)

Table <tablename> has already been imported for database <dbname>.
Import aborted

Table had been imported previously without error

This import being done with a different logical database name

First import of the table was using a logical name of db1, later the schema is updated and the table needs to be reimported therefore an import is done however the logical name is now db2.

CAUSE:

The logical dbname is written into the icfdb and compared when the next import is done, if they are not the same the error is raised

FIX:

Either:
1. Delete the imported table and then import the table with the new logical name.

2. Update the entity_dbname for the affected table in the gsc_entity_mnemonic table to be db2