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 and later
Information in this document applies to any platform.


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?


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

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