com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'next_previous_links' is unknown.

Configuring Timestamp Conversion for RDBMS

Owned by Former user (Deleted)
Oct 08, 2018
1 min read

Note that the following functionality is only applicable to data integration in WSO2 Enterprise Integrator.

By default, a timestamp is always converted to the UTC time zone before inserting the timestamp data to the database. When retrieving the data, the server will convert the timestamp back to the server's time zone. This can sometimes lead to inconsistencies where the time zones applicable to timestamps (for inserting data and retrieving data) are different. Therefore, you can disable UTC conversion for RDBMSs as follows:

  1. Open the server startup script, which is stored in the <EI_HOME>/bin directory.
    • For Linux: integrator.sh
    • For Windows: integrator.bat 
  2. Set the following property to true: -Ddss.legacy.timezone.mode=true

This configuration ensures that data is entered into RDBMSs using the server time zone without converting to UTC.


com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'next_previous_links2' is unknown.