| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| sql error -818 : starting workflow .... |
« View previous topic :: View next topic » |
| Author |
Message
|
| vinod_sasidharan |
 Posted: Tue May 04, 2004 9:37 am Post subject: sql error -818 : starting workflow .... |
 |
|
Newbie
Joined: 29 Oct 2003
Posts: 9
|
Hi
My configuration
*************
mq workflow 3.4
mq series 5.3
aix 5.1
ISSUE
************
When i try to start workflow ..
i get ........>
FMC31000E A database error occurred. SQL code: -818.
******************************************************
******************************************************
error - > 818 says that timestamp mismatch
SQL0818N A timestamp conflict occurred.
Explanation: The timestamp generated by the precompiler at
precompile time is not the same as the timestamp stored with the
package at bind time.
******************************************************
Also i found from IBm site rebind the database
and hence i tried
fmczrdb -o=b -y FMC -d=FMCDB
and again ended up with error
******************************************************
/4c/fmc/wf3.4/temp340>fmczrdb -o=b -y FMC -d=FMCDB
DB2 user ID : fmc
DB2 password :
FMC33999E Internal error: 'FmcAssertionException, Condition=*** Pre-condition failed in /projects/fmc/drvp/lbld/v340/src/fmcks
tr.cxx(1326): !IsNull()'.
FMC33141I Setup of database completed with errors.
******************************************************
Can anyone help me out to come out of the sql -818 error or the FMC33999E error.
regards ,
vinod |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue May 04, 2004 9:59 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
When I have had this error in the past I have deleted my configuration and started over... Thats fine for a developer, but if this is a production database, you will obviously need a better solution.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mqworkflow |
| Posted: Wed May 05, 2004 9:11 am Post subject: |
|
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
check the file qm.ini for the Qmanager in var/mqm/ directory.
It has the userid/password the database you are trying to connect to. Check the password. Also check if the user id under which you are starting the workflow server has the required Database environment variables set.
I think this is the most likely issue with you.
Hope this helps. |
|
| Back to top |
|
|
| vinod_sasidharan |
| Posted: Thu May 06, 2004 11:29 am Post subject: Solved......BUT .... |
|
|
Newbie
Joined: 29 Oct 2003
Posts: 9
|
Hi ,
Workflow started once i did the rebind (fmczrdb) using ROOT USER .since fmc user was not able rebind (assertion error).....
"FMC33999E Internal error: 'FmcAssertionException"
Even if it is by pass ...
I am still on the process of finding why fmc is not able to rebind
(FMC33999E Internal error: 'FmcAssertionException)
regards ,
vinod |
|
| 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
|
|
|
|
