Batch Loader: Finish batch load failed

Hello
I am trying to add new parts via Batch Loader program but for some reason it kept showing an error stating "No Item of Type Product Found". I checked the value and there is nothing wrong with it. If I exclude this field then my batch load would be successful. I can't find what's wrong. If someone could advise me what would be wrong, I really appreciate that very much.
Regards,
Jakk
XML:
<?xml version="1.0"?>
-<Item action="add" type="Part">
<item_number>@1</item_number>
<name>@2</name>
<classification>@3</classification>
<make_buy>@4</make_buy>
<awb_phase>@5</awb_phase>
<awb_u_m>@6</awb_u_m>
<part_group>@7</part_group>
<description>@8</description>
<awb_config_desc>@9</awb_config_desc>

-<product_code>

-<Item action="get" type="Product" select="id">
<description>@10</description>
</Item>
</product_code>

-<vol_rm_spec>

-<Item action="get" type="Document" select="id">
<keyed_name>@11</keyed_name>
</Item>
</vol_rm_spec>
<material_class>@12</material_class>
<awb_mtr_class>@13</awb_mtr_class>
<awb_cvn_temp>@14</awb_cvn_temp>
<awb_smy>@15</awb_smy>
<weight>@16</weight>
</Item>

Data:

Part Number (item_number) Name (name & keyed_name) Type (classification) Source (make_buy) Phase (awb_phase) U/M (awb_u_m) Part Group (part_group) Description (description) Configuration Description (awb_config_desc) Product Code 4 (product_code) Material Specification (vol_rm_spec) Material Class (material_class) MTR Class (awb_mtr_class) CVN Temp (awb_cvn_temp) SMY (ksi) [awb_smy] Weight (weight)
ERP-TEST-JK CENT-5.500x6.250-3R-13.50L-.26W-FL Component Manufactured Production EA Centralizer Centralizer - 5.5" x 6.25" - 3 rib - 13.5" L - 0.26" wall - Float (Painted) Die104600 PC4-000091 Cent-0.26F-5.50 30049 Centralizer material specification N/A 10 NA 28 18.4

Log:

[4:29:31 PM]: Start batch load

[ *** Worker process for lines 2 - 5 *** ]:
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]: #1 - Failed to process row 1000000-01 CENT-5.500x6.250-3R-13.50L-.26W-FL Component Manufactured Production EA Centralizer Centralizer - 5.5" x 6.25" - 3 rib - 13.5" L - 0.26" wall - Float (Painted) Die104600 PC4-000091 Cent-0.26F-5.50 30049 Centralizer material specification N/A 10 NA 28 18.4
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Code: SOAP-ENV:Server
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Message: No items of type Product found.
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Details: No items of type Product found.No items of type 'Product' found using the criteria:
<Item type="Product" action="get" select="id" doGetItem="1"><description>PC4-000091 Cent-0.26F-5.50</description></Item>
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]: #2 - Failed to process row 1000000-02 CENT-5.500x6.250-3R-13.50L-.26W-FL Component Manufactured Production EA Centralizer Centralizer - 5.5" x 6.25" - 3 rib - 13.5" L - 0.26" wall - Float (No paint) Die104600 PC4-000091 Cent-0.26F-5.50 30049 Centralizer material specification N/A 10 NA 28 18.4
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Code: SOAP-ENV:Server
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Message: No items of type Product found.
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Details: No items of type Product found.No items of type 'Product' found using the criteria:
<Item type="Product" action="get" select="id" doGetItem="1"><description>PC4-000091 Cent-0.26F-5.50</description></Item>
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]: #3 - Failed to process row 1000001-01 CENT-5.500x6.250-3R-16.25L-.26W-CR Component Manufactured Production EA Centralizer Centralizer - 5.5" x 6.25" - 3 rib - 16.25" L - 0.26" wall - Crimp (Painted) Die104600 PC4-000106 Cent-0.26C-5.50 30049 Centralizer material specification N/A 10 NA 28 22.2
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Code: SOAP-ENV:Server
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Message: No items of type Product found.
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Details: No items of type Product found.No items of type 'Product' found using the criteria:
<Item type="Product" action="get" select="id" doGetItem="1"><description>PC4-000106 Cent-0.26C-5.50</description></Item>
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]: #4 - Failed to process row 1000001-02 CENT-5.500x6.250-3R-16.25L-.26W-CR Component Manufactured Production EA Centralizer Centralizer - 5.5" x 6.25" - 3 rib - 16.25" L - 0.26" wall - Crimp (No paint) Die104600 PC4-000106 Cent-0.26C-5.50 30049 Centralizer material specification N/A 10 NA 28 22.2
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Code: SOAP-ENV:Server
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Message: No items of type Product found.
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]:  Details: No items of type Product found.No items of type 'Product' found using the criteria:
<Item type="Product" action="get" select="id" doGetItem="1"><description>PC4-000106 Cent-0.26C-5.50</description></Item>
[4:29:33 PM Worker process for lines up to 4 (Thread #1)]: Finished
 processed successfully - 0
 average processed request time - 0 ms
 failed to process - 4
 total time - 0.2967437 sec
[4:29:35 PM]: Finish batch load: succeeded - 0; failed - 4
  • Hi Jakk

    Its not an error and it is because system cannot find any product with this description "PC4-000106 Cent-0.26C-5.50". Can you confirm in ARAS, whether the Product with same description exist in ARAS ?

     

    Thank You

    Gopikrishnan R

  • Hello Gopikrishnan,

    I found the issue in the code and after I changed it, I can load with out an issue.

      <product_code>
        <Item type="Product" action="get" select="id">
          <keyed_name>@10</keyed_name>
        </Item>
      </product_code>

    Regards,

    Jakk