SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Cannot resolve the collation conflict between "Lat
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

psudhakar999
Starting Member

India
4 Posts

Posted - 08/20/2011 :  14:53:27  Show Profile  Reply with Quote
Message: HandlingInstanceID: 779adf9f-74a4-49c1-ba34-606754326db0
An exception of type 'System.Reflection.TargetInvocationException' occurred and was caught.
-------------------------------------------------------------------------------------------
08/20/2011 11:26:26
Type : System.Reflection.TargetInvocationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
Source : System
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : Void RaiseExceptionIfNecessary()
Stack Trace : at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at System.ComponentModel.RunWorkerCompletedEventArgs.get_Result()
at India.Gov.UIDAI.EC.EnrolmentClient.Controls.Enrolment.DemographicControl.bgPinCodeWorker_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)

Additional Info:

MachineName : ADMIN-PC
TimeStamp : 20/08/2011 5:56:26 AM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
AppDomainName : UID.EnrolmentClient.exe
ThreadIdentity :
WindowsIdentity : admin-PC\admin
Inner Exception
---------------
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 16
LineNumber : 1
Number : 468
Procedure :
Server : (local)\SQLEXPRESS
State : 9
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)
at India.Gov.UIDAI.EC.DataAccess.Config.PinCodeDALC.FindVTC(Int32 pincode, PostalAddressElement state, PostalAddressElement district)
at India.Gov.UIDAI.EC.DomainManager.Config.PincodeDAO.FindVTC(Int32 pincode, PostalAddressElement state, PostalAddressElement district)
at India.Gov.UIDAI.EC.Controller.EnrollmentController.FindVTC(Int32 pinCode, PostalAddressElement state, PostalAddressElement district)
at India.Gov.UIDAI.EC.EnrolmentClient.Controls.Enrolment.DemographicControl.FillStateAndDistrictData(String pinCodeText)
at India.Gov.UIDAI.EC.EnrolmentClient.Controls.Enrolment.DemographicControl.bgPinCodeWorker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)


Category: UID Exceptions
Priority: 1
Severity: Error
Process Id: 3324
Process Name: C:\Program Files\UID Authority of India\Aadhaar Enrolment Client\UID.EnrolmentClient.exe
Extended Properties: HandlingInstanceID: 779adf9f-74a4-49c1-ba34-606754326db0
An exception of type 'System.Reflection.TargetInvocationException' occurred and was caught.

Sudhakar P

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 08/20/2011 :  15:12:46  Show Profile  Reply with Quote
The error message seems to indicate that you have a query which tries to UNION two sets of data that have different collations. Change your query to force the collation before you do the union. Something like this:
select col1 collate SQL_Latin1_General_CP1_CI_AS from YourTable1
union
select col2 collate SQL_Latin1_General_CP1_CI_AS from YourTable2
Go to Top of Page

psudhakar999
Starting Member

India
4 Posts

Posted - 08/21/2011 :  06:14:46  Show Profile  Reply with Quote
HI Sunita thanks for your reply someone from HO logged into same system they executed below commands and problem fixed can u suggest me a step by step guide for same

sqlcmd -s (local)\SQLEXPRESS

SELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollation
go

SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC')
go

SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC_Add')
go

ALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_General_CP1_CI_AS
go

Please guide i have same problem in another 5 systems If u want to i will give teamviewer connection my email psudhakar999@gmail.com contact 9701999102

If i am trying to do same it shows 'RC_VTC_Add')
object not available

Sudhakar P
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 08/21/2011 :  08:01:25  Show Profile  Reply with Quote
What HO did is sort of self-explanatory. They changed the collation of those columns that were different from the collation of the database. I assume you are allowed to do the same to your databases.

Depending on the collations and your data, you want to be careful that you don't lose some information when you change the collation. In your case, it doesn't look like you will have any issues based on the error message.

Here is their code with my comments on what I think they were trying to do. You will need to adapt it to your systems/databases/tables.
-- This command connects you to the database server. You will need to replace the 
-- "(local)\SQLEXPRESS" with the correct server name (or log on the server and run 
-- the commands from there). Alternatively, you can connect to the server using
-- SQL Server Management Studio.
sqlcmd -s (local)\SQLEXPRESS 

-- Look up the collation property of the Database. They probably found that it is
-- SQL_Latin1_General_CP1_CI_AS
SELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollation
go

-- Look up the collation for each column in the 'RC_VTC' table. They probably found that
-- the collation of all columns is the same as that of the database.
SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC')
go

-- Look up the collation for each column in the 'RC_VTC_Add' table. They probably found that
-- the collation of six columns is different from the collation of the database.
SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC_Add')
go

-- The six alter table statements below changes the collation of each of those
-- columns to match that of the database.
ALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_General_CP1_CI_AS
go
Go to Top of Page

psudhakar999
Starting Member

India
4 Posts

Posted - 08/22/2011 :  05:00:01  Show Profile  Reply with Quote
At below step i get this Error

1> ALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_
AS
2> go
Msg 4902, Level 16, State 1, Server ADMIN-PC\SQLEXPRESS, Line 1
Cannot find the object "RC_VTC_Add" because it does not exist or you do not have
permissions.
1>

Sudhakar P
Go to Top of Page

psudhakar999
Starting Member

India
4 Posts

Posted - 08/24/2011 :  01:54:46  Show Profile  Reply with Quote
Hi Sunitha,

Below was the process we have followed and problem was fixed can we give script to do same automatically

C:\Users\admin>sqlcmd -s (local)\SQLEXPRESS

1>SELECT DATABASEPROPERTYEX('AADHAAREnrolmentClient', 'Collation') SQLCollation; (Press Enter)
2>go (Press Enter)

<1 rows affected>
1>SELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollation; (Press Enter)
2>go (Press Enter)

<1 rows affected>
1>use AADHAARMasterData (Press Enter)
2>go (Press Enter)
Changed database context to 'AADHAARMasterData'.
1>collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC') (Press Enter)
2>go (Press Enter)

(3 rows affected)
1>SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC_Add') (Press Enter)
2>go (Press Enter)


(6 rows affected)
1> ALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) COLLATE SQL_Latin1
_General_CP1_CI_AS (Press Enter)
2> go (Press Enter)


1> ALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Lat
in1_General_CP1_CI_AS (Press Enter)
2> go (Press Enter)


1> ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_G
eneral_CP1_CI_AS (Press Enter)
2> go (Press Enter)


1> ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_
General_CP1_CI_AS (Press Enter)
2> go (Press Enter)


1> ALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_Gen
eral_CP1_CI_AS (Press Enter)
2> go (Press Enter)
1> exit




Sudhakar P
Go to Top of Page

tk.pal
Starting Member

India
2 Posts

Posted - 12/30/2012 :  10:29:05  Show Profile  Reply with Quote
Aadhaar software problem, export time hang my aadhaar software .No virus detected my computer. Pls help me ...


Team viewer connecting Perpose
India 09832671771

Thank you


T.Pal
Go to Top of Page

tk.pal
Starting Member

India
2 Posts

Posted - 12/30/2012 :  10:54:48  Show Profile  Reply with Quote
quote:
Originally posted by tk.pal

Aadhaar software problem, export time hang my aadhaar software .No virus detected my computer. Pls help me ...


English week so problem not understood to u .




Team viewer connecting Perpose
India 09832671771

Thank you


T.Pal



T.Pal
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000