Better version of 'Not a single Item' Error?
Hello, Does anyone know if it is possible to edit a piece of code to produce a more descriptive error rather than just 'Not a single Item'. I understand the logic behind why this issue occurs and I have my own ways of finding where this error occurs but it would be a lot easier if the error tells you which method it originates from. Thanks, Joshua
How to create itemtype Requirement using C#? Getting error that cannot pass null value in column.
Hello, I am currently using Aras Innovator 12.0 and Requirement Engineering module version 12.0R1. I am trying to create Requirement itemtype by using following C# code: Input to the function is given in SOAP UI as: I am getting an error on this for null value in managed_by_id while I have already given value for managed_by_id.The value given for managed_by_id is taken from aras database.(Database record was for a Requirement added through UI). Error Message: <s:Envelope xmlns:s="">schemas.xmlsoap.org/.../"> <s:Body> <s:Fault> <faultcode xmlns:a="">schemas.microsoft.com/.../faultcode> <faultstring xml:lang="en-US">Aras Web Service Error =Exception occur during create entity , Aras Error Code =SOAP-ENV:Server and Aras Error Message =Cannot insert the value NULL into column 'MANAGED_BY_ID', table 'InnovatorSolutions.innovator.RE_REQUIREMENT'; column does not allow nulls. INSERT fails. The statement has been terminated. in SQL: INSERT INTO [RE_REQUIREMENT] ( [CONFIG_ID],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[REQ_CATEGORY],[REQ_COMPLEXITY],[REQ_DOCUMENT_TYPE],[REQ_GROUP],[REQ_PRIORITY],[REQ_RISK],[REQ_RM_TITLE],[REQ_TIER],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[ITEM_NUMBER] ) VALUES ( @p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31 )</faultstring> <detail> <ExceptionDetail xmlns="">schemas.datacontract.org/.../System.ServiceModel" xmlns:i="">www.w3.org/.../XMLSchema-instance"> <HelpLink i:nil="true"/> <InnerException i:nil="true"/> <Message>Aras Web Service Error =Exception occur during create entity , Aras Error Code =SOAP-ENV:Server and Aras Error Message =Cannot insert the value NULL into column 'MANAGED_BY_ID', table 'InnovatorSolutions.innovator.RE_REQUIREMENT'; column does not allow nulls. INSERT fails. The statement has been terminated. in SQL: INSERT INTO [RE_REQUIREMENT] ( [CONFIG_ID],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[REQ_CATEGORY],[REQ_COMPLEXITY],[REQ_DOCUMENT_TYPE],[REQ_GROUP],[REQ_PRIORITY],[REQ_RISK],[REQ_RM_TITLE],[REQ_TIER],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[ITEM_NUMBER] ) VALUES ( @p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31 )</Message> <Type>com.opshub.aras.service.exception.ArasWebAPIExceptions</Type> </ExceptionDetail> </detail> </s:Fault> </s:Body> </s:Envelope> I am not able to find reason for such failure because of null as I am explicitly passing the value for managed_by_id. Thanks in advance.
"Root element is missing." XML Error when trying to add Requirement through .NET API
I am trying to add a Requirement through the .NET API. Here is my code: //creating new connection HttpServerConnection conn = IomFactory.CreateHttpServerConnection(serverUrl, dbName, username, password); Innovator inn = IomFactory.CreateInnovator(conn); conn.Login(); Item addItem = inn.newItem("re_Requirement", "add"); Dictionary<string, string> fieldDict = new Dictionary<string, string>(); //adding properties fieldDict.Add("managed_by_id", "AD30A6D8D3B642F5A2AFED1A4B02BEFA"); fieldDict.Add("req_priority", "Critical"); fieldDict.Add("classification", "Test"); fieldDict.Add("owned_by_id", "AD30A6D8D3B642F5A2AFED1A4B02BEFA"); fieldDict.Add("req_risk", "Low"); fieldDict.Add("type", "Text"); foreach (KeyValuePair<string,string> field in fieldDict) { addItem.setProperty(field.Key, field.Value); } Item result = addItem.apply(); Console.WriteLine(result); Console.WriteLine(result.isError()); // returns true When I run this program in Visual Studio, I get the following error: <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Root element is missing.]]></faultstring><detail><af:legacy_detail><![CDATA[Root element is missing.]]></af:legacy_detail><af:exception message="Root element is missing." type="System.Xml.XmlException" /></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> I am using Aras 11 SP15. Note that this has the Requirements Engineering feature only instead of the Requirements Management, hence the name of the item is re_Requirement. How to solve this issue?
