SA Developer .NET

Welcome to SA Developer .NET Sign in | Join | Help
in Search

Issue with reporting services

Last post 11-28-2008, 21:56 by sandeep. 7 replies.
Sort Posts: Previous Next
  •  11-27-2008, 17:43 15907

    Issue with reporting services

    Hi All,
     Its been 2 weeks i am facing this issue.
    I have sql server 2005 with Reporting services on Windows server 2003 64 bit machine.
    I have configured the dashboard and its working .Sometimes it showing generated report with no issues
    But 9 out of 10 i am getting error when wants to see the reports when i checked the log files
    at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles below error is displaying

    11/27/08 10:31:22, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 3096
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x20154C3C
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x00000000
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x00000000
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
    11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
    11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
    11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0153.mdmp
    11/27/08 10:31:29, ACTION,                  w3wp.exe, Watson Invoke: No
     
    Again in event view for Application application below error is coming

    Event Type: Error
    Event Source: Windows Search Service
    Event Category: Gatherer
    Event ID: 3083
    Date:  11/27/2008
    Time:  10:32:13 AM
    User:  N/A
    Computer: CIGSCMMETRIC01
    Description:
    The protocol handler Search.Mapi2Handler.1 cannot be loaded. Error description: Class not registered.
    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.

    Please can anyone help me


    If you want something you never had,
    do something you have never done!
  •  11-27-2008, 21:27 15909 in reply to 15907

    Re: Issue with reporting services

    Do any of these help? (all turned up by googling the error message)

    http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=938119&SiteID=1

    https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1797158&SiteID=1

    https://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PageID=1&PostID=938119

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windowsupdate&tid=9b5af08d-a6d8-4a8a-991a-c90ab3bffeb1&cat=en_US_56d1dd45-de9e-4fc5-9bc1-2d1d0de6daee&lang=en&cr=US&sloc=&p=1

     


    Gail Shaw - SQL In the Wild
    SQL Server MVP
    --
    Chaos, panic and disorder. My job here is done!
  •  11-28-2008, 0:47 15910 in reply to 15909

    Re: Issue with reporting services

    Thanks for reply Gila,

    But my main issue is first error

    ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

    this is causing application to stop


    If you want something you never had,
    do something you have never done!
  •  11-28-2008, 1:06 15911 in reply to 15910

    Re: Issue with reporting services

    Try these:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307844&SiteID=1

    http://www.manning-sandbox.com/thread.jspa?messageID=49781

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=463047&SiteID=1

    http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/36522/Fatal-exception-error-in-MSSQL2005-SP1

    http://forums.asp.net/p/1275119/2427187.aspx

    What's the version of SQL 2005/SSRS 2005? 32 bit or 64 bit?


    Gail Shaw - SQL In the Wild
    SQL Server MVP
    --
    Chaos, panic and disorder. My job here is done!
  •  11-28-2008, 1:27 15912 in reply to 15911

    Re: Issue with reporting services

    SQL server 2005 and SSRS  is 32 bit


    If you want something you never had,
    do something you have never done!
  •  11-28-2008, 9:16 15914 in reply to 15912

    Re: Issue with reporting services

    What patch/hotfix level?

    A lot of those articles reference a hotfix that fixed the issue. Maybe have a look and see if you've got that fix on?


    Gail Shaw - SQL In the Wild
    SQL Server MVP
    --
    Chaos, panic and disorder. My job here is done!
  •  11-28-2008, 13:52 15929 in reply to 15914

    Re: Issue with reporting services

    had the same problem.

    found out that auto update ahad installed a sql patch (kb948109)

    i removed it and everything started working again.


    You cannot make anything fool-proof... Fools are too inventive

    http://dotnet.org.za/doubleJ
  •  11-28-2008, 21:56 15937 in reply to 15929

    Re: Issue with reporting services

    Now really saying i forgot all the hot fixes and patches i have installed
    Its quite confusing as some guys are saying to install SP2 and some are saying because of that one only they were getting these issues ?

    I have SP2 in my machine ..
    Again I have installed the hot fixes from below url http://support.microsoft.com/default.aspx/kb/949095/en-us

    Main issue is that its working but in between it is giving these errors
    the frequencu of these errors increases along the time :(

     


    If you want something you never had,
    do something you have never done!
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems