cancel
Showing results for 
Search instead for 
Did you mean: 

CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Hello.

I am trying install new fresh ePO5.10 Update4 +.CSR2.6 with external MS SQL Server 2016 Standard SP2 CU10.

CSR still reports Partitioning: Not supported by database.

I can not found any documentation specific about CSR and partitioning.

Any idea where to check SQL partitioning option on SQL side? Based on SQL doc, partitioning should be available in MSSQL2016Std from SP1 by default and CSR should configure partition during DB schema deployment.

thx for any help/idea.

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Confirmed to be CSR 2.6 issue in detection SQL supported feature. SR ticket closed as to be solved in next CSR version.

View solution in original post

7 Replies
Highlighted
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 2 of 8

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

It's enabled in CSR.  I've already done it, and I believe these are the steps...

In CSR go to Report Server Settings.  Then click Database.  Then click edit.

Click Advanced, then there's an option to partition the database.  It should be supposed on all versions MSSQL2016.

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 3 of 8

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Hi,

The partitioning option will be available only on Enterprise edition. Make sure DB server has enough space

Go to Report server Settings - database tab - edit -  Advance  -- Check whether partition option is available ?

 

 

Regards

Alok Sarda

Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Hi aloksard. DB partitioning is part of SQL2016 Standard from SP1. Enterprise edition is not needed anymore.

Tested on SQL2016 Std with SP2 using sample from https://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

Works on SQL side, but ePo reports partitioning is not supported.

Could there be (in CSR) some SQL version check for "Enterprise" when connecting to external DB ?

Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution
Now I tested using SQL2012 Enterprise but CSR still reports no partitinioning supported.
So fresh SQL install with 600GB disk free space:
SQL2016Std SP2:
- not supported in CSR
- OK in SQL Studio (via sql query)
SQL2012 Ent:
- not supported in CSR
- OK in SQL Studio (via sql query)

Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution
Escalated to support as SR-4-20441246661
Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Confirmed to be CSR 2.6 issue in detection SQL supported feature. SR ticket closed as to be solved in next CSR version.

View solution in original post

Highlighted

Re: CSR - SQL Database - Partitioning: Not supported by database ?

Jump to solution

Hi AaronT

Strange, but Advanced options still displays Partitioning not supported.

SQL server itself supports such feature as I can use SQL Wizard to partition. So I guess there must be some DB or ePO settings.

 
 
You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community