March 22, 2012 at 2:43 pm
hi,
please solve this error ,its urgent
Msg 6260, Level 16, State 1, Procedure pPerformanceHistorySecurity, Line 94
An error occurred while getting new row from user defined Table Valued Function :
System.ApplicationException: Rep XML: Unexpected attribute 'AccruedFee' - ensure that the correct SQL accounting function is being called
March 22, 2012 at 2:53 pm
Can't help you. We can't see from here what you see there. Please post the code, the whole code and nothing but the code.
March 22, 2012 at 3:08 pm
There is definitely a solution to this problem. The first step in finding your solution will come to you magically when you read the first link in either my signature or Lynn's.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 22, 2012 at 4:03 pm
That actually looks like a custom exception (so one intentionally raised by the code) in a CLR function
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2012 at 4:07 pm
I would hope that what ever is here: Procedure pPerformanceHistorySecurity, Line 94
will give us (more importantly you) a clue.
March 22, 2012 at 4:38 pm
From reading it, I agree that it appears to be a custom error. It also appears that from the error - the file being loaded had an XML attribute that was not supposed to be there.
I'd start looking at the XML that you are trying to load.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 4:40 pm
For an urgent error sure not getting any response from the OP and it has been almost 2 hours.
March 22, 2012 at 4:45 pm
Lynn Pettis (3/22/2012)
For an urgent error sure not getting any response from the OP and it has been almost 2 hours.
Well, maybe they are fixing it currently and will get back later.;-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 5:23 pm
Lynn Pettis (3/22/2012)
For an urgent error sure not getting any response from the OP and it has been almost 2 hours.
Urgent = 'My problem's more important than any other here'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2012 at 6:45 pm
i got the solution
March 22, 2012 at 7:00 pm
hbtkp (3/22/2012)
i got the solution
you have some curious helpers. what was dont to fix the issue??
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 7:42 pm
its me
March 22, 2012 at 8:40 pm
hbtkp (3/22/2012)
its me
Not what he meant. Forum etiquette says that if you solve your problem you need to post your solution.
March 23, 2012 at 1:07 am
Please do tell what was done to fix the error.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 23, 2012 at 5:14 am
Sounds to me like the OP decided it was a PEBKAC error.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply