Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
psudhakar999
Starting Member
4 Posts |
Posted - 2011-08-20 : 14:53:27
|
Message: HandlingInstanceID: 779adf9f-74a4-49c1-ba34-606754326db0An exception of type 'System.Reflection.TargetInvocationException' occurred and was caught.-------------------------------------------------------------------------------------------08/20/2011 11:26:26Type : System.Reflection.TargetInvocationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Message : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.Source : SystemHelp link : Data : System.Collections.ListDictionaryInternalTargetSite : 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-PCTimeStamp : 20/08/2011 5:56:26 AMFullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35AppDomainName : UID.EnrolmentClient.exeThreadIdentity : 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 ExceptionsPriority: 1Severity: ErrorProcess Id: 3324Process Name: C:\Program Files\UID Authority of India\Aadhaar Enrolment Client\UID.EnrolmentClient.exeExtended Properties: HandlingInstanceID: 779adf9f-74a4-49c1-ba34-606754326db0An exception of type 'System.Reflection.TargetInvocationException' occurred and was caught.Sudhakar P |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-20 : 15:12:46
|
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 YourTable1unionselect col2 collate SQL_Latin1_General_CP1_CI_AS from YourTable2 |
|
|
psudhakar999
Starting Member
4 Posts |
Posted - 2011-08-21 : 06:14:46
|
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 samesqlcmd -s (local)\SQLEXPRESS SELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollationgoSELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC')goSELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC_Add')goALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_General_CP1_CI_ASgoPlease guide i have same problem in another 5 systems If u want to i will give teamviewer connection my email psudhakar999@gmail.com contact 9701999102If i am trying to do same it shows 'RC_VTC_Add')object not availableSudhakar P |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-21 : 08:01:25
|
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_ASSELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollationgo-- 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_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_General_CP1_CI_ASgoALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_General_CP1_CI_ASgo |
|
|
psudhakar999
Starting Member
4 Posts |
Posted - 2011-08-22 : 05:00:01
|
At below step i get this Error 1> ALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_AS2> goMsg 4902, Level 16, State 1, Server ADMIN-PC\SQLEXPRESS, Line 1Cannot find the object "RC_VTC_Add" because it does not exist or you do not have permissions.1>Sudhakar P |
|
|
psudhakar999
Starting Member
4 Posts |
Posted - 2011-08-24 : 01:54:46
|
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)\SQLEXPRESS1>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_Latin1_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_General_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_General_CP1_CI_AS (Press Enter)2> go (Press Enter)1> exitSudhakar P |
|
|
tk.pal
Starting Member
2 Posts |
Posted - 2012-12-30 : 10:29:05
|
Aadhaar software problem, export time hang my aadhaar software .No virus detected my computer. Pls help me ...Team viewer connecting PerposeIndia 09832671771Thank youT.Pal |
|
|
tk.pal
Starting Member
2 Posts |
Posted - 2012-12-30 : 10:54:48
|
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 PerposeIndia 09832671771Thank youT.Pal
T.Pal |
|
|
|
|
|
|
|