November 3, 2008 at 12:23 pm
I'm trying to use the Fuzzy Lookup transform in SSIS (SQL2k5), and I get the following error when I execute my package when it hits the Fuzzy lookup:
"A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_FuzzyLookupTableMaintenanceInstall"
I noticed in Management Studio that the three system stored procs related to the Fuzzy Lookup MatchIndex maintenance tables (sp_FuzzyLookupTableMaintenanceInstall, sp_FuzzyLookupTableMaintenanceInvoke, sp_FuzzyLookupTableMaintenanceUninstall) all seem to be disabled or locked in the master database. I'm using the SA account when I see this, the three procs show with a "padlock" icon on them in the Object Explorer. The server has Enterprise Edition installed so I would expect these three procs to be enabled. What does the "padlock" icon signify? How can I enable these procs so I can use the Fuzzy Lookup?
Thanks!
May 18, 2010 at 6:59 am
Hi,
any one haas found a solution for this error. I am gettting the folwoogin error when i am trying to update the lookup table
Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInvoke':
System.Data.SqlClient.SqlException: Transaction is not allowed to roll back inside a user defined routine, trigger or aggregate because the transaction is not started in that CLR level. Change application logic to enforce strict transaction nesting.
System.Data.SqlClient.SqlException:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlInternalConnectionSmi.ExecuteTransaction(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Rollback()
at Microsoft.SqlServer.Dts.TxBestMatch.TableMaintenance.TranWrap(DataCleaningOperation c)
at Microsoft.SqlServer.Dts.TxBestMatch.TableMaintenance.ServerInvoke(String etiTableName)
. User transaction, if any, will be rolled back.
The statement has been terminated.
thanks in advance, need tohe solution urgently.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply