Advertisements

Monthly Archives: March 2014

Difference between VLOOKUP and INDEX-MATCH Formulas in Excel

Below is a Video Illustration in Excel 2010. It applies to Excel 2007 and above

Advertisements

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

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!

Sonicwall CDP Agent Error – HTTP Error Request

I went through the Sonicwall Forums and did not find the correct answer to this problem

SonicwallCDPAgentError

I tried updating Adobe Air and Restarting the System. But still had no luck

  • Open Task Manager
  • Under Services Tab; locate a service named SonicWALLCDPProxy
  • This service is most likely stopped. Start this service and open the Agent once again

SonicwallCDPProxy

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

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

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

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

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.

iPhone / iPad – Wrong Apple ID showing when updating apps

If you are faced with this problem; ask yourself two questions

  • Have you used more than 1 Apple ID with the same Apple Device during its lifetime?
  • Have you synchronized your iPhone with PC’s running different Apple ID’s?

If either of them are true the real reason for the error is because the version of the App that you wish to update was installed / updated / synchronized  using an alternate or old Apple ID

To resolve this issue; just delete the App. When re-installing the App again from iTunes, it will automatically download and install using the current configured Apple ID on your device

Printers not printing with SafeQ working on Cluster mode

Very recently, I happened to go through a very tricky situation with the printers in our office, all connected through SafeQ ports (not IP ports). The users would print, but when they went to the printers to release the jobs, the jobs were not displayed on the YSoft Terminal. I checked the print server queue and couldn’t find any pending jobs stuck in the queue. I tried restarting both the Print spooler services, that didn’t help. I tried restarting both the CML (Primary Server) and the Secondary Node (Secondary Server) and this helped for about 5 minutes. After 5 minutes or so the prints would stop appearing on the YSoft SafeQ terminal.

After having checked for more than 2 hours, I realized that the secondary partition on the Secondary server had run out of space. When checked, I was shocked to find that the ldf file for the SafeQ Database has consumed almost 90% of space on the secondary partition. Once this file was truncated, the jobs had started appearing on the terminals and the print jobs were all smooth, fast and back to normal.

Movie Maker 2012 does not run on Windows 7 32-bit/64-bit

After installing Movie Maker, you face the below error as illustrated

MovieMakerError

You may go through the link that shows up in the error and check the minimum system requirements. The only pointer that may catch your attention is the DirectX Version on your PC. The minimum DirectX Version expected is version 9.

To crosscheck this click Start – Type Dxdiag and press enter. The DirectX Version will be listed in the DirectX Diagnostic Tool Window that opens up. If your PC is relatively new and frequently updated; there is no reason why your DirectX Version should be below 10; so forget the minimum requirement of DirectX 9 for Movie Maker 2012

DirectX

The most obvious solution to get your Movie Maker software working is to update your Display Driver

  • Locate your Display Driver Model and Driver Version
  • Start – Control Panel – Device Manager

DeviceManager

  • As per the illustration, the display card is Intel and hence I will proceed to the Intel Website to download and Install the latest driver (https://downloadcenter.intel.com/Default.aspx?lang=eng)
  • But if in your case; it’s an NVIDIA proceed to this link instead (http://www.nvidia.com/Download/index.aspx)
  • Locate your driver using the search options available on the respective Driver Manufacturer webpage.
  • Download and Install the latest updates
  • Once done, restart the PC and try running Movie Maker