New server - Problem with collation

Kinetic ERP
1

This weekend we are trying to move our on-prem Kinetic onto a new set of servers. I have 1 SQL server, 1 app server and another SQL server that we user for SSRS reporting (Both printing and our own reports). Annoyingly I hadn’t tested printing before as its usually never a problem!

So before starting today I thought I would test printing. Nothing prints and I get this error
—> System.Data.SqlClient.SqlException (0x80131904): Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the UNION operation.
Could not use view or function ‘Ice.ReportStore’ because of binding errors.

I’ve been through all the databases on both servers. None have that Latin1_General_CI_AS collation. Its like its hard coded into Epicor itself

Im stumped now and cant proceed. Anyone got any ideas? No one seems to have posted about it before here or in EpiCare

2

have you looked in the ServerLog for the printing app server to see if can give you any hints?

1 Like
3

Thank Greg, nothing else in even viewer other than the same message

We tracked it down to the new IceCommon database and the ice.ReportStore view. We changed this to force a collation and got it working but I will log this with support anyway as I don’t like making corrections like this and it could be something that can be handled for future versions

1 Like