Symptoms:  

If you use an Oracle Database and you receive a “ORA-01002: fetch out of sequence” filtering errorwe have a solution for it.

Resolution:  

For WorldServer 10.4.4 and 10.4.5, you can fix this issue by deploying the update to WorldServer 10.4.4 or 10.4.5, available on FTP.

For WorldServer 11.1.0 and 11.1.1, do the following:

  1. Make sure that you have an appropriate version of the File Type Support (FTS) Server installed. For WorldServer 11.1.0, you need to have at least Cumulative Update 3 or later of FTS 11.1.0. For WorldServer 11.1.1, you can have any version of FTS 11.1.1.
  2. Stop FTS.
  3. Go to the directory where FTS was installed and open the “Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config” file with a text editor.
  4. Search for “connectionString”.
  5. In the line referring to Oracle databases, add the following text at the end of the connectionString attribute: ConnectionReset=true. The line should now have the following structure: <add name="SystemDb" connectionString="Host=host;SID=wsdb;Port=1521;User Id=user;Password=abc;ConnectionReset=true" providerName="DDTek.Oracle"/>
  6. Start FTS.

If you cannot deploy this fix, contact the SDL Support Team:

  •     Log on to your "My SDL" Account.
  •     Log a support request via Support & Education Support

Notes: 

  • All systems running WorldServer 10.4.4 to 11.1.1 and using an Oracle database should have this hotfix applied.
  • The fix for this issue is also available in WS 11.2. Please make sure you add ConnectionReset=true for the existing connections.
Anonymous