After installing the OCS/Lync report pack, when running the OCS/Lync Default Gathering, the Peer-to-Peer Audio Calls, Video Calls, and Desktop Sharing sessions subtask is failing with:
"Error in report pack data source execute ---> QmsOcs.QmsGeneralException (0x80004005): Error occured while retrieving P2P session data ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."
WORKAROUND 1
1. Open the MessageStats console, disconnect from your OCS or Lync pool and delete your existing OCS/Lync Default Gathering Task.
2. Verify T_OCS_Configuration table exists in the MessageStats database. If it does not exist, uninstall and reinstall the OCS/Lync Report pack.
WORKAROUND 2
1. Run the "QmsOcsLyncDatabase.sql" script (found in unzipped package "SQL\Platforms\OCS-Lync directory") against the database manually to create the table or populate the missing columns in the table.
WORKAROUND 3
Note: This procedure will remove any previous gathered information against OCS/Lync.
Note: This procedure will remove any previous gathered information against OCS/Lync.
1. Open the MessageStats console, disconnect from your OCS or Lync pool and delete your existing OCS/Lync Default Gathering Task.
2. Uninstall the Report Pack
3. Back up the MessageStats database
4. Run the attached script "DropOCSObjects.sql" that will drop all the OCS tables & Stored Procedures from the database
5. Run "QmsOcsLyncDatabase.sql" found in the unzipped package "SQL\Platforms\OCS-Lync" against the MessageStats database.
6. Run the OCS/Lync Report pack installer
7. Deselect the database
8. Proceed with the install of the Report pack
9. Once completed, open the MessageStats console
10. Make a connection to your OCS/Lync Pool.
11. Create a OCS/Lync Default Gathering
You should no longer see the error.
