Maximo Open Forum

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

Don't change the owner. As that technote calls out, this information is stored on start center configuration tables and is stored in some other tables as well and you'll break functionality by changing the ownership. We have plans to change this in the product in a future release but no ETA yet. 

I'd ask your hosting provider if they have a solution for modifying the queries. For example, when I was at Projetech we had built an application for managing queries that we'd grant customers. You'd grant this to an administrator and they could see and modify any public queries even when they're not the owner. 

If you're hosted somewhere else you can try and follow the instructions here: https://www.bpdzenith.com/wp-content/uploads/2020/02/MaxTECH-Build-a-Custom-Application-to-Manage-all-Queries.pdf though I haven't tested this solution specifically. 

------------------------------
Steven Shull
IBM
------------------------------

Original Message:
Sent: 08-22-2022 17:05
From: Rob Radcliff
Subject: Changing owner of Query?

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

Hi Steven,

Thanks for the recommendation. The blog post was a very good road map. We had to make a couple of modifications for our environment. It's up and running and a great tool.

Thanks!

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

Original Message:
Sent: 08-22-2022 20:33
From: Steven Shull
Subject: Changing owner of Query?

Don't change the owner. As that technote calls out, this information is stored on start center configuration tables and is stored in some other tables as well and you'll break functionality by changing the ownership. We have plans to change this in the product in a future release but no ETA yet. 

I'd ask your hosting provider if they have a solution for modifying the queries. For example, when I was at Projetech we had built an application for managing queries that we'd grant customers. You'd grant this to an administrator and they could see and modify any public queries even when they're not the owner. 

If you're hosted somewhere else you can try and follow the instructions here: https://www.bpdzenith.com/wp-content/uploads/2020/02/MaxTECH-Build-a-Custom-Application-to-Manage-all-Queries.pdf though I haven't tested this solution specifically. 

------------------------------
Steven Shull
IBM

Original Message:
Sent: 08-22-2022 17:05
From: Rob Radcliff
Subject: Changing owner of Query?

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

Once you're in the situation you're in, I don't know of another solution but editing the owner from the back end / sql.
It does require some careful editing.
If these aren't public queries, why not just copy the sql and create a new query under for  the current owner that needs them, and sql-delete the old ones?

In the future, these two articles about public queries are insightful.
https://blogs.perficient.com/2018/02/14/maximo-public-query-best-practices-meet-maxquery/

https://blogs.perficient.com/2018/02/15/maximo-public-queries-part-2-lets-do-this-right/


------------------------------
Robert Matthews
Itam
------------------------------

Original Message:
Sent: 08-22-2022 17:05
From: Rob Radcliff
Subject: Changing owner of Query?

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

Hi Rob,

Do take on board Steven's advice and the solution from BPD, as I have run head-long into the issue.  That said, it can be done.  Your challenge is it being hosted, which brings you back to the BPD Zenith's solution.

The sooner the issue with the query owner is fixed the better.

------------------------------
Regards,
Craig Kokay
ISW
Maximo Practice Manager
eMail: ckokay@isw.net.au
Phone: +61-411-682-040

#IBMChampion2022
------------------------------

Original Message:
Sent: 08-22-2022 17:05
From: Rob Radcliff
Subject: Changing owner of Query?

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------

I hadn't read through the BPDZenith link posted above, before my post; that looks like a great way to approach it, after you get through your current state.

------------------------------
Robert Matthews
Itam
------------------------------

Original Message:
Sent: 08-22-2022 17:05
From: Rob Radcliff
Subject: Changing owner of Query?

Hi All,

We are on a hosted instance of Maximo. I'm trying to change the owner of some queries that have left the company. I've tried Automation Scripts and received the message "The Owner field is either read only or part of the primary key. You cannot edit this field." Not good.

After a bit more research I found an IBM article that states the only work around is to use SQL to change the owner via the back-end (sql update). I can't do this as it's hosted. https://www.ibm.com/support/pages/updating-or-changing-ownership-existing-query-maximo

Has anyone else come across a solution for this? Emailing the hosting company every time something needs to change seems a little silly. I've thought of logging in as the user that left and making the query public, but not crazy about this solution.

Thanks.
#Administration
#Architecture
#Customizations
#Infrastructure

------------------------------
Rob Radcliff
Wake County GSA
------------------------------