Author |
Message
|
dunesand |
Posted: Thu Oct 06, 2005 5:53 am Post subject: Clearing Unprocessed Collab Events... |
|
|
 Acolyte
Joined: 17 Nov 2003 Posts: 65 Location: Cambridgeshire, UK
|
I'm using WBI Express Plus 4.4 (just applied 4.4.0.1 fix pack but still says 4.4.0.0 in System Manager??) on Win 2003.
It sounds like a common "Gotcha", but say a collaboration has a few unprocessed events that need sorting out, and you delete the collaboration, then the Flow Manager can no longer access these events. How do I clear them?
The collab is then loaded back onto the ICS instance, but you can't delete it because it says there are "x number of unprocessed events in the system owned by myCollab".
*roll on Process Server* |
|
Back to top |
|
 |
Ratan |
Posted: Thu Oct 06, 2005 9:38 am Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
With ICS you can delete the contents of the WIP tables for such cases. I dont know about WBI Express. If it is same as ICS, then you should be clearing the WIP tables in the repository database. _________________ -Ratan
Last edited by Ratan on Thu Oct 06, 2005 1:46 pm; edited 1 time in total |
|
Back to top |
|
 |
hopsala |
Posted: Thu Oct 06, 2005 11:01 am Post subject: |
|
|
 Guardian
Joined: 24 Sep 2004 Posts: 960
|
|
Back to top |
|
 |
dunesand |
Posted: Fri Oct 07, 2005 12:09 am Post subject: |
|
|
 Acolyte
Joined: 17 Nov 2003 Posts: 65 Location: Cambridgeshire, UK
|
Thanks for the replies.
I found some data in two tables CxWipBlobs and CxWIPObjects which I removed. Restarting ICS, I still get the same problem when trying to just stop and delete the collaboration. The System Manager complains about 4 "Unprocessed Events".
The more I use a ICS, the more I hate it.  |
|
Back to top |
|
 |
hopsala |
Posted: Fri Oct 07, 2005 1:09 am Post subject: |
|
|
 Guardian
Joined: 24 Sep 2004 Posts: 960
|
|
Back to top |
|
 |
dunesand |
Posted: Fri Oct 07, 2005 1:48 am Post subject: |
|
|
 Acolyte
Joined: 17 Nov 2003 Posts: 65 Location: Cambridgeshire, UK
|
Gripe1:
The Flow Manager just doesn't appear to work. I'm sure I've not configured one of the gazillion options that exist in each oriface of the application correctly...
Gripe2:
But all I have is a simply JText adapter that reads in an XML file, passes a BO to a collaboration, then to another JText adapter for streaming to disk. I've not even got as far as mappings etc, the ASBO that comes in is the same ASBO that goes through the collab, and out onto disk.
I've designed all the BO's I'll be using and the mappings required, but just want to get this one basic process working first.
The agent picks up the file, correctly parses it into an object and passes it onto its controller. This then fails with some duplication error that means nothing to me.
This appears for the controller on the to and controller on the from port.
Code: |
Unable to create flow controlled resource:Attempt to create duplicate flow controlled resource with discriptor: [ ... ] because of the following problem: {2}. |
Of course if I could see the failed event (Gripe1), then I could delete it.
Gripe3:
Each time I make a change to the collab, I have to delete the repository on the server, update the user project from the intergration component library, then deploy from user project to my ICS instance.
Why? Well because even when I stop the collab, i can't overwrite it because it's still active (I stop all the adapter controllers etc too), and when I try to delete the collab, it comes back with the unprocessed event error.
Any ideas as to what I'm doing wrong?
Last edited by dunesand on Tue Oct 18, 2005 6:27 am; edited 1 time in total |
|
Back to top |
|
 |
Ratan |
Posted: Fri Oct 07, 2005 6:45 am Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
Quote: |
The Flow Manager just doesn't appear to work. I'm sure I've not configured one of the gazillion options that exist in each oriface of the application correctly... |
This is a tool I hate. Takes for ever to connect to the server.
Try deleting from all these tables:
DELETE FROM CXSTATELOG;
DELETE FROM CXTRANSBLOBS;
DELETE FROM CXWIPBLOBS;
DELETE FROM CXWORKFLOWCONTEXT;
DELETE FROM CXASTATEBUSOBJS;
DELETE FROM CXCOMPBUSOBJS;
DELETE FROM CXCOMPSTATESTATSCONFIG;
DELETE FROM CXCSTATEBUSOBJS;
DELETE FROM CXFAILEDEVENTKEYS;
DELETE FROM CXPBUSOBJMESSAGE;
DELETE FROM CXPBUSOBJSTATE;
DELETE FROM CXRECEIVEINBOUND;
DELETE FROM CXWIPOBJECTS; _________________ -Ratan |
|
Back to top |
|
 |
dunesand |
Posted: Fri Oct 07, 2005 6:54 am Post subject: |
|
|
 Acolyte
Joined: 17 Nov 2003 Posts: 65 Location: Cambridgeshire, UK
|
|
Back to top |
|
 |
Ratan |
Posted: Fri Oct 07, 2005 7:32 am Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
I am on 4.2.1 _________________ -Ratan |
|
Back to top |
|
 |
|