| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Execution Server dies on the first hit |
« View previous topic :: View next topic » |
| Author |
Message
|
| satboppana |
 Posted: Thu Apr 15, 2004 7:51 pm Post subject: Execution Server dies on the first hit |
 |
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
Environment:
3-tier
Custom Java Client on WAS
Workflow Server 3.4.3 on AIX 5.1
DB2 7.2 on AIX
& MQ 5.3
A java listener on AIX listens to the client requests and gets data from DB2.
The DB2 box was rebooted for some reason and then on the Execution servers starts terminating upon receiving a request.
I have also tried from the FAT client and i was able to see only Process Instance List and template list.
Could not see Workitems or Worklists. It was hanging at that point.
Any ideas???
_________________
Sb |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri Apr 16, 2004 5:05 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
What is in fmcsys.log, fmcerr.log?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Fri Apr 16, 2004 6:26 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
After your Db2 server was rebooted did you restart WF ?
_________________
-Ratan |
|
| Back to top |
|
|
| satboppana |
| Posted: Fri Apr 16, 2004 7:25 am Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
We did restart the wf server
ANd the log is as follows
WebSphere MQ Workflow 3.4 Error Report
Report creation = 04/16/04 00:56:59
Related message = FMC31050E An error has occurred which has terminated processing.
Error location = File=/projects/fmc/drvp/lbld/v340/aix/src/fmckdbg.cxx, Line=199, Function=fmckAssert(const char *, const char *, unsigned int)
Error data = FmcAssertionException, Condition=*** Assertion failed in /projects/fmc/drvp/lbld/v340/src/fmcscbrg.cxx(101): false
_________________
Sb |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Apr 16, 2004 7:32 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Nothing helpful in these logs, how about MQ or Db2 logs
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| satboppana |
| Posted: Fri Apr 16, 2004 12:34 pm Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
From Db2diag
DiagData
0000 0064 ...d
2004-04-15-09.22.25.113678 Instance:db2inst1 Node:000
PID:159044(amqzlaa0_nd) Appid:C0A83820.E017.040407153220
XA DTP Support sqlxa_map_sqlca_to_xa_rc Probe:102
DIA4703E Non-zero SQLCODE returned for XA interface request.
String Title: XA Interface SQLCA PID:159044 Node:000
SQLCODE = -30081 TOKEN 1: 73 TOKEN 2: *
Dump File:/home/db2inst1/sqllib/db2dump/159044.000 Data:SQLCA
2004-04-15-09.22.30.070850 Instance:db2inst1 Node:000
PID:134336(fmcsmain) Appid:C0A83820.B88D.040415142229
XA DTP Support sqlxa_open Probe:101
DIA4701E Database "FMCDB" could not be opened for distributed transaction
processing.
String Title: XA Interface SQLCA PID:134336 Node:000
SQLCODE = -1036
2004-04-15-09.22.35.125138 Instance:db2inst1 Node:000
PID:195490(fmcsmain) Appid:C0A83820.930A.040408222737
XA DTP Support sqlxa_end Probe:10
_________________
Sb |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Apr 16, 2004 12:58 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I would say that this is your problem
| Quote: |
| DIA4701E Database "FMCDB" could not be opened for distributed transaction processing. |
Why this is happening I do not know. You probably need to open a PMR
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| satboppana |
| Posted: Fri Apr 16, 2004 1:30 pm Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
We r working with IBM and found out that the worklists are corrupted.
_________________
Sb |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Apr 16, 2004 1:33 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
How did your worklists get corrupted? That seems pretty strange
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| satboppana |
| Posted: Fri Apr 16, 2004 1:49 pm Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
Yes it is strange.
We deleted the worklists from the table and we could logon thru the Fat & Web client.
We r in the process of login thru the custom java client
_________________
Sb |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Apr 16, 2004 1:58 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
So, are you doing direct access to the DB2 Worklist Table? Or are you saying that MQWF is corrupting the Worklist on its own?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| satboppana |
| Posted: Tue Apr 20, 2004 12:43 pm Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
these are the logs
FMC_PUBLIC_WORK_LIST {
this=202d3748
_oid=005F406D000000000000000000000001
_beepOption=1
_threshold=
_state=0
_name=SearchTX
_filter=not yet materialized
_order=
_v2Filter=
_description=
_filterAsSql=not yet materialized
_parametersAsSql=not yet materialized
_parameterValues=not yet materialized }
2004-04-15, 14:46:32.290, fmcdlob.inl( 198) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::AsT1(),
2004-04-15, 14:46:32.290, fmcdlob.inl( 234) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::Materialize(),
2004-04-15, 14:46:32.290, fmcdbmat.cxx( 4865) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filter(), >entry
2004-04-15, 14:46:32.292, fmcdbmat.cxx( 4939) (09,Sq,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filter(),
VALUES(SUBSTR(:a45000filterLobLoc, 1)) INTO :*a45000filterLob :ia45000filterLob
2004-04-15, 14:46:32.292, fmcdbmat.cxx( 4865) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filter(), <exit
2004-04-15, 14:46:32.292, fmcdlob.inl( 198) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::AsT1(),
2004-04-15, 14:46:32.292, fmcdlob.inl( 234) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::Materialize(),
2004-04-15, 14:46:32.292, fmcdbmat.cxx( 4982) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filterAsSql(), >entry
2004-04-15, 14:46:32.294, fmcdbmat.cxx( 5056) (09,Sq,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filterAsSql(),
VALUES(SUBSTR(:a45050filterAsSqlLobLoc, 1)) INTO :*a45050filterAsSqlLob :ia45050filterAsSqlLob
2004-04-15, 14:46:32.294, fmcdbmat.cxx( 4982) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::filterAsSql(), <exit
2004-04-15, 14:46:32.295, fmcdlob.inl( 198) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::AsT1(),
2004-04-15, 14:46:32.295, fmcdlob.inl( 234) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcString,FmcDatabase::PublicWorkList,FmcDBLobLocator>::Materialize(),
2004-04-15, 14:46:32.295, fmcdbmat.cxx( 5099) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parametersAsSql(), >entry
2004-04-15, 14:46:32.296, fmcdbmat.cxx( 5173) (09,Sq,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parametersAsSql(),
VALUES(SUBSTR(:a45100parametersAsSqlLobLoc, 1)) INTO :*a45100parametersAsSqlLob :ia45100parametersAsSqlLob
2004-04-15, 14:46:32.297, fmcdbmat.cxx( 5099) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parametersAsSql(), <exit
2004-04-15, 14:46:32.297, fmcdlob.inl( 198) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcStream,FmcDatabase::PublicWorkList,FmcDBLobLocator>::AsT1(),
2004-04-15, 14:46:32.297, fmcdlob.inl( 234) (03,Fl,To), fmcemain(237336- 1), FmcLOBAccess<FmcStream,FmcDatabase::PublicWorkList,FmcDBLobLocator>::Materialize(),
2004-04-15, 14:46:32.297, fmcdbmat.cxx( 5216) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parameterValues(), >entry
2004-04-15, 14:46:32.298, fmckdynp.cxx( 75) (99,Gn,Kr), fmcemain(237336- 1), FmcDynPointer::DataRep::DataRep(), 8192 bytes allocated
2004-04-15, 14:46:32.299, fmcdbmat.cxx( 5290) (09,Sq,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parameterValues(),
VALUES(SUBSTR(:a45150parameterValuesLobLoc, 1)) INTO :*a45150parameterValuesLob :ia45150parameterValuesLob
2004-04-15, 14:46:32.299, fmcksdds.cxx( 180) (00,Er,Kr), fmcemain(237336- 1), FmcStream::StreamHeader::Decode(), THROW_INT, FmcStream::ExcKindError, Origin=File=/projects/fmc/drvp/lbld/v340/aix/src/fmcksdds.cxx, Line=180, Function=FmcStream::StreamHeader::Decode(FmcStream &)
2004-04-15, 14:46:32.300, fmcksdds.cxx( 452) (99,Gn,Kr), fmcemain(237336- 1), FmcStream::~FmcStream(), stream size = 8192, buffer size = 8192
2004-04-15, 14:46:32.300, fmckdynp.cxx( 83) (99,Gn,Kr), fmcemain(237336- 1), FmcDynPointer::DataRep::~DataRep(), 8192 bytes deleted
2004-04-15, 14:46:32.300, fmcdbmat.cxx( 5216) (03,Fl,DB), fmcemain(237336- 1), FmcDatabase::PublicWorkList::parameterValues(), <exit
And IBM said that the public worklists were corrupted
_________________
Sb |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Thu Apr 22, 2004 1:08 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
satboppana
Was there an explanation as to why/how these workflow worklists got corrupted from IBM? Were they able to recreate this. It would be interesting to know whether or not this was more of a one time thing or is this something that can happen again.
Thanks,
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| satboppana |
| Posted: Mon Apr 26, 2004 2:47 am Post subject: |
|
|
Acolyte
Joined: 20 Dec 2001
Posts: 64
|
IBM has no answer yet
_________________
Sb |
|
| 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
|
|
|
|
