SQL Server Performance

Error when running report

Discussion in 'SQL Server 2005 Reporting Services' started by DStevensTN, May 1, 2006.

  1. DStevensTN New Member

    I have configured Reporting Services on 2 servers, on one everything runs fine and reports can be generated. On the other, I get the following error when trying to run a report:
    '/' is an unexpected token. The expected token is '='. Line 9, position 33.

    I am not that familiar with Reporting Services so I could have made any mistake.

    Any help is greatly appreciated.

    Below is a warning in the event log
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 5/1/2006 5:16:38 PM
    Event time (UTC): 5/1/2006 10:16:38 PM
    Event ID: ced716f32f8b48f69b1329efffbcebb4
    Event sequence: 76
    Event occurrence: 3
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/root/Reports-3-127909852575625000
    Trust level: RosettaMgr
    Application Virtual Path: /Reports
    Application Path: C:program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManager
    Machine name: MSIDEVSQL

    Process information:
    Process ID: 3656
    Process name: aspnet_wp.exe
    Account name: MSIDEVSQLASPNET

    Exception information:
    Exception type: XmlException
    Exception message: '/' is an unexpected token. The expected token is '='. Line 9, position 33.

    Request information:
    Request URL:http://msidevsql/Reports/Reserved.R...xd?OpType=StyleSheet&Version=2005.090.1399.00
    Request path: /Reports/Reserved.ReportViewerWebControl.axd
    User host address: 10.0.1.80
    User: MNSdstevens
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: MSIDEVSQLASPNET

    Thread information:
    Thread ID: 6
    Thread account name: MSIDEVSQLASPNET
    Is impersonating: True
    Stack trace: at System.Xml.XmlTextReaderImpl.Throw(Exception e)
    at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
    at System.Xml.XmlTextReaderImpl.ThrowUnexpectedToken(String expectedToken1, String expectedToken2)
    at System.Xml.XmlTextReaderImpl.ParseAttributes()
    at System.Xml.XmlTextReaderImpl.ParseElement()
    at System.Xml.XmlTextReaderImpl.ParseElementContent()
    at System.Xml.XmlTextReaderImpl.Read()
    at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
    at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
    at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
    at System.Xml.XmlDocument.Load(XmlReader reader)
    at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
    at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
    at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
    at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
    at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    Custom event details:
  2. DStevensTN New Member

    FYI,
    this is machine is running SQL Server 2005 Database services and Reporting Services, but also 2000 Database.
  3. DStevensTN New Member

    I'm not thrilled with the solution, but I have everything running now. I just recreated the Website under a different name and everything works.

Share This Page