GP error after running utilities

(0) Share

Report

Posted on by Romryan

I am getting this error whenever I do any GP client installation.This comes up when running utilities.When I did an in depth checking I found that all GP related databases(Dynamics and Company ones) have sql collation(Latin1_General_CI_AS) different from system databases (master,msdb,tempdb and model) that have SQL_Latin1_General_CP1_CI_AS.

Kindly help

RomRyan

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

These are the two sql collation sequences that are supported by GP.

SQL_Latin1_General_CP1_CI_AS

Latin1_General_BIN

If your GP databases are indeed using the Latin1_General_CI_AS collation sequence you are going to need to convert these databases to one of the two listed. I have always used the bulk-copy method but there are other ways. Essentially you have to export out the entire database to text file, create a new database with the correct collation sequence and then import the data back in.

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

Thanks Richard,

Kindly please give me the links that can guide me on this.

RomRyan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The same subject which is discussed in another thread. Refer the link:

community.dynamics.com/.../33858.aspx

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

How new are the databases? Is this a new installation? A test migration? What is the status of the data?

Unfortunately I have to agree with Richard on this one - you have no choice but to move the data.

If this is a new installation and you are just in the process of building the system for the first time - I would suggest that you consider either of (1) completely new installation of SQL with the correct collation or (2) create a new instance on the same SQL Server installation and make sure it is the correct collation.

Hope this helps.

Was this reply helpful? Yes No