MQSeries.net :: View topic - [solved]fmczbstr problem using oracle 9.2.0.6

pa3gxn

When trying to create the database tables with fmczutil I manage to create the tables but initialization of the database fails.
I get the following error:
FMC33130I Initializing the database.
FMC33003I fmczbstr -gFMCZG -sFMCOZG1 -xCPL0 -dOZG1 -uuser_fmc
FMC24500I fmczbstr is starting.
FMC25110E Module /projects/fmc/drv2/lbld/v350/aix/src/fmczbstr.cxx FmcBootstrapUtility::InitializeDB(FmcString &) 758 UnKnownException(): Action: Create Type: SystemGroup Key: : .
FMC24560I fmczbstr finished and found 1 errors 0 warnings. RC = 20
FMC33149E Return code from Bootstrap is: 20

I'm using a local db and character-conversion as suggested on the IBM site works fine.

I hope anyone can help me with this problem
thx
Frans

The problem was situated in the character conversion of Workflow.
You have to set the Oracle setting to the correct character set, the one workflow expects.
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
The character set of the database doesn't matter.
Oracle (SQLnet*) will do the character conversion for you.