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
