|
02.04.2007, 20:02 | #1 |
Участник
|
Проблема с ODBC?
Привет.
В журнале трассировки операторов SQL в DAX обнуружили след. строки с типом error: [Microsoft][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor ran out of stack space during query optimization. [Microsoft Business Solutions-Axapta] Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [‡PJ] Error message [] [Microsoft][ODBC SQL Server Driver]Memory allocation failure Что это и как с этим бороться? |
|
02.04.2007, 20:44 | #2 |
Участник
|
Цитата из BOL
Цитата:
Error 8621
Severity Level 16 Message Text Internal Query Processor Error: The query processor ran out of stack space during query optimization. Explanation The Query Processor is using a large but limited memory stack when optimizing queries. In some extreme situations the stack size may become a limit for a given very large query--for example, a query containing an inlist with 100,000 constants. Action Simplify the query to avoid this problem. For example, in the case of an extremely large inlist use temporary table or table variable to store the constants, and rewrite the query to use this variable or temporary table instead.
__________________
Axapta v.3.0 sp5 kr2 |
|