| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [SOLVED] Workflow Configuration Issue Oracle DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqworkflow |
 Posted: Mon Feb 23, 2004 12:19 pm Post subject: [SOLVED] Workflow Configuration Issue Oracle DB |
 |
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
Hi All,
We have installed and configured MQ workflow 3.4 sp4 on solaris 8 with oracle 9i as 3 tier RTDB. we can start the workflow server and use the fmcibie utilityto import/export the fdls into RTDB. But when we try to connect to the workflow system either through webclient or thick client, we get a time out error.
The fmcerr.log file says something like this. Could some one let us know what might be the problem.
WebSphere MQ Workflow 3.4 Error Report
Report creation = 02/20/04 06:33:07 PM
Related message = FMC31050E An error has occurred which has terminated processing.
Error location = File=/projects/fmc/drvl/lbld/v340/objsopt/oracle/fmcdbac2/fmcdblst.cxx, Line=8705, Function=NA
Error data = FmcSQLException, Sqlcode=-942, Sqlerrmc=ORA-00942: table or view does not exist
, Sqlerrp=NOT SET , Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=0, Sqlerrd[3]=0, Sqlerrd[4]=183, Sqlerrd[5]=0, Sqlwarn= , Sqlext=
WebSphere MQ Workflow 3.4 Error Report
Report creation = 02/20/04 06:33:07 PM
Related message = FMC31050E An error has occurred which has terminated processing.
Error location = File=/projects/fmc/drvl/lbld/v340/objsopt/oracle/fmcdbac2/fmcdblst.cxx, Line=8705, Function=NA
Error data = FmcSQLException, Sqlcode=-942, Sqlerrmc=ORA-00942: table or view does not exist
, Sqlerrp=NOT SET , Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=0, Sqlerrd[3]=0, Sqlerrd[4]=183, Sqlerrd[5]=0, Sqlwarn= , Sqlext=
WebSphere MQ Workflow 3.4 Error Report
Report creation = 02/20/04 06:33:12 PM
Related message = FMC31050E An error has occurred which has terminated processing.
Error location = File=/projects/fmc/drvl/lbld/v340/objsopt/oracle/fmcdbac2/fmcdblst.cxx, Line=8705, Function=NA
Error data = FmcSQLException, Sqlcode=-942, Sqlerrmc=ORA-00942: table or view does not exist
, Sqlerrp=NOT SET , Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=0, Sqlerrd[3]=0, Sqlerrd[4]=183, Sqlerrd[5]=0, Sqlwarn= , Sqlext=
WebSphere MQ Workflow 3.4 Error Report
Report creation = 02/20/04 06:33:12 PM
Related message = FMC31050E An error has occurred which has terminated processing.
Error location = File=/projects/fmc/drvl/lbld/v340/objsopt/oracle/fmcdbac2/fmcdblst.cxx, Line=8705, Function=NA
Error data = FmcSQLException, Sqlcode=-942, Sqlerrmc=ORA-00942: table or view does not exist
, Sqlerrp=NOT SET , Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=0, Sqlerrd[3]=0, Sqlerrd[4]=183, Sqlerrd[5]=0, Sqlwarn= , Sqlext= |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Feb 23, 2004 1:12 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
How do you know your workflow server is started. I bet your server is down.
You can do an import even though your workflow server is down. All you need is DB manager to be up to import something into workflow runtime.
On the workflow server machine do
| Code: |
| ps -ef | grep fmcamain |
See if you can see anything.
If you see a process try logging into workflow using the admin utility fmcautil |
|
| Back to top |
|
|
| mqworkflow |
| Posted: Tue Feb 24, 2004 6:34 am Post subject: SOLVED |
|
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
Hi Vennela,
The admin server has indeed started and I was able to use fmcautil. The problem is now fixed though. The oracle script file fmczsid.sql which is supposed to create the database tables did not create a few tables which are necessary if it finds that the table space is not enough for those tables. But the script comes up saying that all the tables were created .
Our Oracle DBA had to go through each one of the tables and make sure that they are indeed created properly.
Thanks a lot
mqwf |
|
| 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
|
|
|
|
