| Author |
Message
|
| golam_m |
 Posted: Wed Sep 06, 2006 6:46 am Post subject: Getting FMC26508E when trying to import FDL with GDC |
 |
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi,
We are trying to import FDL containing process template definitions with GDC ( Global Data Container). It throws following exception during import.
"FMC26508E The global data container information for process 'W008_ReviewECO_V010' (table 'GCON1') could not be created in the database."
The Workflow run time database name is PIRTDB and the Database User is PIUSR,We issued the following command sequence in the AIX server where workflow is installed.
1. We logged in to the AIX server with Workflow installation owner (FMC)
2. connect to PIRTDB
3. grant createtab on database to user PIUSR
4. grant createin on schema fmc to user PIUSR
5. grant use of tablespace gcontain to user PIUSR
6. commit
All the above commands went successful, still we are facing issues while importing the FDL.
We tried other solution as mentioned below.
1. We import and translate with one fdl only one process
containing a global data container.
2. Or we import the whole fdl containing all processes without
the option -t (translate).
Then, for each process, we execute a command like:
fmcibie -uadmin -ppassword -c "TRANSLATE PROCESS NeuScan"
which translates the process model "NeuScan" in the runtime
database.
It didn't work also.
Please help us.
Thanks, |
|
| Back to top |
|
 |
| jmac |
| Posted: Wed Sep 06, 2006 7:50 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I am not certain of this, but it seems to me that the user doing the import may be the one which needs to have the proper authorization to create the table.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| golam_m |
| Posted: Thu Sep 07, 2006 8:25 pm Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi John,
We import the FDLs using "ADMIN" user which is a MQ Workflow administrator user. "ADMIN" is not a DB2 user. Can we give the privilege to "ADMIN" to create the table? Shall we make "ADMIN" a DB2 user?
In windows machine, the Run Time DB user id and password is provided during creation of a configuration. It creates the tables during import of FDLs (using MQ Workflow "ADMIN") to run time server.
The same is not working in the AIX machine.
Please let me know If I need to provide more details.
Thanks, |
|
| Back to top |
|
|
| k4mik4z3 |
| Posted: Fri Sep 08, 2006 5:24 am Post subject: |
|
|
Novice
Joined: 03 Aug 2006
Posts: 24
Location: India
|
Have u changed the Global data container fields before this deployment ? ie. u deployed first with one set of fields and then changed or added some field before u deployed the model this time ?
Is this the only error line u got or any more ?
Try dropping the GCON1 table and deploying again. |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Sep 08, 2006 5:25 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| golam_m wrote: |
| We import the FDLs using "ADMIN" user which is a MQ Workflow administrator user. "ADMIN" is not a DB2 user. Can we give the privilege to "ADMIN" to create the table? Shall we make "ADMIN" a DB2 user? |
It is my opinion that this is what is necessary. But I am not a heavy user of GDC, so I am not 100% certain.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| golam_m |
| Posted: Thu Sep 14, 2006 5:59 am Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi ,
I have not changed the Global data container fields before this deployment. This is the first time I am deploying after the configuration set up. I am also not sure whether the configuration set up has been done properly.
Pasted below are the extract of the fmczchk.log and content of the fmcrc file.
==================================================================
the output of fmczchk.log
FMC34010I: Configuration checker version 3.6.0.118 started.
FMC34119I: No command-line options specified.
FMC34012I: ===> General checks.
FMC34011I: Performing WebSphere MQ Workflow Version 3.6.0 checks.
FMC34101I: The Operating System is AIX 5.2.
FMC34103I: Local time is 2006-09-13 07:56:52.
FMC34104I: Universal time coordinated (UTC) is 2006-09-13 12:56:52.
FMC34157I: Patch xlC.rte-6.0.0.0 is installed, minimum required version is 5.0.0
.0.
FMC34314I: The local IP address is 172.17.64.42.
FMC34131I: The WebSphere MQ Workflow installation directory is /usr/lpp/fmc/bin.
FMC34154I: WebSphere MQ Workflow Version 3.6.0.0 is installed.
FMC34143I: The default configuration is 'IDEAL' (from the general configuration
profile).
FMC34121I: The current configuration is 'IDEAL'.
FMC34145I: The following configurations are available: IDEAL.
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/IDEAL/fmcrc.
FMC34136I: The user profile for fmc is /home/fmc/.fmcrc.
FMC34113I: Language specification is 'enu' (from the installation profile).
FMC34115I: The message catalog is /usr/lpp/fmc/msg/fmckmenu.cat.
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.
FMC34146I: The current code page is ISO8859-1.
FMC34013I: ===> Admin Server found, checks started.
FMC34516E: Variable DB2_RR_TO_RS is not set (should be set to 'YES').
FMC34500I: ==> Database Manager configuration for pidb2cl.
FMC34509E: Query heap size is 0, must be at least 1500.
FMC34501I: ==> Database configuration for PIRTDB.
FMC34503E: sqlfxdb: SQL30082N Attempt to establish connection failed with secur
ity reason "3" ("PASSWORD MISSING").
FMC34013I: ===> Server message device found, checks started.
FMC34303I: TCP port fmclXZ0Z002E1414 found at number 1414.
FMC34306I: The local listener for port 1414 is active.
FMC34nnnW: No MQSeries TCP port found at default number 5010
FMC34404I: The MQSeries Server 5.3.0.10 is installed.
FMC34nnnI: System for XZ0Z002E is PI.EAIGRP.PISYS
FMC34031I: Successfully loaded QM switch file library db2swit.
FMC34nnnI: Settings for XZ0Z002E from /var/mqm/qmgrs/XZ0Z002E/qm.ini
FMC34nnnI: XAResourceManager.XAOpenString = DB=PIRTDB, toc=t, UID=piusr, PWD=*
*****
FMC34nnnI: Channels.MaxChannels = <null>
FMC34nnnI: Channels.MaxActiveChannels = <null>
FMC34nnnE: Queue manager PAIPI01 not found in /var/mqm/mqs.ini
FMC34nnnI: Default queue manager is XZ0Z002E
FMC34013I: ===> Execution Server found, checks started.
FMC34013I: ===> Client message layer (server API) found, checks started.
FMC34nnnI: FMLConnectName is 'PI.EAIGRP.PISYS,XZ0Z002E,FMC.FMCGRP.FMCSYS,PAIPI01
'
FMC34nnnI: Channel definition file is /var/fmc/chltabs/MQWFCHL.TAB
FMC34410I: Channel table /var/fmc/chltabs/MQWFCHL.TAB has 3 entries.
FMC34411I: 0: Active; Queue Manager PAIPI01 connecting to dcxintpi(1414) throu
gh TCP.
FMC34411I: 1: Active; Queue Manager XZ0Z002E connecting to dcxintpi(1414) thro
ugh TCP.
FMC34411I: 2: Active; Queue Manager XZ0Z002E connecting to dcxintpi(1414) thro
ugh TCP.
FMC34nnnI: This client can connect to an OS/390 server
FMC34013I: ===> Client message layer (client API) found, checks started.
FMC34013I: ===> WebSphere MQ Workflow C/C++ API found, checks started.
FMC34nnnI: API will use queue manager 'XZ0Z002E' (queue prefix PI)
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34317I: Need root user authority to create a raw socket for ping.
FMC34013I: ===> Java API found, checks started.
FMC34nnnI: CLASSPATH='/home/pidb2cl/sqllib/java/db2java.zip:/home/pidb2cl/sqllib
/java/db2jcc.jar:/home/pidb2cl/sqllib/function:/home/pidb2cl/sqllib/java/db2jcc_
license_cu.jar:.'
FMC34100I: Messages have been written to /usr/lpp/fmc/bin/fmczchk.log.
FMC34998I: See fmczchk.htm for more information on the messages.
FMC34999I: Configuration checker ended: 4 error(s), 1 warning(s), rc = 0.
=========================================================================
Content of fmcrc file:
Configuration/IDEAL/ConfigurationAdministrator=idealadm
Configuration/IDEAL/ConfigurationGroup=fmcgroup
Configuration/IDEAL/ConfiguredComponents=ASIUK
Configuration/IDEAL/SystemGroup=EAIGRP
Configuration/IDEAL/System=PISYS
Configuration/IDEAL/MQPrefix=PI
Configuration/IDEAL/MQQueueManager=XZ0Z002E
Configuration/IDEAL/MQConnectionType=MQServer
Configuration/IDEAL/RTDatabase=PIRTDB
Configuration/IDEAL/RTDatabaseAlias=PIRTDB
Configuration/IDEAL/RTDatabaseInstanceIsRemote=1
Configuration/IDEAL/RTDB2Instance=pidb
Configuration/IDEAL/RTDB2LocalInstance=pidb2cl
Configuration/IDEAL/RTDatabaseAdministratorUserID=pidb
Configuration/IDEAL/RTDatabaseUserID=piusr
Configuration/IDEAL/RTDatabaseMQWorkflowUser=ADMIN
Configuration/IDEAL/CreateRuntimeDatabase=1
Configuration/IDEAL/LoadFDL=0
Configuration/IDEAL/RTDatabaseLocation=/home/pidb/pidb
Configuration/IDEAL/RTDatabaseContainerDirectory=/home/pidb/pidb
Configuration/IDEAL/RTDatabaseLogLocation=/logs/ideal/DB2/pidb
Configuration/IDEAL/RTDatabaseLayoutFile=/var/fmc/cfgs/FMC/fmcdblay.ini
Configuration/IDEAL/RTDatabaseSpaceManagement=d
Configuration/IDEAL/MQPrincipal=idealadm
Configuration/IDEAL/MQCommunicationProtocol=t
Configuration/IDEAL/MQCommunicationAddress=dcxintpi
Configuration/IDEAL/MQPort=1414
Configuration/IDEAL/FMLServerChannelTable=/var/fmc/chltabs/MQWFCHL.TAB
Configuration/IDEAL/MQBackupQueues=c
Configuration/IDEAL/MQTransactionCoordinator=piusr
Configuration/IDEAL/MQTransactionCoordinatorStartsQM=0
Configuration/IDEAL/MQClusterName=EAIGRP
Configuration/IDEAL/MQClusterMode=f
Configuration/IDEAL/RTExecutionServerOperationMode=Standalone
Configuration/IDEAL/RTErrorLogFile=/var/fmc/cfgs/IDEAL/log/fmcerr.log
Configuration/IDEAL/RTSystemLogFile=/var/fmc/cfgs/IDEAL/log/fmcsys.log
Configuration/IDEAL/FMLClientChannelTable=/var/fmc/chltabs/MQWFCHL.TAB
Configuration/IDEAL/FMLConnectName=PI.EAIGRP.PISYS,XZ0Z002E,FMC.FMCGRP.FMCSYS,PA
IPI01
Configuration/IDEAL/FMLSegmentation=0
Configuration/IDEAL/RTDatabasePassword=0511190627
Configuration/IDEAL/RTDatabaseAdministratorPassword=05110AF7
Configuration/IDEAL/RTAuthenticationExitTypeServer=JAVA
~
=========================================================================
Thanks, |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Sep 14, 2006 6:37 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| Quote: |
| FMC34503E: sqlfxdb: SQL30082N Attempt to establish connection failed with security reason "3" ("PASSWORD MISSING"). |
Not sure what this issue is, but I would say it certainly looks like the issue you are having could be related to this.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| golam_m |
| Posted: Thu Sep 28, 2006 4:09 am Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi John,
We have created the DB user called admin and gave the same password which MQ Workflow admin user has. Still we are facing the issue. Please help us.
Thanks, |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu Sep 28, 2006 6:35 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi,
I still think, its a user authorization issue.
Try these steps.
-Get the dbadmin permission(like fmc) to 'piusr'
-use fmczutil to reset the dbpassword.
-Make sure qm.ini has the correct password.
-Restart the server and try import.
Creating a db user 'admin' does not solve the problem. Import utility internally reads the fmcrc and uses the db user and password set there.
Thanks,
-Mahesh |
|
| Back to top |
|
|
| golam_m |
| Posted: Tue Oct 03, 2006 4:57 am Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi,
We executed the following steps.
Get the dbadmin permission(like fmc) to 'piusr'
Comment: Admin privilege is given to "pisur"
-use fmczutil to reset the dbpassword.
Comment: piusr and password is already configured
-Make sure qm.ini has the correct password.
Comment: Checked, it has correct password
-Restart the server and try import.
Comment: Restarted the server.
It is still not working.
We have also tried the solutions available in the following links.
http://www-1.ibm.com/support/docview.wss?uid=swg21141273
and
http://www-1.ibm.com/support/docview.wss?uid=isg1IY78060
Neither of these resolved the issue.
I am wondering whether Gloabl Containers can be implemented in a 3 tier architecture.
Thanks, |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Tue Oct 03, 2006 6:19 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
| Quote: |
| I am wondering whether Gloabl Containers can be implemented in a 3 tier architecture. |
We have a three tier architecture and using GDC. No problems.
Thanks,
-Mahesh |
|
| Back to top |
|
|
| vijaycr |
| Posted: Wed Oct 11, 2006 1:02 am Post subject: |
|
|
Acolyte
Joined: 11 Oct 2006
Posts: 62
Location: Singapore
|
Check if there is already a table with the name GCCON1 in the database.
The same table name might be used by some other process.
If this FDL is created by the build time the tablename shld be prefixed with 'GC_' trying to import a fdl with any other prefix would fail with a syntax error. Note that your table name is 'GCCON1'. Which version are of MQWF using? |
|
| Back to top |
|
|
|
|
