This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
In older versions of Maximo there was a crossover from jobtask to workorder that does not exist any more. Would you recommend a crossover domain or an automation script to get additional attributes added to the JOBTASK object to come over to the work order tasks when a job plan is applied?
If you recommend an automation script could you please provide and example?
The attributes I have added to both JOBTASK and WORKORDER objects are:
LR_SECTION
LR_QUESTION
LR_REFERENCE
LR_WEIGHT
As always thanks for your help.
Sorry I should included:
Maximo 7.5 - DB2 10.1 - WebSphere
Just use a crossover domain
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 12:02
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] JOBTASK to WORKORDER
In older versions of Maximo there was a crossover from jobtask to workorder that does not exist any more. Would you recommend a crossover domain or an automation script to get additional attributes added to the JOBTASK object to come over to the work order tasks when a job plan is applied?
If you recommend an automation script could you please provide and example?
The attributes I have added to both JOBTASK and WORKORDER objects are:
LR_SECTION
LR_QUESTION
LR_REFERENCE
LR_WEIGHT
As always thanks for your help.
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Thanks Ian,
I tried the following but got an error about the taskid needing to be set first.
Created crossover on jobtask object.
Validation: (where jobtask.jpnum = (select jpnum from workorder where workorder.wonum =:parent)
And (workorder.taskid=jobtask.jptask)
And istask=1)
Applied the crossover domain to workorder.jpnum.
I presume you are trying to get the field to crossover from the job plan task to the work order task
Therefore you’ve added the new fields to the
Woactivity view and workorder table
If that’s the case I would put the domain on the woactivity Jobtaskid and use the validation as
Jobtaskid = : jobtaskid
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 12:25
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Thanks Ian,
I tried the following but got an error about the taskid needing to be set first.
Created crossover on jobtask object.
Validation: (where jobtask.jpnum = (select jpnum from workorder where workorder.wonum =:parent)
And (workorder.taskid=jobtask.jptask)
And istask=1)
Applied the crossover domain to workorder.jpnum.
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Thanks for the response Ian,
I did try as you recommended:
Created crossover domain:
Name: JOBTASK2WO
Object: JOBTASK
Validation: JOBTASKID = :JOBTASKID
Associated domain to WOACTIVITY.JOBTASKID
Configured the DB
Received the following error when trying to attach the job plan to the work order:
BMXAA4512E - The job plan for Job Plan LOW cannot be copied.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
Removed the domain from WOACTIVY.JOBTASKID and the job plan attached fine, but the fields did not crossover (as expected)
Any other ideas?
Ok can you try it against the workorder.jobtaskid instead
If it doesn’t work there then well have to try something different
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 13:48
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Thanks for the response Ian,
I did try as you recommended:
Created crossover domain:
Name: JOBTASK2WO
Object: JOBTASK
Validation: JOBTASKID = :JOBTASKID
Associated domain to WOACTIVITY.JOBTASKID
Configured the DB
Received the following error when trying to attach the job plan to the work order:
BMXAA4512E - The job plan for Job Plan LOW cannot be copied.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
Removed the domain from WOACTIVY.JOBTASKID and the job plan attached fine, but the fields did not crossover (as expected)
Any other ideas?
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Did you check your new fields are on the woactivity view
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 05 February 2014 14:11
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] RE: JOBTASK to WORKORDER
Ok can you try it against the workorder.jobtaskid instead
If it doesn’t work there then well have to try something different
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com<mailto:mlevinson@ledgesoft.com>
Sent: 05 February 2014 13:48
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Thanks for the response Ian,
I did try as you recommended:
Created crossover domain:
Name: JOBTASK2WO
Object: JOBTASK
Validation: JOBTASKID = :JOBTASKID
Associated domain to WOACTIVITY.JOBTASKID
Configured the DB
Received the following error when trying to attach the job plan to the work order:
BMXAA4512E - The job plan for Job Plan LOW cannot be copied.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
Removed the domain from WOACTIVY.JOBTASKID and the job plan attached fine, but the fields did not crossover (as expected)
Any other ideas?
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
****************************************************************************************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
****************************************************************************************************************************************************************************************
Actually why are you crossing them over why not just create two relationships woactivity to jobtask and workorder to jobtask and reference them on your
Work order / woactivity tabs using
:relationship.fieldname
This means that if you ever change your job plan task the data is kept up to date on any open work orders
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 05 February 2014 12:49
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] RE: JOBTASK to WORKORDER
I presume you are trying to get the field to crossover from the job plan task to the work order task
Therefore you’ve added the new fields to the
Woactivity view and workorder table
If that’s the case I would put the domain on the woactivity Jobtaskid and use the validation as
Jobtaskid = : jobtaskid
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com<mailto:mlevinson@ledgesoft.com>
Sent: 05 February 2014 12:25
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Thanks Ian,
I tried the following but got an error about the taskid needing to be set first.
Created crossover on jobtask object.
Validation: (where jobtask.jpnum = (select jpnum from workorder where workorder.wonum =:parent)
And (workorder.taskid=jobtask.jptask)
And istask=1)
Applied the crossover domain to workorder.jpnum.
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
****************************************************************************************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
****************************************************************************************************************************************************************************************
The attributes do exist on the WOACTIVITY object.
After associating the domain to WORKORDER.JOBTASKID the job plan created the tasks, but none of the data crossed over.
Maybe try this
Automation script on workorder object
Action add
Create relationship workorder to jobtask
jobtaskid = :jobtaskid
create IN parameter INSECTION bound to relationship. LR_SECTION
create OUT parameter OUTSECTION bound to LR_SECTION
script
OUTSECTION = INSECTION
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Created relationship on the WORKORDER object:
______________________________
WO_JOBTASK - jobtaskid = :jobtaskid and siteid = :siteid
Created Automation Script:
______________________________
Source Code - outsection = insection
Variables - insection (IN) bind type - Attribute
outsection (OUT) bind type - Attribute
Launch Point Variables
insection (IN) binding value - WO_JOBTASK.JPNUM
outsection (OUT) binding value - LR_SECTION
Nothing came across when I created a new record and picked a job plan. The task records did get created but no "Sections" came across.
Just read your last post Ian.
The only reason I have continued down this path is I have already created the report spec that we have farmed out to 3rd party and it is being developed. Maybe I should just do as you say and redesign the report spec........
Launch Point Variables
insection (IN) binding value - WO_JOBTASK.LR_SECTION
----
WO_JOBTASK - jobtaskid = :jobtaskid and siteid = :siteid <---- you don’t need siteid as this is a unique key but it won’t cause a problem if you leave it the way it is
Save the work order and check if the value is set
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 15:22
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Created relationship on the WORKORDER object:
______________________________
WO_JOBTASK - jobtaskid = :jobtaskid and siteid = :siteid
Created Automation Script:
______________________________
Source Code - outsection = insection
Variables - insection (IN) bind type - Attribute
outsection (OUT) bind type - Attribute
Launch Point Variables
insection (IN) binding value - WO_JOBTASK.JPNUM!
outsection (OUT) binding value - LR_SECTION
Nothing came across when I created a new record and picked a job plan. The task records did get created but no "Sections" came across.
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Made the change:
Launch Point Variables
insection (IN) binding value - WO_JOBTASK.LR_SECTION
created new record, saved and no sections
Does the job plan have a siteid ?? if not
Remove the
And siteid = :siteid from the relationship
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 15:34
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Made the change:
Launch Point Variables
insection (IN) binding value - WO_JOBTASK.LR_SECTION
created new record, saved and no sections
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Yes the job plan has a site associated with it.
You need to validate step by step, it isn't practical for someone to
troubleshoot issues via email. There are two main avenues you need to
investigate, via logs and the database.
Add steps to your automation script to print the values the script is
"seeing", print out the WONUM to verify which work order the script is
firing for (also verify you are not in admin mode which would deactivate
all scripts). Print out WORKORDER.JOBTASKID and WORKORDER.SITEID, verify
that a corresponding JOBTASK exists.
Can you run the following and post the result
Select workorder.LR_SECTION,jobtask.LR_SECTION, wonum, istask from workorder,jobtask where workorder.wonum = ‘your task wonum’ and workorder.siteid = ‘your siteid’ and workorder.jobtaskid = jobtask.jobtaskid and workorder.siteid = jobtask.siteid
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 16:15
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
Yes the job plan has a site associated with it.
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
No results from query
WONUM ISTASK JOBTASKID
10357 1 7
Select LR_SECTION,siteid, from jobtask where jobtaskid = 7
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 16:59
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
WONUM ISTASK JOBTASKID
10357 1 7
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
LR_SECTION SITEID
4.1.1
No siteid so relationship isn’t working
Take off siteid from relationship
i.e. should just be jobtaskid = :jobtaskid
as they are unique it does not need the siteid
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 05 February 2014 17:09
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: JOBTASK to WORKORDER
LR_SECTION SITEID
4.1.1
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Ian,
I have decided to cut my losses and modify the report spec to use the relationship WO_JOBTASK to display the information.
I want you to know that I really appreciate all of the time you have spent helping me work through this problem. You efforts are appreciated more than you know, not only on this issue but all the issues you get involved in.
You are truly an asset to this forum.