Upgraded SQL 7.0 to 2K and sp_updatestats/"Unknown Token" error

[fsaeed]

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

 

[SSAJAROFF]

Re: Upgraded SQL 7.0 to 2K and sp_updatestats/\"Unknown Token\" error

Hi Faisal,

If I were you, would backup content and structure of PROD.F4572Z1, drop that
table, recreate it (from its scripts), recreate its indexes and restore its
data.
Sometimes, SQL goes simply mad!

Regards, Sebastian Sajaroff

Montreal, Canada

----- Original Message -----
From: "fsaeed" <[email protected]>
To: <[email protected]>
Sent: Wednesday, October 08, 2003 3:16 PM
Subject: Upgraded SQL 7.0 to 2K and sp_updatestats/"Unknown Token" error


SecurityFix
drive for the 90gig database.
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:
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.
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=62329
messages, login to http://www.jdelist.com/forums, click Control Panel, then
click Edit by "Subscribe / Unsubscribe from receiving board posts by email,
change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®



ERP8 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
[email protected]
Canada

 

[Alex_Pastuhov]

Re: Upgraded SQL 7.0 to 2K and sp_updatestats/\"Unknown Token\" error

I have seen similar errors before. In all cases I found them to be caused by MDAC and changing MDAC version always helped.

Could also be a network error, I suppose, though unlikely if you run the script on the DB Server machine locally.

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm