Mike-
Can you please send me a copy of the solution document to (e-mail address removed)...Thanks
MikeRM wrote:
Hi Christophe,Thanks for your help.
22-Dec-08
Hi Christophe
Thanks for your help
Upon reading all the documents, I doubled checked the issue of project
server and its connectivity from SQL server. I have just found this error in
the event log
Event Type: Erro
Event Source: Office SharePoint Serve
Event Category: Project Server Analysis Cube Building
Event ID: 768
Date: 23/12/200
Time: 11:45:34 A
User: N/
Computer: PROJECT0
Description
Standard Information
SI Entry Point:
Project User: RMTP\suppor
Correlation Id: 5084e6d6-e401-42fb-9ff4-7eaf77632f4
PWA Site URL:
http://project01/PW
SSP Name: ProjectServer_SS
PSError: CBSASConnectionFailure (17003
Cube build failed to connect to the Analysis Services server. Verify the
data source connection is valid. Error: Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=rmtp-project01
ASDBName=officeservers ASExtraNetAddress=rmtp-project01 RangeChoice=0
PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=12/19/2008 15:21:16
ToDate=12/19/2008 15:21:16 HighPriority=Tru
Does this help isolate what we still need to do to get it working
Many Thank
Mik
:
Previous Posts In This Thread:
Error: Cannot connect to Analysis Services version '10.0.1600.22'.
Hi
We have been unable to get the Analysis Services to work on a fresh install
of Project Server 2007 and SQL 20008 on a single box, we get the following
error
Analysis Services session failed with the following error: Failed to connect
to the Analysis Services server rmtp-project01. Error: Cannot connect to
Analysis Services version '10.0.1600.22'
This is what we have done
1. Re-fresh the server OS
2. Enable IIS services 6.0 then Install MS .NET Framework 3.
3. Install the WindowsServer2003-KB942288-V4-x64.exe (Windows Installer for
SQL2008)
4. Install MS .NET Framework 3.
5. Install SQL 2008, Upgrade Advisor, Native Client, Policies, Browser,
Setup Support, Books online,
6. Install SQL Server 2005 Analysis Services 9.0 OLEDB Provide
7. Install SQL Server 2005 Backward compatibilit
8. Install SQL Server
Native Clien
9. Install SQL Server Management Object Collectio
10. Install SQL Server Setup Support File
11. Install SQL Server VSS Write
12. Install Office Server/Project Server 200
13. Install Sharepoint SP1 updates - kb93698
14. Office Server SP1 updates - kb93698
15. Infrastructure update for MSOffice Servers - kb95129
16. Configure OLAP (
http://technet.microsoft.com/en-us/library/dd285466.aspx
17. Install MS SQL 2005 SP3
Can anyone explain what we need to do to get it running? It would be a nice
Christmas present
Many Thank
Mike
Re: Error: Cannot connect to Analysis Services version '10.0.1600.22'.
Check this blog post I did
http://blogs.msdn.com/chrisfie/arch...pc-running-on-sql-2005-to-sql-server-2008.asp
basically you need the Feature Pack SP3 for SQL 200
--
Christophe Fiessinge
Microsof
http://blogs.msdn.com/chrisfi
Hi Christophe,Thanks for your help.
Hi Christophe
Thanks for your help
Upon reading all the documents, I doubled checked the issue of project
server and its connectivity from SQL server. I have just found this error in
the event log
Event Type: Erro
Event Source: Office SharePoint Serve
Event Category: Project Server Analysis Cube Building
Event ID: 768
Date: 23/12/200
Time: 11:45:34 A
User: N/
Computer: PROJECT0
Description
Standard Information
SI Entry Point:
Project User: RMTP\suppor
Correlation Id: 5084e6d6-e401-42fb-9ff4-7eaf77632f4
PWA Site URL:
http://project01/PW
SSP Name: ProjectServer_SSP
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the
data source connection is valid. Error: Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=rmtp-project01
ASDBName=officeservers ASExtraNetAddress=rmtp-project01 RangeChoice=0
PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=12/19/2008 15:21:16
ToDate=12/19/2008 15:21:16 HighPriority=True
Does this help isolate what we still need to do to get it working?
Many Thanks
Mike
:
Connectivity errors are typically due to the wrong version of the components
Connectivity errors are typically due to the wrong version of the components
required.
Again the SQL 2005 SP3 feature pack should address this issue, also read
this:
http://technet.microsoft.com/en-us/library/dd285466.aspx
--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie
Hi Christophe,We have already fully installed 2005 SP3 and we see no
Hi Christophe,
We have already fully installed 2005 SP3 and we see no difference when we
run cube build.
We have double checked the SSP admin account and rights and all looks
correct following
these instructions
http://technet.microsoft.com/en-us/library/dd285466.aspx
We are a loss for what to try next as we have followed instructions to the
letter.
The only thing we have found is that we noticed from your blog article that
you recommend installing Sharepoint server before SQL2008
http://blogs.msdn.com/chrisfie/arch...e-with-sql-server-2008-analysis-services.aspx
We followed the Technet instructions and installed SQL2008 and then
installed Project Server. Could this be significant?
Many Thanks
Mike
:
Hi Christophe,In looking through the Implementing and Administering PS2007
Hi Christophe,
In looking through the Implementing and Administering PS2007 book we noticed
that we should expect to see an MSOLAP group but we don't, so we are unable
to add our admin user to the group. I think this may be our problem.
How should we add the OLAP group?
Thanks again
Mike
the order should not make a difference-- Christophe
the order should not make a difference
--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie
Re: Error: Cannot connect to Analysis Services version '10.0.1600.
Please ignore that last post, according to the technet article
(
http://technet.microsoft.com/en-us/library/dd285466.aspx
) it is not relevant to SQL2008 installs.
Essentially we have fully installed SQL Server 2008 including Feature Pack
then applied the SQL2005 components with SP3 following the technet article
exactly, taking the SQL2008 option
Some more pointers (ref technet article):
"Edit the Analysis Services DSO configuration" - we do not see an "AS2008"
entry in the msmdsrv.ini file
"Determine SQL Server Analysis Services named Instance port number" - we do
not see a populated <Instances> entry in in the Msmdredir.ini file
Can anyone offer any advice of what we should try?
Thanks
Mike
We have finally fixed this problem with some help.
We have finally fixed this problem with some help. I have a solution document
from the consultant. Please post here if you need help and I will forward a
copy
:
Plese help
Hi I am having the same issue. It would be very much appreciated if you can send me the pocess you can send me the process you followed to resolve this issue.
Plese help
Hi I am having the same issue. It would be very much appreciated if you can send me the pocess you can send me the process you followed to resolve this issue.
need help
Hi
I am having the same problem. Can send me the process you followed to resolve this issue.
same issue.
Can send me the process you followed to resolve this issue. I can connect to the cube and create a new one but cannot refresh it.
Cannot connect to Analysis Services version '10.0.1600.22'
I am having a similar problem
Please send me the document that helped you solve your problem
Thanks
Re: Error: Cannot connect to Analysis Services version '10.0.1600.
Could you forward a copy please
:
Fixed.
Fixed. We had DSO\LocksDirectory and DSO\RemoteLocksDirectory file paths in
the properties of AS, as well as native SQL client. Blanking those two
fields out forced the cube build to use the native SQL client connection
which worked successfully
:
Re: Error: Cannot connect to Analysis Services version '10.0.1600.
Hi Mike, Chri
Can you please forward this document to me at (e-mail address removed)
Thank
-
Manmeet Chaudhar
:
Cannot connect to Analysis Services version '10.0.1600.22'..".
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Cannot connect to Analysis Services version '10.0.1600.22'..".
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Cannot connect to Analysis Services version '10.0.1600.22'..".
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Cannot connect to Analysis Services version '10.0.1600.22'..".
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Cannot connect to Analysis Services version '10.0.1600.22'..".
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Cannot connect to Analysis Services version '10.0.1600.22'..".
Please sent me this document on my email id (e-mail address removed), as i am also facing same problem
Thanks in advance.
Dear Christophe, I am also facing same problem, please send me the the
Dear Christophe
I am also facing same problem, please send me the the document, so that
can resolve the issue
Regards
Gurdarshan Sing
+91989139779
:
Error: Cannot connect to Analysis Services version '10.0.1600
Hi Mike
I am facing exactly same problem. It will be very kind of you to send me your solution document
Thank
Greetings
Claude
Project Server Olap Issue
Can you please send the solution document to me at (e-mail address removed). Thanks
connect to analysis services version 10.0.1600.22
Mike, how exactly is it that we will get magically redirected back to this page? I did not really see that happening before I tried and it definitely did not happen when I tried.
Please send a copy
Mike, I would be greatful if you would send a copy of the solution document. Thank you!
SSAS for Project Cube Building Errors
Mike,
I am having a similar problem.
Please send me the document that helped you solve your problem. (e-mail address removed)
Thanks
Kenny
Fixed the errors...
Basically, the SSP account was no longer an admin of Analysis Services (AS) following a OS patching cycle reboot. The SPP account in AS appeared as a SID. Deleted the SID account and re-added the SSP account, restarted AS and all was good.
Hope this helps...
I was getting the following errors:
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Analysis Cube Building
Event ID: 7682
Date: 6/1/2010
Time: 2:20:32 PM
User: N/A
Computer: PRJCT07
Description:
Standard Information
SI Entry Point:
Project User: DOMAIN\ME
Correlation Id: b66ddcc0-c485-47c6-b3ae-71edcd58bf81
PWA Site URL:
http://project07/PWA
SSP Name: ProjSSP82
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SQLTEST2CLUSTER\PROJECT ASDBName=Project2007Cube ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=06/01/2010 14:19:52 ToDate=06/01/2010 14:19:52 HighPriority=True
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7704
Date: 6/1/2010
Time: 2:20:32 PM
User: N/A
Computer: PRJCT07
Description:
Standard Information
SI Entry Point:
Project User: DOMAIAN\ME
Correlation Id: b66ddcc0-c485-47c6-b3ae-71edcd58bf81
PWA Site URL:
http://project07/PWA
SSP Name: ProjSSP82
PSError: GeneralQueueJobFailed (26000)
A queue job has failed. This is a general error logged by the Project Server Queue everytime a job fails - for effective troubleshooting use this error message with other more specific error messages (if any), the Operations guide (which documents more details about queued jobs) and the trace log (which could provide more detailed context). More information about the failed job follows. GUID of the failed job: 30852718-5800-4e96-aded-cda84135838c. Name of the computer that processed this job: PRJCT07 (to debug further, you need to look at the trace log from this computer). Failed job type: CBSRequest. Failed sub-job type: CBSQueueMessage. Failed sub-job ID: 2. Stage where sub-job failed: (this is useful when one sub-job has more than one logical processing stages).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Fixed the errors...
Basically, the SSP account was no longer an admin of Analysis Services (AS) following a OS patching cycle reboot. The SPP account in AS appeared as a SID. Deleted the SID account and re-added the SSP account, restarted AS and all was good.
Fix continued
Not sure why this page will not let me paste... ,but here goes... Delete the SID account and add your SSP account back in. Then stop and restart Analysis Services... Worked in my situation. I have no understanding as to why the account appeared as a SID in AS, but it did... Also, cube building was working fine prior to the OS update reboot.... Enjoy!
Kenny
Need that help
I am having the same issue with ProjServ 2010 & SQL 2008 trying to build cubes. I would appreciate a copy of that document.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Win a Free License of SandRibbon for Silverlight
http://www.eggheadcafe.com/tutorial...ee-license-of-sandribbon-for-silverlight.aspx