| Applies To | |||
| Product(s): | AutoPIPE, | ||
| Version(s): | All | ||
| Area: | Message | ||
| Original Author: | Bentley Technical Support Group |
Nov 2014, AutoPIPE V8i 09.06.01.10
Problem:
The following appears when reviewing the results grids:
---------------------------
Bentley AutoPIPE
---------------------------
Query is too complex.
---------------------------
OK
---------------------------
And then
---------------------------
Bentley AutoPIPE
---------------------------
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
---------------------------
OK
---------------------------
Why does this occur and how to avoid it?
Solution:
The problem is occurring due to the number of printable combinations exceeding 254. This is a database related limitation. AutoPIPE 12.04 and lower cannot specify more than 254 comparison cases as criteria in result grids while querying the database.
This issue (644882) is general and is repeatable in a fresh model, if more than 254 combinations are created with print flag ON.
The avoidance to the problem is to limit the number of combinations using 'Print' flag.
This can be performed using Non-code combination tab of Tools->Combinations dialog. Unchecking the "Print" flags for some combinations, so that the total number of combinations with print flag enabled not exceeding 254, the issue can be avoided.
A new enhancement has been logged (89315) and will be updated in a future version of the program.
Update:
- AutoPIPE 23 update 1 - will fix this issue (644882).
- AutoPIPE 12.06.00.048 and higher can now handle a maximum of 1000 code and 1000 non-code combinations (including the default and user defined combinations) are available, for a possible total of 2000 combinations in the result grids and output reports.