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.
LVL 2
MedassurantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MedassurantAuthor Commented:
I checked the config file and saw where the 2nd error was coming from so I just removed that from the config file and in doing so, seemingly got rid of both problems, though I don't kow why the teradata issue would go away by removing the DocumentLibrary extension line.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jbattleyCommented:
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?
0
MedassurantAuthor Commented:
rsreportserver.config file should be located under the ReportServer folder in your MSSQL folder under Program Files.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

jbattleyCommented:
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>
0
MedassurantAuthor Commented:
is this 2005 or 2008? because your config file looks alot different than mine.
0
jbattleyCommented:
I upgraded SQL 2000 to 2008.
0
MedassurantAuthor Commented:
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    <!-- and the -->  It's set as a txt file but normally would be a .config file.
rsreportserver.txt
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.