maximum number of vector aggregates exceeded

maximum number of vector aggregates exceeded

Post by Rob Dia » Thu, 11 Mar 1999 04:00:00



Hi.  I am writing regarding an error message I have come across with SQL
Server 6.5.  The error is the following:

error number 227, severity 16  Maximum number of vector aggregates exceeded
(125 max, 126 found).

Is there a way to get around this?  I have not found ANY documentation on
this particular error and I cannot find any server setting that can be
changed regarding this.  I have 3 clients who have all experienced this now
and are getting upset.

What I am doing is trying to summarize data in a table.  This table has 2
text fields on it (the key) and up to 240 FLOAT fields.  I am writing the
query as:

INSERT INTO TABLEX (KEY1,KEY2,DATA1,DATA2,...,DATAN)
SELECT KEY1,KEY2,SUM(DATA1) DATA1, SUM(DATA2) DATA2,... SUM(DATAN) DATAN
FROM TABLE2
GROUP BY KEY1,KEY2.

This query works fine until I have 125 or more data columns.

Any ideas would be greatly appreciated.
Thanks!

 
 
 

maximum number of vector aggregates exceeded

Post by Neil Pik » Sat, 13 Mar 1999 04:00:00


Rob,

 I very much doubt this limit is user changeable.  You'll have to usetemp
table(s) and split the query up.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see www.ntfaq.com/sql.html
 and http://www.swynk.com/faq/sql/sqlserverfaq.asp
 and GO MSSQL Lib 1 on Compuserve

 
 
 

1. Maximum number of vector aggregates exceeded

Hi.  I am writing regarding an error message I have come across with SQL
Server 6.5.  The error is the following:

error number 227, severity 16  Maximum number of vector aggregates exceeded
(125 max, 126 found).

Is there a way to get around this?  I have not found ANY documentation on
this particular error and I cannot find any server setting that can be
changed regarding this.  I have 3 clients who have all experienced this now
and are getting upset.

What I am doing is trying to summarize data in a table.  This table has 2
text fields on it (the key) and up to 240 FLOAT fields.  I am writing the
query as:

INSERT INTO TABLEX (KEY1,KEY2,DATA1,DATA2,...,DATAN)
SELECT KEY1,KEY2,SUM(DATA1) DATA1, SUM(DATA2) DATA2,... SUM(DATAN) DATAN
FROM TABLE2
GROUP BY KEY1,KEY2.

This query works fine until I have 125 or more data columns.

Any ideas would be greatly appreciated.
Thanks!

2. Student needing a helping hand

3. maximum number of vector aggregates

4. 38357-NE-OMAHA-ORACLE Financials-Customer Support-Oracle Financials Specialists

5. Maximum number of vector aggregates reached error message

6. Writing Log File from a SP

7. Help: Msg 610 Maximum number of databases exceeded?

8. Alternative Front End for MSDE/SQL Server

9. maximum number of processes 150 exceeded?

10. 4GL err -257: System limit on maximum number of statements exceeded

11. Maximum number of configured user connections exceeded

12. maximum number of cursors exceeded - CURNULL

13. Error 925 Maximum number of used databases for each query has been exceeded