asked on

2 different Event 108 errors on both SSRS 2005 and 2008

I've analyzed the servers we are using for SSRS 2005 and 2008 and we discovered a small issue, though I can't seem to find what the cause is as it isn't affecting anything that we can find. In the eventlog, after a subscription is run(copying to a file folder on another server), an even id 108 shows up. Not exactly at the same time. Sometimes it is hours apart it appears. the errors are below:

Event Type:      Error
Event Source:      Report Server (MSSQLSERVER)
Event Category:      Extension
Event ID:      108
Date:            10/28/2008
Time:            4:35:17 PM
User:            N/A
Computer:      servername
Description:
Report Server (MSSQLSERVER) cannot load the TERADATA extension.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type:      Error
Event Source:      Report Server (MSSQLSERVER)
Event Category:      Extension
Event ID:      108
Date:            10/28/2008
Time:            3:00:05 PM
User:            N/A
Computer:      ServerName
Description:
Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any help would be appreciated. We want to move to just using 2008 for obvious reasons as it is better, but until even this small issue is resolved, it won't get approved for production. We are not using TERADATA at all, so I'm not sure why we're even getting that error. And finding any erorr messages or info on SSRS2008 online like google is like pulling teeth.

ASKER CERTIFIED SOLUTION

Medassurant

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jbattley

Which config file are you referring to? I'm only getting the "Report Server (MSSQLSERVER) cannot load the TERADATA extension" without the DocumentLibrary error. I get this error once a day. Can you tell me how to locate the config file?

Medassurant

ASKER

rsreportserver.config file should be located under the ReportServer folder in your MSSQL folder under Program Files.

jbattley

I scanned by rsreportserver.config file and didn't locate the DocumentLibrary Extension. Below is a copy of this file. Can you please provide a recommended solution? Thank you!

<Configuration>
      <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAKxo3f3hnA0CIMbjAvEEtIQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAEu9Cx9t7TzLFQ7NsH4xT9YAAAAA
BIAAAKAAAAAQAAAA1i3rq/0E5hHP+7nBFfRIzyABAAAF6AdTdDAu5jbgJXPjprwtEUqm6bvuvik6
9XIn0LSzJv/bVOnLr9+1EjZtvKRoufgBUEMWrxiwBQWQ4rrneB0s2DBik1s4JyJ1srl6qfAxpguh
k/zi53ngnW5r+P+W2EgadUmfM7E9ba4eSUWLw7chpvPhwyqSP/eykx2swMP5i7SwNx2rnk29A5Zf
vL3okCWYzKRkHnlYFayCJViOP1OzOj4eB7PyNY+Hi2fzTfpPgaT8q8quT5qORY7CAa1mRz0dyEZz
g43/56KV5p9rEFgrb1tcS0exf0Tk8pkbH9HKzb4hs7V2QZR5o7ExGEBPmERGAUeWstgvBrBa/YMk
h/4PA7Ox+iHErdlowjxTUxHSryTe+ZHHYKEO6EuFttXnSTIUAAAA0a4sOENqdj+MMz154j4sh6vo
33g=</Dsn>
      <ConnectionType>Default</ConnectionType>
      <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAKxo3f3hnA0CIMbjAvEEtIQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFspZHQaZsjaY1kkDz1ecPcAAAAA
BIAAAKAAAAAQAAAADLlSASv/MvVA0rB+6VyoXggAAADaqX8g0jdv9RQAAACFM65fyulX9VhSe/Mk
hViHZWSCmQ==</LogonUser>
      <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAKxo3f3hnA0CIMbjAvEEtIQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAKnNKp0UpuQLpaBoO3XQTksAAAAA
BIAAAKAAAAAQAAAAvGBKABN0NESLNsco0pLOHQgAAAC8sQz4FVJl/RQAAABqMR0DpjhS/GK2Mr7r
iUTyTvOFFg==</LogonDomain>
      <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAKxo3f3hnA0CIMbjAvEEtIQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAANAqb+YPg8wFu7wPHfZP3KEAAAAA
BIAAAKAAAAAQAAAA6Y3QOJcJejKNkPAlS/EfTAgAAAC4kyxJckkShhQAAACNFJ3QKn5q5lPlwtCm
Z0gro3bP7w==</LogonCred>
      <InstanceId>MSSQL.1</InstanceId>
      <InstallationID>{14727501-dfc0-48c5-aba6-df453f2ddfb5}</InstallationID>
      <Add Key="SecureConnectionLevel" Value="0"/>
      <Add Key="InstanceName" Value="MSSQLSERVER"/>
      <Add Key="ProcessRecycleOptions" Value="0"/>
      <Add Key="CleanupCycleMinutes" Value="10"/>
      <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
      <Add Key="MaxActiveReqForOneUser" Value="20"/>
      <Add Key="DatabaseQueryTimeout" Value="120"/>
      <Add Key="RunningRequestsScavengerCycle" Value="60"/>
      <Add Key="RunningRequestsDbCycle" Value="60"/>
      <Add Key="RunningRequestsAge" Value="30"/>
      <Add Key="MaxScheduleWait" Value="5"/>
      <Add Key="DisplayErrorLink" Value="true"/>
      <Service>
            <IsSchedulingService>True</IsSchedulingService>
            <IsNotificationService>True</IsNotificationService>
            <IsEventService>True</IsEventService>
            <PollingInterval>10</PollingInterval>
            <MemoryLimit>60</MemoryLimit>
            <RecycleTime>720</RecycleTime>
            <MaximumMemoryLimit>80</MaximumMemoryLimit>
            <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
            <MaxQueueThreads>0</MaxQueueThreads>
            <UrlRoot>http://MERCURY/ReportServer</UrlRoot>
            <UnattendedExecutionAccount>
                  <UserName></UserName>
                  <Password></Password>
                  <Domain></Domain>
            </UnattendedExecutionAccount>
            <PolicyLevel>rssrvpolicy.config</PolicyLevel>
      </Service>
      <Extensions>
            <Delivery>
                  <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
                        <MaxRetries>3</MaxRetries>
                        <SecondsBeforeRetry>900</SecondsBeforeRetry>
                        <Configuration>
                              <FileShareConfiguration>
                                    <ExcludedRenderFormats>
                                          <RenderingExtension>HTMLOWC</RenderingExtension>
                                          <RenderingExtension>NULL</RenderingExtension>
                                    </ExcludedRenderFormats>
                              </FileShareConfiguration>
                        </Configuration>
                  </Extension>
                  <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
                        <MaxRetries>3</MaxRetries>
                        <SecondsBeforeRetry>900</SecondsBeforeRetry>
                        <Configuration>
                              <RSEmailDPConfiguration>
                                    <SMTPServer></SMTPServer>
                                    <SMTPServerPort></SMTPServerPort>
                                    <SMTPAccountName></SMTPAccountName>
                                    <SMTPConnectionTimeout></SMTPConnectionTimeout>
                                    <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
                                    <SMTPUseSSL></SMTPUseSSL>
                                    <SendUsing></SendUsing>
                                    <SMTPAuthenticate></SMTPAuthenticate>
                                    <From></From>
                                    <EmbeddedRenderFormats>
                                          <RenderingExtension>MHTML</RenderingExtension>
                                    </EmbeddedRenderFormats>
                                    <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
                                    <ExcludedRenderFormats>
                                          <RenderingExtension>HTMLOWC</RenderingExtension>
                                          <RenderingExtension>NULL</RenderingExtension>
                                    </ExcludedRenderFormats>
                                    <SendEmailToUserAlias>True</SendEmailToUserAlias>
                                    <DefaultHostName></DefaultHostName>
                                    <PermittedHosts></PermittedHosts>
                              </RSEmailDPConfiguration>
                        </Configuration>
                  </Extension>
                  <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
            </Delivery>
            <Render>
                  <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
                  <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
                  <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
                  <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
                  <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
                  <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
                  <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
                  <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
                  <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
                  <Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
                        <Configuration>
                              <OWCConfiguration>
                                    <OWCDownloadLocation language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
                                    <OWCDownloadLocation language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
                              </OWCConfiguration>
                        </Configuration>
                  </Extension>
            </Render>
            <Data>
                  <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
                  <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
                  <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
                  <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
            </Data>
            <Security>
                  <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>
            </Security>
            <Authentication>
                  <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>
            </Authentication>
            <EventProcessing>
                  <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
                        <Event>
                              <Type>ReportHistorySnapshotCreated</Type>
                        </Event>
                  </Extension>
                  <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
                        <Event>
                              <Type>TimedSubscription</Type>
                        </Event>
                  </Extension>
                  <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
                        <Event>
                              <Type>SnapshotUpdated</Type>
                        </Event>
                  </Extension>
            </EventProcessing>
      </Extensions>
</Configuration>

Medassurant

ASKER

is this 2005 or 2008? because your config file looks alot different than mine.

jbattley

I upgraded SQL 2000 to 2008.

Medassurant

ASKER

I honestly have no idea then, so I apologize. To me, the differences inthe config file are the biggest problem. I've attached what our config file looks like, which was corrected in the visual basic program that came with SQL2008. The stuff for Sharepoint and TERADATA have been commented out with the  It's set as a txt file but normally would be a .config file.
rsreportserver.txt