error plz solve its urgent

Question

error plz solve its urgent

hbtkp

SSCommitted

Points: 1731
More actions
March 22, 2012 at 2:43 pm

#270539

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

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

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.

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

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/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

I would hope that what ever is here: Procedure pPerformanceHistorySecurity, Line 94

will give us (more importantly you) a clue.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

For an urgent error sure not getting any response from the OP and it has been almost 2 hours.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

hbtkp SSCommitted Points: 1731 More actions · Answer 9

hbtkp

SSCommitted

Points: 1731

March 22, 2012 at 6:45 pm

#1463120

i got the solution

CapnHector SSCoach Points: 16143 More actions · Answer 10

hbtkp (3/22/2012)
i got the solution

you have some curious helpers. what was dont to fix the issue??

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

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]

hbtkp SSCommitted Points: 1731 More actions · Answer 11

hbtkp

SSCommitted

Points: 1731

March 22, 2012 at 7:42 pm

#1463132

its me

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 12

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 14

Sounds to me like the OP decided it was a PEBKAC error.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.