Maximo Open Forum

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

Just a couple questions. What version of MXLoader are you using; did you try the MXLoader Wizard?

Maximo version?

------------------------------
Christopher Winston
Projetech Inc.
------------------------------

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

Hi Christopher.

I made sure I had the latest 8.3.5 version and I did try using the MXLoader wizard. When I only added PKs, versus R values versus adding all columns for MXAPICONTRACT via the wizard it still returns no records.

I am using version 7.6.1.2

------------------------------
Jennifer Chung
York Region
------------------------------

Original Message:
Sent: 08-11-2022 18:34
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

Just a couple questions. What version of MXLoader are you using; did you try the MXLoader Wizard?

Maximo version?

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

I only have demo data, and the wizard runs slow, but it seems to work.


I have MxLoader 8.3.5 as well, and Maximo 7.6.1.2 in SQL Server. 

Hopefully, someone else can shed some light.

------------------------------
Christopher Winston
Projetech Inc.
------------------------------

Original Message:
Sent: 08-16-2022 18:26
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hi Christopher.

I made sure I had the latest 8.3.5 version and I did try using the MXLoader wizard. When I only added PKs, versus R values versus adding all columns for MXAPICONTRACT via the wizard it still returns no records.

I am using version 7.6.1.2

------------------------------
Jennifer Chung
York Region

Original Message:
Sent: 08-11-2022 18:34
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

Just a couple questions. What version of MXLoader are you using; did you try the MXLoader Wizard?

Maximo version?

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

Hi Chris, 

I actually worked with IBM support to figure this out. 
 
My MIF was not enabled for this particular object structure. I also had to enable some security permissions on the object structure for both the application and security groups I was in. 

I cant pinpoint the exact moment it started working but I believe it was a permissions thing! Thanks for assisting!

------------------------------
Jennifer Chung
York Region
------------------------------

Original Message:
Sent: 08-16-2022 23:08
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

I only have demo data, and the wizard runs slow, but it seems to work.


I have MxLoader 8.3.5 as well, and Maximo 7.6.1.2 in SQL Server. 

Hopefully, someone else can shed some light.

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-16-2022 18:26
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hi Christopher.

I made sure I had the latest 8.3.5 version and I did try using the MXLoader wizard. When I only added PKs, versus R values versus adding all columns for MXAPICONTRACT via the wizard it still returns no records.

I am using version 7.6.1.2

------------------------------
Jennifer Chung
York Region

Original Message:
Sent: 08-11-2022 18:34
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

Just a couple questions. What version of MXLoader are you using; did you try the MXLoader Wizard?

Maximo version?

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

A good reminder to cover the basics - security. For easy reference, there is a page with a number of Maximo Reporting Reference Links including the Report Object Structure (ROS) guide including security: 



------------------------------
Christopher Winston
Projetech Inc.
------------------------------

Original Message:
Sent: 08-18-2022 14:15
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hi Chris, 

I actually worked with IBM support to figure this out. 
 
My MIF was not enabled for this particular object structure. I also had to enable some security permissions on the object structure for both the application and security groups I was in. 

I cant pinpoint the exact moment it started working but I believe it was a permissions thing! Thanks for assisting!

------------------------------
Jennifer Chung
York Region

Original Message:
Sent: 08-16-2022 23:08
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

I only have demo data, and the wizard runs slow, but it seems to work.


I have MxLoader 8.3.5 as well, and Maximo 7.6.1.2 in SQL Server. 

Hopefully, someone else can shed some light.

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-16-2022 18:26
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hi Christopher.

I made sure I had the latest 8.3.5 version and I did try using the MXLoader wizard. When I only added PKs, versus R values versus adding all columns for MXAPICONTRACT via the wizard it still returns no records.

I am using version 7.6.1.2

------------------------------
Jennifer Chung
York Region

Original Message:
Sent: 08-11-2022 18:34
From: Christopher Winston
Subject: Trouble querying and updating purchase contracts with MxLoader

Just a couple questions. What version of MXLoader are you using; did you try the MXLoader Wizard?

Maximo version?

------------------------------
Christopher Winston
Projetech Inc.

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

Jennifer,
When using the wizard from MXLoader make sure you select the fields that are Primary K (PK) and fields that are Required (R) in the list. From your screenshot  you provided it looks like you are missing these key fields, whereas in Christopher's screenshot he has the fields. I would start with that. If it still does not work then I suggest looking at the SystemOut.log or SystemErr.log for any additional clues. 

Mike

------------------------------
Michael Marsonet
OSV Advisory Inc.
------------------------------

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------

Hi Mike!

I believe it was a permissions thing. I also established a publish channel for this as well.

Jen

------------------------------
Jennifer Chung
York Region
------------------------------

Original Message:
Sent: 08-17-2022 08:44
From: Michael Marsonet
Subject: Trouble querying and updating purchase contracts with MxLoader

Jennifer,
When using the wizard from MXLoader make sure you select the fields that are Primary K (PK) and fields that are Required (R) in the list. From your screenshot  you provided it looks like you are missing these key fields, whereas in Christopher's screenshot he has the fields. I would start with that. If it still does not work then I suggest looking at the SystemOut.log or SystemErr.log for any additional clues. 

Mike

------------------------------
Michael Marsonet
OSV Advisory Inc.

Original Message:
Sent: 08-09-2022 14:51
From: Jennifer Chung
Subject: Trouble querying and updating purchase contracts with MxLoader

Hello all,

I'm having some trouble with the out of the box object structure for Contracts. When I look at the backend CONTRACT table in the database it has data but the object structure doesn't seem to be giving me anything. I did manage to load contracts in using PURCHVIEW but I am still confused why this structure does not work?


#Integrations

------------------------------
Jennifer Chung
York Region
------------------------------