Maximo Anywhere

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

Hi Doug,

It sounds like you need to configure the object structure to restrict the commlogid attribute so that Maximo uses the AUTOKEY to load the data: https://www.ibm.com/support/pages/loading-data-integration-framework-using-autokey-or-sequences

The process is pretty straightforward:

1. Open the Object Structures application and bring up your object structure.
2. Pick Inbound Setting Restrictions from the Select Action / More Actions menu.
3. Click on the COMMLOG object in the objects list.
4. Select the Override? checkbox for the COMMLOGID attribute.
5. Select the Restricted? checkbox for the COMMLOGID attribute.  (You may need to select different objects on the screen to get Maximo to pick up your 'Override?' change so that it makes this checkbox editable.)
6. Hit OK.

The internal sequence columns are automatically restricted but that would only apply to the COMMLOGUID column so you need to manually restrict the commlogid column as well.

------------------------------
Adam Davis
Maximo Consultant
Asset Partners
Chicago IL
312-224-8300
------------------------------

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

I have used that process many times while loading data.
I went ahead and made the change and then restarted maximo but am still getting the same error

------------------------------
doug carrington
------------------------------

Original Message:
Sent: Thu September 16, 2021 12:26 PM
From: Adam Davis
Subject: CommLogId is null

Hi Doug,

It sounds like you need to configure the object structure to restrict the commlogid attribute so that Maximo uses the AUTOKEY to load the data: https://www.ibm.com/support/pages/loading-data-integration-framework-using-autokey-or-sequences

The process is pretty straightforward:

1. Open the Object Structures application and bring up your object structure.
2. Pick Inbound Setting Restrictions from the Select Action / More Actions menu.
3. Click on the COMMLOG object in the objects list.
4. Select the Override? checkbox for the COMMLOGID attribute.
5. Select the Restricted? checkbox for the COMMLOGID attribute.  (You may need to select different objects on the screen to get Maximo to pick up your 'Override?' change so that it makes this checkbox editable.)
6. Hit OK.

The internal sequence columns are automatically restricted but that would only apply to the COMMLOGUID column so you need to manually restrict the commlogid column as well.

------------------------------
Adam Davis
Maximo Consultant
Asset Partners
Chicago IL
312-224-8300

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

It will good to check few of things here:
1. From your post , I gather that commlog is a child table so can you share the relationship used for it. If the relationship query is not proper then you might be facing this issue. Check Maximo logs as well.
2. Enable app debugging and extract the json request created your work execution app. This will help you understand the post request sent from the app and also resolve the issue. 
3. I will also check if the rdf puller was run properly and resources were properly created in your app.xml.

------------------------------
Biplab Choudhury
Maximo Consultant
Tata Consultancy Services
Melbourne
------------------------------

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

Sorry for delay in responding to this.  Just saw the thread:  Have you used this as a guide for how to Add the Comm log to Maximo Anywhere? Start with that and see if the procedures match with yours. Please let us know if that helps or not.

------------------------------
Bradley K. Downing , MBA
Solutions Engineer
IBM
Bakersfield CA
------------------------------

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

Bradley,
commlog was already setup per that document before I got involved so they could view the logs. i added logic to add/edit commlog and send out the email notifications.
I have it working but it was a combination of things. there were some advances settings/overrides on the object structure causing the autokey not to work. once I corrected that the save in anywhere still failed needing a value in commlogid so I set a default value which gets pass the error and the autokey is now workinging.

------------------------------
doug carrington
------------------------------

Original Message:
Sent: Tue September 28, 2021 04:55 PM
From: Bradley Downing
Subject: CommLogId is null

Sorry for delay in responding to this.  Just saw the thread:  Have you used this as a guide for how to Add the Comm log to Maximo Anywhere? Start with that and see if the procedures match with yours. Please let us know if that helps or not.

------------------------------
Bradley K. Downing , MBA
Solutions Engineer
IBM
Bakersfield CA

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------

I also added a commtemplate to the screen so the user could select one and the commlog would populate. It is a odd object in that the sendto is nonpersistent and calculated and the message doesn't like to display correctly due to rich text regardless of the cssClass. nothing is ever easy...


------------------------------
doug carrington
------------------------------

Original Message:
Sent: Tue September 28, 2021 05:07 PM
From: doug carrington
Subject: CommLogId is null

Bradley,
commlog was already setup per that document before I got involved so they could view the logs. i added logic to add/edit commlog and send out the email notifications.
I have it working but it was a combination of things. there were some advances settings/overrides on the object structure causing the autokey not to work. once I corrected that the save in anywhere still failed needing a value in commlogid so I set a default value which gets pass the error and the autokey is now workinging.

------------------------------
doug carrington

Original Message:
Sent: Tue September 28, 2021 04:55 PM
From: Bradley Downing
Subject: CommLogId is null

Sorry for delay in responding to this.  Just saw the thread:  Have you used this as a guide for how to Add the Comm log to Maximo Anywhere? Start with that and see if the procedures match with yours. Please let us know if that helps or not.

------------------------------
Bradley K. Downing , MBA
Solutions Engineer
IBM
Bakersfield CA

Original Message:
Sent: Thu September 16, 2021 12:03 PM
From: doug carrington
Subject: CommLogId is null

Hello Everyone,
I am making a fairly simple change in WorkExecution to allow a commlog to be added.
The issue i am having is that when the record is created a commlogid value is not being populated.
This field is set to default to the autokey value but it never happens so an error is thrown.
If i default the field to a value then the commlog record is created.
I have done similar work with other objects(planned materials for example) and never ran into the key not being set.
any thoughts on what the issue might be?
i have tried changing some of the advanced settings on the objectstructure(wodetail\commlog). even tried creating an autoscript to populate the commlogid but the oslc structure complains since if commlogid is null.

thanks,
doug

------------------------------
doug carrington
------------------------------