| Author |
Message
|
| rachu19118 |
 Posted: Mon May 16, 2005 8:34 am Post subject: [SOLVED]error while configuring buildtime |
 |
|
Newbie
Joined: 19 Jul 2004
Posts: 2
|
Hi,
Following are the log entries. Can someone help me configure the workflow buildtime .
Environment is
DB2 8.1
MQ 5.3
MQWF 3.4
entries in fmczkcfg.log
5/16/2005 12:22:35 PM FMC33741I Creating the Buildtime database. This may take a while ...
5/16/2005 12:25:25 PM FMC33920E Error occurred. See c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
5/16/2005 12:25:25 PM FMC33905E Error while creating Buildtime database FMCBTDB occurred.
See the log file c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
5/16/2005 12:25:30 PM FMC33905E Error while creating Buildtime database FMCBTDB occurred.
See the log file c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
entries in @fmczbt.log
5/16/2005 12:22:35 PM FMC33110I The database manager is already active.
5/16/2005 12:22:36 PM FMC33115I Creating the database - FMCBTDB
5/16/2005 12:22:36 PM FMC33116I Please wait... This may take a while.
5/16/2005 12:24:21 PM FMC33118I Database FMCBTDB has been created on node DB2.
5/16/2005 12:24:21 PM FMC33120I Updating the database configuration.
5/16/2005 12:24:21 PM FMC33003I SQL1482W The BUFFPAGE parameter will only be used if one of the buffer pools
is defined with a size of -1.
5/16/2005 12:24:24 PM FMC33124I Creating a tablespace that is managed by system.
5/16/2005 12:24:24 PM FMC33125I Creating a table that is managed by system.
5/16/2005 12:25:25 PM FMC33140I Setup of DB2 completed successfully.
Thanks. |
|
| Back to top |
|
 |
| Ratan |
| Posted: Mon May 16, 2005 8:37 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
what do you see in db2diag.log?
_________________
-Ratan |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue May 17, 2005 3:21 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rachu19118,
I checked the same log file in my comp. and noticed the same lines. So the problem is not with this as my configuration is working properly. And u'll notice that this is a warning and not an error, indicated by W and E respectively.
I think what you should try is, make sure ur db2 services are all started including the security server. I can only remember having troble in configuration when the db2 services or MQ Series services were not running properly. |
|
| Back to top |
|
|
| demarial |
| Posted: Tue May 31, 2005 9:32 am Post subject: |
|
|
Newbie
Joined: 31 May 2005
Posts: 9
|
I am also experiencing problems creating buildtime. I can create runtime and import sample FDLs, however, buildtime fails immediately after successfully creating the BT database (according to the logs).
My environment:
Windows XP sp2
DB2 8.1.3
MQ 5.30.0
MW WF 3.5 |
|
| Back to top |
|
|
| kotha |
| Posted: Tue May 31, 2005 10:50 am Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
| What the @fmczbt log file says?? |
|
| Back to top |
|
|
| demarial |
| Posted: Tue May 31, 2005 11:00 am Post subject: |
|
|
Newbie
Joined: 31 May 2005
Posts: 9
|
@fmczbt.log
5/31/2005 2:56:09 PM FMC33110I The database manager is already active.
5/31/2005 2:56:09 PM FMC33115I Creating the database - DBBT
5/31/2005 2:56:09 PM FMC33116I Please wait... This may take a while.
5/31/2005 2:58:09 PM FMC33118I Database DBBT has been created on node DB2.
5/31/2005 2:58:09 PM FMC33120I Updating the database configuration.
5/31/2005 2:58:09 PM FMC33003I SQL1482W The BUFFPAGE parameter will only be used if one of the buffer pools
is defined with a size of -1.
5/31/2005 2:58:13 PM FMC33124I Creating a tablespace that is managed by system.
5/31/2005 2:58:13 PM FMC33125I Creating a table that is managed by system.
5/31/2005 2:59:20 PM FMC33140I Setup of DB2 completed successfully. |
|
| Back to top |
|
|
| jmac |
| Posted: Tue May 31, 2005 11:30 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Looks to me like this worked
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| demarial |
| Posted: Tue May 31, 2005 11:36 am Post subject: |
|
|
Newbie
Joined: 31 May 2005
Posts: 9
|
Exactly! The database was created, however, I received an error during the build and the buildtime environment never was created.
I have tried using the command line utility (fmczutil) and the configuration GUI tool.
I applied MQWF sp4 and that still did not help. I can't find any logs that indicate what the problem is.
fmczkcfg.log
5/31/2005 2:56:09 PM FMC33741I Creating the Buildtime database. This may take a while ...
5/31/2005 2:59:20 PM FMC33920E Error occurred. See c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
5/31/2005 2:59:20 PM FMC33905E Error while creating Buildtime database DBBT occurred.
See the log file c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
5/31/2005 2:59:23 PM FMC33905E Error while creating Buildtime database DBBT occurred.
See the log file c:\program files\ibm websphere mq workflow\cfgs\fmc\log\@fmczbt.log for more information.
I am at a loss! |
|
| Back to top |
|
|
| kotha |
| Posted: Tue May 31, 2005 12:03 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
| check the DB2 wether DBBT is there or not. |
|
| Back to top |
|
|
| demarial |
| Posted: Tue May 31, 2005 1:12 pm Post subject: |
|
|
Newbie
Joined: 31 May 2005
Posts: 9
|
| DBBT is there, but the buildtime tool was not created. |
|
| Back to top |
|
|
| vennela |
| Posted: Tue May 31, 2005 1:14 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| demarial wrote: |
| DBBT is there, but the buildtime tool was not created. |
This cannot happen.
When you install workflow, buildtime tool will be present.
Is the configuration created or not is the question.
What happens when you issue fmczchk -d |
|
| Back to top |
|
|
| demarial |
| Posted: Tue May 31, 2005 1:23 pm Post subject: |
|
|
Newbie
Joined: 31 May 2005
Posts: 9
|
What I meant is that the buildtime environment was not created.
output from fmczchk -d
FMC34010I: Configuration checker version 3.5.0.118 started.
FMC34120I: Command-line options specified: -d
FMC34012I: ===> General checks.
FMC34011I: Performing WebSphere MQ Workflow Version 3.5.0 checks.
FMC34101I: The Operating System is Windows XP 5.1 (Service Pack 2).
FMC34103I: Local time is 2005-05-31 17:21:38.
FMC34104I: Universal time coordinated (UTC) is 2005-05-31 21:21:38.
FMC34-DBG: Successfully loaded library c:\windows\system32\wsock32.dll
FMC34301I: WinSock version: WinSock 2.0.
FMC34314I: The local IP address is 10.1.53.78.
FMC34131I: The WebSphere MQ Workflow installation directory is c:\program files\
ibm websphere mq workflow\bin.
FMC34154I: WebSphere MQ Workflow Version 3.5.0.4 is installed.
FMC34143I: The default configuration is 'FMC' (from the general configuration pr
ofile).
FMC34121I: The current configuration is 'FMC'.
FMC34145I: The following configurations are available: FMC.
FMC34-DBG: Installation profile values:
FMC34-DBG: ServiceLevel: '4'
FMC34-DBG: FolderName: 'IBM WebSphere MQ Workflow'
FMC34-DBG: ConfigurationRootDirectory: 'C:\Program Files\IBM WebSphere MQ Work
flow'
FMC34-DBG: InstallationDirectory: 'C:\Program Files\IBM WebSphere MQ Workflow'
FMC34-DBG: InstalledComponents: 'JWHGCLUMDRBPASI'
FMC34-DBG: Language: 'ENU'
FMC34-DBG: VRM: '030500'
FMC34-DBG: General configuration profile values:
FMC34-DBG: DefaultConfigurationID: 'FMC'
FMC34-DBG: Current configuration profile values:
FMC34-DBG: Agent.Reaper.Ratio: '0'
FMC34-DBG: Agent.Reaper.Threshold: '0'
FMC34-DBG: Agent.Reaper.Cycle: '0'
FMC34-DBG: RTIconDirectory: 'c:\program files\ibm websphere mq workflow\bin\ic
oninst'
FMC34-DBG: RTDatabasePassword: '********'
FMC34-DBG: FMLSegmentation: '0'
FMC34-DBG: FMLConnectName: 'FMC.FMCGRP.FMCSYS,FMCQM'
FMC34-DBG: FMLClientChannelTable: 'c:\program files\ibm websphere mq workflow\
chltabs\mqwfchl.tab'
FMC34-DBG: RTSystemLogFile: 'c:\program files\ibm websphere mq workflow\cfgs\f
mc\log\fmcsys.log'
FMC34-DBG: RTErrorLogFile: 'c:\program files\ibm websphere mq workflow\cfgs\fm
c\log\fmcerr.log'
FMC34-DBG: RTExecutionServerOperationMode: 'Standalone'
FMC34-DBG: MQClusterMode: 'f'
FMC34-DBG: MQClusterName: 'FMCGRP'
FMC34-DBG: MQTransactionCoordinatorStartsQM: '0'
FMC34-DBG: MQTransactionCoordinator: 'db2admin'
FMC34-DBG: MQBackupQueues: 'c'
FMC34-DBG: FMLServerChannelTable: 'c:\program files\ibm websphere mq workflow\
chltabs\mqwfchl.tab'
FMC34-DBG: MQPort: '5010'
FMC34-DBG: MQCommunicationAddress: 'FRA80806'
FMC34-DBG: MQCommunicationProtocol: 't'
FMC34-DBG: MQPrincipal: 'fmc'
FMC34-DBG: RTDatabaseSpaceManagement: 'd'
FMC34-DBG: RTDatabaseLayoutFile: 'c:\program files\ibm websphere mq workflow\c
fgs\fmc\fmcdblay.ini'
FMC34-DBG: RTDatabaseLogLocation: 'C:\Program Files\IBM WebSphere MQ Workflow\
rt_db\DB2\FMCDB'
FMC34-DBG: RTDatabaseContainerDirectory: 'C:\Program Files\IBM WebSphere MQ Wo
rkflow\rt_db\DB2\FMCDB'
FMC34-DBG: RTDatabaseLocation: 'C:'
FMC34-DBG: LoadFDL: '0'
FMC34-DBG: CreateRuntimeDatabase: '0'
FMC34-DBG: RTDatabaseMQWorkflowUser: 'ADMIN'
FMC34-DBG: RTDatabaseUserID: 'db2admin'
FMC34-DBG: RTDatabaseAdministratorUserID: 'db2admin'
FMC34-DBG: RTDB2LocalInstance: 'DB2'
FMC34-DBG: RTDB2Instance: 'DB2'
FMC34-DBG: RTDatabaseInstanceIsRemote: '0'
FMC34-DBG: RTDatabaseAlias: 'FMCDB'
FMC34-DBG: RTDatabase: 'FMCDB'
FMC34-DBG: MQQueueManager: 'FMCQM'
FMC34-DBG: MQPrefix: 'FMC'
FMC34-DBG: System: 'FMCSYS'
FMC34-DBG: SystemGroup: 'FMCGRP'
FMC34-DBG: ConfiguredComponents: 'ASIRCU'
FMC34-DBG: User profile values:
FMC34-DBG: (none)
FMC34113I: Language specification is 'ENU' (from the installation profile).
FMC34115I: The message catalog is c:\progra~1\ibmweb~1\bin\fmckmenu.cat.
FMC34-DBG: NLSPATH='C:\PROGRA~1\IBMWEB~1\BIN\%N'
FMC34132I: The XPG4 locale is EN_US.IBM-1252.
FMC34133I: The ANSI code page is 1252, the OEM code page is 437.
FMC34134I: The locale file used is c:\progra~1\ibmweb~1\bin\locale\en_us\ibm-125
2.lcl.
FMC34-DBG: LC_ALL='EN_US', LANG='', LOCPATH='C:\PROGRA~1\IBMWEB~1\BIN\LOCALE'
FMC34013I: ===> Admin Server found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\fmcamain.exe
FMC34-DBG: Successfully loaded library c:\progra~1\ibm\sqllib\bin\db2cli.dll
FMC34-DBG: Successfully loaded library c:\progra~1\ibm\sqllib\bin\db2sys.dll
FMC34-DBG: Successfully loaded library c:\progra~1\ibm\sqllib\bin\db2app.dll
FMC34122I: Environment variable DB2_RR_TO_RS is set to 'YES'.
FMC34500I: ==> Database Manager configuration for DB2.
FMC34508I: Agent stack size is 96.
FMC34508I: Query heap size is 1500.
FMC34501I: ==> Database configuration for FMCDB.
FMC34508I: Log file size is 4095.
FMC34508I: Log primary is 4.
FMC34508I: Log second is 124.
FMC34508I: Database heap is 400.
FMC34508I: Default application heap is 512.
FMC34508I: Number of page cleaners is 2.
FMC34508I: Log buffer size is 16.
FMC34508I: Lock list is 1000.
FMC34502I: ==> Database connection to FMCDB.
FMC34508I: Buffer pool size is 2000.
FMC34515I: Connect to FMCDB was successful (user ID 'DEMARIAL').
FMC34-DBG: User ID specified for connect was '<null>'
FMC34510I: The DBMS name is DB2/NT (version 08.01.0003).
FMC34511I: The database driver is db2cli.dll (Version 08.01.0003).
FMC34512I: The database name for alias 'FMCDB' is 'fmcdb'.
FMC34700I: ==> Service Control Manager configuration.
FMC34-DBG: Settings for service 'DB2NTSECSERVER':
FMC34-DBG: Service type: 16
FMC34-DBG: Start type: auto start
FMC34-DBG: Error control: normal
FMC34-DBG: Binary: "C:\Program Files\IBM\SQLLIB\BIN\db2sec.exe"
FMC34-DBG: Start name: LocalSystem
FMC34-DBG: Display name: DB2 Security Server
FMC34nnnI: Service DB2NTSECSERVER: Startup automatic, account LocalSystem
FMC34-DBG: Settings for service 'MQSeriesServices':
FMC34-DBG: Service type: 16
FMC34-DBG: Start type: auto start
FMC34-DBG: Error control: ignore
FMC34-DBG: Binary: C:\Program Files\IBM\WebSphere MQ\bin\amqsvc.exe
FMC34-DBG: Start name: LocalSystem
FMC34-DBG: Display name: IBM MQSeries
FMC34-DBG: Depends on: DB2NTSECSERVER
FMC34nnnI: Service MQSeriesServices: Startup automatic, account LocalSystem
FMC34535I: Service 'DB2' does not exist, assuming DB2 client installation.
FMC34-DBG: Settings for service 'MQ Workflow - FMC':
FMC34-DBG: Service type: 16
FMC34-DBG: Start type: auto start
FMC34-DBG: Error control: normal
FMC34-DBG: Binary: c:\program files\ibm websphere mq workflow\bin\fmcamain.exe
FMC34-DBG: Start name: LocalSystem
FMC34-DBG: Display name: IBM MQ Workflow 3.5 - FMC
FMC34-DBG: Depends on: MQSeriesServices
FMC34nnnI: Service MQ Workflow - FMC: Startup automatic, account LocalSystem
FMC34013I: ===> Server message device found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\fmccdfms.dll
FMC34-DBG: Services file is 'c:\windows\system32\drivers\etc\services'
FMC34303I: TCP port fmclFMCQM5010 found at number 5010.
FMC34306I: The local listener for port 5010 is active.
FMC34-DBG: CSD for MQSeries Server from profile is 'CSD08'
FMC34-DBG: Skipping CSD 'CSD00' for MQSeries Server from profile
FMC34404I: The MQSeries Server 5.3.0.8 is installed.
FMC34-DBG: Using Registry to locate qm.ini files
FMC34nnnI: System for FMCQM is FMC.FMCGRP.FMCSYS
FMC34031I: Successfully loaded QM switch file library db2swit.dll.
FMC34nnnW: ThreadOfControl for FMCQM in Queue manager FMCQM registry is PROCESS,
should be THREAD
FMC34nnnI: Settings for FMCQM from Queue manager FMCQM registry
FMC34nnnI: XAResourceManager.XAOpenString = DB=FMCDB, TPM=MQ, toc=p, UID=db2ad
min, PWD=******
FMC34nnnI: Channels.MaxChannels = <null>
FMC34nnnI: Channels.MaxActiveChannels = <null>
FMC34nnnI: Queue Manager QM_fra80806 not used by WebSphere MQ Workflow
FMC34nnnI: Default queue manager is QM_fra80806
FMC34013I: ===> Execution Server found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\fmcemain.exe
FMC34013I: ===> Client message layer (server API) found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\mqserver\fmccfml
c.dll
FMC34-DBG: FMLConnectName taken from configuration profile
FMC34nnnI: FMLConnectName is 'FMC.FMCGRP.FMCSYS,FMCQM'
FMC34-DBG: FMLClientChannelTable taken from configuration profile
FMC34nnnI: Channel definition file is c:\program files\ibm websphere mq workflow
\chltabs\mqwfchl.tab
FMC34-DBG: Reading channel table c:\program files\ibm websphere mq workflow\chlt
abs\mqwfchl.tab
FMC34410I: Channel table c:\program files\ibm websphere mq workflow\chltabs\mqwf
chl.tab has 1 entries.
FMC34411I: 0: Active; Queue Manager FMCQM connecting to FRA80806(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 c:\program files\ibm websphere mq workflow\bin\mqclient\fmccfml
c.dll
FMC34-DBG: FMLConnectName taken from configuration profile
FMC34-DBG: c:\program files\ibm websphere mq workflow\bin\mqclient\fmccfmlc.dll
is not active, skipping checks
FMC34013I: ===> WebSphere MQ Workflow C/C++ API found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\fmcjdint.dll
FMC34-DBG: SystemGroup taken from configuration profile
FMC34-DBG: System taken from configuration profile
FMC34nnnI: API will use queue manager 'FMCQM' (queue prefix FMC)
FMC34-DBG: Reading channel table c:\program files\ibm websphere mq workflow\chlt
abs\mqwfchl.tab
FMC34-DBG: recv: type = , id = 239, seq = 42
FMC34324I: Ping FRA80806 successful.
FMC34-DBG: Checking c:\program files\ibm websphere mq workflow\bin\java3500...
FMC34-DBG: Checking c:\program files\ibm websphere mq workflow\bin\java3504...
FMC34014I: ===> Java API (fmcjapi.jar) is not installed.
FMC34-DBG: ===> Java API not checked (none of 'K' configured)
FMC34-DBG: ===> Buildtime not checked (none of 'B' configured)
FMC34013I: ===> Runtime Client found, checks started.
FMC34-DBG: Found c:\program files\ibm websphere mq workflow\bin\fmcn6rtc.exe
FMC34-DBG: 'threed32.ocx' is c:\windows\system32\threed32.ocx
FMC34-DBG: 'comdlg32.ocx' is c:\windows\system32\comdlg32.ocx
FMC34-DBG: 'mscomctl.ocx' is c:\windows\system32\mscomctl.ocx
FMC34-DBG: 'fmcn6cc.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6cc.ocx
FMC34-DBG: 'fmcn6sc.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6sc.ocx
FMC34-DBG: 'fmcn6pc.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6pc.ocx
FMC34-DBG: 'fmcn6fc.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6fc.ocx
FMC34-DBG: 'fmcn6ptl.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6ptl.ocx
FMC34-DBG: 'fmcn6wc.ocx' is c:\progra~1\ibmweb~1\bin\fmcn6wc.ocx
FMC34-DBG: 'fmcbvbci.ocx' is c:\progra~1\ibmweb~1\bin\fmcbvbci.ocx
FMC34-DBG: 'fmcnmonc.ocx' is c:\progra~1\ibmweb~1\bin\fmcnmonc.ocx
FMC34-DBG: Version of c:\windows\system32\comctl32.dll is 5.82 (xpsp_sp2_rtm.040
803-2158)
FMC34031I: Successfully loaded Runtime Client resource library fmcn6enu.dll.
FMC34nnnI: Runtime Client help file is c:\program files\ibm websphere mq workflo
w\bin\fmcn6enu.hlp
FMC34100I: Messages have been written to c:\fmczchk.log.
FMC34998I: See fmczchk.htm for more information on the messages.
FMC34999I: Configuration checker ended: 0 error(s), 1 warning(s), rc = 0.
C:\> |
|
| Back to top |
|
|
| jmac |
| Posted: Tue May 31, 2005 1:55 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| Code: |
| FMC34-DBG: ===> Buildtime not checked (none of 'B' configured) |
This is not good  (as if you didn't already know that)
I don't believe I have ever seen this before.
Please try this experiment:
1. Fire up windows mqwf config program
2. Create new config BT
3. Select Only Buildtime to configure
4. CHANGE the Database type to MS Access
5. Configure.
This will attempt to configure an MSAccess BTDB.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| kotha |
| Posted: Tue May 31, 2005 3:37 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
I see DBBT for the buildtime database in the above discussion.
is there any NAMING standards for the buildtime and runtime database.
Last edited by kotha on Wed Jun 01, 2005 5:08 am; edited 1 time in total |
|
| Back to top |
|
|
| hos |
| Posted: Wed Jun 01, 2005 1:11 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
| Once you have sucessfully created the BT DB, can you create a NEW BT configuration and select 'use existing DB' and select the BT DB that is already created? |
|
| Back to top |
|
|
|
|
