SSRS导出excel报错

0
请教各位大神，我的报表打开展示都没有问题，就是在导出excel的时候等待时间长，再过几分钟就显示报错了，导不出来，请问有什么可以排查解决的思路吗，万分感谢大家！在SharePoint日志里查也没有明确的错误说明。

QQ图片20171102174447.png


360截图20171102174921953.jpg

 
2017-11-02 添加评论
分享

没有找到相关结果

    已邀请:
    0

    GeorgeYao - 路漫漫其修远兮，吾将上下而求索！ 2017-11-03 回答

    这个有可能是访问SP服务器超时，导致报错。
    2017-11-03 1
    分享
    0

    tisdeny1986 2017-11-03 回答

    以下是SP服务器里截取到的log，有大神指导一下吗。
    11/03/2017 10:47:41.35     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Monitoring                        nasq    Medium      Entering monitored scope (Request (GET:http://fibss:80/FIBI/Reserved. ... PENXML))     
    11/03/2017 10:47:41.35     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Logging Correlation Data          xmnv    Medium      Name=Request (GET:http://fibss:80/FIBI/Reserved. ... PENXML)    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.37     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Logging Correlation Data          xmnv    Medium      Site=/    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.38     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Topology                          e5mc    Medium      WcfSendRequest: RemoteAddress: 'http://fibss:32843/457f4536ca4f4aa38ee99faa08647118/ReportExecution.svc' Channel: 'Microsoft.ReportingServices.ServiceContract.IReportExecution' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Execution/GetExecutionInfo' MessageId: 'urn:uuid:d8a4d37e-1655-4c69-82d1-70e8ab45e194'    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.42     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Topology                          e5mb    Medium      WcfReceiveRequest: LocalAddress: 'http://fibss.hold.founder.com:32843/457f4536ca4f4aa38ee99faa08647118/ReportExecution.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Execution/GetExecutionInfo' MessageId: 'urn:uuid:d8a4d37e-1655-4c69-82d1-70e8ab45e194'    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.42     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Monitoring                        nasq    Medium      Entering monitored scope (ExecuteWcfServerOperation)    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.68     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Monitoring                        b4ly    Medium      Leaving Monitored Scope (ExecuteWcfServerOperation). 执行时间=263.571138231256    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.70     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Monitoring                        b4ly    High        Leaving Monitored Scope (ExecuteWcfOperation:http://schemas.microsoft.com/s ... onInfo). 执行时间=322.965628313096    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.71     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Monitoring                        b4ly    High        Leaving Monitored Scope (ExecuteOnApplication:GetExecutionInfo). 执行时间=328.075635311192    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:41.71     w3wp.exe (0x2EA0)                           0x0624    SharePoint Foundation             Topology                          e5mc    Medium      WcfSendRequest: RemoteAddress: 'http://fibss:32843/457f4536ca4f4aa38ee99faa08647118/ReportStreaming.svc' Channel: 'Microsoft.ReportingServices.ServiceContract.IReportStreamingAsyncClient' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Streaming/ProcessStreamRequest' MessageId: 'urn:uuid:bb265dea-9d9f-4c2a-8a55-8c03fabea07e'    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:42.01     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Topology                          e5mb    Medium      WcfReceiveRequest: LocalAddress: 'http://fibss.hold.founder.com:32843/457f4536ca4f4aa38ee99faa08647118/ReportStreaming.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Streaming/ProcessStreamRequest' MessageId: 'urn:uuid:bb265dea-9d9f-4c2a-8a55-8c03fabea07e'    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:42.01     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Monitoring                        nasq    Medium      Entering monitored scope (ExecuteWcfServerOperation)    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:42.02     w3wp.exe (0x24D4)                           0x27C8    SharePoint Foundation             Monitoring                        b4ly    Medium      Leaving Monitored Scope (ExecuteWcfServerOperation). 执行时间=5.34243877364302    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    11/03/2017 10:47:42.12     w3wp.exe (0x24D4)                           0x27C8    SQL Server Reporting Services     Report Server Catalog             0000    Medium      RenderFromSession('http://fibss/FIBI/OperationBI/RPT.OP006.rdl')    e71bfdb5-cf87-40bd-8343-bb9fab811f1b
    2017-11-03 0
    分享
    0

    郑大鹏 2017-11-06 回答

    看看你导出的是 .xls 格式的还是.xlsx格式的
    如果是2007以前版本的话，单个字段的值的字符不能超过35564个字符好像
    行数也不能超过一定的行数
    可以在官网上查一下具体相关信息
    2017-11-06 1
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册