Good Morning,

We had the need to customize the ECR Form where we added some more field in the affected item tab for different stages of our product besides the out of the box "In Build" and "In Service", but when we tried to change the code so these field would show up on the ECR Report, it looked as though it would take and would "Save, Unlock and Close", but when pulling up the ECR Report these fields are not there and the basic report is the same as before.  Is this a locked report that can't be customized? 

This is imperative when sending to our outsourced manufacturer and internally for cost affectivity and to show what products are affected by this requested change.

Any help would be greatly appreciated.

Sue

---

Sue

You need login as admin, go to Administration/Reports, edit ECR Report, then

- go to Report tab and modify the query to retrieve your custom fields values from the server;

- go to Stylesheet tab and modify the stylesheet to display the values in the table.

thanks, but now when I try and create an ECR, (the fields are there and do function) I get an ApplyItem error, and can't even save, unlock and close.  It works with the ECN, which is strange, because they go hand in hand with this customization, but now am getting this error with each ECR that I have tried to create.

 Sue

---

Sue

Need error details/stack trace, etc. to think about the error reasons.

Exception during ApplyItem

Stack Trace

at asystem.environment.getstacktrace(exception e, Boolean needFileInfo) at system.environment.get_StackTrace() at Aras.Server.Core.XML.

 This is just the start of the error.  It would take an hour to type all the details for this error.  Does this help, or do you need me to put all the details in?

 Sue

---

Sue

Please, use Copy Buffer button to copy the message with stack trace into clipboard.

Technical Message 

 

Exception during ApplyItemException during ApplyItem Conversion from type 'DBNull' to type 'String' is not valid. System.InvalidCastException Microsoft.VisualBasic at Microsoft.VisualBasic.CompilerServices.StringType.FromObject(Object Value) at Aras.Server.Core.Workflow.WorkflowEmail(String& eventName, InnovatorDatabase& conn, String& ActivityId, String& processID, String& assignmentID, String& toAssignmentID, String& DelegateTo) at Aras.Server.Core.Workflow.ActivateActivity(XmlDocument& itemDom, XmlDocument& responseDom) at Aras.Server.Core.Workflow.RunThroughPathAndActivateActivity(String PathID, String PathName, String TargetActivityId, Boolean PostMethodsMustSucceed, XmlDocument& outDom) at Aras.Server.Core.Workflow.EvaluateActivity(XmlDocument& itemDom, XmlDocument& responseDom) at Aras.Server.Core.Workflow.ActivateActivity(XmlDocument& itemDom, XmlDocument& responseDom) at Aras.Server.Core.Workflow.startWorkflow(XmlDocument& itemDom, XmlDocument& responseDom) 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()

 

Stack Trace 

at 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.Startup.SetErrorMessageFromException(XmlDocument aDom, String amsg, Exception e) 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 F:\Program Files\Aras\Innovator\Innovator\Server\InnovatorServer.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(IntPtr ecb, Int32 iWRType)

---

Sue

I really am up the creek without a paddle on this one, if anyone can help, I would appreciate it.  I can't write any ECR's and am in need of some guidence on where we went wrong.

Thanks,

---

Sue

Is this the error message you get when trying to save an ECR or the ECR Report?

---

"I know this stuff like the back of my hand. Hey, where'd that mole come from?"

I did not fully investigate the problem but i guess it's because of something unusual in Workflow Map attached to ECR ItemType. For example, an activity assignment has no related (if true then assign an identity instead of "no related" in the assignment). You can detach the workflow map from ECR ItemType also.

 

I appreciate your feedback, but have gone through the item type and we did make some addtions and this may be causing the problem.  We did not change the workflow for this with the exception assignments.  Is there a way to reset the ECR back to it's original "Out of the Box" configuration?

 

---

Sue

The error comes up when trying to save the ECR.  There were new properties added to the ECR that I think may be affecting it, and another admin tried to copy the ECR Report and added the properties that we wanted to be able to see when generating the ECR report.  We also copied the ECN report and have not problems, but the new properties were not added to the Item Type for the ECN, but were added to the ECR Item Type, so I'm thinking this is where the error is coming from, but the other admin can't remember all that he added, so I am in need of the original configuration for the properties for the ECR to be able to compare and see if this is the source of the error.

---

Sue

You can compare the changes in the following way. Create a new original InnovatorSolutions database (using installer for example). Use SolutionsUpgrade Export utility and export PLM Solution both from the new database and your modified database. Now you can find changes comparing created xml files.