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.
Crowdsourced Requirements for an ARAS mobile client (iOS+Android)
Dear Community Members, We are developing a react native based client that could communicate with the ARAS server- as we have expertise both on ARAS and react native framework. Since it is react-native, it could be used by users for both iOS and Android platforms. I thought of writing to the community to get feedback as to what could be the features that could be incorporated based on the real market need. Right out of the box, I can think of these features that could be useful to the people on the go: 1. Change workflow management/approval (Currently managed by ARAS flow on windows store) 2. Part search/ edit 3. User management / access management If you are working at an establishment that uses ARAS, and have a good use case for mobility, let us know specific features that we could incorporate into the mobile client. Regards Pranav
"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?
