| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQWF Adminserver error |
« View previous topic :: View next topic » |
| Author |
Message
|
| emileke |
 Posted: Mon Aug 07, 2006 4:14 pm Post subject: MQWF Adminserver error |
 |
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
FMC34503E: sqlfxdb: SQL30082N Attempt to establish connection failed with security reason "17" ("UNSUPPORTED FUNCTION").
FMC34-DBG: SQLSTATE 08001: The application requester is unable to establish the connection |
|
| Back to top |
|
 |
| kotha |
| Posted: Mon Aug 07, 2006 7:03 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
emileva,
check your data base connection. |
|
| Back to top |
|
|
| emileke |
| Posted: Mon Aug 07, 2006 10:01 pm Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
Database Connection works
_________________
Emile M Kearns |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Aug 08, 2006 5:34 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What do you get when you do fmczchk
Also, looks like an authorization issue
When and where are you getting this error
What works and what doesn't work |
|
| Back to top |
|
|
| emileke |
| Posted: Wed Aug 09, 2006 9:36 pm Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
The Administration Server does not startup. When you say authorization, where and what ?
Output fmczchk -d:
FMC34012I: ===> General checks.
FMC34011I: Performing WebSphere MQ Workflow Version 3.5.0 checks.
FMC34101I: The Operating System is AIX 5.2.
FMC34103I: Local time is 2006-08-10 07:36:56.
FMC34104I: Universal time coordinated (UTC) is 2006-08-10 05:36:56.
FMC34-DBG: TZ is set to USAST-2
FMC34157I: Patch xlC.rte-6.0.0.0 is installed, minimum required version is 5.0.0.0.
FMC34314I: The local IP address is 10.111.67.220.
FMC34131I: The WebSphere MQ Workflow installation directory is /usr/lpp/fmc/bin.
FMC34154I: WebSphere MQ Workflow Version 3.5.0.1 is installed.
FMC34143I: The default configuration is 'FMC' (from the general configuration profile).
FMC34121I: The current configuration is 'FMC'.
FMC34145I: The following configurations are available: FMC.
FMC34135I: The installation profile is /usr/lpp/fmc/fmcrc.
FMC34135I: The general configuration profile is /var/fmc/fmcrc.
FMC34135I: The configuration profile is /var/fmc/cfgs/FMC/fmcrc.
FMC34136I: The user profile for fmc is /home/fmc/.fmcrc.
FMC34-DBG: Installation profile values:
FMC34-DBG: InstallationDirectory: '/usr/lpp/fmc'
FMC34-DBG: ConfigurationRootDirectory: '/var/fmc'
FMC34-DBG: InstalledComponents: 'SIPCUAD'
FMC34-DBG: MQWorkflowAdministrator: 'fmc'
FMC34-DBG: MQWorkflowGroup: 'fmcgrp'
FMC34-DBG: VRM: '030500'
FMC34-DBG: ServiceLevel: '1'
FMC34-DBG: Language: 'enu'
FMC34-DBG: RTDatabaseType: 'DB2'
FMC34-DBG: MQConnectionType: 'MQServer'
FMC34-DBG: General configuration profile values:
FMC34-DBG: DefaultConfigurationID: 'FMC'
FMC34-DBG: Current configuration profile values:
FMC34-DBG: ConfigurationAdministrator: 'fmc'
FMC34-DBG: ConfigurationGroup: 'fmcgrp'
FMC34-DBG: ConfiguredComponents: 'SIU'
FMC34-DBG: SystemGroup: 'FMCGRP'
FMC34-DBG: System: 'FMCSYS2'
FMC34-DBG: MQPrefix: 'FMC'
FMC34-DBG: MQQueueManager: 'FMCQM2'
FMC34-DBG: RTDatabase: 'FMCDB'
FMC34-DBG: RTDatabaseAlias: 'FMCDB'
FMC34-DBG: RTDatabaseInstanceIsRemote: '1'
FMC34-DBG: RTDB2Instance: 'fmcnode'
FMC34-DBG: RTDB2LocalInstance: 'db2inst1'
FMC34-DBG: RTDatabaseAdministratorUserID: 'db2inst2'
FMC34-DBG: RTDatabaseUserID: 'fmc'
FMC34-DBG: RTDatabaseMQWorkflowUser: 'ADMIN'
FMC34-DBG: CreateRuntimeDatabase: '0'
FMC34-DBG: LoadFDL: '1'
FMC34-DBG: MQPrincipal: 'fmc'
FMC34-DBG: MQCommunicationProtocol: 't'
FMC34-DBG: MQCommunicationAddress: '10.111.67.220'
FMC34-DBG: MQPort: '5010'
FMC34-DBG: FMLServerChannelTable: '/var/fmc/chltabs/MQWFCHL.TAB'
FMC34-DBG: MQBackupQueues: 'l'
FMC34-DBG: MQTransactionCoordinator: 'fmc'
FMC34-DBG: MQTransactionCoordinatorStartsQM: '0'
FMC34-DBG: MQClusterName: 'FMCGRP'
FMC34-DBG: MQClusterMode: 'a'
FMC34-DBG: MQClusterFirstQueueManager: 'FMCQM'
FMC34-DBG: MQClusterPrincipal: 'fmc'
FMC34-DBG: MQClusterProtocol: 't'
FMC34-DBG: MQClusterCommunicationAddress: '10.111.67.219'
FMC34-DBG: MQClusterPort: '5010'
FMC34-DBG: RTExecutionServerOperationMode: 'Standalone'
FMC34-DBG: RTErrorLogFile: '/var/fmc/cfgs/FMC/log/fmcerr.log'
FMC34-DBG: RTSystemLogFile: '/var/fmc/cfgs/FMC/log/fmcsys.log'
FMC34-DBG: FMLClientChannelTable: '/var/fmc/chltabs/MQWFCHL.TAB'
FMC34-DBG: FMLConnectName: 'FMC.FMCGRP.FMCSYS2,FMCQM2'
FMC34-DBG: FMLSegmentation: '0'
FMC34-DBG: RTDatabasePassword: '********'
FMC34-DBG: RTSystemShutdownMode: 'keepsessions'
FMC34-DBG: FMC_TRACE_FILE: 'trace08082006'
FMC34-DBG: User profile values:
FMC34-DBG: (none)
FMC34113I: Language specification is 'enu' (from the installation profile).
FMC34115I: The message catalog is /usr/lpp/fmc/msg/fmckmenu.cat.
FMC34-DBG: LC_MESSAGES='', NLSPATH='/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lpp/fmc/msg/%N'
FMC34132I: The XPG4 locale is en_US en_US en_US en_US en_US en_US.
FMC34134I: The locale file used is /usr/lib/nls/loc/en_US.
FMC34-DBG: LC_ALL='', LANG='en_US', LOCPATH='/usr/lib/nls/loc'
FMC34146I: The current code page is ISO8859-1.
FMC34013I: ===> Admin Server found, checks started.
FMC34-DBG: Found /usr/lpp/fmc/bin/fmcamain
FMC34-DBG: Successfully loaded library libdb2.a
FMC34-DBG: Read '/home/db2inst1/sqllib/db2profile'
FMC34-DBG: Read '/home/db2inst1/sqllib/userprofile'
FMC34-DBG: Read '/home/db2inst1/sqllib/profile.env'
FMC34122I: Environment variable DB2_RR_TO_RS is set to 'YES'.
FMC34500I: ==> Database Manager configuration for db2inst1.
FMC34509E: Query heap size is 0, must be at least 1500.
FMC34501I: ==> Database configuration for FMCDB.
FMC34503E: sqlfxdb: SQL30082N Attempt to establish connection failed with security reason "17" ("UNSUPPORTED FUNCTION").
FMC34-DBG: SQLSTATE 08001: The application requester is unable to establish the connection.
FMC34013I: ===> Server message device found, checks started.
FMC34-DBG: Found /usr/lpp/fmc/lib/libfmccdfms.a
FMC34-DBG: Services file is '/etc/services'
FMC34303I: TCP port MQSeriesI found at number 1414.
FMC34306I: The local listener for port 1414 is active.
FMC34303I: TCP port MQSeriesII found at number 1415.
FMC34306I: The local listener for port 1415 is active.
FMC34303I: TCP port fmclFMCQM25010 found at number 5010.
FMC34306I: The local listener for port 5010 is active.
FMC34404I: The MQSeries Server 5.3.0.9 is installed.
FMC34-DBG: Using /var/mqm/mqs.ini to locate qm.ini files
FMC34nnnI: System for FMCQM2 is FMC.FMCGRP.FMCSYS2
FMC34031I: Successfully loaded QM switch file library db2swit.
FMC34nnnI: Settings for FMCQM2 from /var/mqm/qmgrs/FMCQM2/qm.ini
FMC34nnnI: XAResourceManager.XAOpenString = DB=FMCDB, toc=p, UID=fmc, PWD=******
FMC34nnnI: Channels.MaxChannels = 100
FMC34nnnI: Channels.MaxActiveChannels = 100
FMC34nnnI: Queue Manager VSPBRKP1 not used by WebSphere MQ Workflow
FMC34nnnI: Queue Manager VSPBRKP2 not used by WebSphere MQ Workflow
FMC34nnnE: Default queue manager <null> not found in /var/mqm/mqs.ini
FMC34013I: ===> Execution Server found, checks started.
FMC34-DBG: Found /usr/lpp/fmc/bin/fmcemain
FMC34013I: ===> Client message layer (server API) found, checks started.
FMC34-DBG: Found /usr/lpp/fmc/lib/mqserver/libfmccfmlc.a
FMC34-DBG: FMLConnectName taken from configuration profile
FMC34nnnI: FMLConnectName is 'FMC.FMCGRP.FMCSYS2,FMCQM2'
FMC34-DBG: FMLClientChannelTable taken from configuration profile
FMC34nnnI: Channel definition file is /var/fmc/chltabs/MQWFCHL.TAB
FMC34-DBG: Reading channel table /var/fmc/chltabs/MQWFCHL.TAB
FMC34410I: Channel table /var/fmc/chltabs/MQWFCHL.TAB has 2 entries.
FMC34411I: 0: Active; Queue Manager FMCQMB connecting to 10.111.67.220(5010) through TCP.
FMC34411I: 1: Active; Queue Manager FMCQM2 connecting to 10.111.67.220(5010) through TCP.
FMC34-DBG: FMLSegmentation taken from configuration profile
FMC34nnnI: This client can connect to an OS/390 server
FMC34013I: ===> Client message layer (client API) found, checks started.
FMC34-DBG: Found /usr/lpp/fmc/lib/mqclient/libfmccfmlc.a
FMC34-DBG: FMLConnectName taken from configuration profile
FMC34-DBG: /usr/lpp/fmc/lib/mqclient/libfmccfmlc.a is not active, skipping checks
FMC34-DBG: ===> WebSphere MQ Workflow C/C++ API not checked (none of 'A' configured)
FMC34-DBG: Checking /usr/lpp/fmc/bin/java3500...
FMC34-DBG: Checking /usr/lpp/fmc/bin/java3501...
FMC34-DBG: ===> Java Agent not checked (none of 'C' configured)
FMC34-DBG: Checking /usr/lpp/fmc/bin/java3500...
FMC34-DBG: Checking /usr/lpp/fmc/bin/java3501...
FMC34014I: ===> Java API (fmcojapi.jar) is not installed.
FMC34-DBG: ===> Java API not checked (none of 'J' configured)
FMC34100I: Messages have been written to /opt/workflow/scripts/fmczchk.log.
FMC34998I: See fmczchk.htm for more information on the messages.
FMC34999I: Configuration checker ended: 3 error(s), 0 warning(s), rc = 0.
ts/fmczchk.log.
FMC34998I: See fmczchk.htm for more information on the messages.
FMC34999I: Configuration checker ended: 3 error(s), 0 warning(s), rc = 0. |
|
| Back to top |
|
|
| hos |
| Posted: Thu Aug 10, 2006 1:16 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
my best guess is, that your DB2 client version does not match to your DB2 server version. Have you upgrated the client but not the server recently? |
|
| Back to top |
|
|
| emileke |
| Posted: Thu Aug 10, 2006 4:22 am Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
| No. none of these environments changed. |
|
| 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
|
|
|
|
