Wednesday, 1 April 2015

Error: Value cannot be null, Parameter name: viewInfo (OR) Error: Microsoft .NET framework: Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error and attempt to continue

blogger tricks
Error Message:
=================================================
Error: Value cannot be null, Parameter name: viewInfo 

(OR) 

Error: Microsoft .NET framework: Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error and attempt to continue


How to resolve this issue?

Step 1:

The error generally occurs if any missing directory/file in %TEMP% and after that SSMS was not working any longer. The missing file is actually not needed, but the missing directory causes the "Value cannot be null" error.
  



  
Step 2: 

If the below temp and tmp variables are not placed in default location, we have to set them into their default location as shown below and restart the MS SQL services once if required.


C:\Users\Gani>set t
TEMP=C:\Users\Gani\AppData\Local\Temp\2
TMP=C:\Users\GaniAppData\Local\Temp\2


Step 3:

Right click on my computer---> Advanced system Settings environment variables ---> edit user variables and you can see the new path set 

Step 4:
Close the SSMS if opened and connect SSMS again. Now the issue gets resolved and able access the GUI interface without any issues




Appreciate your suggestions. Please comment your feedback and reach me out via email


Regards,
Ganapathi varma
Senior SQL Engineer, MCP


No comments:

Post a Comment