Error when executing Report

Hi all,
I have created about 40 reports that access our core ERP solution. All
these reports function perfectly. In the last day I have created 2 new
reports that access a different server/database thus a new shared datasource
was created. However, I am intermittantly receiving the following error
when I attempt to execute the two new reports:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
a.. Cannot create a connection to data source 'Blah2'.
(rsErrorOpeningConnection) Get Online Help
a.. SQL Server does not exist or access denied.
The reports function everytime in Visual Studio. What is going on?
Thanks
ClintSounds like a security issue. What does your datasource specify for a
username/password?
Steve
"AshVsAOD" wrote:
> Hi all,
> I have created about 40 reports that access our core ERP solution. All
> these reports function perfectly. In the last day I have created 2 new
> reports that access a different server/database thus a new shared datasource
> was created. However, I am intermittantly receiving the following error
> when I attempt to execute the two new reports:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> a.. Cannot create a connection to data source 'Blah2'.
> (rsErrorOpeningConnection) Get Online Help
> a.. SQL Server does not exist or access denied.
> The reports function everytime in Visual Studio. What is going on?
> Thanks
> Clint
>
>|||I thought that too. I have changed the datasource to be both shared and
custom. The username and password are correct. I am at a loss..
Especially seeing how it is so intermittant.
"SteveIrwin" <SteveIrwin@.discussions.microsoft.com> wrote in message
news:6EC53430-5F17-43A6-BF6C-426CF018CDBC@.microsoft.com...
> Sounds like a security issue. What does your datasource specify for a
> username/password?
> Steve
> "AshVsAOD" wrote:
> > Hi all,
> >
> > I have created about 40 reports that access our core ERP solution. All
> > these reports function perfectly. In the last day I have created 2 new
> > reports that access a different server/database thus a new shared
datasource
> > was created. However, I am intermittantly receiving the following error
> > when I attempt to execute the two new reports:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
Get
> > Online Help
> > a.. Cannot create a connection to data source 'Blah2'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. SQL Server does not exist or access denied.
> > The reports function everytime in Visual Studio. What is going on?
> >
> > Thanks
> > Clint
> >
> >
> >|||Not sure whether this will help. When u deploy the shared datsource to the
reportserver, try inputting the connection info and then run the report. I
had the same issue, and the connection trying the dba changed pointed to a
different instance..
Suresh
"AshVsAOD" wrote:
> I thought that too. I have changed the datasource to be both shared and
> custom. The username and password are correct. I am at a loss..
> Especially seeing how it is so intermittant.
> "SteveIrwin" <SteveIrwin@.discussions.microsoft.com> wrote in message
> news:6EC53430-5F17-43A6-BF6C-426CF018CDBC@.microsoft.com...
> > Sounds like a security issue. What does your datasource specify for a
> > username/password?
> >
> > Steve
> >
> > "AshVsAOD" wrote:
> >
> > > Hi all,
> > >
> > > I have created about 40 reports that access our core ERP solution. All
> > > these reports function perfectly. In the last day I have created 2 new
> > > reports that access a different server/database thus a new shared
> datasource
> > > was created. However, I am intermittantly receiving the following error
> > > when I attempt to execute the two new reports:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted)
> Get
> > > Online Help
> > > a.. Cannot create a connection to data source 'Blah2'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > a.. SQL Server does not exist or access denied.
> > > The reports function everytime in Visual Studio. What is going on?
> > >
> > > Thanks
> > > Clint
> > >
> > >
> > >
>
>sql

Error when changing sa password or when trying to access DB via sa

Hi,
Two weird things with the sa account, and I found a solution on
Microsoft.com, but it's not working.
First, when I go to change the SA password in Enterprise Manager, I
get the following error:
Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
collection. If the name is a qualified name, use [] to separate
various parts of the name, and try again.
So, I checked the knowledgebase and found this:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
This is the exact issue I'm having, but when I run: sp_changedbowner
sa
... I get the following message in Query Analyzer:
Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
22
Cannot change the owner of the master database.
So, I searched for this error and found this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
Catch-22... I need to change the Master DB to be owned by 'sa', yet it
won't let me change it since it's not already owned. Am I missing
something? This did happen just after I restored a database, just as
discribed in the first support doc, but it gives no exact syntax on
what to plug into Query Analyzer to resolve the issue, other then
using the sp_changedbowner stored procedure. And I must be using it
incorrectly to get the error, or it's another bug in MS SQL.
Can someone point me to the right direction? What should be an easy
back-up and restore is turning into a multi-hour ordeal.
Thanks,
Alex.If your a local admin or domain admin connect to the SQL Server using Query
Analyser and ask for a 'WinNT Authentication' then issue the following
command
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
In EnterPrise manager Delete and Re-Register the troublesome server, when
registering use the new password.
--
HTH
Ryan Waight, MCDBA, MCSE
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270835.36d6e245@.posting.google.com...
> Hi,
> Two weird things with the sa account, and I found a solution on
> Microsoft.com, but it's not working.
> First, when I go to change the SA password in Enterprise Manager, I
> get the following error:
> Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
> collection. If the name is a qualified name, use [] to separate
> various parts of the name, and try again.
> So, I checked the knowledgebase and found this:
>
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
> This is the exact issue I'm having, but when I run: sp_changedbowner
> sa
> ... I get the following message in Query Analyzer:
> Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
> 22
> Cannot change the owner of the master database.
> So, I searched for this error and found this:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
> Catch-22... I need to change the Master DB to be owned by 'sa', yet it
> won't let me change it since it's not already owned. Am I missing
> something? This did happen just after I restored a database, just as
> discribed in the first support doc, but it gives no exact syntax on
> what to plug into Query Analyzer to resolve the issue, other then
> using the sp_changedbowner stored procedure. And I must be using it
> incorrectly to get the error, or it's another bug in MS SQL.
> Can someone point me to the right direction? What should be an easy
> back-up and restore is turning into a multi-hour ordeal.
> Thanks,
> Alex.|||Yes, you cannot change database owner to MASTER.
If you run sp_helpuser on your restored database, should
show the "LoginName" as NULL if 'sa' do not own it.
You only needed to run sp_changedbowner on your restored
database. -->
use <restored_db>
go
sp_changedbowner 'sa'
go

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2000 on them, and am getting exactly the same error on all 3.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2
000 on them, and am getting exactly the same error on all 3.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.