Developer forum

Forum » Integration » Server Collation Issue when running the batch job

Server Collation Issue when running the batch job

E-mail notifications
Thaw Htun Lynn
Reply
Posted on 16/05/2016 07:47:34

Hi,

We are configuring the Dynamicweb CMS integration solution with NAV for a client. In our development server, we hvae NAV database and Dynamicweb database installed in the same SQL instance but we didnt' face any issue. The db collation setting in development server is as below.

1. TempDb - SQL_Latin1_General_CP1_CI_AS

2. ModalDb - SQL_Latin1_General_CP1_CI_AS

3. NAV DB - Latin1_General_100_CS_AS

4. Dynamicweb - Latin1_General_CI_AS

 

When we move the solution from development to UAT (will be promoted to Live after UAT) server, we face the issues in batch jobs as below. 

[dbo.EcomManufacturersTempTableForBulkImport] to main table [dbo.EcomManufacturers]. Exception: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation.

Our database collation configuration setting is as below.

1. TempDb - Latin1_General_100_CS_AS

2. ModalDb - Latin1_General_100_CS_AS

3. NAV DB - Latin1_General_100_CS_AS

4. Dynamicweb - Latin1_General_CI_AS

What could be the best solution for us to move forward to make both the application working on the same SQL instant.

 

Best Regards,

Thaw


Replies

 
Nicolai Høeg Pedersen
Posted on 16/05/2016 10:06:21
Reply
This post has been marked as an answer

You should be able to change the DW db to be CS - it could of course have an impact on some minor things, but I do not think it will. I don't know if you can simply change the tempdb to CI instead...

Votes for this answer: 1
 
Thaw Htun Lynn
Posted on 16/05/2016 11:26:49
Reply

Hi Nicolai,

Yes. I did create the DB with CS collation but hit with errors because some query in application doesn't follow case sensitive names. I am not able to open up front-end or admin site if we use CS. 

I've asked the NAV team to change the tempdb to CI but also there is some issue in NAV side and they need to evaluate the functions and error again.

Regards,

Thaw

 

You must be logged in to post in the forum