The upgrade script runs for quite sometime before the program seems to hang and issues various error messages.
The program may issue the following errors:
- At pass through: Error = 3146 Application-define or object-defined error
- Error in ErrorTrap code! Error = 3127: The INSERT INTO statement contains the following unknown field name” ‘USER’. Make sure you have typed the name correctly, and try the operation again.
- At Startup: Error = 3146: ODBC – call failed
The user is asked to login to SEOM, the process will run for a while and the same messages may appear repetitively.
There is no confirmation of successful completion, but the Log-In screen may appear.
When attempting to login, the Error in ErrorTrap message described above may be issued, or “At CheckTables: Error = 91: Object variable of With block variable not set” may be encountered.
ODBC Timeout errors are occurring during the upgrade process, preventing the upgrade script from successfully completing the conversion of the data file.
Set system parameter SQLServerODBCTimeout to a number significantly higher than the default value of 60.
Component and Versions Affected
- Any Enterprise Edition, when using an SQL store data file.