.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Project Server 2007 Cube Building Error

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server



I have no experience with MDX and it appears that during the cube building process for Project Server 2007 there seems to be some deficient MDX scripts.  I looked at the SASS logs with no luck and looked in the application logs with no luck.  I scripted out the problematic cube MSP_Portfoilio_Analyzer and found the 'Reported' syntax but don't really know how to correct or if there is even a problem.  The cube has built in the past with no problems.  Any help would be appreciated.


Server build is as follows:

Microsoft SQL Server 2005 - 9.00.3200.00 (X64)   Oct  2 2007 12:23:02   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)  


The server has both SQL Server and SSAS installed.

View Complete Post

More Related Resource Links

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Building Records Management Solutions with SharePoint Server 2007

Learn records management features and concepts, such as Records Center configuration, and records series planning and routing, and explore the Official File Web service and a sample client application to create and deploy a custom router with a routing type.

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

Problem create a web application on SharePoint 2007 (Project Server 2007)

I installed a Project Server 2007 in a 3 server structure (all Win 2003 sp2; one for App server hosting Central Admin, Project Server service & Search service; one for web server; one for database server).  They are only in the same domain and I use the same network account for the installation as well as the WSS service account.  The same network are local admin for those 3 servers. All installation & patches seem ok (at least I don't get error messages) until I attempt to create my first Web Application.  After I filled out the web appliction and try to click OK, the page does not change and i saw the java error at the right bottom corner from my IE browser (version 6). The message is .... Line: 1686 Char: 1 Error: 'WebForm_PostBackOptions' is undefined Code: 0 URL: http://myservername:28804/_admin/extendvs.aspx On my SP log, below are the portion of the log when the error happen. 09/09/2010 12:28:29  1  INF        Entering function UserInterface.ShowCentralAdmin 09/09/2010 12:28:29  1  INF          The show central admin command has been chosen 09/09/2010 12:28:29  1  INF          Searching for registry key Software\Microsoft\Shared Tools\Web Server Extensions\12.0\WSS\CentralAdministrati

error when installing sharepoint server 2007 on Windows server 2008 r2

I ve tried to install sharepoint server 2007 on server 64 bit with windows server 2008 r2,but it gave me compatibilty error

Sql error+sharepoint server 2007 installation on windows server 2008 r2


I am trying to install sharepoint server 2007 on windows server 2008 r2,I downloaded the version of sharepoint that contains service pack2,after the installation finished,message displayed that mssql\officeservers cant be found?

Must I install sql server 208 before installing sharepoint,is sql express that is already installed with sharepoint 2007 not compatible with windows server 2008 r2

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x


I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.


but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:

It means that I can not process the cube using the same method any more ?

Installing Microsoft Office SharePoint Server 2007 on Windows 7, getting error please help

Hi all Installing Microsoft Office SharePoint Server 2007 on Windows 7 Ultimate 32-bit, getting error "Windows Server 2003 sp1" is required for this product, any help please.

Sharepoint server 2007 Implement SSl Error


Hi ,

i am trying SSl implement Sharepoint server 2007 server existing web application after create certifiacre . IIS 6.0 .i got below error

The page must be viewed over a secure channel

The page you are trying to access is secured with Secure Sockets Layer (SSL).

Please try the following:

  • Type https:// at the beginning of the address you are attempting to reach and press ENTER.

HTTP Error 403.4 - Forbidden: SSL is required to view this resource.
Internet Information Services (IIS)

Technical Information (for support personnel)

  • Go to Microsoft Product Support Services and perform a title search for the words HTTP and 403.
  • Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Secure Sockets Layer (SSL), and About Custom Error Messages.


Surendra Singh


Surendra Singh

"Error in PortalCrawl Web Service." error while crawling People on MOSS 2007 from Sharepoint Server


Hi All,

I am getting "Error in PortalCrawl Web Service. " error while crawling people [SSP] on MOSS 2007 box from Sharepoint 2010 box.

NOTE: I am able to crawl People i.e SSP application on other MOSS 2007 box successfully by following same steps which i am using to crawl above mentioned SSP which is giving error.

If anyone has faced similar error ,please suggest.



"Error in PortalCrawl Web Service." error while crawling People on MOSS 2007 from Sharepoint Server


Hi All,

I am getting "Error in PortalCrawl Web Service. " error while crawling people [SSP] on MOSS 2007 box from Sharepoint 2010 box.

NOTE: I am able to crawl People i.e SSP application on other MOSS 2007 box successfully by following same steps which i am using to crawl above mentioned SSP which is giving error.

If anyone has faced similar error ,please suggest.



Project server 2007 "Project Application Service " can not start


Hi, all

I have a sharepoint 2007 installed on server 2008,it works ok

,today I tried to installed project server 2007 (sp2)on it , it also is ok

but when I try to to start the "Project Application Service " to start project server

It also return back to stop.

I found the article from the web

but My server is windows 2008, the document and setting  can not access

Microsoft Project Server Frequently Asked Questions (FAQs): Overview

FAQ Title: Unable to start project application service after installation

Applies To: Server 2007
Group: Common Errors

Microsoft Project Server Frequently Asked Questions (FAQs): Details
Background Description

When you install Project Server 2007 the installation appears successful, but you are unable to start tgeProject Application Service from the "Services on Server" page.  Clicking the Start link causes the "Operation in Progress" page to display temporarily and then returns with the status unchanged.  


This may be related to permissions

Parameter error writing to excell 2007 file using SQL 2008 Server Agent JOB, works in BIDS.


I am getting the following error message when I try to run a script that writes to an excel file calling my Package with a SQL 2008 JOB.

Executed as user: xxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Option "12.0;HDR=YES;" is not valid.  The command line parameters are invalid.  The step failed.

This same package runs correctly if I execute it in dev mode in BIDS.  I had to set 64bitmode to false in Dev mode to get it to work.  I set executable options in the job step to 'run in 32 bit mode'  The error message indicates to me it is trying to run in 32 bit mode which should be correct but it doesn't like the extended parameters. .   

Here is my connection string from the data sources tab on the job

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\xxxx.xlsx;Extended Properties="EXCEL 12.0;HDR=YES";

This was filled in ny the connection object for me.  I have read the article closely at http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html and still can't figure out what I need to change. 

Error saving Office 2010 files opened from SharePoint Server 2007


I have recently started testing Office 2010 and have found only 1 major issue - I cannot save any Office 2010 files opened from a SharePoint Server 2007 location.  Upon save I receive an error message saying "Upload Failed. This file wan not uploaded because the specified path was not found on the server." and the file is captured in the Microsoft Upload Center.  Using the Upload Center action 'Open Web Site' opens the site without problem; however, a all subsequent resolve actions fail.  Any ideas?


  * MS Windows Server 2003 R2
  * MS SQL Server 2008 R2
  *Office SharePoint Server 2007
  *MS Office 2010 Premium

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend