Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#Maximo
#AssetandFacilitiesManagement

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#AssetandFacilitiesManagement
#Maximo

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara
------------------------------

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#Maximo
#AssetandFacilitiesManagement

"Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?

• If Flat, what are you choosing in the "Action" field?
• If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"

Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------

Original Message:
Sent: Mon September 28, 2020 06:39 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#Maximo
#AssetandFacilitiesManagement

Hi Jason,

This is a flat file import via the Object Structure enabled for Application Import on 'Stocked Tools' application.
I believe 'Action' field is only required if we use Flatfile consumer cron task?

Attached is a sample file that I am using, it has only one line of data.
(haven't really excluded much fields here)

------------------------------
K Kunnuthara
------------------------------

Original Message:
Sent: Mon September 28, 2020 06:55 PM
From: Jason Uppenborn
Subject: Stocked Tools data upload

"Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?

• If Flat, what are you choosing in the "Action" field?
• If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"

Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 06:39 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#Maximo
#AssetandFacilitiesManagement

Maximo is going to do some action with your data. If you don't specify which one, it will choose one for you. Rather than take the default, try choosing AddChange.

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------

Original Message:
Sent: Mon September 28, 2020 10:46 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi Jason,

This is a flat file import via the Object Structure enabled for Application Import on 'Stocked Tools' application.
I believe 'Action' field is only required if we use Flatfile consumer cron task?

Attached is a sample file that I am using, it has only one line of data.
(haven't really excluded much fields here)

------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 06:55 PM
From: Jason Uppenborn
Subject: Stocked Tools data upload

"Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?

• If Flat, what are you choosing in the "Action" field?
• If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"

Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 06:39 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#AssetandFacilitiesManagement
#Maximo

Hi Jason,

Tried with AddChange, and it seems to have brought up a little bit more details in the error:

[ERROR] [maxuatui05] [] Processing failed for STK99. The object structure is 1. The primary object is TOOLINV. The key is 2009385~3006~GSM~ITEMSET1.
BMXAA4134E - ITEMNUM3 did not validate. Gather the logs from the <HOME> directory and determine the problem by looking at the message that is appended to this message.
psdi.app.inventory.ToolInv incompatible with psdi.app.item.Item



There might be a bug?

------------------------------
K Kunnuthara
------------------------------

Original Message:
Sent: Tue September 29, 2020 10:23 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

Maximo is going to do some action with your data. If you don't specify which one, it will choose one for you. Rather than take the default, try choosing AddChange.

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 10:46 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi Jason,

This is a flat file import via the Object Structure enabled for Application Import on 'Stocked Tools' application.
I believe 'Action' field is only required if we use Flatfile consumer cron task?

Attached is a sample file that I am using, it has only one line of data.
(haven't really excluded much fields here)

------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 06:55 PM
From: Jason Uppenborn
Subject: Stocked Tools data upload

"Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?

• If Flat, what are you choosing in the "Action" field?
• If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"

Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 06:39 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#Maximo
#AssetandFacilitiesManagement

Yes, you should probably raise a Support Case for this.

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------

Original Message:
Sent: Tue September 29, 2020 09:21 PM
From: KKunnuthara
Subject: Stocked Tools data upload

Hi Jason,

Tried with AddChange, and it seems to have brought up a little bit more details in the error:

[ERROR] [maxuatui05] [] Processing failed for STK99. The object structure is 1. The primary object is TOOLINV. The key is 2009385~3006~GSM~ITEMSET1.
BMXAA4134E - ITEMNUM3 did not validate. Gather the logs from the <HOME> directory and determine the problem by looking at the message that is appended to this message.
psdi.app.inventory.ToolInv incompatible with psdi.app.item.Item



There might be a bug?

------------------------------
K Kunnuthara

Original Message:
Sent: Tue September 29, 2020 10:23 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

Maximo is going to do some action with your data. If you don't specify which one, it will choose one for you. Rather than take the default, try choosing AddChange.

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 10:46 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi Jason,

This is a flat file import via the Object Structure enabled for Application Import on 'Stocked Tools' application.
I believe 'Action' field is only required if we use Flatfile consumer cron task?

Attached is a sample file that I am using, it has only one line of data.
(haven't really excluded much fields here)

------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 06:55 PM
From: Jason Uppenborn
Subject: Stocked Tools data upload

"Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?

• If Flat, what are you choosing in the "Action" field?
• If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"

Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Mon September 28, 2020 06:39 PM
From: K Kunnuthara
Subject: Stocked Tools data upload

@Jason Uppenborn

Thanks for the inputs.

​select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
This does not return any results.

I am using 'Sync' in Application Import.

It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


------------------------------
K Kunnuthara

Original Message:
Sent: Mon September 28, 2020 10:37 AM
From: Jason Uppenborn
Subject: Stocked Tools data upload

You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

Does that key already exist in INVENTORY? Do you get data back from the following query?

select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

And what Action are you choosing in Application Import?

------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting

Original Message:
Sent: Wed September 23, 2020 03:25 AM
From: K Kunnuthara
Subject: Stocked Tools data upload

Hi guys,


As a first step, tools and the associated specifications have been created in 'Tools' application.

As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
is throwing the following error

BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


The above message does not make sense as the ITEM table do not have a Storeroom field.
Has anyone tried Application Import for adding tools to storerooms?


@Steven Shull  @Jason Uppenborn  @Alex Walter
Do you guys have any thoughts?


Thanks,

------------------------------
K Kunnuthara
------------------------------​​​​​​
#AssetandFacilitiesManagement
#Maximo