Is it working with Lync Archiving role?
SimWhite
8 Jun 2011 9:43 AM
Okan Gurer
8 Jun 2011 11:48 PM
As per as my tests, yes it is working on Lync Archiving database as well. Please share all your experiences if you face any issue. Thanks.
29 Jun 2011 9:17 PM
It is working perfectly with Lync 2010... you only need to run it with elevated privileges
DrRez
25 Oct 2011 4:38 PM
A customer asks: "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 an error message which appears to be a timeout." Any ideas here, folks?
26 Oct 2011 8:38 AM
This is an already reported issue to us (Faruk Celik and Okan Gurer) . Actually this is not a bug but “by design” issue. SqlException with “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding” error message thrown when the query issued by the tool takes more than the period defined in SqlCommand timeout. The default value for SqlCommand timeout in ADO.NET is 30 seconds.
High likely our customer is querying a long datetime period and it's taking lots of time inside OCS Arhciving database server. As a result OCSArchiveViewer stops saying "it took so long, I'd better cut".
This issue will not appear if you selects a small datetime range because it takes less time inside SQL Server Engine to gather the asked data.
WORKAROUND:
=============
The only workaround this is decreasing the datetime period that you’re querying and getting the results in more than one. Simply instead of querying 6 months period for a SIP, try to query for this for 2 months if it works fine for 2 months period, you can split this 6 months perioed into 3 pieces and you can query 3 times.
A few notes about this :
1)The very same query may not raise the error today with 30 seconds timeout but tomorrow it may work because of less load (Assuming that this SQL Server is also used for other purposes than OCS IM Archiving purposes)
2) It's always better to run the OCSArchiveViwere on top of the very same machine your SQL Server storing your OCS/Lync IM archive data. Because if you’re reaching the SQL Server through a VPN over WAN in another location and you’re running the OCSArchiveViewer on a remote machine, probability if getting similar errors like that much more due to network overhead. For such VPN scenarios ets, as a very easy workaround (if applicable, I mean if the SQL Server admin gives you remot oi ealcgcneper)i,s oinstall OCSArchiveViewer on your remote SQL Server machine and run OCSArchiveViewer from there by RDPing to SQL Server machine. As OCSArchiveViewer will be reaching SQL Server locally, it will work faster for sure
FIX:
====
To “fix” this, we’re planning to add a “Command Timeout” textbox. By default the CommandTimeout value will be 30 seconds again. If the querying fails because of CommandTimeout with this information, we will pop up a message like “Please increase the command timeout value. The data that you’re querying is taking long time to retrieve from SQL server”) for such long running queries.
I'll announce from here when we've released the new/fixed version of OCS Archive Viewer very soon.
Faruk
soder
3 Feb 2012 10:29 AM
Hi Faruk: did you manage to fix this issue? "Very soon" has already expired a couple of months ago :)
3 Feb 2012 3:33 PM
Hi soder,
Yes, it's already fixed and sorry about this delay. As we've received some other feedbacks than the one above, we experienced a bit delay.
Even though it's just a tool, every single build needs to pass some internal processes because this tool is published on Microsoft Download Center and it needs to pass the processes every single Microsoft "product" pass.
We'll do our best to finish the planned fixes, enhancements asap.
Regards,
Faruk
soder
18 Mar 2012 1:28 PM
Faruk: you are suggesting that as the time of writing my post here, the downloadable version of the tool is still experiencing the issue?
DrRez
24 Apr 2012 4:27 PM
Adding this reader comment (sent to NextHop feedback alias): "Is there an issue with this tool when trying to pull conversations using the 1:1 Messages button? I get all data instead of the data just between the two dates entered."
DrRez
24 Apr 2012 4:29 PM
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."
Jon
5 Jul 2012 11:22 AM
Hi
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
10 Jul 2012 8:41 AM
@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
Jon
10 Jul 2012 5:23 PM
@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
darkstar3d
2 Aug 2012 3:43 PM
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
----------------------------------------
Jim
31 Aug 2012 5:26 PM
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?