Kbase 15967: Database request failed / SQL Engine can handle only 512 col
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Database request failed / SQL Engine can handle only 512 col
Report Builder will return the error message
V7 - "Database request failed due to lack of resources"
V8 - "SQL Engine can handle only 512 columns, but this
report requires #### columns"
if a table has more than 512 fields/columns in it.
This commonly happens if there are fields in the table
that have extents, because each array element gets
counted as a separate column.
For example, if a table has 13 fields in it and each
field is an extent of 53, the total number of columns
in the table is 689.
This is because Dynamic SQL in the SQL Engine has
a limit of 512 columns per table.
95-06-07-074 Enhancement Request - SQL Engine
95-06-26-047 Enhancement Request - Report Builder
Progress Software Technical Support Note # 15967