| Author |
Message
|
| mkhadse |
 Posted: Thu Dec 05, 2002 11:05 am Post subject: Error while creating the first Workflow Runtime Configuratio |
 |
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Hi,
I installed Workflow 3.2.2 on Windows 2000 and the while creating he first configuration (FMC) I get the following error.
FMC33146E DB2 API call 'sqlecrea' ended with error: 'SQL1005N The database alias "FMCDB2" already exists in either the local database directory or system database directory'
I have selected that a new runtime database should be created for this configuration.
After the error message if I check the db2 database I see that the database is created.
Has anybody come accross such an error? Please help.
Thanks in advance. |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Dec 05, 2002 11:29 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
You need to delete the already created FMCDB2 database and stat over again. Use DB2 utiliies to drop the database and start again.
OR
give a name other than FMCDB2
---
Venny |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 12:11 pm Post subject: Error while creating the first Workflow Runtime Configuratio |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Hi
I tried it many times with FMCDb, FMCDB1, FMCDB2, FMCDB3 ... All of these database were inexistent before starting to create the conifguration.
Is there anything else that I might be missing?
Thanks |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Dec 05, 2002 12:18 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I don't know:
You using the GUI or fmczutil
If you are using the GUI then when you select the DB2 instance, the box below it shows all the cataloged databases. If you select one of those then either
1. it accepts the selected database
2. it complains it's not a valid workflow runtime/buildtime database.
or
Pick a name that's not listed in the table |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 12:25 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
I am using the GUI. Should I use fmczutil? The Installation manual says we should use the GUI.
Once in the GUI, it shows the catalogued instances. When I choose and instance, then its displayes the databases that exists.
Then I click on create a new database. Then a dialog appears for database parameters. I click OK set the username and password for the database and click Next 2 times and then clicked Finish. |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Dec 05, 2002 12:48 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
GUI should work pretty good.
After you select the DB2 instance, it would show a few databases below.
You are saying that you are not selecting ay of thoe but opting to create a new one.
Try selecting the already listed databases? If it complains saying that the database is not a valid database then try until you are succesful
---
What happens after the configuration fails-- does it create a database anyway?
---
Venny |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Dec 05, 2002 1:07 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
You might run into such problems if you are using a terminal services client to connect to the win2000 machine where you are configuring WF.
-Laze |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 1:14 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
| I tried all the databases listed. I t gave me errors stating - 'Not a valid workflow runtime database.' Then I created new database using the NEW button. And that gives the same error as well. |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 1:16 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Laze:
I tried it from the Windows 200 console as well as connecting using terminal services client. In both cases I receive the same error.
Any ideas?
Thanks |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Dec 05, 2002 1:31 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What version of DB2 are you running
And why 3.2.2 .. the current version is 3.3.2 with Service Pack 3.
There's a DB2 utility called (Control Center I guess). Use it to delete the databases created. I am not sure if the delete would also uncatalog the database. If it doesn't you have to uncatalog the database too.
Really am not of much help though. Don't know the root cause.
Crate a new instance and give a new database name (give a wild name like XYDB2)
I don't thin even that one works.
DB2 versions? |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 1:53 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
| I tried it with XYZDB, still the same error. |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Dec 05, 2002 2:11 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
This is what I found from the internal PD database
Hope this helps
| Code: |
Support indicated this could be a db2 problem. Contacted DB2 support
in Toronto and they said this sounds like a problem with the Sync
Point Manager Name parameter in Db2 (SPM_NAME). In V6.1, the SPM_NAME
defaults to the hostname. In cust's case, the hostname contains a
dash (-). A dash is invalid for the SPM_NAME. Had customer do the
following:
1) db2cmd
2) from DB2 window, issue
. db2 get dbm cfg | more
. ...and look for value of SPM_NAME
3) confirmed that SPM_NAME was the hostname (that contains a dash)
4) from DB2 window, issue
. db2 update dbm cfg using SPM_NAME newname (a name with no dashes)
5) go to Services menu and STOP and START the DB2-DB2 service
6) delete workflow configuration and drop the databases created
. for workflow
7) define new configuration (using the userid created
. called "MQSERIES" for the Workflow administration)
8) start the Workflow Service
Changing the SPM_NAME parameter in DB2 fixed the problem with the
workflow database/configuration errors.
|
Venny |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Dec 05, 2002 2:43 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
|
| Back to top |
|
|
| vennela |
| Posted: Thu Dec 05, 2002 4:47 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Did you check what your SPM_NAME is set to in database configuration
See my previous post about how to do this. May be your version is 7-1. But what's your hostname. It says if your host name contains dashes (-) then it might not work.
Can't go anywhere from here
---
venny |
|
| Back to top |
|
|
| mkhadse |
| Posted: Fri Dec 06, 2002 6:59 am Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Yes I checked there are only alphabetical characters no hyphen. I think I will have to get to IBM for support.
Thanks for your help. |
|
| Back to top |
|
|
|
|
