Another Snap shot for publication is running ?

i was doing replication on SQL 7, both my pulisher and subscriber was SQL 7
and the replicatoin was happening without any problem.Then i upgraded it to
SQL 2000 and restore the backup which was taken on SQL7.
After that when i am starting my agent then it is giving thie error "ANOTHER
SNAPSHOT AGENT FOR THE PUBLICATION IS RUNNING"
Please let me know hot to fix this problem as my complete setup is down.
Thanks & Regards
Asif
There are some reports that this was caused by an incomplete application of
a SQL 7 SP.
With this in mind, perhaps the best option is to script out your
publication(s), and subscriber(s), and then drop them, disable replication,
reenable it, and rerun your publication and subscription scripts.
"Asif" <Asif@.discussions.microsoft.com> wrote in message
news:BCCBF6A0-3EFB-459F-9C58-A0FC19FF2F46@.microsoft.com...
> i was doing replication on SQL 7, both my pulisher and subscriber was SQL
7
> and the replicatoin was happening without any problem.Then i upgraded it
to
> SQL 2000 and restore the backup which was taken on SQL7.
> After that when i am starting my agent then it is giving thie error
"ANOTHER
> SNAPSHOT AGENT FOR THE PUBLICATION IS RUNNING"
> Please let me know hot to fix this problem as my complete setup is down.
> Thanks & Regards
> Asif
|||Thanks for the reply.
Our SQL servers are SQL 2000 from ground up. No SQL7 SPs should be around.
In fact, I eventually was able to reproduce it. The tricky option is on the
Snapshot tab on publication properties - If you check "Do not lock tables
during snapshot generation...", that's when it happened. Without check the
option, you get a normal sp_MSins.
But I still couldn't figure out what exactly this has helped not to block
the table.
Richard
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eO#6xBstEHA.2948@.TK2MSFTNGP15.phx.gbl...
> There are some reports that this was caused by an incomplete application
of
> a SQL 7 SP.
> With this in mind, perhaps the best option is to script out your
> publication(s), and subscriber(s), and then drop them, disable
replication,[vbcol=seagreen]
> reenable it, and rerun your publication and subscription scripts.
>
> "Asif" <Asif@.discussions.microsoft.com> wrote in message
> news:BCCBF6A0-3EFB-459F-9C58-A0FC19FF2F46@.microsoft.com...
SQL
> 7
> to
> "ANOTHER
>
|||It still locks the tables with that box checked. You can see the lock
requests if you watch.
"Richard Ding" wrote:

> Thanks for the reply.
> Our SQL servers are SQL 2000 from ground up. No SQL7 SPs should be around.
> In fact, I eventually was able to reproduce it. The tricky option is on the
> Snapshot tab on publication properties - If you check "Do not lock tables
> during snapshot generation...", that's when it happened. Without check the
> option, you get a normal sp_MSins.
> But I still couldn't figure out what exactly this has helped not to block
> the table.
>
> Richard
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eO#6xBstEHA.2948@.TK2MSFTNGP15.phx.gbl...
> of
> replication,
> SQL
>
>

Analysis Services 2005 Aggregations?

Hi,

When i try to calculate the cube aggregations it will always give me 0 aggregations... why is this happening? I have about 10 dimensions and if i remove 3 of them (always the same dims) the aggregations are calculated to about 99% so why the hell with that dims it would not calculate? They are Parent-Child Dimensions...

Best Regards,

Luis Sim?es

Looks like a bug to me.

Can you please try and contact Customer Support and open a case about this behavior. It would be helpful if you will be willing to share your cube design.

Thanks.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

How do i contact Customer Support?

About the cube i really can't post anything about it because it is beeing done to a major public entity and i have no authorization to pass schemas, designs or data out of here...

So is there anyway we can synch and try to find the problem?

Best Regards,

Luis Sim?es

|||

http://support.microsoft.com/ph/2855

See if you pass the information to Customer Support in more general terms. How many dimensions, how many attributes per dimension. How many hierarhies in every dimension.
To try and reproduce the problem in generic version of your cube.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

I am doomed! The cube is so slow that i can't do anything with it... Jesus....

Has for the microsoft site i was unable to find a direct way of contact with them unless i have to pay for support...

Do you have any sugestions?

U have msn?

Regards

|||

Luis.

It is really hard or nearly impossible to help you with very short description of the problem.
It is even harder to help if you cannot share any of your data.

Can you try and describe your cube design in general terms like:

Dim1 ( KeyAttr, Attr1 , Attr2 ....) Parent-Child
Attr1 is related to KeyAttr and usage is set to Parent.

Dim2 (KeyAttr, Attr1 , Attr2 ) Regular
Hierarchies Hier1 (Attr2, Attr1, KeyAttr)

....

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Well i am shure now that the problem lays within the Parent-Child Dimensions because i have created new dimensions for the same purpose but flattened.. no parent-child and the cube gets 95% aggregated...

So basically all my Parent-Child Dimensions are done like the book says...

So i have A Parent Atribute and a Key Atribute

Example: Products Dimension

PARENT_PRODUCT_COD -> this is the parent atribute

PRODUCT_COD -> this is the key atribute

In the parent atribute i also have parameterized the UNARY OPERATOR and ROLLUP FORMULA with the correct columns

So i don't really know where is the problem...

Regards,

|||

The solution for your problem ( I got better description of it through the MS guys in Portugal) is:

For every PC dimension you should change AggregationUsage property of the Parent attribute to None.
For every Key attribute you should set AggregationUsage to Unrestricted.

Once you've done this, you should see aggregation desing algorithm desinging aggregations for you.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

I have received from Jose Silva (MS Portugal) the changed project, after calculating the aggregations i still get 0%....

It seems it is a known bug by AS 2005 programmers team and probably only solved by a hotfix...

Lets see what happens in the next days... and then i will post the result here so the community can be informed about this problem.

Thank you!

Best Regards,

Luis Simoes
WorldVision Consulting

Analysis Services 2005 Aggregations?

Hi,

When i try to calculate the cube aggregations it will always give me 0 aggregations... why is this happening? I have about 10 dimensions and if i remove 3 of them (always the same dims) the aggregations are calculated to about 99% so why the hell with that dims it would not calculate? They are Parent-Child Dimensions...

Best Regards,

Luis Sim?es

Looks like a bug to me.

Can you please try and contact Customer Support and open a case about this behavior. It would be helpful if you will be willing to share your cube design.

Thanks.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

How do i contact Customer Support?

About the cube i really can't post anything about it because it is beeing done to a major public entity and i have no authorization to pass schemas, designs or data out of here...

So is there anyway we can synch and try to find the problem?

Best Regards,

Luis Sim?es

|||

http://support.microsoft.com/ph/2855

See if you pass the information to Customer Support in more general terms. How many dimensions, how many attributes per dimension. How many hierarhies in every dimension.
To try and reproduce the problem in generic version of your cube.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

I am doomed! The cube is so slow that i can't do anything with it... Jesus....

Has for the microsoft site i was unable to find a direct way of contact with them unless i have to pay for support...

Do you have any sugestions?

U have msn?

Regards

|||

Luis.

It is really hard or nearly impossible to help you with very short description of the problem.
It is even harder to help if you cannot share any of your data.

Can you try and describe your cube design in general terms like:

Dim1 ( KeyAttr, Attr1 , Attr2 ....) Parent-Child
Attr1 is related to KeyAttr and usage is set to Parent.

Dim2 (KeyAttr, Attr1 , Attr2 ) Regular
Hierarchies Hier1 (Attr2, Attr1, KeyAttr)

....

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Well i am shure now that the problem lays within the Parent-Child Dimensions because i have created new dimensions for the same purpose but flattened.. no parent-child and the cube gets 95% aggregated...

So basically all my Parent-Child Dimensions are done like the book says...

So i have A Parent Atribute and a Key Atribute

Example: Products Dimension

PARENT_PRODUCT_COD -> this is the parent atribute

PRODUCT_COD -> this is the key atribute

In the parent atribute i also have parameterized the UNARY OPERATOR and ROLLUP FORMULA with the correct columns

So i don't really know where is the problem...

Regards,

|||

The solution for your problem ( I got better description of it through the MS guys in Portugal) is:

For every PC dimension you should change AggregationUsage property of the Parent attribute to None.
For every Key attribute you should set AggregationUsage to Unrestricted.

Once you've done this, you should see aggregation desing algorithm desinging aggregations for you.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

I have received from Jose Silva (MS Portugal) the changed project, after calculating the aggregations i still get 0%....

It seems it is a known bug by AS 2005 programmers team and probably only solved by a hotfix...

Lets see what happens in the next days... and then i will post the result here so the community can be informed about this problem.

Thank you!

Best Regards,

Luis Simoes
WorldVision Consulting