Batch Loader displays fail message when uploading mass data in PLMA

I am trying to update PLMA with values in the field which are currently blank using a primary key in a Tab delimited Text file.

I am getting an autogenerated template in Batch loader

<Item type='Part' action='edit'>
<item_number>@1</item_number>
<_stuff_master_uid>@2</_stuff_master_uid>
</Item>

I can verify the data, but when I try to load, it gives me a fail result

Error message: 

SOAP-ENV:Server.MissingCriteriaException

Aras.Server.Core.MissingCriteriaException

Can I get guidance on why am I getting the error message ?

Parents
  • Hi Parth

    Edit action in AML should have where attribute. Update your query like below


    <Item action="edit" type="Part" where="[Part].item_number ='@1'">
    <_stuff_master_uid>@2</_stuff_master_uid>
    </Item>

    Note: Above query will create new generation of Part item and update only latest generation. If you don't want to create new generation then use below query

    <Item action="edit" type="Part" where="[Part].item_number ='@1'" version="0">
    <_stuff_master_uid>@2</_stuff_master_uid>
    </Item>

    Thank You

    Gopikrishnan R

Reply
  • Hi Parth

    Edit action in AML should have where attribute. Update your query like below


    <Item action="edit" type="Part" where="[Part].item_number ='@1'">
    <_stuff_master_uid>@2</_stuff_master_uid>
    </Item>

    Note: Above query will create new generation of Part item and update only latest generation. If you don't want to create new generation then use below query

    <Item action="edit" type="Part" where="[Part].item_number ='@1'" version="0">
    <_stuff_master_uid>@2</_stuff_master_uid>
    </Item>

    Thank You

    Gopikrishnan R

Children
  • Thank you Gopikrishnan.

    I used this template in batchloader.

    I am getting the following error now:
    Code: SOAP-ENV:Server.InsufficientPermissionsException
    Message: You have insufficient permissions to perform 'update' operation.

    Details: You have insufficient permissions to perform 'update' operation.

    Is this an access issue ? I am already an admin in PLMA

  • Yes it is an permission issue. Can you check the permission for Part item ? or can you try using root user account

  • Thank you - It worked now

    Also, When I want blank (null values) in a field and try to use batchloader, the output shows @2 in the main application

    I am using this template:

    <Item action="edit" type="Part" where="[Part].item_number ='@1'">
    <_uin_na>@2</_uin_na>
    </Item>

    Here, item_number = primary key

    uin_na needs to be blank (currently it has value)

  • In this case, you need to use the life below

    <Item action="edit" type="Part" where="[Part].item_number ='@1'">
    <_uin_na condition="is null"></_uin_na>
    </Item>

  • Thank you

    It worked perfectly fine!

  • I have 1 more use-case with which I need to resolve- 

    I need to ADD new vendor to Table of Content PID table - under AVL Tab.

    I have information of PID, AVL name in my csv template. What should be my AML template in batchloader ?

    I am attaching a picture of what and where vendor needs to be added -

  • Hi

    You have use below AML query. Changes needed in bold.

    AVL should be the name of the AVL relationship. 

    avl_name should be the name of the AVL name property

    @1 -- PID Number

    @2 -- AVL Name in Excel

    <AML>
    <Item action ="add" type="AVL">
    <avl_name>@2</avl_name>
    <source_id>
    <Item action ="get" type="Part" where="[Part].item_number='@1'">
    <source_id>
    </AML>