Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

BillG — Wed, 09 Jan 2013 21:16:14 GMT

This is rediculous the date filter does not work on 1:1. I have tired it with several user accounts and all data for the past year is being pulled up. I only need the IMs for 2 days. Is there a new version of this tool or has it been sent to the "End of Life" graveyard?

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Faruk Celik — Wed, 10 Oct 2012 14:15:37 GMT

@darkstar3d,

Was this error happened only once or you're receiving this error repeatedly ? I mean can you reproduce this issue at will ?

As you see from the the stack trace, error appears when you clicked on "Connect" button. I'm wondering if you have tried running the OCS IM ArchiveViewer on top of the SQL Server where you're storing your OCS/Lync Archiving data (Trying a "local connection" to the SQL Server instead of "remote connection" just to avoid any issues between your machine to SQL Server) ?

Thanks,

Faruk

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Faruk Celik — Wed, 10 Oct 2012 14:12:21 GMT

@Jim

Please read my response on "10-26-2011 7:38 AM" about timeout error.

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

JoelG — Wed, 26 Sep 2012 16:41:45 GMT

hi, i test in OCS and Lync and work fine,but have a bug, date filter no work, when retrive mesages, retrive all.

thanks

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Jim — Fri, 31 Aug 2012 15:26:56 GMT

I am trying to use this tool, and when I try to get it to even connect, I am getting the timeout error. Any thoughts?

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

darkstar3d — Thu, 02 Aug 2012 13:43:47 GMT

Got this trying to connect to Microsoft Lync Server 2010 (4.0.7577.0)

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.NullReferenceException: Object reference not set to an instance of an object.

at OCSArchiveViewer.Form1.btnConnectToSQL_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll

----------------------------------------

OCSArchiveViewer

Assembly Version: 1.0.0.0

Win32 Version: 1.0.0.0

CodeBase: file:///C:/Program%20Files%20(x86)/OCS%20IM%20Archive%20Viewer%201.0/OCSArchiveViewer.exe

----------------------------------------

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5462 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Transactions

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.EnterpriseServices

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Jon — Tue, 10 Jul 2012 15:23:33 GMT

@Faruk

error msg:-

Unhandled exception has occurred in your application. if you click continue, the application will ignore this error and attempt to continue. if you click quit, the application will close immediately.

Failed to convert parameter value from guid to a int32.

is this the rest of what you require:-

************** Exception Text **************

System.InvalidCastException: Failed to convert parameter value from a Guid to a Int32. ---> System.InvalidCastException: Object must implement IConvertible.

at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)

at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType)

--- End of inner exception stack trace ---

at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType)

at System.Data.SqlClient.SqlParameter.GetCoercedValue()

at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)

at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters)

at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at OCSArchiveViewer.Form1.parseBody()

at OCSArchiveViewer.Form1.btnGetMessages_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Jon

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Faruk Celik — Tue, 10 Jul 2012 06:41:46 GMT

@Jon:

Hi,

Could you please share the exact error message ? If you get a stack trace appreciate if you can post here so we can take a look

Faruk

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

Jon — Thu, 05 Jul 2012 09:22:00 GMT

When trying to use this tool (v1.0) to retrieve conference conversations I get an error 'failed to convert parameter value from a Guid to a Int32'

Retrieving a 1:1 conversation works fine only getting the error for the conference chat.

Any ideas on how to resolve?

Thank you

re: Office Communications Server 2007 R2 Tool: OCS IM Archive Viewer

DrRez — Tue, 24 Apr 2012 14:29:56 GMT

A reader asks (sent to NextHop feedback alias): "I am trying to use your tool for querying my OCS Archive database, however it gives me a time out when attempting to do so. I have tried the OCS Archive viewer on both the same system that is hosting the OCS Archive database, and a separate system. I get the below error message which appears to be a timeout."