fsaeed
Member
Upgraded SQL 7.0 to 2K and sp_updatestats/\"Unknown Token\" error
We were SQL 7.0SP2, Mdac 2.5RTM, ODBC version 3.70.09.61.
Upgraded to SQL2KSP2, MDAC2.6SP2, ODBC version 2000.80.746.00 + SecurityFix
We are on OneWorld Xe,Sp19+,Update4. 4 Processor box, 4Gig memory, 120Gig drive for the 90gig database.
As stated in Microsoft instructions...we did a sp_updatestats in QA and it worked on a JDE_PD7333 database(6.5Gig). Only does 20% of the Production 90Gig DB and 70% of the JDE7333 (2.5Gig) DB before we got the following error:
.....
.....
Updating PROD.F01151Z1
Updating PROD.F4343
Updating PROD.F4572Z1
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
We are on Win2K Advance Server SP2. No errors reported in Windows or SQL logs. I keep an eye on hardware resources (Memory,HardDrive and CPU) and they don't seem to get hammered during this SQL sp_updatestats command. This command is run while all JDE network/queue services have been stopped.
Any ideas?? Has anyone had this happen to them on a OneWorld database???
Thanks,
Faisal
We were SQL 7.0SP2, Mdac 2.5RTM, ODBC version 3.70.09.61.
Upgraded to SQL2KSP2, MDAC2.6SP2, ODBC version 2000.80.746.00 + SecurityFix
We are on OneWorld Xe,Sp19+,Update4. 4 Processor box, 4Gig memory, 120Gig drive for the 90gig database.
As stated in Microsoft instructions...we did a sp_updatestats in QA and it worked on a JDE_PD7333 database(6.5Gig). Only does 20% of the Production 90Gig DB and 70% of the JDE7333 (2.5Gig) DB before we got the following error:
.....
.....
Updating PROD.F01151Z1
Updating PROD.F4343
Updating PROD.F4572Z1
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
We are on Win2K Advance Server SP2. No errors reported in Windows or SQL logs. I keep an eye on hardware resources (Memory,HardDrive and CPU) and they don't seem to get hammered during this SQL sp_updatestats command. This command is run while all JDE network/queue services have been stopped.
Any ideas?? Has anyone had this happen to them on a OneWorld database???
Thanks,
Faisal