April 16, 2013 at 10:16 am
I am receiving the following error when attempting to Insert new rows into a table. The table has Computed fields using DoubleMetaphoneResult(). What causes this error?
Msg 6522, Level 16, State 2, Line 49
A .NET Framework error occurred during execution of user defined routine or aggregate 'DoubleMetaphoneEncode':
System.NullReferenceException: Object reference not set to an instance of an object.
System.NullReferenceException:
at Phonetic.Tools.DoubleMetaphone.IsSlavoGermanic(String _RawText)
at Phonetic.Tools.DoubleMetaphone.DoubleMetaphoneEncode(String RawText)
April 16, 2013 at 10:20 am
Your computed column is calling a CLR implementation of the DoubleMetaphone phonetic algorithm. This isn't a SQL error as such.
What's the word(s) it's failing on?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
April 16, 2013 at 10:27 am
Thanks for the additional explanation. A "null" value was causing the error.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply