error plz solve its urgent

  • 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

  • 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.

  • 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/

  • 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
  • I would hope that what ever is here: Procedure pPerformanceHistorySecurity, Line 94

    will give us (more importantly you) a clue.

  • 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

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

  • 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

  • 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
  • i got the solution

  • 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]

  • its me

  • 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.

  • 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

  • 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.

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

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