lawrni - Wednesday, September 19, 2007 12:42 PM:
Hi,
I've just tried my first install of Aras innovator and everything seemed to be going OK. I can log in and start making changes and explore the UI etc, but on pressing 'save' on several of the pop-up forms (but not all) I get the following error message (see below).
I guess that there is something not quite right with my database setup.
Can anyone give me some guidance as to what I should do - re-intall the database/ create a new database ? Point me to the right place in the database to check to see if something did not install correctly.
Many thanks (in advance)
Nick
The method associated with the server event onAfterAdd failed: Method SQL PROCESS was not found.GetMethodIDByNameFromCache returned an empty stringat System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at Aras.Server.Core.XML.SetErrorMessage(XmlDocument& xmlDom, Int64 faultCode, String& errorMessage, String& dbMessage) at Aras.Server.Core.ApplyItem.ExecuteServerEvent(XmlDocument& itemDom, XmlDocument& errorDom, String ItemTypeID, String eventName, Boolean MustBeCalled) at Aras.Server.Core.CCProxy.ExecuteServerEvent(XmlDocument& itemDom, XmlDocument& errorDom, String ItemTypeID, String eventName, Boolean MustBeCalled) at Aras.Server.Core.AddItem.AddItem_Implementation(XmlDocument& inDom, Hashtable& AdditionalItemInfo, XmlDocument& outDom, XmlDocument& relatedItemDom) at Aras.Server.Core.AddItem.AddItem(XmlDocument& inDom, Hashtable& AdditionalItemInfo, XmlDocument& outDom) at Aras.Server.Core.ApplyItem.ApplyItem_Implementaion(XmlDocument& inDom_, Hashtable& AdditionalItemInfo, XmlDocument& outDom) at Aras.Server.Core.ApplyItem.ApplyItem(XmlDocument& inDom, XmlDocument& outDom) at Aras.Server.Core.Utilities.ApplySoapAction(String& soap_action, XmlDocument& inDom, XmlDocument& outDom, Boolean sec_chk, TextWriter writer) at Aras.Server.Core.Startup.soap_action_dispatch() at Aras.Server.Core.Startup.soap_action_dispatch_errorhandler() at Aras.Server.Core.Startup.innovatorserver_main_dispatch() at Aras.Server.Core.Startup.innovatorserver_main() at ASP.innovatorserver_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:Program FilesArasInnovatorInnovatorServerInnovatorServer.aspx:line 20 at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.innovatorserver_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) at System.Web.Hosting.ISAPIRuntime.ProcessRequest(ntPtr ecb, Int32 iWRType)
SamsAn - Monday, September 24, 2007 9:59 AM:
Hi.
Please execute the select below for your database directly (using SQL Query Analyzer tool for example):
SELECT name,is_current,generation,config_id FROM innovator.method WHERE name='SQL PROCESS'
Does the select returns at least one row? Please, provide the returned values for further investigations.
lawrni - Thursday, September 27, 2007 10:50 AM:
Hi SamsAn
Many thanks for your reply.
I don't know if this helps or not, but when I execute your query, no rows are returned. I assume this means there is something wrong with my database table setup. Any suggestions on how I should proceed ?
Many thanks (in advance)
Nick
SamsAn - Thursday, September 27, 2007 11:15 AM:
Hi Nick.
I think the following.
Probably, you have the case sensitive db collation (or Method table db collation). To confirm it, please execute
SELECT name,is_current,generation,config_id FROM innovator.method WHERE UPPER(name)='SQL PROCESS'
It should return at least one row (if my guess is truthful). So, if it is true then you need to correct the collation manually to get case insensitive collation.
Hope it helps.
lawrni - Monday, October 1, 2007 4:32 AM:
Hi,
Many thanks for your reply. Yes - you are correct that, when I execute the select statement you specified, I do get one row returned.
I'll investigate further, because the default collation for my SQL server is case and accent sensitive, but I changed the collation on this database to case insensitive.
I'll let you know what I find.
Cheers
Nick
