Monday, October 03, 2011

Mutex could not be created

I was getting the following error when I was browsing the web site which was build and published on to the local machine -

Server Error in '/Ea' Application. ----------------- Mutex could not be created.

The workaround I have got for now is:

- If you have visual studio 2005/2008 open, close it
- Go to the ASP.NET temporary folder for v2.0 of the framework
\Microsoft.Net\Framework\v2.0\Temporary ASpNET pages
- Remove the folder for your application (or all of them)
- Reset IIS (on a command line window, >iisreset) [not always needed, but I had to use it sometimes]
- First Browse your page from IE (http://localhost/your app)
- Then reopen Visual studio

And it should work now

I hope it will work for you as it does for me.

Monday, September 05, 2011

SSAS errors: Errors in the metadata manager. The dimension with ID of 'xxx' referenced by the 'yyy' cube, does not exist.

When deploying Analysis Services solution I am getting errors:

Errors in the metadata manager. The attribute with ID of .., Name of .. referenced by the .. measure group dimension does not exist.

Errors in the metadata manager. An error occurred when loading the .. measure group, from the file, partitionWithFullPath.xml


One of the reasons why you could be getting this error message is because you are trying to deploy solution using "Changes Only" deployment method and as not all changes are deployed, metadata that is already deployed conflicts with your current metadata about cube.

To see if this will fix your problem follow these steps -

• In Business Intelligence Development Studio (BIDS) select your solution in Solution explorer, right mouse click and select Rebuild. You should not get any error during this step.

• In BIDS select menu item "Project" and choose "Properties" menu item

• Go to "Deployment" tab and change "Deployment Mode" to "Deploy All". Change Processing Option to "Full processing", or to "Do not process" if you are planning to process latter. Close this dialog.

• Select your solution in the Solution explorer and choose "Deploy" item.

• If reason for above stated error was metadata inconsistencies, you should see no errors during deployment and/or processing.

• Change your deployment setting back to what you usually use.

Wednesday, August 24, 2011

Cast Error on SqlDataReader using Enterprise Data Library 5.0

I was trying to fill the dropdown in the conventional way by binding the dropdown with the DataReader. But, somehow couldn't do it and was getting the cast error.

After some googling, got this article which I thought worth sharing it with others -

ExecuteReader in Enterprise Library wraps IDataReader into RefCountingDataReader that as SqlDataReader implements IDataReader interface.
RefCountingDataReader has InnerReader property that you can cast to SqlDataReader.


Here is the code -

SqlDataReader reader;
reader = ((RefCountingDataReader)db.ExecuteReader(command)).InnerReader as SqlDataReader;
if (reader != null)
reader.Read();
return reader;

Wednesday, August 17, 2011

Error using Microsoft Enterprise Library Data Application Block

I was trying to use Data Access Application Block in a Winforms application. I have added the right references including Microsoft.Practices.EnterpriseLibrary.Data

when I build the application I get this error -

1 The referenced assembly "Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project.

Also, where I have referenced with using statement in classes, I was getting errors like -

The type or namespace name 'Data' does not exist in the namespace 'Microsoft.Practices.EnterpriseLibrary' (are you missing an assembly reference?)

After some googling, I got this solution which might be of help to others as well -

This is a known issue in EntLib 5.0. You must target the full .NET Framework instead of the Client Profile (Right click on project, select Properties). The Data Access Application Block has a dependency on System.Data.Oracle that has been removed from the client profile.



Monday, July 18, 2011

Windows Installer CleanUp Utility

When you are working on your computer and installing a new program, the installation suddenly fails. Now you are left with a partly installed program. You try to install the program again, but you are unsuccessful. Or, maybe you have problems trying to remove an old program because the installation files are corrupted.

By running the Windows Installer CleanUp Utility, you will be able to remove that program and can proceed further. I thought of sharing it as many people still don't know about it.

Thursday, June 16, 2011

Encrypting & Decrypting XML

I have been given a task to encrypt an xml file before sending it to a different server and use it there after decrypting it just to make the data transfer more secured.

Here is what the code does to encrypt and decrypt an xml file -

This is to be entered in the web.config file -

< system.web>
< machineKey validationKey="1B8B081B3ED61D4663AE0F85406E69A5C8D8D2B8" decryptionKey="77C3813937C1C210054267AC940D0E75A4BD988F095EDE2D"
decryption="3DES"
validation="SHA1"/>

OR

< machineKey
validationKey="AutoGenerate,IsolateApps"
decryptionKey="AutoGenerate,IsolateApps"
validation="SHA1"
decryption="Auto"
/>


Now is the code -

public XmlDocument Config = new XmlDocument();

public string sEnvironment = "";

string sLoc = string.Empty;

protected void Page_Load(object sender, EventArgs e)
{
sLoc = Server.MapPath("XMLFile1.xml");
Config.Load(sLoc);

sEnvironment = "Prod"; // ConfigurationSettings.AppSettings["Environment"].ToString();
if (IsXmlEncrypted(Config))
//Config = DecryptXml(Config);
DecryptXml(sLoc);
else
{
if (sEnvironment != "Local")
{
EncryptXml(sLoc, "root");
}
Config = DecryptXml(Config);
}
}

#region Encrypt and Decrypt Methods

///
/// EncryptXml is a method that will encrypt and entire Xml file, or just a particular node in an Xml. This method accepts 2 parameters: the path where the Xml file is located
/// and the node that must be encrypted. If the entire Xml document needs to be encrypted, the root node of the Xml document must be passed as the node parameter.
/// NOTE: This method SAVES the file! If you do not need to overwrite your Xml file, then DO NOT USE this method. Use the other version in its place.
///

/// The actual path where the Xml file is stored.
/// The node from which encryption starts. If the root node is passed as a parameter, the entire document will be encrypted.
/// If you do not need the entire document encrypted, but instead, just one node, pass the node in in xpath format: "root/parent/child"
///

public void EncryptXml(string file, string node)
{

sLoc = Server.MapPath("web.config");
Config.Load(sLoc);

XmlNode xNode = Config.SelectSingleNode("configuration/system.web/machineKey");

CspParameters cspParams = new CspParameters();

cspParams.KeyContainerName = xNode.Attributes["validationKey"].InnerText;
cspParams.Flags = CspProviderFlags.UseMachineKeyStore;

RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.PreserveWhitespace = true;
xmlDoc.Load(file);

XmlElement elementToEncrypt = xmlDoc.GetElementsByTagName(node)[0] as XmlElement;

if (elementToEncrypt != null)
{
RijndaelManaged sessionKey = new RijndaelManaged();
sessionKey.KeySize = 256;

EncryptedXml eXml = new EncryptedXml();

byte[] encryptedElement = eXml.EncryptData(elementToEncrypt, sessionKey, false);
EncryptedData eData = new EncryptedData();
eData.Type = EncryptedXml.XmlEncElementUrl;

eData.EncryptionMethod = new EncryptionMethod(EncryptedXml.XmlEncAES256Url);

EncryptedKey eKey = new EncryptedKey();
byte[] encryptedKey = EncryptedXml.EncryptKey(sessionKey.Key, rsaKey, false);
eKey.CipherData = new CipherData(encryptedKey);
eKey.EncryptionMethod = new EncryptionMethod(EncryptedXml.XmlEncRSA15Url);

eData.KeyInfo = new KeyInfo();

KeyInfoName kin = new KeyInfoName();

kin.Value = xNode.Attributes["decryptionKey"].InnerText;
eKey.KeyInfo.AddClause(kin);

eData.KeyInfo.AddClause(new KeyInfoEncryptedKey(eKey));

eData.CipherData.CipherValue = encryptedElement;
EncryptedXml.ReplaceElement(elementToEncrypt, eData, false);

xmlDoc.Save(file);
}
else
throw new ArgumentNullException("The specified node does not exist in the provided Xml document.");
}

///
/// EncryptXml is a method that will encrypt an Xml file and return an XmlDocument object for use IN MEMORY. If the XmlDocument needs to be saved, then it is up to the calling
/// program to save the encrypted Xml file.
///

/// A previously loaded Xml file that needs to be encrypted.
/// he node from which encryption starts. If the root node is passed as a parameter, the entire document will be encrypted.
/// If you do not need the entire document encrypted, but instead, just one node, pass the node in in xpath format: "root/parent/child"
///
/// An encrypted XmlDocument. How it is used is up to the calling program.

public static XmlDocument EncryptXml(XmlDocument xmlDoc, string node)
{
XmlDocument xmlDocToEncrypt = xmlDoc;
XmlDocument config = DotNetNuke.Common.Utilities.Config.Load();
XmlNode xNode = config.SelectSingleNode("configuration/system.web/machineKey");

CspParameters cspParams = new CspParameters();

cspParams.KeyContainerName = xNode.Attributes["validationKey"].InnerText;
cspParams.Flags = CspProviderFlags.UseMachineKeyStore;

RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);

XmlElement elementToEncrypt = xmlDocToEncrypt.GetElementsByTagName(node)[0] as XmlElement;

if (elementToEncrypt != null)
{
RijndaelManaged sessionKey = new RijndaelManaged();
sessionKey.KeySize = 256;

EncryptedXml eXml = new EncryptedXml();

byte[] encryptedElement = eXml.EncryptData(elementToEncrypt, sessionKey, false);
EncryptedData eData = new EncryptedData();
eData.Type = EncryptedXml.XmlEncElementUrl;

eData.EncryptionMethod = new EncryptionMethod(EncryptedXml.XmlEncAES256Url);

EncryptedKey eKey = new EncryptedKey();
byte[] encryptedKey = EncryptedXml.EncryptKey(sessionKey.Key, rsaKey, false);
eKey.CipherData = new CipherData(encryptedKey);
eKey.EncryptionMethod = new EncryptionMethod(EncryptedXml.XmlEncRSA15Url);

eData.KeyInfo = new KeyInfo();

KeyInfoName kin = new KeyInfoName();

kin.Value = xNode.Attributes["decryptionKey"].InnerText;
eKey.KeyInfo.AddClause(kin);

eData.KeyInfo.AddClause(new KeyInfoEncryptedKey(eKey));

eData.CipherData.CipherValue = encryptedElement;
EncryptedXml.ReplaceElement(elementToEncrypt, eData, false);

return xmlDocToEncrypt;
}
else
throw new ArgumentNullException("The specified Xml node does not exist in the provided Xml document.");
}

///
/// This method encrypts a string!
///

/// The string that needs to be encrypted.
/// The encrypted string.

public static string EncryptData(string data)
{
DotNetNuke.Security.PortalSecurity ps = new PortalSecurity();

XmlDocument config = DotNetNuke.Common.Utilities.Config.Load();
XmlNode node = config.SelectSingleNode("configuration/system.web/machineKey");

return ps.Encrypt(node.Attributes["decryptionKey"].InnerText, data);
}

///
/// This method decrypts a previously encrypted string!
///

/// The string that needs to be decrypted.
/// The decrypted string.

public static string DecryptData(string data)
{
DotNetNuke.Security.PortalSecurity ps = new PortalSecurity();

XmlDocument config = DotNetNuke.Common.Utilities.Config.Load();
XmlNode node = config.SelectSingleNode("configuration/system.web/machineKey");

return ps.Decrypt(node.Attributes["decryptionKey"].InnerText, data);
}

///
/// DecryptXml decrypts an Xml file. This method will decrypt the file and then save it to the specified location. If you
/// do not want your original file overwritten, then do not use this method.
///

/// The path of the encrypted Xml file.

public void DecryptXml(string file)
{
sLoc = Server.MapPath("web.config");
Config.Load(sLoc);

XmlNode xNode = Config.SelectSingleNode("configuration/system.web/machineKey");

CspParameters cspParams = new CspParameters();

cspParams.KeyContainerName = xNode.Attributes["validationKey"].InnerText;
cspParams.Flags = CspProviderFlags.UseMachineKeyStore;

RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.PreserveWhitespace = true;
xmlDoc.Load(file);

EncryptedXml eXml = new EncryptedXml(xmlDoc);
eXml.AddKeyNameMapping(xNode.Attributes["decryptionKey"].InnerText, rsaKey);

eXml.DecryptDocument();

try
{
xmlDoc.Save(file);
}
catch (XmlException ex)
{
DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
}
}

///
/// This version of DecryptXml will decrypt a given Xml file for use in memory. If the file needs to be saved, it is up to the calling program to handle that.
///

/// The encrypted Xml document that must be decrypted
/// The node within the document that is to be decrypted

public XmlDocument DecryptXml(XmlDocument xDoc)
{
sLoc = Server.MapPath("web.config");
Config.Load(sLoc);

XmlNode xNode = Config.SelectSingleNode("configuration/system.web/machineKey");

XmlDocument xmlDoc = xDoc;

CspParameters cspParams = new CspParameters();

cspParams.KeyContainerName = xNode.Attributes["validationKey"].InnerText;
cspParams.Flags = CspProviderFlags.UseMachineKeyStore;

RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);

EncryptedXml eXml = new EncryptedXml(xmlDoc);
eXml.AddKeyNameMapping(xNode.Attributes["decryptionKey"].InnerText, rsaKey);

eXml.DecryptDocument();

return xmlDoc;
}

///
/// This method will determine if the "EncryptedData" node exists. If so, then this file has been encrypted.
///

/// The xml file to test for encryption.
/// TRUE OR FALSE

public static bool IsXmlEncrypted(XmlDocument xDoc)
{
XmlElement eData = xDoc.GetElementsByTagName("EncryptedData")[0] as XmlElement;

if (eData != null)
return true;
else
return false;
}

Tuesday, June 14, 2011

Reseed the Auto increment field

You can reseed the Auto increment field to the desired number by using the following SQL statement -
[I think it is specific for SQL Server only] other Database have their own methods.

Syntax :-

DBCC CHECKIDENT ("TableName", RESEED, 0)

Sunday, May 29, 2011

jQuery !!

jQuery is a library that makes it quicker and easier to build JavaScript webpages and web apps. I often find myself short of pleased with the built in functionality of AJAX and having to do some client side “touch ups” using jQuery. The essential part of a jQuery statement, the selector, is what makes jQuery a good choice for client side scripting, and an even better reason to avoid traditional java script. The selector allows you to query HTML elements to perform some logic, hence the name jQuery. Below are some of the common use of selectors.

#id

To select an element by the ID attribute. If the ID contains special character then you can escape them with backslashes. For example to find a text box with ID txtName you can write the following :

$(“#txtName”)

Then you can do any operation on the text box like getting the value or changing the css class.

element

To find all the elements in the page with the given element name. For example to get all the DIV elements following is the syntax

$(“div”)

This will find all the DIVs present in the page. You can do any operation after that.

.class

To find all elements with the given class name. The following code finds all the elements which have class name ‘RedButton’.

$(“.RedButton”)

*
This finds all the elements in the document. The syntax is :-

$(“*”)

selector 1, selector 2, selector N

This matches the combined result of all the specified selectors. We can specify N number of selectors to get a single result. Suppose you want to find all the DIVs, a text box with ID ‘txtName’ and a Button with class name ‘RedButton’. Then following is the syntax:

$(“div, #txtName, .RedButton”)

Suppose you want to change the border color of all these elements then write :

$(“div, #txtName, .RedButton”).css(“border”,”3px solid blue”);

It will change all the specified elements’ border color to blue.

There are some good tools available to test your jQuery selectors on your Apps while debugging in .Net, firebug being the most common (http://getfirebug.com/).

For a more comprehensive overview of jQuery and its syntax use the link provided for W3 schools (http://www.w3schools.com/jquery/default.asp).

jQuery cheat sheet (http://www.javascripttoolbox.com/jquery/cheatsheet/JQueryCheatSheet-1.3.2.pdf).

jQuery video (http://www.youtube.com/watch?v=7eQI90xYez0).

Thursday, May 26, 2011

Install missing templates in the installed Visual Studio templates

One day, I tried to create a new WCF Service Application and when I opened the Visual studio and clicked on Add new project, I found that this project option is missing from my Visual studio templates. To add the missing templates to your current installed templates, you need to run the following command on Visual studio command prompt after closing all the instances of the Visual studio.

devenv/installvstemplates
and then Press Enter.

Let the processing to be completed and then open visual studio. Now all the missing templates would be visible under Visual Studio installed templates.