cancel
Showing results for 
Search instead for 
Did you mean: 

number of tables exceeds its maximum table count in statement exceeds its maximum 4095

yakcinar
Active Contributor
0 Kudos
9,927

Hello,

I have installed HANA DB 2.00.040.00.

And I want to check parameters and run minichecks. Running these SQL Statements give "Cannot get the data provider outline, number of tables exceeds its maximum table count in statement exceeds its maximum 4095" error as seen below.

Is there a solution for this error?

Can we change the limit?

Thanks for the help.

Regards,

Yuksel AKCINAR

Accepted Solutions (1)

Accepted Solutions (1)

dennispadia
Active Contributor

Hello Yuksel,

Can you please check SAP Note 1969700 and follow the workaround as mentioned

Regards,

Dennis

yakcinar
Active Contributor
0 Kudos

Thank you Dennis.

It worked.

Indeed I was using the attachments of this note and searched the error many times via support.sap.com and google. But could not reach this answer. Keywords are important for searches.

.

Quick answers.

That's why I like scn.

.

Thanks and Regards,

Yuksel AKCINAR

former_member363555
Discoverer
0 Kudos

Thank you, Dennis, for the workaround it worked for me as well.

0 Kudos

Thank you for your correct response.

ismailbesiroglu
Explorer
0 Kudos

Thank you for your correct response.

Additional info: The parameter change at nameserver level is not sufficient if we want to execute the statement at tenant database.

We need to change it in indexserver.ini file for that purpose.

Best regards

lbreddemann
Active Contributor
0 Kudos

This is not “additional information” but precisely what the screenshot of the SAP note (from back in April) states.

The change in the nameserver.ini is only required for SQL that runs in the SystemDB.

Answers (0)