ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » [Solved]Staff Administration API- Workflow 3.6

Post new topic  Reply to topic
 [Solved]Staff Administration API- Workflow 3.6 « View previous topic :: View next topic » 
Author Message
girish
PostPosted: Thu Jul 14, 2005 9:23 pm    Post subject: [Solved]Staff Administration API- Workflow 3.6 Reply with quote

Newbie

Joined: 07 May 2005
Posts: 6

Hi,
We are trying to use Staff Administration APIs provided by Workflow 3.6 to manage staff in Workflow.

We tried executing the sample code provided by IBM to test these APIs. To make the arch simple, we have DB2 runtime database, WF server and the sample java program residing on the same AIX system.

When we execute the sample program, it throws the following exception while calling session.logon() api -

com.ibm.workflow.client.util.FmcApiException:
FMC38009E MQSeries Workflow API Error :
API Return Code : 147
Error Origin : FmcDBRecord.java:132
Error Message : FMC00147E Error accessing database: [IBM][CLI Driver]
[DB2/NT] SQL0010N The string constant beginning with "'FMCSYS FOR UPDATE OF NEX
T_AVAILABLE_OID" does not have an ending string delimiter. SQLSTATE=42603

Please note, when we execute any other Workflow java client, which logons using ExecutionService API it works fine.

Has anyone faced similar problem?


Last edited by girish on Wed Sep 21, 2005 9:41 pm; edited 1 time in total
Back to top
View user's profile Send private message
jmac
PostPosted: Fri Jul 15, 2005 5:24 am    Post subject: Reply with quote

Jedi Knight

Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC

I have been able to run this with no problems. I would check the versions of DB2, Java, etc, to ensure that you are on supported levels, and if you still have the problem, you might need to open a PMR
_________________
John McDonald
RETIRED
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
MQRR
PostPosted: Mon Apr 10, 2006 3:48 pm    Post subject: staff api issues Reply with quote

Centurion

Joined: 10 Aug 2003
Posts: 110

Versions i am using

WF : 3.6
MQ version : 530.10 CSD10
DB2Version: DB2 v8.1.10.812


I am getting following error when using staff api, any ideas?


[4/10/06 15:35:21:000 PDT] 617feef6 SystemErr R com.ibm.workflow.client.util.FmcApiException:
FMC38009E MQSeries Workflow API Error :
API Return Code : 147
Error Origin : FmcDBRecord.java:132
Error Message : FMC00147E Error accessing database: [IBM][CLI Driver][DB2/NT] SQL0010N The string constant beginning with "'FMCSYS FOR UPDATE OF NEXT_AVAILABLE_OID" does not have an ending string delimiter. SQLSTATE=42603
Back to top
View user's profile Send private message
MQRR
PostPosted: Mon Apr 10, 2006 4:44 pm    Post subject: Reply with quote

Centurion

Joined: 10 Aug 2003
Posts: 110

I found this link which gives a solution to my problem. But still after apllying the SP2 it does not solve my problem.

http://www-1.ibm.com/support/docview.wss?uid=swg1IY73549
Back to top
View user's profile Send private message
MQRR
PostPosted: Tue Apr 11, 2006 9:58 am    Post subject: Reply with quote

Centurion

Joined: 10 Aug 2003
Posts: 110

It is solved. forgot to replace fmcistf jar in my application with new fmcistf jar that comes with the sp2.

MQRR
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » [Solved]Staff Administration API- Workflow 3.6
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.