Pre-synchronization ERROR
k.Naushad
i am upgrading from 3.0 sp1 to 4.0.
during pre-synchronization of upgrade checklist i get the a list of 58 jobs
which
basically deleteduplicates and drop indexes. out of which 7 are giving errors.
these 7 jobs are actually trying to delete duplicates in the following tables
OLAPDataSource, OLAPCubeDatasource, OLAPDataSourceRelation,
OLAPCubeRelation, OLAPDataSourceRange, OLAPDataSourceField, OLAPEnum
when i check the error for all of these 7 jobs it says "invalid Table"
i check for its existence and they do exist in database of 3.0 sys layer and
also the 4.0 where the updatechecklist is running.
Error is being thrown in the class "ReleaseUpdateDB" in method
"DeleteDuplicatesUsing Names" in this method it runs these two lines
Tableid tableid = tablename2id(_tablename);
// _tablename takes names of 7 tables listed above//
Tablename sqlTablename = ReleaseUpdateDB::backendTableName(tableid);
// if _tablename is having any of the above 7 tablenames listed then the
above line of code does not return any value that is the backendtablename is
blank and then the error is thrown by subsequent lines of code for not having
valid table name saying "invalidTable Name".
why is the second line of code not returning the name of the table when the
table
is existing in the database.?
help greatly appreciated.
Luegisdorf
Could it be, that the tables are not physically created on the Database
(MS-SQL/Orcale), and therefore the exception happens?
If yes, you may have to take the old AX 3.0, do synchronize (to create the
missing tables on DB), then start the upgrade ...
Best regards
Patrick