Error: [.NET Data Provider][101151] Too Many Restrictions Supplied

Database
Enthusiast

Error: [.NET Data Provider][101151] Too Many Restrictions Supplied

I received the error given in the title when trying to do some fairly simple selects to pull metadata from a Teradata server and wasnt able to find much on this error and how to go about solving it. Any help would be greatly appreciated.

2 REPLIES
Teradata Employee

Re: Error: [.NET Data Provider][101151] Too Many Restrictions Supplied

You are trying to execute one of the Schema Collections. Please provide additional information; i.e. the name of the schema collection, and the list of Schema Collection Restrictions. I think your application assume that all Schema Collection are common across all Databases. The ADO.NET specification has only 5 common schema collections. The remaining schema collections are Provider specific; therefore you should refer to .NET Data Provider for Teradata documentation:

http://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/webframe.html#SchemaCollections...

e.g. The Columns schema collection accepts three restrictions; namely TABLE_SCHEMA, TABLE_NAME and COLUMN_NAME:

http://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/webframe.html#SchemaColumnsColl...

Teradata Employee

Re: Error: [.NET Data Provider][101151] Too Many Restrictions Supplied

BTW, I recommend that you post .NET Data Provider related questions to the Connectivity forum.