Hi everybody,after the successful installation and some traps (forbidden Access to .net2 Temp folder, IIS needs a flag for allowing skripts, DB with CS collation - changed to CI) I got aras up and running.My system is W2k Server Sp2 german, Sqlserver2005 german, IE6I tried to create (with user admin) a new part (Design-->parts).
The following error occurs. Is there a solution for that issue ?The creation of other objects (doc, user, ...) works fine.All hints + solution are welcome - thanks in advance
MichaelHere the error message (it is mixed up with english and german-bold my translation):The method associated with the server event onAfterAdd failed: InnovatorDatabaseException: Die gespeicherte Prozedur(stored procedure) 'PE_ExecuteRollupPart' wurde nicht gefunden (not found). in SQL: exec PE_ExecuteRollupPart 'A6EFD45298AE475E97D41C6D952C0F92','Part','19','4'<BR>Error while running method SQL Process.Exception in server-side method SQL Process (Type is VB) : Ein Aufrufziel hat einen Ausnahmefehler verursacht. Source : mscorlib Stack Trace : bei System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) bei System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) bei System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) bei System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) bei IOME.Evaluator.CompileAndRun(String MethodID, String MethodCode, DateTime MethodDateTimeStamp, String MethodType, String MethodChecksum, Object inDom, Object outDom, Boolean runp, Boolean check_cachep) bei IOME.Evaluator.DoEval(String MethodID, String MethodCode, DateTime MethodDateTimeStamp, String MethodType, String MethodChecksum, Object inDom, Object outDom) bei Aras.Server.Core.ApplyItem.ExecuteMethodByCacheXML(XmlDocument& inDom, XmlDocument& outDom, XmlElement& Method, Boolean& MustBeCalled, Boolean& UseErrorDom) Inner Exception in server-side method SQL Process (Type is VB) : InnovatorDatabaseException: Die gespeicherte Prozedur 'PE_ExecuteRollupPart' wurde nicht gefunden. in SQL: exec PE_ExecuteRollupPart 'A6EFD45298AE475E97D41C6D952C0F92','Part','19','4' Source : InnovatorCore Stack Trace : bei Aras.Server.Core.InnovatorSQLServerDatabase.ExecuteSelect(String SelectQuery) bei PKG_8671449EAEF7C3DA5A98B0DB163C301A.CLS_8671449EAEF7C3DA5A98B0DB163C301A.dosqlrs(String sql, String tp) in C:\Programme\Aras\Innovator\Innovator\Server\dll\-keo5wcs.0.vb:Zeile 247. bei PKG_8671449EAEF7C3DA5A98B0DB163C301A.CLS_8671449EAEF7C3DA5A98B0DB163C301A.procedure_call(XmlDocument indom, XmlDocument outdom) in C:\Programme\Aras\Innovator\Innovator\Server\dll\-keo5wcs.0.vb:Zeile 405. bei PKG_8671449EAEF7C3DA5A98B0DB163C301A.CLS_8671449EAEF7C3DA5A98B0DB163C301A.Main(XmlDocument inDom, XmlDocument outDom, Object Iob, Object Svr, Object Ses) in C:\Programme\Aras\Innovator\Innovator\Server\dll\-keo5wcs.0.vb:Zeile 122. bei PKG_8671449EAEF7C3DA5A98B0DB163C301A.CLS_8671449EAEF7C3DA5A98B0DB163C301A.FNC_method(Object inDom, Object outDom, Object InnovatorObject, Object InnovatorContext) in C:\Programme\Aras\Innovator\Innovator\Server\dll\-keo5wcs.0.vb:Zeile 520.bei System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) bei System.Environment.get_StackTrace() bei Aras.Server.Core.XML.SetErrorMessage(XmlDocument& xmlDom, Int64 faultCode, String& errorMessage, String& dbMessage) bei Aras.Server.Core.ApplyItem.ExecuteServerEvent(XmlDocument& itemDom, XmlDocument& errorDom, String ItemTypeID, String eventName, Boolean MustBeCalled) bei Aras.Server.Core.CCProxy.ExecuteServerEvent(XmlDocument& itemDom, XmlDocument& errorDom, String ItemTypeID, String eventName, Boolean MustBeCalled) bei Aras.Server.Core.AddItem.AddItem_Implementation(XmlDocument& inDom, Hashtable& AdditionalItemInfo, XmlDocument& outDom, XmlDocument& relatedItemDom) bei Aras.Server.Core.AddItem.AddItem(XmlDocument& inDom, Hashtable& AdditionalItemInfo, XmlDocument& outDom) bei Aras.Server.Core.ApplyItem.ApplyItem_Implementaion(XmlDocument& inDom_, Hashtable& AdditionalItemInfo, XmlDocument& outDom) bei Aras.Server.Core.ApplyItem.ApplyItem(XmlDocument& inDom, XmlDocument& outDom) bei Aras.Server.Core.Utilities.ApplySoapAction(String& soap_action, XmlDocument& inDom, XmlDocument& outDom, Boolean sec_chk, TextWriter writer) bei Aras.Server.Core.Startup.soap_action_dispatch() bei Aras.Server.Core.Startup.soap_action_dispatch_errorhandler() bei Aras.Server.Core.Startup.innovatorserver_main_dispatch() bei Aras.Server.Core.Startup.innovatorserver_main() bei ASP.innovatorserver_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:\Programme\Aras\Innovator\Innovator\Server\InnovatorServer.aspx:Zeile 20. bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Page.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) bei System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) bei System.Web.UI.Page.ProcessRequest() bei System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) bei System.Web.UI.Page.ProcessRequest(HttpContext context) bei ASP.innovatorserver_aspx.ProcessRequest(HttpContext context) bei System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() bei System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) bei System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) bei System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) bei System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) bei System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) bei System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
Sounds like the install did not go correctly. That stored procedure should have been created on install of the database. I recommend deleting the database and removing innovator and installing again.
It is faster than trying to figure out what else went wrong.
-Chris