locked
How to determine if OCS 2007 R2 Archiving Server is Archiving, and Actually Retrieve Messages RRS feed

  • Question

  • We have deployed Archiving Service.
    I have a new database, LcsLog.  But I cannot access it through SQL Management Studio(no permissions) and as far as I can tell, there is no provided interface for retrieving conversations.  Archival and Retrieval are a compliance requirement.
    We are running OCS R2 Standard Evaluation on Server 2008 with the installed SQL Express 2005.
    Thursday, October 15, 2009 6:49 PM

Answers

  • yes your ocs isn't archiving...

    Try to check all configs (step by spep):
    http://technet.microsoft.com/en-us/library/dd425118(office.13).aspx
    Bruno Estrozi - MCSE +S +M/MCTS/MCITP - Unified Communications Specialist | http://brunoestrozi.com.br
    • Marked as answer by David McKenzie Tuesday, October 20, 2009 5:56 PM
    Friday, October 16, 2009 4:31 PM
  • SOmehow or other I must have missed
    To associate a Front End Server with the Archiving Server >
    Step 6. To enable archiving, select the Activate IM content archiving check box.   
    Because it wasn't checked.
    I also missed the Directory Services Integration requirement for the MSMQ Feature.

    Fixed both of those and I am up and running.

    Now to code the query application.

    THanks to all for their input
    • Marked as answer by David McKenzie Tuesday, October 20, 2009 5:55 PM
    Tuesday, October 20, 2009 5:41 PM

All replies

  • Verify if you specified the correct stance where the database are.

    When you open SQL Management Studio select the option "Run as Administrator" and you only will acess the data base if the SQL Management Studio are installed on the same server which the SQL Express.


    Bruno Estrozi - MCSE +S +M/MCTS/MCITP - Unified Communications Specialist | http://brunoestrozi.com.br
    Friday, October 16, 2009 12:44 PM
  • Great!
    "Run as Administrator"
    Clear as mud, that requirement was.
    Now I can see all the tables, but there's no data.
    The tables were created by the setup.
    Everything (SQL Express, OCS, Archiving Server, SQL gement Studio) is located on a single server.
    Setup says Archiveing Service is successfully deployed, and I enabled all users.
    Friday, October 16, 2009 2:30 PM
  • Try to execute this query:

    SELECT * from dbo.Messages, dbo.Users where
    dbo.Users.UserId = Messages.FromId

    If you don't see the conversations history this means which your ocs isn't archiving.

    Bruno Estrozi - MCSE +S +M/MCTS/MCITP - Unified Communications Specialist | http://brunoestrozi.com.br
    Friday, October 16, 2009 2:44 PM
  • Or you could use this tool from the OCS R2 Resource Kit Tools

    ArchivingCDR Reporter (ArchivingCDRReporter.exe, ArchivingCDRReporter_Config.xml)
    This reporting tool has built-in SQL queries to retrieve and view information from the Archiving and Call Detail Records (CDR) Backend. The tool enables the user to view Office Communications Server 2007 usage reports based on the Archiving and CDR tables.

    Download ResourceKit
    http://www.microsoft.com/downloads/details.aspx?FamilyID=9e79a236-c0df-4a72-aba6-9a9602a93ed0&DisplayLang=en
    - Belgian Unified Communications Community : http://www.pro-exchange.be -
    Friday, October 16, 2009 3:38 PM
  • (0 row(s) affected)
    Which I think means that OCS isn't archiving.
    There are 0 rows in dbo.MEssages and dbo.Users
    Any suggestions?

    Friday, October 16, 2009 4:13 PM
  • yes your ocs isn't archiving...

    Try to check all configs (step by spep):
    http://technet.microsoft.com/en-us/library/dd425118(office.13).aspx
    Bruno Estrozi - MCSE +S +M/MCTS/MCITP - Unified Communications Specialist | http://brunoestrozi.com.br
    • Marked as answer by David McKenzie Tuesday, October 20, 2009 5:56 PM
    Friday, October 16, 2009 4:31 PM
  • Have you installed MSMQ on both FE and Archiving server?
    Have you rebooted both machines?
    - Belgian Unified Communications Community : http://www.pro-exchange.be -
    Monday, October 19, 2009 11:21 AM
  • Yes
    Archiving and FE roles are on the same machine and it has MSMQ installed.
    The setup scripts actually enforce this requirement.

    I have now reviewed all setup steps and rerun those which can be rerun and rebooted.
    Still no rows in Users or Messages tables.

    What else can I do.

    Archiving is an absolute requirement.
    Monday, October 19, 2009 3:30 PM
  • FE and Archiving roles are on same server.
    MSMQ is installed.

    Experiencing a little learning curve on Server 2008.
    Found this error in the OCS Applications Event Log.
    Not having much luck finding a resolution or circumvention


    Log Name:      Office Communications Server
    Source:        OCS Archiving Agent
    Date:          9/17/2009 8:30:47 AM
    Event ID:      30524
    Task Category: (1011)
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      server.domain
    Description:
    Office Communications Server Archiving Agent failed to create a local administration queue for acknowledgements. The Archiving Agent will not be able to log any message.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="OCS Archiving Agent" />
        <EventID Qualifiers="33779">30524</EventID>
        <Level>3</Level>
        <Task>1011</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2009-09-17T13:30:47.000Z" />
        <EventRecordID>835</EventRecordID>
        <Channel>Office Communications Server</Channel>
        <Computer>Server.domain</Computer>
        <Security />
      </System>
      <EventData>
      </EventData>
    </Event>

    Monday, October 19, 2009 3:47 PM
  • SOmehow or other I must have missed
    To associate a Front End Server with the Archiving Server >
    Step 6. To enable archiving, select the Activate IM content archiving check box.   
    Because it wasn't checked.
    I also missed the Directory Services Integration requirement for the MSMQ Feature.

    Fixed both of those and I am up and running.

    Now to code the query application.

    THanks to all for their input
    • Marked as answer by David McKenzie Tuesday, October 20, 2009 5:55 PM
    Tuesday, October 20, 2009 5:41 PM