Windows Server 2003
Macola 7.6.300
Sql 2000
I performed an upgrade from 7.6.200 to 300 today.
Everything went well, I performed the pre-update, client, server and instmac.
No errors on anything.
Now the users are complaining about:
schema check failed cannot find field ar_terms_cc_fg in sycdefil_sql MSL
I don't know much about this thing I got stuck upgrading it due to incompatibility with windows 7.
Can anyone help please?
One of them also claims some companies are updated, some aren't. I'm not sure how he knows or think he knows that..
Thanks,
Kenny
*************EDIT************
Okay I found an upgrade log.
This thing is trying to update tables that don't exist....
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'bmexplwk_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_OECTLFIL_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'oectlfil_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_OEORDLIN_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'oeordlin_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_SYCDEFIL_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]An explicit DROP INDEX is not allowed on index 'sycdefil_sql.PK__SYCDEFIL_SQL__2A363CC5'. It is being used for PRIMARY KEY constraint enforcement.
Macola 7.6.300
Sql 2000
I performed an upgrade from 7.6.200 to 300 today.
Everything went well, I performed the pre-update, client, server and instmac.
No errors on anything.
Now the users are complaining about:
schema check failed cannot find field ar_terms_cc_fg in sycdefil_sql MSL
I don't know much about this thing I got stuck upgrading it due to incompatibility with windows 7.
Can anyone help please?
One of them also claims some companies are updated, some aren't. I'm not sure how he knows or think he knows that..
Thanks,
Kenny
*************EDIT************
Okay I found an upgrade log.
This thing is trying to update tables that don't exist....
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'bmexplwk_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_OECTLFIL_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'oectlfil_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_OEORDLIN_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'oeordlin_sql' because this table does not exist in database 'DATA_110'.
Loading SQL Script from file 'M:\macsql\sqlscript\76300_SYCDEFIL_SQL.SQL'.
Connect Info: Server 'server2', DB 'DATA_110', UID 'sa', Trusted? 0
[Microsoft][ODBC SQL Server Driver][SQL Server]An explicit DROP INDEX is not allowed on index 'sycdefil_sql.PK__SYCDEFIL_SQL__2A363CC5'. It is being used for PRIMARY KEY constraint enforcement.