Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

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

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

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

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

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

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error In Merge Replication while server syncs

At first we received error like

"The merge process could not retrieve identity range resource for table..."

then after solving this error we again started syncing of servers manually then we got some other error like

"the process could not enumerate changes to the subscriber".

We tried our best to solve this problem but some error appears each time like

"The process could not deliver the snapshot to the Subscriber."

"The schema script 'sync -t"Design" -o"dbo" -d"\\ECOSYSTEM\D$\FTP\MSSQL\EcoSystem\ftp\ECOSYSTEM_MLEcosystem_MLEcosystem\20060619204802\Design_1337.bcp" -hORDER( [intDesignId] ASC)' could not be propagated to the subscriber"

again identity erroe emerges and agin we do the same process.

How to solve these problem?

These look like transitory network issues. Can you set QueryTimeout to something larger and see if this solves the problem.

-- Hilary Cotter

Error in Merge replication "The schema script..."

I'm trying to set up a merge replication. Publication is created successfully and snapshot also, but when I create pull subscription on subscriber server and merge agent starts, after some time I get an error message of this type:

The schema script '\\ANIL\REPLDATA\unc\ANIL_BEJK_BEJK\20070625142735\dl_HF_vMSCene_3836.sch' could not be propagated to the subscriber.

It seams there is a problem with certain Views and SPs, because tables are successfully created, and some Views and SPs also.

I tried to exclude problematic articles, but every time another one pops up. Up until now, I excluded 7 articles from publication (1 Stored Procedure and 6 Views) but I still get errors.

I gave up because I can't exclude half of the Views and SPs just to make it work.

Is there something that can be done to solve this problem?

Thanks!
Does your SQL Server agent account have rights to read the share \\anil\repldata? Ensure that this account also has rights to list files and folders on the physical drive underlying \\anil\repldata.

If you are using a push subscription it should be the SQL Server agent account on the publisher. If you are using a pull subscription is should be the SQL Server agent account on the subscriber.|||

Hi Hilary

Sharing permisions were set to Read/Write to "Everyone", and security permisions also Read/Write to "Everyone", but it didn't work until I added an account on subscriber computer (which is not in domain) with same username and password as one that exists on publisher (which is in domain). I set SQL Server Agent to use that account and everything started to work fine.

I'm connecting to publisher using the VPN, and despite the fact that those two accounts are not from the same domain, everything is working fine. This is a little bit confusing. It looks like domain name doesn't play any role when logging in to shared folder.

Thanks for the help.

Anil

Error in Merge replication "The schema script..."

I'm trying to set up a merge replication. Publication is created successfully and snapshot also, but when I create pull subscription on subscriber server and merge agent starts, after some time I get an error message of this type:

The schema script '\\ANIL\REPLDATA\unc\ANIL_BEJK_BEJK\20070625142735\dl_HF_vMSCene_3836.sch' could not be propagated to the subscriber.

It seams there is a problem with certain Views and SPs, because tables are successfully created, and some Views and SPs also.

I tried to exclude problematic articles, but every time another one pops up. Up until now, I excluded 7 articles from publication (1 Stored Procedure and 6 Views) but I still get errors.

I gave up because I can't exclude half of the Views and SPs just to make it work.

Is there something that can be done to solve this problem?

Thanks!
Does your SQL Server agent account have rights to read the share \\anil\repldata? Ensure that this account also has rights to list files and folders on the physical drive underlying \\anil\repldata.

If you are using a push subscription it should be the SQL Server agent account on the publisher. If you are using a pull subscription is should be the SQL Server agent account on the subscriber.|||

Hi Hilary

Sharing permisions were set to Read/Write to "Everyone", and security permisions also Read/Write to "Everyone", but it didn't work until I added an account on subscriber computer (which is not in domain) with same username and password as one that exists on publisher (which is in domain). I set SQL Server Agent to use that account and everything started to work fine.

I'm connecting to publisher using the VPN, and despite the fact that those two accounts are not from the same domain, everything is working fine. This is a little bit confusing. It looks like domain name doesn't play any role when logging in to shared folder.

Thanks for the help.

Anil

Error in Merge Replication

Hi,

I have made two subscription in Merge Replication .

One Subscription is syncing data properly while other on is giving error

'The process could not enumerate changes at the 'Publisher'. error -2147200999

MS SQL Server Service Pack 4 is installed.

Now how can resolve it.

Thanks

Sanjay Tiwari

Is this an immediate error, or does it happen after a long time? If the latter, then increase the querytimeout parameter for the merge agent.

Error in Merge Agent Replication

Dear All,
while connecting the merge agent after updates in the
subscriber , the following error occured
'the process could not enumerate changes at the subscriber'
Any reason why this error appears?
Waiting for ur feedback.
Thanks in advance
Dalia,
Could you enable logging on the merge agent (-output
c:\somefile.log -outputverboselevel 3) and we can see if
there is any more info to help.
Regards
Paul Ibison
|||does the error message complain about any missing stored procedures?
90% or more of merge replication errors can be clear by simply restart your merge agent. Can you try this to see if it clears the error message.