Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

Unable to increment Revision of "Affected Item" under ECN using AML code

Hi All, The below code is used to increment the revision of the affected item under ECN and set the new value to New Item Revision property under the "Affected Item" Itemtype. This code is working properly in Aras 9.2 but not incrementing the revision as expected in Aras 11.5. Unlike 9.2, the "generation" property of Affected Item, ECN Affected Item and other ItemTypes is not set to "Unique" by default in 11.5. When I tried to set the generation of any ItemType to "Unique", the below error occurs - " The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name innovator.AFFECTED_ITEM...". Please let me know if the above default generation configuration is the cause for this failure of below "action=version" code and the resolution to fix this issue as it is preventing the ECN release. Appreciate your quick response! Item affItem = affItemRel.createRelatedItem("Affected Item","get"); affItem.setAttribute("select","action,interchangeable,affected_id(keyed_name,state,is_released,itemtype),new_item_id(keyed_name,state,config_id,itemtype)"); Item thisItem = affItemRel.getItemsByXPath(rootXPath+"Item[@type='Affected Item'][action='Change'][interchangeable='1'][../../@id='"+thisId+"']"); if (thisItem.getItemCount() == 1) { Item tempItem = this.newItem(); tempItem.loadAML("<Item typeId='"+thisItem.getPropertyItem("affected_id").getProperty("itemtype", "")+"' action='version'/>"); tempItem.setID(thisItem.getProperty("affected_id","NON_EXISTING")); tempItem = tempItem.apply(); affItem = this.newItem("Affected Item","edit"); affItem.setID(thisItem.getID()); affItem.setAttribute("serverEvents","0"); affItem.setAttribute("doGetItem","0"); affItem.setProperty("new_item_id",tempItem.getID()); affItem = affItem.apply(); }   Regards, Charita

8 Replies

  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi All, I excluded the "action=version" and tried to manually increment the revision using the below code, but it did not work. Item newAff = affItem; newAff.setID(affItem.getID()); newAff.setAttribute("select","new_item_rev"); newAff.setProperty("new_item_rev",string.Format("{0:00}", Int32.Parse(affItem.getProperty("affected_rev"))+1)); newAff = newAff.apply(); Can someone please help me in resolving the above Revision increment issue. Thank you in advance!! Regards, Charita  
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi All, I have been trying out various ways to fix the issue but unable to fix the above version increment issue in Aras 11.5 instance. Request you to please suggest me on how to resolve the above issue as it is critical.   Regards, Charita V  
  • dlindinger's avatar
    dlindinger
    Creator I
    9 years ago
    This is a snippet of code that does versioning from the method PE_ChangeItemTransition Item versionItem = Utils.Innovator.newItem(type, "version"); String idList = String.Join(",", versionIds); versionItem.setAttribute("idlist", idList); Item res = versionItem.apply(); This will make new generations of all of the ids in idlist of the type "type". Hope this helps, Dennis
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi Dennis, Thank you for your response!! I have used the above code from  the method "PE_ChangeItemTransition", but unable to find the "versionIds" - String[] versionIds = items.Select((TSource item) => item.ID).ToArray(); I am not sure if all the items in the system are to be considered for "items" is in the above line of code (this IList<TSource> items). I have chosen the "type" as "Part" and even tried with the below line to increment the revision of the affItem, but got "Object reference not set to an instance of an object" error. Item myItem= inn.applyAML("<AML><Item type='Part' action='version' id='"+affItem.getID()+"'/></AML>"); Please note that the revision is not incremented in Aras 11.5 where as the code in my first post (action=version) works absolutely fine and increments the "new_item_rev" field under "Affected Item" in Aras 9.2 The only difference which I observed with respect to configuration is - the "generation" property is NOT set to "Unique" in Aras 11.5 by default, but it is set to "Unique" in 9.2 by default (OOTB). Since the "Versioning" of  "Part" itemtype is set to "Automatic" in both the Aras versions, I suspect that the above change in generation is the cause of the issue. I have tried in all possible ways, but action=version always fails and need to resolve the issue. The "new_item_rev" value of an affected item will be incremented whenever a new ECN gets released on that item. Can you please let me know on how the above revision increment can be achieved in Aras 11.5 through code or configuration changes. Appreciate your quick response! -  Charita
  • dlindinger's avatar
    dlindinger
    Creator I
    9 years ago
    Let's confirm that basics... In nash or AML Studio, run the following AML <Item action="add" type="part" id="12345678901234567890123456789012"> <item_number>100</item_number> </Item> This should create a new part with item_number=100 and generation 1. This works in an out-of-the-box database. If you have other required properties, then you may need to modify your AML with the additional properties. Run this AML to make a new generation of the part. <Item action="version" type="Part" id="12345678901234567890123456789012"/> Rerun the search for part 100 and you should see generation 2. Dennis
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi Dennis, The Part got created successfully with generation "1" as per the first code, but failed to create a new generation(2) using the below code in NASH - <AML> <Item type="Part" action="version" id="12345678901234567890123456789012"/> </AML> Error in NASH - "Object reference not set to an instance of an object" <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Object reference not set to an instance of an object.]]></faultstring><detail><af:legacy_detail><![CDATA[Object reference not set to an instance of an object.]]></af:legacy_detail><af:exception message="Object reference not set to an instance of an object." type="System.NullReferenceException"/></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> For "Part" itemtype, the generation property is set to Unique in both Aras 9.2 and 11.5 by default For "Affected Item" itemtype, the generation property is NOT set to Unique in Aras 11.5 but is "Unique" in 9.2 by default. Please let me know how the  version and generation of the item/Part can be incremented through configuration/code changes(there are already around 400 items available in our instance). - Charita
  • dlindinger's avatar
    dlindinger
    Creator I
    9 years ago
    My best guess is that you have a method hooked on the part itemtype that is being triggered when you issue the version command and that method is throwing the error. Here are some things to try (in no particular order). #1
    1. delete the part 100 you created earlier
    2. rerun the aml to create the part
    3. Run this AML to version
    <Item action="version" type="Part" id="7DF530C86F6B49B8A08996E990C5BFAB" serverEvents="0"/> If that is successful, then I'm pretty sure there is a method hooked that is throwing an error. #2
    1. Retest in an out-of-the-box database to confirm that my environment and your environment are both working the same
    #3
    1. Temporarily unhook the part's server events
    2. retest with the aml
    #4
    1. What happens if you create a part in the UI
    2. Save, unlock, and close the part
    3. Edit the part in the UI
    4. Save, unlock and close the part
    5. Any errors?
    Also, in the OOTB environment, the Affected Item ItemType is not versionable. Is it in yours? Are you trying to version the affected item or the part that is referenced on the affected item? Dennis
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi Dennis, The generation got incremented after disabling the server events. I have found the cause of the issue by disabling each custom server event on Part itemtype and fixed it. The error occurred due to a null check not being done which threw "Object reference not set to an instance of an object" error. Thank you very much for your help!! - Charita