Upgrade to 2014 Sage-50 US edition causing me major headaches

Sage 50 Accounting U.S.

Sage 50 Accounting U.S.
Welcome to the Sage 50 Accounting U.S. edition product support community! Here you can ask questions, discuss the product and share best practices with other Sage 50 U.S. users.

Upgrade to 2014 Sage-50 US edition causing me major headaches

This question is answered

Hello,

I was prompted to perform the upgrade to 2014 Sage-50 US Edition.  Was prompted to convert database.  Afterward, when I attempted to use the Sage .NET API to talk to it, I ran into errors...

Sage.Peachtree.API.Exceptions.UntranslatedException was unhandled   HResult=-2146232832   Message=Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Invalid procedure name.   Source=JobPro.SageIntegration   StackTrace:        at JobPro.SageIntegration.SageConnection.OpenCompany(Guid companyGUID) in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegration\SageConnection.cs:line 154        at JobPro.SageIntegration.SageConnection.StartSageConnection() in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegration\SageConnection.cs:line 88        at JobPro.SageIntegrationWinUtil.frmConnect.ConnectToSage50() in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegrationWinUtil\frmConnect.cs:line 65        at JobPro.SageIntegrationWinUtil.frmConnect.btnConnect_Click(Object sender, EventArgs e) in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegrationWinUtil\frmConnect.cs:line 46        at System.Windows.Forms.Control.OnClick(EventArgs e)        at System.Windows.Forms.Button.OnClick(EventArgs e)        at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)        at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)        at System.Windows.Forms.Control.WndProc(Message& m)        at System.Windows.Forms.ButtonBase.WndProc(Message& m)        at System.Windows.Forms.Button.WndProc(Message& m)        at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)        at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)        at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)        at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)        at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)        at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)        at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)        at System.Windows.Forms.Application.RunDialog(Form form)        at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)        at JobPro.SageIntegrationWinUtil.frmMain.openConnectionToolStripMenuItem_Click(Object sender, EventArgs e) in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegrationWinUtil\frmMain.cs:line 343        at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)        at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)        at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)        at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)        at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)        at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)        at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)        at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)        at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)        at System.Windows.Forms.Control.WndProc(Message& m)        at System.Windows.Forms.ScrollableControl.WndProc(Message& m)        at System.Windows.Forms.ToolStrip.WndProc(Message& m)        at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)        at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)        at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)        at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)        at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)        at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)        at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)        at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)        at System.Windows.Forms.Application.Run(Form mainForm)        at JobPro.SageIntegrationWinUtil.Program.Main() in c:\sptfs\JobPro\JP_NET\JobPro-Dev\JobPro.SageIntegrationWinUtil\Program.cs:line 32        at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)        at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)        at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()        at System.Threading.ThreadHelper.ThreadStart_Context(Object state)        at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)        at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)        at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)        at System.Threading.ThreadHelper.ThreadStart()   InnerException: Sage.SBD.ACS.Framework.DataTypes.DatabaseException        HResult=-2146232832        Message=Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Invalid procedure name.        Source=Sage.Peachtree.Domain        StackTrace:             at Sage.Peachtree.Domain.Entities.BaseDomainEntity.SaveInternal()             at Sage.Peachtree.Domain.Entities.BaseDomainEntity.SaveTemplateMethod()             at Sage.Peachtree.Domain.Entities.BaseDomainEntity.Save()             at Sage.Peachtree.Domain.APICompanyContext.VerifyAccess(Boolean requestAccess, IDictionary`2 authenticationCredentials)             at Sage.Peachtree.API.PeachtreeSession.VerifyOrRequestAccess(CompanyIdentifier companyId, Boolean isAccessRequest, IDictionary`2 authenticationCredentials)        InnerException: Pervasive.Data.SqlClient.PsqlException             HResult=-2147467259             Message=Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Invalid procedure name.             Source=Pervasive.Data.SqlClient             ErrorCode=-2147467259             Number=-5220             SQLState=0             StackTrace:                  at Pervasive.Data.SqlClient.Lna.w.a(String , ad , l )                  at Pervasive.Data.SqlClient.PsqlCommand.a(Boolean , CommandBehavior , Boolean )                  at Pervasive.Data.SqlClient.PsqlCommand.ExecuteNonQuery()                  at Sage.SBD.ACS.Framework.DataAccess.EntityDLO.SaveInternal(Int32 groupNumber, EntityDHO dho, DbOperationContext dbOperation)                  at Sage.SBD.ACS.Framework.DataAccess.EntityDLO.Save(TableMergeRule mergeRule, EntityDHO& dho, DbOperationContext dbOperation)             InnerException:

 

After chatting with support staff at Sage, I was instructed to perform a repair.  I did this, but this did not resolve the error.  2nd chat session ended in my doing a complete uninstall and reinstall of my Sage Product.  However,  the Sage API continues to give an error in that it expects to find the Sage.PeachTree.API.dll v2.0.202 which it cannot find.  Have finally resolved to uninstall the sage app again, remove all Sage APIs from the GAC and registry, and try to install again.

Was there a new SageSDK I needed to install or something?

 

David

Verified Answer
  • Ok.  I worked through the issue but am now stuck in an older version of Sage-50 until I find the time to try again.  

    Clearing out instances of the following dlls from the GAC and reinstalling Sage from the source I originally used to install from, did the trick:

        Sage.PeachTree.API.dll

        Sage.PeachTree.API.Resolver.dll

        policy.2014.0.Sage.Peachtree.API.dll

        policy.2014.0.Sage.Peachtree.Resolver.dll

All Replies
  • Ok.  I worked through the issue but am now stuck in an older version of Sage-50 until I find the time to try again.  

    Clearing out instances of the following dlls from the GAC and reinstalling Sage from the source I originally used to install from, did the trick:

        Sage.PeachTree.API.dll

        Sage.PeachTree.API.Resolver.dll

        policy.2014.0.Sage.Peachtree.API.dll

        policy.2014.0.Sage.Peachtree.Resolver.dll