"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?
UX - Secondary Nav - Goto Form(s)
I want to get this View/Form(s) data from the SOAP response that happens between the selection of an ItemType and the building of that IT's Secondary Nav. I then want to use my new friend, aras.uiShowItem("Form", the_form_id) to go straight to the related form(s) for an Item Type. This is another (especially administrative) convenience I'd like to implement for smooth sailing.
Error (SOAP) Messages
Good day all. Since I have inherited the database from another contractor, I am not sure what is normal and what is unique to my system. The error (SOAP) messages do not seem to be useful. I have been trying to create an e-mail message that will pull the request information and put it in the body. I used the Configuring Aras Innovator Email Notifications from the community blog, but I keep receiving an error. The message is of no help, other than there is an error. It doesn't mention what the problem is, or I don't know how to read this. I tried going to the Aras link, but I receive a Page Not Found error. Any help in understanding this would be great. Thank you. <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"> <SOAP-ENV:Body> <SOAP-ENV:Fault xmlns:af="">www.aras.com/InnovatorFault"> <faultcode>SOAP-ENV:Server</faultcode> <faultstring> <![CDATA[Conversion from type 'DBNull' to type 'String' is not valid.]]> </faultstring> <detail> <af:legacy_detail> <![CDATA[Conversion from type 'DBNull' to type 'String' is not valid.]]> </af:legacy_detail> <af:exception message="Conversion from type 'DBNull' to type 'String' is not valid." type="System.InvalidCastException"/> </detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
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.
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
orderBy itemtype properties with pagination
Hello community, I am facing a new challenge, I need to sort the answer of a SOAP request but since I have an itemtype property, I only figure to sort on the id of the itemtype used in the property and not on the name of the instances... Datamodel : - I have an item bug - this item has a property "criticality" that is an itemtype property linked to 4 items with a property _name and values K1,K2,K3 and K4 I would like to get a page of the first 100 issues over all sorted by ascending criticality thus K1,K2,K3,K4... <Item type='bug' select='_criticality' action='get' page='1' pagesize='25' orderBy='_criticality'> </Item> With that request I get a set of issues but sorted with the order K3 K1 K4 K2 since it's using the id of the property itemtype _criticality... I tried to orderBy _criticality._name and other stuff but it's not sorting at all... Thanks in advance, Hadrien
