My Oracle Support Banner

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

Last updated on JULY 07, 2021

Applies to:

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

Goal

After installing the Near Realtime Denorm application from the EP an error appears:

ERROR - Denorm Request for CustomSectionTemplate [Ingegneria (pkid:1020fcc1b0de-XXXX-XXXX-XXXX-ff14f25af6d3 - denorm_cs_table_id:e47d9d55-XXXX-XXXX-XXXX-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-XXXX-XXXX-XXXX-ff14f25af6d3', 0, 1, 0, 'e47d9d55-XXXX-XXXX-XXXX-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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.