Friday, June 22, 2007

I thank Asela for helping me to initiate this blog and helping me with editing it with his expertise in web designing. Thanx again.

Thursday, June 21, 2007

Problem Running Bugzilla - Internal Server Error!!

Did everything in the manual, all the configurations to apache httpd.conf file but still getting the Internal Server Error! ?
wel the same thing happened to me too, after strugling for several days, this is the cause of it I found,
as you know you must put the following sataments in the httpd.conf to make .cgi file to run by apache using perl.

AddHandler cgi-script .cgi

Options Indexes FollowSymLinks ExecCGI

ScriptInterpreterSource Registry-Strict

But how does apache know where perl is? the problem is there, you must create registry values for .cgi extension so that apache can use perl to run them.

You can add the followng entries in the registry,

create the following key;


Put 'default' value with the path to perl.exe followed by "-T"

example: C:\Perl\bin\perl.exe -T

Run bugzilla again, things should be ok if you have done other configurations correclty.


Problem with Calculated Members in SSAS

Have you ever experienced disappearing all your data in the cube after putting a calculated member to it?
This strange thing heppened to me once,
I created this simple cube with SSAS, Deployed it and Processed it. After that I browed it with BI studio and the data were diplayed correctly.
Then I added a calculated member and processed the whole project again. Here I have an empty cube with no data. I processed and processed, which didn't make my data come back!!
Then I found the reason for this in MSDN forum
It was a stupid thing I did;
In you cube design screen, in Calculations tab, you have a pane in right hand side called 'Script Organizer' which lists all your scripts. There is one item called 'CALCULATE' by default. I have accidently deleted this item. When you do that it doesn't give any error and the project is processed successfully and the newly added calculated member is diplayed, but it makes the cube to be empty or disappear the data inside the cube.
You can put this 'CALCULATE;' statment either in the script organizer pane or somewhere in the script of your calculated member. Then the problem is solved.