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.
Thx I'll give it a try in the am.
The sender of this message is responsible for its content and addressing. Any actions not conforming to Petrobras System internal policies are forbidden.
----- Original Message -----
From: "Shannon Rotz" [shannonrotz@yahoo.ca]
Sent: 04/11/2012 06:17 PM MST
To: <MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Process Revision Issue
Hi George: I have run across that issue before. If I recall correctly,
it's fixed in a later patch, but in the mean time, you need to run the
following against the database:
Delete from wfassignment where processed = 'PURCHREQ' and processrev = 13
Note: this assumes you have no transactions related to this revision
(although if you're able to delete it, you shouldn't have any).
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
George
Sent: April-11-12 5:05 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Process Revision Issue
Hello everyone,
Here is what I'm working on, I was in workflow designer and I created a new
revision to my PURCHREQ workflow to make some changes, it created revision
13. My changes didn't work so I deleted the process revision 13. Now when I
go back to create a new revision I get an error.
Here is what the error says:
Database error number 2601 has occurred when operating on WFASSIGNMENT
Assignment=1 Process=PURCHREQ Process Revision=13 Workflow ID=0 Node ID=5.
[PRSEAMS] Cannot insert duplicate key row in object
'dbo.wfassignment' with unique index 'wfassign_ndx1'
Has anyone come across something like this and if so how can I fix it?
Maximo 6.2.1
Weblogic
SQL Server 2005
thx,
mrggutz
Note: that should be "processid", not "processed" - my spell-checker
thought it was smarter than me :(
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
ggutierrez@pasadenarefining.com
Sent: April-11-12 7:12 PM
To: MAXIMO
Subject: Re: [MAXIMO List] Process Revision Issue
Thx I'll give it a try in the am.
The sender of this message is responsible for its content and addressing.
Any actions not conforming to Petrobras System internal policies are
forbidden.
----- Original Message -----
From: "Shannon Rotz" [shannonrotz@yahoo.ca <mailto:shannonrotz%40yahoo.ca> ]
Sent: 04/11/2012 06:17 PM MST
To: <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
Subject: RE: [MAXIMO List] Process Revision Issue
Hi George: I have run across that issue before. If I recall correctly,
it's fixed in a later patch, but in the mean time, you need to run the
following against the database:
Delete from wfassignment where processed = 'PURCHREQ' and processrev = 13
Note: this assumes you have no transactions related to this revision
(although if you're able to delete it, you shouldn't have any).
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of
George
Sent: April-11-12 5:05 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Process Revision Issue
Hello everyone,
Here is what I'm working on, I was in workflow designer and I created a new
revision to my PURCHREQ workflow to make some changes, it created revision
13. My changes didn't work so I deleted the process revision 13. Now when I
go back to create a new revision I get an error.
Here is what the error says:
Database error number 2601 has occurred when operating on WFASSIGNMENT
Assignment=1 Process=PURCHREQ Process Revision=13 Workflow ID=0 Node ID=5.
[PRSEAMS] Cannot insert duplicate key row in object
'dbo.wfassignment' with unique index 'wfassign_ndx1'
Has anyone come across something like this and if so how can I fix it?
Maximo 6.2.1
Weblogic
SQL Server 2005
thx,
mrggutz
Shannon that worked for me I had to change the 'processid' to
'processname'.
I went in to Maximo and did the create new revision and then saved with no
more errors coming up.
thanks for all the help I'm gonna put this one in my arsenal of sql
statements.
You just saved me from having to recreate my entire workflow......:)
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
"Shannon Rotz"
<shannonrotz@yahoo.c
a> To
Sent by: <MAXIMO@yahoogroups.com>
MAXIMO@yahoogroups.c cc
om
Subject
RE: [MAXIMO List] Process
04/11/2012 10:30 PM Revision Issue
Please respond to
MAXIMO@yahoogroups.c
om
Note: that should be "processid", not "processed" - my spell-checker
thought it was smarter than me :(
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
ggutierrez@pasadenarefining.com
Sent: April-11-12 7:12 PM
To: MAXIMO
Subject: Re: [MAXIMO List] Process Revision Issue
Thx I'll give it a try in the am.
The sender of this message is responsible for its content and addressing.
Any actions not conforming to Petrobras System internal policies are
forbidden.
----- Original Message -----
From: "Shannon Rotz" [shannonrotz@yahoo.ca <mailto:shannonrotz%40yahoo.ca
> ]
Sent: 04/11/2012 06:17 PM MST
To: <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
Subject: RE: [MAXIMO List] Process Revision Issue
Hi George: I have run across that issue before. If I recall correctly,
it's fixed in a later patch, but in the mean time, you need to run the
following against the database:
Delete from wfassignment where processed = 'PURCHREQ' and processrev = 13
Note: this assumes you have no transactions related to this revision
(although if you're able to delete it, you shouldn't have any).
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On
Behalf
Of
George
Sent: April-11-12 5:05 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Process Revision Issue
Hello everyone,
Here is what I'm working on, I was in workflow designer and I created a new
revision to my PURCHREQ workflow to make some changes, it created revision
13. My changes didn't work so I deleted the process revision 13. Now when I
go back to create a new revision I get an error.
Here is what the error says:
Database error number 2601 has occurred when operating on WFASSIGNMENT
Assignment=1 Process=PURCHREQ Process Revision=13 Workflow ID=0 Node ID=5.
[PRSEAMS] Cannot insert duplicate key row in object
'dbo.wfassignment' with unique index 'wfassign_ndx1'
Has anyone come across something like this and if so how can I fix it?
Maximo 6.2.1
Weblogic
SQL Server 2005
thx,
mrggutz
Now I got a new error
Errors found for process PURCHREQ - Purchase Request Process:
Interaction Node START1: Send User Back to Start Center has an application which will not accept the controlled MBO, and no relation to another MBO.
I'm scrathing my head right now......
helps
thx,
mrggutz
--- In MAXIMO@yahoogroups.com, ggutierrez@... wrote:
>
> Shannon that worked for me I had to change the 'processid' to
> 'processname'.
> I went in to Maximo and did the create new revision and then saved with no
> more errors coming up.
>
> thanks for all the help I'm gonna put this one in my arsenal of sql
> statements.
>
>
> You just saved me from having to recreate my entire workflow......:)
>
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
>
>
> "Shannon Rotz"
> <shannonrotz@...
> a> To
> Sent by: <MAXIMO@yahoogroups.com>
> MAXIMO@... cc
> om
> Subject
> RE: [MAXIMO List] Process
> 04/11/2012 10:30 PM Revision Issue
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
>
>
>
>
>
>
> Note: that should be "processid", not "processed" - my spell-checker
> thought it was smarter than me :(
>
> Shannon
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> ggutierrez@...
> Sent: April-11-12 7:12 PM
> To: MAXIMO
> Subject: Re: [MAXIMO List] Process Revision Issue
>
> Thx I'll give it a try in the am.
>
> The sender of this message is responsible for its content and addressing.
> Any actions not conforming to Petrobras System internal policies are
> forbidden.
>
> ----- Original Message -----
> From: "Shannon Rotz" [shannonrotz@... <mailto:shannonrotz%40yahoo.ca
> > ]
> Sent: 04/11/2012 06:17 PM MST
> To: <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
> Subject: RE: [MAXIMO List] Process Revision Issue
>
> Hi George: I have run across that issue before. If I recall correctly,
> it's fixed in a later patch, but in the mean time, you need to run the
> following against the database:
>
> Delete from wfassignment where processed = 'PURCHREQ' and processrev = 13
>
> Note: this assumes you have no transactions related to this revision
> (although if you're able to delete it, you shouldn't have any).
>
> Shannon
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On
> Behalf
> Of
> George
> Sent: April-11-12 5:05 PM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Process Revision Issue
>
> Hello everyone,
> Here is what I'm working on, I was in workflow designer and I created a new
> revision to my PURCHREQ workflow to make some changes, it created revision
> 13. My changes didn't work so I deleted the process revision 13. Now when I
> go back to create a new revision I get an error.
>
> Here is what the error says:
> Database error number 2601 has occurred when operating on WFASSIGNMENT
> Assignment=1 Process=PURCHREQ Process Revision=13 Workflow ID=0 Node ID=5.
> [PRSEAMS] Cannot insert duplicate key row in object
> 'dbo.wfassignment' with unique index 'wfassign_ndx1'
>
> Has anyone come across something like this and if so how can I fix it?
>
> Maximo 6.2.1
> Weblogic
> SQL Server 2005
>
> thx,
> mrggutz
>
>
>
>
>
>
>
>
>
>
>
>
>
>
What's your START1 node got for parameters?
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
George
Sent: April-12-12 6:27 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Process Revision Issue
Now I got a new error
Errors found for process PURCHREQ - Purchase Request Process:
Interaction Node START1: Send User Back to Start Center has an application
which will not accept the controlled MBO, and no relation to another MBO.
I'm scrathing my head right now......
helps
thx,
mrggutz
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@... wrote:
>
> Shannon that worked for me I had to change the 'processid' to
> 'processname'.
> I went in to Maximo and did the create new revision and then saved with no
> more errors coming up.
>
> thanks for all the help I'm gonna put this one in my arsenal of sql
> statements.
>
>
> You just saved me from having to recreate my entire workflow......:)
>
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
>
>
> "Shannon Rotz"
> <shannonrotz@... <mailto:shannonrotz@...%20%0b>
> a> To
> Sent by: <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
> MAXIMO@... cc
> om
> Subject
> RE: [MAXIMO List] Process
> 04/11/2012 10:30 PM Revision Issue
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
>
>
>
>
>
>
> Note: that should be "processid", not "processed" - my spell-checker
> thought it was smarter than me :(
>
> Shannon
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of
> ggutierrez@...
> Sent: April-11-12 7:12 PM
> To: MAXIMO
> Subject: Re: [MAXIMO List] Process Revision Issue
>
> Thx I'll give it a try in the am.
>
> The sender of this message is responsible for its content and addressing.
> Any actions not conforming to Petrobras System internal policies are
> forbidden.
>
> ----- Original Message -----
> From: "Shannon Rotz" [shannonrotz@... <mailto:shannonrotz%40yahoo.ca
<mailto:shannonrotz%40yahoo.ca%0b>
> > ]
> Sent: 04/11/2012 06:17 PM MST
> To: <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> >
> Subject: RE: [MAXIMO List] Process Revision Issue
>
> Hi George: I have run across that issue before. If I recall correctly,
> it's fixed in a later patch, but in the mean time, you need to run the
> following against the database:
>
> Delete from wfassignment where processed = 'PURCHREQ' and processrev = 13
>
> Note: this assumes you have no transactions related to this revision
> (although if you're able to delete it, you shouldn't have any).
>
> Shannon
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com>
> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ] On
> Behalf
> Of
> George
> Sent: April-11-12 5:05 PM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Process Revision Issue
>
> Hello everyone,
> Here is what I'm working on, I was in workflow designer and I created a
new
> revision to my PURCHREQ workflow to make some changes, it created revision
> 13. My changes didn't work so I deleted the process revision 13. Now when
I
> go back to create a new revision I get an error.
>
> Here is what the error says:
> Database error number 2601 has occurred when operating on WFASSIGNMENT
> Assignment=1 Process=PURCHREQ Process Revision=13 Workflow ID=0 Node ID=5.
> [PRSEAMS] Cannot insert duplicate key row in object
> 'dbo.wfassignment' with unique index 'wfassign_ndx1'
>
> Has anyone come across something like this and if so how can I fix it?
>
> Maximo 6.2.1
> Weblogic
> SQL Server 2005
>
> thx,
> mrggutz
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Title
(Embedded image moved to file: pic12938.gif)
START1(Embedded image moved to file:
pic02223.gif)(Embedded image moved to file:
pic22142.gif)Send User Back to Start Center
Application
(Embedded image moved to file: pic23754.gif)
STARTCNTR(Embedded image moved to file:
pic06511.gif)Select Value
Tab Name
(Embedded image moved to file: pic22741.gif)
(Embedded image moved to file: pic20175.gif)
Action
(Embedded image moved to file: pic21459.gif)
(Embedded image moved to file: pic17825.gif)
Select Value
Relation
(Embedded image moved to file: pic03221.gif)
(Embedded image moved to file: pic17870.gif)
Detail Menu
Launch Process
(Embedded image moved to file: pic01626.gif)
(Embedded image moved to file: pic31934.gif)
Select Value
Directions Title
(Embedded image moved to file: pic15205.gif)
Workflow Message(Embedded image moved to file:
pic31783.gif)
Directions Body
(Embedded image moved to file: pic23850.gif)
Purchase Requisition Sent to Purchasing
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave