After Installing Near Realtime Denorm Application Following Error Occurs (MSSQLServer Database): "Cannot resolve the collation conflict..." (Doc ID 1963454.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.1.1.5 and later
Information in this document applies to any platform.

Goal

After installing the Near Realtime Denorm application from the EP an error appears:
015-01-09 11:28:41 911 - ERROR - Denorm Request for CustomSectionTemplate [Ingegneria (pkid:1020fcc1b0de-3f35-4294-9215-ff14f25af6d3 - denorm_cs_table_id:e47d9d55-c5e4-4bea-b227-e8e40dcb1a78] - ERROR: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.: dbo.DENORM_PROCESS_CS_REQUEST '1020fcc1b0de-3f35-4294-9215-ff14f25af6d3', 0, 1, 0, 'e47d9d55-c5e4-4bea-b227-e8e40dcb1a78', 0 at Xeno.Data.XDataQueryIsolated.executeStoredProcedure(String procedureName, ProcedureArgument[] arguments)
  at Xeno.Prodika.DenormServices.CSDenormRequestQueue.Receive(Object[] targetObject)

What causes this error message?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms