Hello Michael,
The reason behind is that i made a migration from IBM Case Manager to IBM BAW using External CPE & NAV by keeping the same DB SCHEMAS but wiith other names like (OSDES schema will be OSDESTST) so after finishing the installation i try to access to the objectstores using ACCE i got a message which contains a sqlqquery (select.. from OSDES) it's like ACCE trying to get the data from the old schema so to resolve this problem i try to edit the schemaDatabase property in Acce but with no sucess because i still got the same message error and for that i said why not changing the schema name in the blob of FNGCD, That's all.
Best regards,
Adil
------------------------------
Adil EL FARGOUNI
------------------------------
Original Message:
Sent: Wed March 22, 2023 05:04 AM
From: Michael Kirchner
Subject: BAW migration / Opening FNGCD Table
Hi Adil EL FARGOUNI,
would you be so kind to explain a bit why you want to modify the GCD blobs?
I agree with Ankits opinion that most of the settings in the GCD can be modified using ACCE (and thus is controlled by the API). Any direct manipulation of the GCD blobs may cause serious issues and thus it's normally only perfomed by IBM expert labs or in very close teaming with the IBM support team.
Best regards,
Michael
------------------------------
Michael Kirchner
Sr. Business Automation Partner Technical Specialist
IBM Technology
Germany
Original Message:
Sent: Mon March 13, 2023 03:44 AM
From: Adil EL FARGOUNI
Subject: BAW migration / Opening FNGCD Table
Thank you Steve i really appreciate your help.
I have already ask the support for the gcdutil but it seems i must make a L2 PMR so im still waiting for the return.
------------------------------
Adil EL FARGOUNI
Original Message:
Sent: Mon March 13, 2023 03:36 AM
From: Steve Lonmo
Subject: BAW migration / Opening FNGCD Table
The data is encrypted with "zlib". I've used a program called "ip tools" to do it. But it no longer seems to be available (it was available at http://erwan.l.free.fr, but that site doesn't seem to exist anymore)
Perhaps there is something at https://www.zlib.net/?
If you have official support from IBM you might be able to persuade them to let you have the in-house "gcdutil" program (version 5.5.x, not earlier) which auto decrypts/encrypts the gcd blob to/from an xml file.
------------------------------
Steve Lonmo
Original Message:
Sent: Fri March 10, 2023 04:40 AM
From: Adil EL FARGOUNI
Subject: BAW migration / Opening FNGCD Table
Hello All,
Is there a way to decyrpt the GCD_BLOB of FNGCD Table's.
I really appreciate your help.
Thanks,
Adil
------------------------------
Adil EL FARGOUNI
------------------------------