Moved my blog to Wordpress

Guys, i have moved my blog to http://ammarfassy.wordpress.com/

MCTS : BizTalk Server 2006

Well i sat for the MCTS 70-235 (Developing Business Process and Integration Solutions using Microsoft BizTalk Server 2006) exam yesterday and glad to inform that i have passed. mmm.. with regard to the paper, most of the questions were related to BAM, BRE, deploying a BizTalk application, debugging BizTalk applications (ex: debugging orchestration, etc), some of them related to schema creation (ex: minoccurs, validating a schema, etc), role links and general BizTalk questions.

Before sitting for the exam just go through the sarvanas’ preparation diary. It helped me a lot in addition to the following Apress and Wrox eBooks :

• BizTalk 2006 Recipes - A Problem-Solution Approach - Mark Beckner, Benjamin Goeltz, Brandon Gross,
  Brennan O’Reilly, Stephen Roger, Mark Smith,
  and Alexander West
• Foundations of BizTalk Server 2006 - Daniel Woolston
• Wrox Professional BizTalk® Server 2006
• - Darren Jefford, Kevin B. Smith, Ewan Fairweather

hope i can use the following image. :)

Rule "Reporting Services Catalog Database File Existence" failed

Due to some reason i had to reinstall the SQL Server 2008 and when setup validates the installation it prompted for following 2 errors as below :

• Rule "Reporting Services Catalog Database File Existence" failed
• Rule "Reporting Services Catalog Temporary Database File Existence" failed.

so what you have to do is to delete following files

• ReportServer.mdf
• ReportServer_log.LDF
• ReportServerTempDB.mdf
• ReportServerTempDB_log.LDF

from the location : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA and re-run the setup.

Error: This row already belongs to another table

I came across a situation where i had to loop through one of the DataTable and to import the same data into another datable where the data order is different. I was trying to do it but the data is not getting copied to the new DataTable. What I have found out is that you can’t just add rows from one DataTable to another. Initially the table structure must be Cloned and then the rows has to be imported. Cloning the DataTable clones the structure including all DataTable schemas and constraints.

DataTable newTable = new DataTable("Sorted");

newTable = transactionHistoryTable.Clone();
for (int j = transactionHistoryTable.Rows.Count - 1; j >= 0; j—)
{
  newTable.ImportRow(transactionHistoryTable.Rows[j]);
}

_dsResponse.Tables.Add(newTable);

as a summary what i am doing is, initially the data what i have is some data in some order which was populated from AS400 API. I need the same data other way around, bottom to top (For ex: transactionHistoryTable has some data and i need to traverse it back).

Failed to connect to the SQL database 'SSODB' on SQL Server

When you tried to configure BizTalk after the successful installation, if you prompted for an error like the one mentioned above, Execute the following command in Visual Studio command prompt.

explore to the following folder:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727>

and run the following command :

RegAsm.exe "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"

Note : As i am using the Windows 2008 R2 Server, i had to explore to the Framework64 folder.

Calling AS400 RPG Programs using C#

Throughout last few months i had a chance to work with AS400, Equation APIs. The purpose of these equations calls are that we have to develop WCF services on top of these API calls. These calls will be consumed by the BizTalk. Initially it was too hard as i couldn't find any resources online. When i searched in gOOgle about the errors which come across at the time of developments, it does not return anything! It was some hard times and thank for my team lead for helping out on those situations. Hope to write something about  AS400, C# in coming days…

Here is the lovely interface of Equation.

As the starting point refer following links :

http://www.netsplore.com/PublicPortal/Default.aspx?tabid=246

http://www.netsplore.com/PublicPortal/Blog/tabid/284/EntryID/13/Default.aspx

Error 4201: The instance name passed was not recognized as valid by a WMI data provider

I was unable to start the Windows Event Log service on Local Computer. When i tried to start the windows event log service was getting  “Windows could not start the Windows Event Log service on Local Computer.    Error 4201: The instance name passed was not recognized as valid by a WMI data provider.”

This happened at the time of installing MOSS 2007 in my Windows Server 2008 R2 Server machine. Totally i was gone mad coz MOSS 2007 uninstallation crashes due to some reason and was unable to find out the error due to Eventlog crash (what a hell).

Finally figured it out it was due to some permission problem and i had to apply the  SYSTEM user with full control on the folder c:\windows\system32\logfiles\wmi\RTbackup. This solved my problem and the lovely event log was working fine as usual.

more details

Another alternative way is there to renaming the RTBackup file. I didnt try that method hence i have to start the machine in safe mode. It will be a headache at all. so for anyone needs to know about that solution please refer this link.