415
hi ,
i have problem when doing conversion from solomon system database ver 6.0 to 2011 version.. it sucess and i can go in to my company database .. after certain try it does not allow me to access and prompt this error message 9808
Sys Msg 9808 "This database may be a preliminary conversion database" occurs in Solomon
is there anyway to solve this problem .. hope hear u all reply and thanks for viewing :)
*This post is locked for comments
DONE!!!!!! :)
So... you have to prepare some tables after the upgrade (from SL7.00 to SL7.03 FP1 Sp4).
You have to check in all tables where Crtd_User = '(PC)' (I have a sql script that do that job for me) Then... UPDATE then to something like this Crtd_User = 'UPGRADE' (or whatever) (Just in case, maybe not necesary at all, I updated Crtd_prog = 'SolFFTW' to Crtd_prog = 'HEINLEIN' (or whatever too)
Then I process de database with Database Maintenance with the option: "6.5x, 7.x to 7.0 SP4"
And the apocalyptic message just "go away"....
PD: I Updated this tables:
UPDATE Vendor SET Crtd_User = 'UPGRADE' where crtd_user = '(PC)'
UPDATE CuryRate SET Crtd_User = 'UPGRADE' where crtd_user = '(PC)'
UPDATE POAddress SET Crtd_User = 'UPGRADE' where crtd_user = '(PC)'
UPDATE Terms SET Crtd_User = 'UPGRADE' where crtd_user = '(PC)'
UPDATE Vendor SET Crtd_prog = 'HEINLEIN' where Crtd_prog = 'SolFFTW'
UPDATE CuryRate SET Crtd_prog = 'HEINLEIN' where Crtd_prog = 'SolFFTW'
UPDATE POAddress SET Crtd_prog = 'HEINLEIN' where Crtd_prog = 'SolFFTW'
UPDATE Terms SET Crtd_prog = 'HEINLEIN' where Crtd_prog = 'SolFFTW'
PD2: MsDynamicsSL.EXE searches at least in this tables:
SELECT COUNT(*) FROM GLSetup (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM Account (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM InTran (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM Vendor (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM CuryRate (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM POAddress (nolock) WHERE crtd_user = '(PC)'
SELECT COUNT(*) FROM Terms (nolock) WHERE crtd_user = '(PC)'
hI THIS COULD BE THE FIX I AM LOOKING FOR, could i get step by step instructions, thank you
Look at this...
solve the problem edy .. i go to GL setup for the problem company database and set zcount = 0 .. after that it can continue to access the company using dynamic SL app
FastForward tools were used to convert a database from Scalable SQL version of SL (2.06) to the MS SQL version (5.x). I think what is happening is 6.0 did not check for the preliminary conversion data flags. When you upgraded to 2011, the software is now checking for those.
fastforward tools ??? i use the microsoft dynamic SL database maintainance in which comes with the application ..
Sounds like there was a problem in the conversion to 6.0 using the FastForward Tools. I don't recall exactly what FastForward did to flag a database when that occured but I think it was something in the GLSetup table and elsewhere. You should be able to contact support to resolve this issue.
anyone ??? thanks
anyone can share idea regrading for my problem ?? really need some help here and thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (