Author |
Topic  |
|
psudhakar999
Starting Member
India
4 Posts |
Posted - 08/20/2011 : 14:53:27
|
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
|
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
|
 |
|
psudhakar999
Starting Member
India
4 Posts |
Posted - 08/21/2011 : 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 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 |
 |
|
sunitabeck
Flowing Fount of Yak Knowledge
5155 Posts |
Posted - 08/21/2011 : 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_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
|
 |
|
psudhakar999
Starting Member
India
4 Posts |
Posted - 08/22/2011 : 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_ 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 |
 |
|
psudhakar999
Starting Member
India
4 Posts |
Posted - 08/24/2011 : 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)\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 |
 |
|
tk.pal
Starting Member
India
2 Posts |
Posted - 12/30/2012 : 10:29:05
|
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 |
 |
|
tk.pal
Starting Member
India
2 Posts |
Posted - 12/30/2012 : 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 Perpose India 09832671771
Thank you
T.Pal
T.Pal |
 |
|
|
Topic  |
|
|
|