Where is the MESSAGE field for the data sync policies?

Hi. I´m running Sentinel 8.2.2 and I´m creating the data synchronization policies for databases to be used for reporting services. Everything is fine, but I can´t seem to find the message field in the field mapping. Curious thing is: the field is there, I can see it and see the values of it in the default search for instance. Why can´t I map it for the data sync? Any thougnts? All other default fields are there.

 

Parents
  • Just to update... if I create a new table natively through Sentinel, the MSG field is there as expected. If the table already exists in the database, I´m still not able to add the MSG field.

    Now, let´s discuss about this scenario: customer had data sync policies up and running fine (including the MSG field) and then they need to upgrade Sentinel, but they want to keep their database which already has historic data. So Sentinel gets upgraded and the database is still the same (and supported). I add new data sync policies to the new Sentinel and connect to the old database in order to keep the historic data and also keep doing data sync for the fresh data. And I cannot include the MSG field because the table already exists. The only way I can add this field is having Sentinel create the table.

    Any thoughts or different experiences?

Reply
  • Just to update... if I create a new table natively through Sentinel, the MSG field is there as expected. If the table already exists in the database, I´m still not able to add the MSG field.

    Now, let´s discuss about this scenario: customer had data sync policies up and running fine (including the MSG field) and then they need to upgrade Sentinel, but they want to keep their database which already has historic data. So Sentinel gets upgraded and the database is still the same (and supported). I add new data sync policies to the new Sentinel and connect to the old database in order to keep the historic data and also keep doing data sync for the fresh data. And I cannot include the MSG field because the table already exists. The only way I can add this field is having Sentinel create the table.

    Any thoughts or different experiences?

Children