How to get items with all of its revisions with maximum generation
Hi, I am trying to get part all revision with maximum generation using IOM: below are the entries: Item Number Generation Revision Testnumber1 1 00 Testnumber1 2 00 Testnumber1 3 00 Testnumber1 4 00 Testnumber1 5 00 Testnumber1 6 00 Testnumber1 7 00 Testnumber1 8 01 Testnumber1 9 01 Testnumber1 10 02 so from above entries I want: Item Number Generation Revision Testnumber1 7 00 Testnumber1 9 01 Testnumber1 10 02 I got this result with below SQL: select item_number, MAX(generation) as generation, major_rev from innovator.PART group by item_number, major_rev order by generation but how to do this with IOM? Regards, Maddy.
IOM TypeInitializationException error with Login
I have been trying to use IOM on 11SP9 but I'm unable to get this code working... // url = "">myserver/InnovatorServer"; url = "">myserver/.../InnovatorServer.aspx"; var myConnection = IomFactory.CreateHttpServerConnection(url, db, user, password); var objItemRes = myConnection.Login(); if (objItemRes.isError()) { MessageBox.Show("Login error " + objItemRes.dom.InnerText); } It gives this error: 999 HTTP Error HttpServerConnection System.TypeInitializationException: The type initializer for 'Aras.Net.WindowsAuthenticationHelper' threw an exception. My project is build on .NET 4.5.2 and I have referenced IOM.dll Version 11.0.0.6549 (1/19/2017) What can be wrong?
Workflow Activity Completion
I am trying to complete workflow assignment with AML but it is acing weird. My request xml looks like given below: <Item action="EvaluateActivity" type="Activity"> <Activity>DE33049EBA694267A44CA41A002E7C51</Activity> <ActivityAssignment>99E2CFE208154E4FBD70E75DE6AB4B74</ActivityAssignment> <Paths><Path>2312B2C556DC4C028F740433E629C934</Path>Submit</Paths> <DelegateTo>0</DelegateTo> <Tasks><Task Completed="1">03D548CE54834C27BDB7974175C8A43F</Task> <Task Completed="1">DEB21FCD697942DC91DFCBECB21747A4</Task></Tasks> <Variables><Variable id="451171CA8A144AD8B87E065216208B02">vb cvbnvxn</Variable> </Variables> <Authentication mode=""/> <Comments>xcbxcvb xcxcbx</Comments> <Complete>0</Complete> </Item> My response reads like the following: <SOAP-ENV:Envelope><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring>The action "",EvaluateActivity is not supported.</faultstring><detail><af:legacy_detail>The action "",EvaluateActivity is not supported.</af:legacy_detail></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> Further more response in nash with the same request is following: <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Failed to get the Activity Tasks.]]></faultstring><detail><af:legacy_detail><![CDATA[Failed to get the Activity Tasks.]]></af:legacy_detail><af:legacy_faultstring><![CDATA[Workflow: EvaluateActivity: Specified Tasks are not found for Activity]]></af:legacy_faultstring></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> I looked at the request xml using Admin->saveRequest setting and my xml matches with what is sent by the official client. What am I missing?[ApplySQL] not allowed for userPrivileged [ApplySQL] not allowed for user
Hi, I am designing a small Windows Forms application, which will allow users to add/delete/view an item to/from Innovator database directly. From this application I can add Document and its attachment, now I want to open that document, and for that I write a sql query, but I get an error like this: [ApplySQL] not allowed for userPrivileged [ApplySQL] not allowed for user Regards, Maddy.
How can I get the IOM SDK 11.0?
I couldn't find IOM.dll file which is referenced in 11.0 of the Programmer's Guide. "A .NET version of IOM.dll can be found in the \Utilities\Aras Innovator <Version> IOM SDK\.NET directory on the CD Image and may be copied to another location and referenced by .NET project" Where is this Utilities folder? There's none in Aras Innovator installation directory and no CD Image available on the website. Could anyone provide the .dll file?How to get the value of relationship item type using the return value of fetchRelationships
hi,All 'my code 'This is the code I tried to write in VB Me.fetchRelationships("File") Dim file as Item = Me.getRelationships("File") Dim t_file_id as string If file.getItemCount()>0 Dim fileCnt as Integer=file.getItemCount() For x=0 To fileCnt-1 t_file_id = file.getItemByIndex(x).getProperty("related_id") file1= file.getItemsByXPath("Relationships/Item[@id='"+t_file_id+" ']") file1.getProperty("doc_name") ' return Not a single item Next End If 'file 'The value obtained is shown below How do I get the doc_name value? If somebody knows and can help I would really appreciate that. Thank you.
