| Author |
Message
|
| nwhi |
 Posted: Tue Aug 02, 2005 9:32 am Post subject: SQL 1017 with fmcibie WFv3.5 and Oracle 9.2.0.1 |
 |
|
Apprentice
Joined: 19 Dec 2002
Posts: 25
Location: UK
|
Strange behaviour. DB created successfully and fmcamain comes up fine, but fmcibie is failing to connect to the DB with an SQL error 1017.
WF v3.5 SP3 and Oracle client connection to separate Oracle server.
fmcibie and fmcamain being run using the same credentials (same userid)
tnsping and SQL plus both work fine. Any ideas what fmcibie may be doing differently to fmacmain to access the database?
V.Strange because it works for a different workflow system that we setup a while ago.
Any ideas what else I can try to test the connection and find out excatly where fmcibie is failing?
Nick
_________________
Nick Whittle
IBM Certified Solutions Designer -
WebSphere MQ Workflow V3.4
MQSolutions (UK) Ltd |
|
| Back to top |
|
 |
| nwhi |
| Posted: Wed Aug 03, 2005 2:19 am Post subject: SOLVED |
|
|
Apprentice
Joined: 19 Dec 2002
Posts: 25
Location: UK
|
1017 is actually Logon Denied (i.e. userid / password problem). The confusing thing is that tnsping and sqlplus worked fine with the same userid / password.
The problem turned out to be the restriction with MQWF that database userid's can only be a maximum of 8 characters. The 9 character userid we were trying to use was being corrupted by WF to a string of 8 characters plus some junk of 3 or 4 characters. Finally discovered this using a trace on Oracle.
So, for future reference, if having DB uid/pwd problems with workflow but a manual connect works fine, remember the length restriction of MQWF!
(  - I must have come across this over half a dozen times before )
_________________
Nick Whittle
IBM Certified Solutions Designer -
WebSphere MQ Workflow V3.4
MQSolutions (UK) Ltd |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Aug 03, 2005 5:32 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Nick:
AH... the old 8 character userid limitiation  .
Shades of MVS....
Thanks for letting us know.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| koko |
| Posted: Tue Aug 09, 2005 10:20 am Post subject: |
|
|
Master
Joined: 26 Sep 2003
Posts: 206
|
Just curious if this problem is only for the fmcautil or fmcibie but not for the WF application itself??.
I have users with long names defined in WF and it works fine.
_________________
Thanks
Koko |
|
| Back to top |
|
|
| nwhi |
| Posted: Wed Aug 10, 2005 1:04 am Post subject: |
|
|
Apprentice
Joined: 19 Dec 2002
Posts: 25
Location: UK
|
koko,
the problem only appeared to affect fmcibie. WF itself (fmcamain) appeared to start without any problems (no warnings or out of the ordinary messages were logged), however we couldn't import any processes into it to test it out!
The problem may well be only an Oracle thing now, but I can certainly remember the same restriction with DB2 UDB once upon a time.
hope this helps
Nick
_________________
Nick Whittle
IBM Certified Solutions Designer -
WebSphere MQ Workflow V3.4
MQSolutions (UK) Ltd |
|
| Back to top |
|
|
|
|
