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:
- Stop the FTS Server.
- 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.
- Search for
connectionString. - In the line referring to Oracle databases, add the following text at the end of the
connectionStringattribute:ConnectionReset=true. - Start the FTS Server.