Month: March 2014

Auto downloading attachments on Outlook to a different folder other than the default one

praveenhLeave a comment

This morning I had a very interesting query from a user. The request was if he could auto-download all the attachments that he received on his Outlook to another folder other than the temporary one (default folder). I sat down for a while looking for rules or any option on Outlook itself. But nothing to be found. When I did a bit of my own research, I figured out that with a bit of coding and then using the Outlook Rules itself, this was possible.

The link found to be very helpful for this purpose. Please note that in the section where one can specify the file type that needs to be stored to the custom folder, one needs to add a double quote before the file type.

For example, here is the code that I had used for my trial runs

Public Sub saveAttachtoDisk(itm As Outlook.MailItem)

Dim objAtt As Outlook.Attachment

Dim saveFolder As String

saveFolder = “D:\Attachments”

For Each objAtt In itm.Attachments

If InStr(objAtt.DisplayName, “.pdf”) Then

objAtt.SaveAsFile saveFolder & “\” & objAtt.DisplayName

End If

Next

End Sub

In the scenario above, the user only wanted PDF files to be saved to a folder in his D drive. The part of the code where I have highlighted as red should have the file extension (file type) within double quotes. In the link provided above this has been given within single quotes.

Although it is mentioned that this works for Outlook 2007 and Outlook 2010, I had tried on Outlook 2013 and it works beautifully without any hiccups. Give it a try! It’s awesome to see it working!

Panic!! Bad system health (SYNCSTATE_RESTART); restarting service – Sonicwall CDP Device

Sunil PadmanabhanLeave a comment

If you are getting this error from your Server Event Logs; it is certain that your backup is not secure and urgent action needs to be taken

The high-probability for this error is that you are running on Older CDP Agent Version (possibly 6.0). With CDP Agent Version 6.0 there is an issue of agent resources leaking due to which the agent service has these panic attacks and restarts the service. In order to fix this issue it is advised to update your CDP Agent to latest available version; which as of currently is 6.1.4.78

Blackberry Bold / Curve – SIM Card Rejected – OS 7

Sunil PadmanabhanLeave a comment

I faced this error recently with a Blackberry Phone running OS 7.

The first thing on my mind was to check the Mobile Network Selections under Network and Connections. Strangely both Network and Connections as well as Wi-Fi Network options would not respond.

The only option left was to do backup and restoration which takes just about 30 minutes. I would suggest you do not crack your brains further on this one doing R&D.

 

 

SQL Database ‘SharePoint_Config’ on SQL Server instance not found

Sunil PadmanabhanLeave a comment

SQL Database ‘SharePoint_Config’ on SQL Server instance ‘GDFS’ not found. Additional error information from SQL Server is included below.

Cannot open database “SharePoint_Config” requested by the login. The login failed. Login failed for user ‘GOLTENSDXB\SP_Farm’.

Before you go about making any drastic changes to the database; it would be wise to check the Status of the Sharepoint_Config database within the SQL Server Management Studio

Is your Sharepoint_Config Database set to Single User Login?

Sharepoint_Config

If yes, we require the trace and kill the session that is connected to this database before we enable multi user

Step 1 – Trace the Session ID connected to the Sharepoint_Config Database

select * from master.sys.sysprocesses 
msp,master.sys.sysdatabases msd 
where msp.spid>50
and msd.name='SharePoint_Config'
and msp.dbid=msd.dbid

Step 2 – Kill the Session and set the Sharepoint_Config Database database to offline mode

kill <spid> [eg: kill 62]
alter database Sharepoint_Config set offline with rollback immediate;

Step 3 – Switch back the Database to Online Mode and set it for Multi-User login

alter database Sharepoint_Config set online,multi_user with rollback immediate;

If your Sharepoint_Config database was not in Single User Login Mode and are still faced with this error; I would recommend below post

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

Unable to shrink Sharepoint_Config_Log file in Sharepoint 2010

Sunil PadmanabhanLeave a comment

Is your Sharepoint_Config_Log file reaching enormous GB size of data and nearing your full drive space utilization?

Shrinking a Log File in your SQL Database may seem very straightforward when accessing SQL Server Management Studio

You may have already tried the below and still not seen any change in the file size

ShrinkLogFile

If the above scenario is true, it is most likely that you have set your DB in Full Recovery Mode and hence will not allow you to shrink the log file

Please note that in my illustration I have made an assumption that the default dbname Sharepoint_Config has been changed; if changed please make revisions to the script accordingly

To confirm this further, run the shrink operating using the SQL Query.

From the SQL Server Management Studio

  • Click New Query and type below command
  • DBCC SHRINKFILE (Sharepoint_Config_LOG);
  • Execute the command
  • Click the Messages tab at the bottom and take note of the error

Your are most likely to get the below error

“Cannot shrink log file 2 because the logical log file located at the end of the file is in use”

In SQL Server Management Studio; run below commands

use master;
alter database Sharepoint_Config set recovery simple;
  • DBCC SHRINKFILE (Sharepoint_Config_LOG);

This will shrink the log file to its default size.