Visual Studio menu items showing twice/duplicate

Problem Statement:

• While opening the visual all the menu iteams are show double-double / duplicate.

Solution:

• Open Visual studio command prompt
• Run following commands:

Devenv.exe /ResetSettings

Devenv.exe /resetuserdata

Reference :

http://stackoverflow.com/questions/16060832/duplicate-menu-items-vs-2012

Regards

Kundan

502.3 - Bad Gateway security error code

Problem Statement:

Whenever you are using IIS ARR with URL Rewrite for Reverse proxy. 
HTTPS to HTTPS. You might receive following error.

Error: IIS 7.5 Detailed Error - 502.3 - Bad Gateway security error code 0x80072f8f

Casue of Problem:

IIS where you configured ARR it doesn't trust the BackEnd IIS Server certificate.

Solution:

Please export the Back End IIS Server certificate and Import it into IIS-ARR local machine under
Trusted Store.

Reference: http://blog.lint.at/iis-as-reverseproxy-with-ssl-offloading/

System.Configuration The entry 'XXX has already been added (C:\Program Files (x86)\Microsoft BizTalk Server 2010\BTSNTSvc64.exe.Config)

Problem Statement:
Sometimes if we get following kind of error message:

Error writing to log. System.Configuration The entry 'XXXX' has already been added. (C:\Program Files (x86)\Microsoft BizTalk Server 2010\BTSNTSvc64.exe.Config line 156)


Cause of Error:

This is the result of a double entry in the config files BTSNTSvc.exe.Config or BTSNTSvc64.exe.Config and machine.config

Solution:

Option 1:

Search machine.config and BTSNTSvc.exe.Config ( or BTSNTSvc64.exe.Config) and remove double entry.


Option 2:

In BTSNTSvc.exe.Config ( or BTSNTSvc64.exe.Config) replace below lines of code.

      <add name="XXXX" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

        filePath="D:\AAAA\Config\BBBB.config" />

with


<remove name="XXXX"/>
 <add name="XXXX" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

        filePath="D:\AAAA\Config\BBBB.config" />

Then it will work :-)

Regards

Kundan

Clean Up BizTalk Databases and Logs

Clean Up BizTalk Databases and Logs


Problem Statement: Usually on Development machine biztalk databases logs grows and fill most of the space of disk. 

Cause: This usually happens when the biztalk jobs either not configured or SQL Agent is not running.

Solution:
Note: This should not be applied on PRODUCTION Servers.

Execure below lines of code on SQL Sever where biztalk is configured.

Step 1:


=====Script Start==============
USE master
ALTER DATABASE BizTalkMgmtDb SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE BizTalkDTADb SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE BizTalkMsgBoxDb SET RECOVERY SIMPLE WITH NO_WAITGO

Use BizTalkMgmtDbDBCC SHRINKFILE (N'BizTalkMgmtDb_log' , 0, TRUNCATEONLY)GO

Use BizTalkDTADbDBCC SHRINKFILE (N'BizTalkDTADb_log' , 0, TRUNCATEONLY)GO

Use BizTalkMsgBoxDbDBCC SHRINKFILE (N'BizTalkMsgBoxDb_log' , 0, TRUNCATEONLY)GO

USE master
ALTER DATABASE BizTalkMgmtDb SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE BizTalkDTADb SET RECOVERY FULL WITH NO_WAITALTER DATABASE BizTalkMsgBoxDb SET RECOVERY FULL WITH NO_WAITGO

=======Script End=================

Step 2: 

a. Go to BizTalk installation directory example :
C:\Program Files (x86)\Microsoft BizTalk Server 2010\Schema\
b. run script msgbox_cleanup_logic.sql  on BizTalk MsgBox DB database.
c. Now execute bts_CleanupMsgbox from BizTalk MsgBox DB database.



References:

http://blogical.se/blogs/johan/archive/2011/12/22/truncate-biztalk-servers-database-log-files-to-clear-up-space.aspx

https://masteringbiztalkserver.wordpress.com/2011/01/10/reset-biztalk-server-msgbox-database-%E2%80%93-useful-for-all-developers/

Regards
Kundan