.NET Buzz Forum - Could not allocate ancillary table for view or function resolution

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

.NET Buzz Forum
Could not allocate ancillary table for view or function resolution

0 replies on 1 page.

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 0 replies on 1 page

Richard Jonas

Posts: 147
Nickname: rjonas
Registered: Nov, 2005

Richard Jonas is a .NET sofware developer living in the UK.

Could not allocate ancillary table for view or function resolution

Posted: May 18, 2006 10:43 AM

This post originated from an RSS feed registered with .NET Buzz by Richard Jonas.
Original Post: Could not allocate ancillary table for view or function resolution Feed Title: Richard Jonas Feed URL: http://feeds.feedburner.com/blogspot/ouNA Feed Description: Richard Jonas's blog about .NET, web development and agile methodologies.	Latest .NET Buzz Posts Latest .NET Buzz Posts by Richard Jonas Latest Posts From Richard Jonas

I received the error message "Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (256) was exceeded." This was because I had created a chain of views, many of which used the "union" SQL statement. e.g. view 1, 3 queries joined with the union statement view 2, 2 queries view 3, 5 queries view 4, 4 queries view 5, 3 queries 3 * 2 * 5 * 4 * 3 is greater than 256, and caused this error. Rewriting some of the views to use CASE...

Read: Could not allocate ancillary table for view or function resolution

Previous Topic

Next Topic


	Web Artima.com