Conversation body not displayed after database migration (From MSSQL to Postgres)

Conversation body not displayed after database migration (From MSSQL to Postgres)

Hi, 

We've just completed a migration of two instances of SDP from our datacenter to AWS. 

In that process we update both installations from version 9.4 to 14.2 and in one of them, the database was migrated from MsSQL to PostgreSQL.

Just in that instance we have a problem whit old conversations. In that conversations, from august 2022 backwards, we are only able to view the title of the conversation, not the body.

August 2022 and above conversations are OK. It's strange because it have no relation with the database migration date, which was on february 2023.

I have observed in the database that the content of the body its actually in the tables (in fact, as a workaround, we are reading old items with a query report), but it is not user friendly so that it would be necessary to recover the old conversations as usual.

I suposse it is a database migration fault because on the other instance we've followed the same way (Export database - clean instalation on AWS - import database - update from 9.4 to 14.2) but in that case, there was no database conversion and there is all fine.

Is it any way to recover that?

Many thanks in advance.

                  New to ADSelfService Plus?