| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| cannot delete person with fmcibie |
« View previous topic :: View next topic » |
| Author |
Message
|
| ecarico |
 Posted: Tue Dec 28, 2004 12:38 pm Post subject: cannot delete person with fmcibie |
 |
|
Novice
Joined: 18 Aug 2004
Posts: 10
|
Everytime I try to use fmcibie to delete a person, I receive this error in the log. FMC31000E A database error occurred. SQL Code -811.
When looking up SQL Code -811 it means: The result of an embedded select statement is a table of more than one row, or the result of the subquery of a basic predicate is more than one value.
FMC31000E just tells me to analyze and correct the error and restart. But, I don't know what and where to analyze. Below is the FDL that I am trying to import. I imported with FMCIBIE -u ADMIN -p password -i staffdowns122804.fdl -o -t HELP!!
/*
*
* FDL definitions generated by MQ Workflow at 2004-12-28, 1:20:52 PM.
*
*/
CODEPAGE 1252
FM_RELEASE V3R4 0
/*
* DELETE PERSONs
*/
DELETE PERSON 'DOWNSJA'
Thanks! |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Dec 28, 2004 1:10 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
This is a new one to me....
Can you dump all of your Person objects?
Try this:
fmcibie -uadmin -ppassword -ePeople.fdl -c"EXPORT PERSON *"
If this is successfull look and see if there are duplicates for that user (I seriously doubt this).
Also what version are you running?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ecarico |
| Posted: Wed Dec 29, 2004 6:23 am Post subject: |
|
|
Novice
Joined: 18 Aug 2004
Posts: 10
|
| We are running 3.4. When I ran the fmcibie that you gave me, it came up with 134 entities and none were duplicates. Any other ideas? |
|
| Back to top |
|
|
| CHF |
| Posted: Wed Dec 29, 2004 6:28 am Post subject: |
|
|
Master
Joined: 16 Dec 2003
Posts: 297
|
I am not sure about this will solve your problem, but try to restart all your services ( WF, MQ, DB2 in the order), and then try to run fmcibie again.
_________________
CHF  |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Dec 29, 2004 6:31 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Strange....
The only other thing I can think of is that somehow this user, "DOWNSJA", has some assignment to some other object(s). In the past when I have run into this, I have received an error message that stated something to that effect. I.E. "DOWNSJA can not be deleted because of associations to other objects"... I am sure you get the idea.
It would be difficult to find these associations, but if the database is small enough you might want to have a look. Look for assignments as ProcessAdministrator of a Model, or maybe coordinator of a role. The other issue is if DOWNSJA is the starter of a running process instance.
I would probably open a PMR on this.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
