March 5, 2017 at 10:51 am
Hello,
I have a Tabular cube in SQL Server 2016 that has partitioning tables, I had to restore it from backup, and when getting everything back to running again. I did so successfully. It was backed up up on 3/1, and had data up to 2/28, and it did not have the Mar17 partition. So after a successful run, I manually copied an existing partition, and renamed it for the Mar17 month, and adjusted the query for the month too, and then processes it manually, and all is well. Now every time the job run, it errors on the manually added partition, with this error:
Process Partition: Error Enter the partition with the ID of the 'partitionname_201703', does not exist in the measure group with the ID of the 'partitionname_2423455342315123' or the user does not have permissions to the access the object.
I look in the partition, partition_manager and partition_template tables and all seems to be square. I've done this before with no issues, so what else can i try and where else can i look?
Many thanks
March 7, 2017 at 9:12 am
Got through it. This was my process, it was the 3rd way i know to deal with populating a partition.
1. Backup Cube
2. Mark w/ value =1 the create partition in partitionmanager table for said partition target and cube
3. Mark 1/ value = 1 the process full partition in partitionmanager table for said partition target and cube
4. Validate the Partitionmanager table. Partitiontemplate and partitions tables have the correct enteries/values for the name1 and name2 of cubename, if not insert
5. Verify data is on SQL Server is in Sub and Ports tables
6. Delete the manually added name1 and name2 partitions on those tables in the target cube
7. Re-start job at step X (partitioning jobs)
8. Patience, takes a while (monitor all executions to see progress and movement to verify a no-hang, or spot error right off the bat)
9. Done - Successful
10. Check the newly added partitions for row count, and date of last process (cleanup and validate)
11. Check the flags were properly cleared in the partitionmanager table for cube name on those fact table partition segments (cleanup and validate
12. Back check with Excel on name1 and name2 count with date
13. Done - Final
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply