Skip to content

David Zhang's BI Blog

Problems and solutions identified in my BI practise

Internet Explorer cannot display the webpage
  
   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.
 
“Diagnose connection problems”

this usually means that a firewall is runing somewhere between the two computer and is blocking 40681 …the remote firewaqll might be blocking your connection”

In sharepoint server , change the setting of windows firewall to open the port through Windows Firewall.  In Windows Windows Firewall, select “Excptions”, and “Add POrt”.

Problem: I installed MOSS first, it worked well.  Then installed Performancepoint, the dasboard desinger worked well, but sharepoint site could not be loaded. from Event Viewer in Computer Management, I found the following error:

“Could not load file or assembly ‘System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′ or one of its dependencies. The system cannot find the file.”

Reason:  deploying performancepoint on sharepoint site need ASP.Net AJAX extension installed but I only installed .Net 3.5.

Solution : downlaoding ASP.Net AJAX 1.0 and installing it

 

 

Problem: 

Missing SQL Server 2005 Management Studio, Business Intelligence Development Studio. After got back  Business Intelligence Development Studio , there are no BI project template in it.

Reason:  sql server 2005 was intalled after Sql server 2008 express which came with sharepoint

Solution:  gonig to set-up files and double clicking “SqlRun_Tools” exe file.

http://blogs.neudesic.com/blogs/pete_orologas/archive/2006/10/12/416.aspx 

I copied the whole fold form the previous installation in another disk :  C:\Program Files\Microsoft Visual Studio 8

I am using AMPServ5.2.6 and recently installed SQL_2008 on vista 64 bit.  Apache failed to start and error message said ” port80 occupied”.  Using netsate cmd found PID 4  is  related to port 80. I turned off SSRS/SSIS etc., then tried to stop and restart AMPServ, there was not  ” port 80 occupied” error message but apache failed to start again. Then I used Event  Viewer in Computer Management and found the following  log: “The Apache service named  reported the following error:  >>> <Directory “E:/APMServ5.2.0/www/cgi-bin”> path is invalid. ”  Then I changed E: to C: in  the 199 line of C:/APMServ5.2.0/Apache/conf/extra/httpd-ssl.conf: ” Finally apache was started.