| Author |
Message
|
| vinodsasidharan |
 Posted: Thu May 22, 2003 8:13 am Post subject: Starting WORKFLOW services problem in windows 2000 |
 |
|
Apprentice
Joined: 25 Apr 2003
Posts: 47
Location: Norwich
|
Hi 
1)
My workflow server is in win 2000 .
sometimes back when i start the mq workflow services it never used to start and says "internal error". what i used to do was . restart the quee managter . restart mq series and try again it worked .
but yesterday i had the same problem but this time once i start . it shows started .but once i refresh it shows not started . i tried above method but no way .
IT NEVER STARTS EVEN AFTER DOING ALL THE STUFFS .
ANY GUESSES PLEASE . WHAT IS WRONG ??
2)
Any body who have tried a online back up and restore of a runtime database .plss tell me the exact process.
i am getting roll forward pending error when i restore the online backups.
??
_________________
Vinod sasidharan
Ibm Certfied MQ Admin 5.3
Ibm Certfied MQ Admin 6.0
Ibm Certfied WAS Admin 6.0
Ibm Certfied WMB Admin 5.0
Ibm Certfied Db2 Specialist.
Sun certified Java Programmer.
"Ai carte, ai parte ....................." |
|
| Back to top |
|
 |
| Ratan |
| Posted: Thu May 22, 2003 8:38 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
but yesterday i had the same problem but this time once i start . it shows started .but once i refresh it shows not started . i tried above method but no way .
|
check the TP_MON_NAME. it should be set to mqmax. (open Db2 command line processor and do "get dbm cfg", this show you your TP_MON_NAME).
Also check you fmcsys.log and fmcerr.log and post the log.
_________________
-Ratan |
|
| Back to top |
|
|
| vinodsasidharan |
| Posted: Thu May 22, 2003 8:44 am Post subject: IT ALREADY IS |
|
|
Apprentice
Joined: 25 Apr 2003
Posts: 47
Location: Norwich
|
 IT ALREADY IS ?
Transaction processor monitor name (TP_MON_NAME) = mqmax
_________________
Vinod sasidharan
Ibm Certfied MQ Admin 5.3
Ibm Certfied MQ Admin 6.0
Ibm Certfied WAS Admin 6.0
Ibm Certfied WMB Admin 5.0
Ibm Certfied Db2 Specialist.
Sun certified Java Programmer.
"Ai carte, ai parte ....................." |
|
| Back to top |
|
|
| vennela |
| Posted: Thu May 22, 2003 8:53 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Any MQ Errors. See MQ Error logs and look for any FDCs. |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu May 22, 2003 8:59 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Is your runtime DB local or remote? If it is remote reboot your win2000 machine hosting WF server.
_________________
-Ratan |
|
| Back to top |
|
|
| sshaker |
| Posted: Thu May 22, 2003 10:03 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 185
|
hi
pl start ur admin server on a console.. u should be getting messages as ur working.. on the console.. in another console try to look at the server processes.. it looks fmcamain process is getting killed.. can u pl tell me ur mq/wf/db2 versions with support pacs? if ur on mq5.3 with sp3 then ur in for a ride without a new hiper for this .. !! i think tpmon is another area which u should lookinto.. make sure that the mqmax.dll is in path..
regards
shaker
_________________
shaker |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Thu May 22, 2003 12:07 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
Vinod:
Incase this problem still exists...
If all else fails, reboot the server(as this might clear up some of the threads that might be hanging) but before you do that try setting all workflow related services(except db2) to manual. In other words, go ahead and set mqseries to be automatic but set workflow to be manual. This could also be an mqseries issue in that, it is possible that mq is simply taking a little longer than expected to come up and workflow in the meantime tries and tries to start, but with mq still coming up spits out an internal error message.
I have experienced a similar issue, (although this was on NT), but the way you are describing the problem, it reminds me very much of the problem that was once bothering me.
Anyways, so once mq comes up, then go into your services and manually try to start workflow and see what happens.
Also ensure that you have all the latest service/fix pacs applied in case that's the missing piece of the puzzle!
Any word on your MQ logs? Like Ratan said as well, how about your workflow err/sys files?
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| vinodsasidharan |
| Posted: Thu May 22, 2003 10:29 pm Post subject: Problem identified but |
|
|
Apprentice
Joined: 25 Apr 2003
Posts: 47
Location: Norwich
|
Hi got the problem .but how to roll forward .??
I ran the fmczchk on -y backup
FMC34503E: SQLConnect: [CLI Driver] SQL1117N A connection to or activation of d
atabase "BACKUP" cannot be made because of ROLL-FORWARD PENDING.
FMC34700I: ==> Service Control Manager configuration.
I tried a online backup on the database backup .
Now how do i get out of roll forward pending state.??
_________________
Vinod sasidharan
Ibm Certfied MQ Admin 5.3
Ibm Certfied MQ Admin 6.0
Ibm Certfied WAS Admin 6.0
Ibm Certfied WMB Admin 5.0
Ibm Certfied Db2 Specialist.
Sun certified Java Programmer.
"Ai carte, ai parte ....................." |
|
| Back to top |
|
|
| Andy |
| Posted: Fri May 23, 2003 7:42 am Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
In DB2 Control Centre, on right click on database, there is option "Stop Roll-Forward"..I dont know the SQL command..you can try it.
But if its the production enviournment and something goes wrong, dont blame me 
_________________
 Andy |
|
| Back to top |
|
|
|
|
