MongoDB Import JSON Error – Unmarshalling Bytes

While importing data from a JSON file into MongoDB using following command  – mongoimport –db my_db –collection my_collection –file json_file.json if you encounter following error – Failed: error unmarshaling bytes on document #0: JSON decoder out of sync – data changing underfoot? Solution: Mos probable reason is some parts of JSON Objects are not properly formatted. […]

Continue reading →

Troubleshooting – Error: Invalid attempt to call HasRows when reader is closed

Usually this error will be encountered while trying to access data from DataReader. Problem: System.InvalidOperationException was unhandled   Message=”Invalid attempt to call HasRows when reader is closed.”   Source=”System.Data”   StackTrace:        at System.Data.SqlClient.SqlDataReader.get_HasRows()   Reason: Most of the times the reason will be – you use SqlCnnection object in using block – which will […]

Continue reading →

Error: WriteFile failed => 0x5(5) when Makecert is run

Problem: Makecert -sv MyCert.pvk -n”CN=MyCompanyCert” MyCert.cer -b01/01/2009 -e 12/31/2018 While executing the above command, sometimes we get the following error. Error: WrtieFile failed => 0x5<5> Solution: The solution for this is to run the command prompt in admin mode. This can be done by right-clicking on the cmd and selecting ‘Run as Administrator‘. Hope this […]

Continue reading →

Common mistakes while installation and deployment of PIAs

Have you ever came across this error message while deploying PIAs along with your add-in as prerequisites? Problem: Error 1316: Setup cannot read from file {PATH}PIARedist.MSI. Check your connection to the network, or CD-ROM drive. For other potential solutions, see SETUP.CHM. Reason: This error occurs if the PIA’s already installed in the client system. This […]

Continue reading →

Troubleshooting Office 2007 Add-ins

Here are few links on troubleshooting Office 2007 and 2010 Add-ins which I just came across. I believe that one can get quick work-around to solve ( at least pin-down) the issue. How to: Re-enable an Add-in That Has Been Disabled Debugging in Application-Level Projects Troubleshooting Run Time Errors in Office Solutions Hope this helps!

Continue reading →

Troubleshooting Error – Unable to cast COM object {00063034-0000-0000-C000-000000000046}

Have you ever suffered from the following error while working with COM objects? Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Outlook.MailItem’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{00063034-0000-0000-C000-000000000046}’ failed due to the following error: No such interface supported (Exception from HRESULT: […]

Continue reading →