ARAS 31 soap-env:server authentication failed for admin authentication failed for admin
Hai, We have upgraded to ARAS 31 from 12. The migration is in progress. While login from application Its working fine. But while login from web API we are getting an error "soap-env:server authentication failed for admin authentication failed for admin" We have tried to give the password in MD5 hash format for username admin. But the error not yet solved. can anyone help us on this? Thanks in advance, Salini
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.
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>
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.
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
"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?
