Re: 9.10 Upgrade - Database does not support native partitioning (1166 Views)
Reply
Valued Contributor
Posts: 77
Registered: ‎12-17-2008
Message 1 of 14 (1,215 Views)

9.10 Upgrade - Database does not support native partitioning

Upgrading from 9.01 to 9.10 failed at the database upgrade stage.

 

SQL Server 2005 Developer SP4 (is on a 1 box test system).

The management and profile database both errored saying they don't support native partitioning.

 

I have had to go for a clean installation for now and create new databases, which worked ok.

Any reason for the above error?

HP Expert
Posts: 5,074
Registered: ‎01-30-2008
Message 2 of 14 (1,192 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

For BSM you must use SQL Server Enterprise edition that includes native partitioning feature.

Valued Contributor
Posts: 77
Registered: ‎12-17-2008
Message 3 of 14 (1,189 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

From what I have read,developer edition is same as enterprise apart from licensing as it is meant for test environment only.
It let's you do a fresh install, so is the upgrade wizard hard coded to only accept Enterprise edition?
HP Expert
Posts: 5,074
Registered: ‎01-30-2008
Message 4 of 14 (1,185 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

I guess it checks the edition only. If it's not Enterprise - BSM is not happy. Anyway BSM is not supported on non-Enterprise SQL Server editions.

Respected Contributor
Posts: 510
Registered: ‎09-01-2009
Message 5 of 14 (1,166 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

We went through the upgrade in our test 8.07 environment, and it failed on the profile db upgrade. The message was quite random but the only thing I could think of was that our db is SQL 2008 Server R2 Enterprise. I know this isn't supported officially but it was working in 8.07 fine, does it not work at all in 9.1?

 

Valued Contributor
Posts: 338
Registered: ‎11-29-2011
Message 6 of 14 (1,101 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

In our learning environment, I am doing an in-place upgrade with SQL enterprise 2008 sp2 (evaluation edition) and getting the "The following databases DON'T support native partitioning" Do we have to enable native partition somewhere? I believe it is enable by default? 

 

Our BAC 8.07 environment was also on SQL Enterprise 2008 sp2 (evaluation edition) and in the Partitioning and purging manager the enterprise template  is activate so BAC recognized our SQL server as Enterprise but BSM does not?

 

Any advice?

 

HP Expert
Posts: 5,074
Registered: ‎01-30-2008
Message 7 of 14 (1,095 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

I would check with your SQL Server DBA if this "evaluation edition" includes database partitioning functionality.

Valued Contributor
Posts: 338
Registered: ‎11-29-2011
Message 8 of 14 (1,091 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

He said it should have all functionallity that the real edition have. There is no restriction on the "evaluation edition". I've looked in the pmanager.log and there are partitioning activity (current BAC 8.07) and there doesnt seem to be any error

Valued Contributor
Posts: 338
Registered: ‎11-29-2011
Message 9 of 14 (1,080 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

So we were wrong...eval edition was in fact the culprit....as soon as we switch to a a non-eval edition upgrade worked like a charm :)......i wonder what the different is? i consulted several sql forum and they assure me that evaluation edition have full parition capabilities. Maybe it have to do with how bsm detect sql version and does not activate native partitioning unless it is a enterprise edition?

Valued Contributor
Posts: 75
Registered: ‎01-05-2012
Message 10 of 14 (962 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

Not what I wanted to hear. I'm also having this issue in a fresh 9.20 install...we're using Developer edition in our test environment til we can get a few new boxes built for our Prod environment.

HP Expert
Posts: 5,074
Registered: ‎01-30-2008
Message 11 of 14 (954 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

SQL Server Developer edition won't work either. I hit this issue myself at one of my customers. BSM was working but data from data collectors were not inserted into DB.

Valued Contributor
Posts: 75
Registered: ‎01-05-2012
Message 12 of 14 (952 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

Dmitry -

 

Thank you very much. That's exactly what is happening in my test environment right now. I assume once you installed Enterprise & (probably) recreated the databases everything was both hunky and dory?

 

Thanks.

HP Expert
Posts: 5,074
Registered: ‎01-30-2008
Message 13 of 14 (946 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

Yep, everything started working fine once SQL Server has been upgraded to Enterprise edition. We didn't even need to recreate any databases.

Valued Contributor
Posts: 75
Registered: ‎01-05-2012
Message 14 of 14 (938 Views)

Re: 9.10 Upgrade - Database does not support native partitioning

[ Edited ]

Rock & roll.

 

Thanks again, Dmitry!

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.