FTS Server configurations for Oracle databases

If your FTS Server instance is connected to an Oracle database, you need to make certain configurations to avoid ORA-01002: fetch out of sequence messages when the FTS Server processes your assets.

After installing the FTS Server, do the following:

  1. Stop the FTS Server.
  2. Go to the directory where the FTS Server was installed and open the Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config file with a text editor.
  3. Search for connectionString.
  4. In the line referring to Oracle databases, add the following text at the end of the connectionString attribute: ConnectionReset=true.
  5. Start the FTS Server.