IBM Sterling Connect:Direct: Error LTQA032I - database corruption
I had a problem with Connect:Direct for Microsoft Windows that not start
So i enable trace startup parameters in Windows services - Connect:Direct
-ttyp=x -tlvl=f -tfil=d:\\startup_cdtrace.cdt -tfsz=10M
Detailed steps: https://www.ibm.com/support/pages/connectdirect-microsoft-windows-will-not-start
In startup_cdtrace.cdt, I found the following error:
09/29 14:44:31.490849 0000094C MN > cd_error_create 09/29 14:44:31.490849 0000094C MN < cd_error_create: structure allocated at 000000000481DA90 09/29 14:44:31.490849 0000094C MN > cd_error_get 09/29 14:44:31.490849 0000094C MN ARG errhandle: 000000000481DAB0 09/29 14:44:31.490849 0000094C MN ARG errkey : 4 09/29 14:44:31.490849 0000094C MN < | | | | | | | cd_error_get: GET_FIRST_ERROR ok - msgid LTQA032I rc 8, fdbk 0
So the error was:
cd_error_get: GET_FIRST_ERROR ok - msgid LTQA032I rc 8, fdbk 0
After some investigation I found that is a corruption on Database.
My Connect:Direct is version 6.1, so I need to recreate PostgreSQL database.
Steps to Rebuild the Connect:Direct Postgres Database
https://www.ibm.com/support/pages/how-recreate-postgresql-database-connectdirect