| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| FmcSQLException [Solved] |
« View previous topic :: View next topic » |
| Author |
Message
|
| msgbrkr |
 Posted: Thu Jan 20, 2005 5:50 pm Post subject: FmcSQLException [Solved] |
 |
|
Newbie
Joined: 21 Apr 2004
Posts: 9
|
Hi all,
My config is as follows: MQWF 3.4 sp5 on UNIX box which accesses DB2 8.1.2 FP6 on a diff UNIX box.
I am getting the following in the fmcsys.log:
Thu, Dec 23, 2004 12:04:45 AM FMC10300I Cleanup server for system group FMCGRP started in system FMCSYS.
Thu, Dec 23, 2004 12:04:45 AM FMC31050E An error has occurred which has terminated processing.
Thu, Dec 23, 2004 12:04:45 AM FmcSQLException, Sqlcode=0, Sqlerrmc=, Sqlerrp=SQLRIC2C, Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=10, Sqlerrd[3]=0, Sqlerrd[4]=0, Sqlerrd[5]=0, Sqlwarn=W W , Sqlstate=01517
Thu, Dec 23, 2004 12:04:45 AM FMC12260E The cleanup server for system group FMCGRP stopped abnormally.
Thanks in advance.
Last edited by msgbrkr on Mon Feb 07, 2005 12:59 pm; edited 1 time in total |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Jan 20, 2005 6:02 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What OS is Database on ?
What OS is WF Server on? (What flavour of UNIX) |
|
| Back to top |
|
|
| msgbrkr |
| Posted: Thu Jan 20, 2005 11:25 pm Post subject: |
|
|
Newbie
Joined: 21 Apr 2004
Posts: 9
|
Both are on HP-UX.
Thanks. |
|
| Back to top |
|
|
| hos |
| Posted: Thu Jan 20, 2005 11:44 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
Sqlstate 01517 = A character that could not be converted was replaced with a substitute character.
Although this is a DB warning it seems to be unexpected to MQWF. You seem to have a codepage mismatch between your servers and the database. Check the instructions for codepages supported on HPUX and the database setup. If that doesn't help, I would recommend to open a PMR. |
|
| Back to top |
|
|
| msgbrkr |
| Posted: Mon Feb 07, 2005 12:58 pm Post subject: |
|
|
Newbie
Joined: 21 Apr 2004
Posts: 9
|
| Thanks hos.....we set the DB2CODEPAGE on the box and its working fine. |
|
| Back to top |
|
|
| tony poole |
| Posted: Fri Jan 06, 2006 2:06 am Post subject: |
|
|
Newbie
Joined: 19 Aug 2003
Posts: 4
Location: Manchester
|
I know that this post is solved but I'm curious as to where you set the DB2CODEPAGE. did you do it via an evironment variable on the app server or did you change it via db2set on the dbserver?
I have the same problem but my db and workflow server are on the same node. My codepage for the database is 923 and apparently the only way of changing this is to delete the database, set the codepage and then re-create the database. We can't do that as the db contains months of transactional data.
Regards
Tony |
|
| 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
|
|
|
|
