Здравствуйте!
В последнее время в системе частенько стала появляться динамическая ошибка DBIF_RSQL_SQL_ERROR (ОсобСит. CX_SY_OPEN_SQL_DB), причём в разных транзакциях.
Цитата:
----------------------------------------------------------------------------------------------------
|КрТекст |
| An SQL error occurred when accessing a table "RKPF " |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Что Вы можете сделать? |
| |
| Make a note of the actions and input which caused the error. |
| |
| To resolve the problem, contact your SAP system administrator. |
| |
| You can use transaction ST22 (ABAP Dump Analysis) to view and administer |
| termination messages, especially those beyond their normal deletion |
| date. |
| |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Указания по устранению ошибки |
| Database error text........: "[601] Could not continue scan with NOLOCK due to |
| data movement." |
| Internal call code.........: "[RSQL/OPEN/RKPF ]" |
| Please check the entries in the system log (Transaction SM21). |
| |
| You may able to find an interim solution to the problem |
| in the SAP note system. If you have access to the note system yourself, |
| use the following search criteria: |
| |
| ------------------------------------------------------------------------ |
| "DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC |
| "SAPDBMMIMRKPFRESB" or "DBMMIMRKPFRESBF01" |
| "PREFETCH" |
| ------------------------------------------------------------------------ |
| If you cannot solve the problem yourself and you wish to send |
| an error message to SAP, include the following documents: |
| |
| 1. A printout of the problem description (short dump) |
| To obtain this, select in the current display "System->List-> |
| Save->Local File (unconverted)". |
| |
| 2. A suitable printout of the system log |
| To obtain this, call the system log through transaction SM21. |
| Limit the time interval to 10 minutes before and 5 minutes |
| after the short dump. In the display, then select the function |
| "System->List->Save->Local File (unconverted)". |
| |
| 3. If the programs are your own programs or modified SAP programs, |
| supply the source code. |
| To do this, select the Editor function "Further Utilities-> |
| Upload/Download->Download". |
| |
| 4. Details regarding the conditions under which the error occurred |
| or which actions and input led to the error. |
| The exception must either be prevented, caught within the procedure "PREFETCH" |
| "(FORM)", or declared in the procedure's RAISING clause. |
| To prevent the exception, note the following: |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Системная среда |
| SAP Release.............. "640" |
| |
| Application server....... "stt-05" |
| Network address.......... "10.0.100.14" |
| Operating system......... "Windows NT" |
| Release.................. "5.2" |
| Hardware type............ "8x Intel 801586" |
| Character length......... 8 Bits |
| Pointer length........... 32 Bits |
| Work process number...... 6 |
| Short dump setting....... "full" |
| |
| Database server.......... "STT-05" |
| Database type............ "MSSQL" |
| Database name............ "TTP" |
| Database owner........... "ttp" |
| |
| Terminal................. " " |
| |
| Character set............ "Russian_Russia.28595" |
| |
| SAP kernel............... "640" |
| Created on............... "Apr 2 2006 23:12:21" |
| Created in............... "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10" |
| Database version......... "SQL_Server_8.00 " |
| |
| Patch level.............. "121" |
| Patch text............... " " |
| |
| Supported environment.... |
| Database................. "MSSQL 7.00.699 or higher, MSSQL 8.00.194" |
| SAP database version..... "640" |
| Operating system......... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2" |
| |
| Memory usage............. |
| Roll..................... 8112 |
| EM....................... 7317072 |
| Heap..................... 0 |
| Page..................... 98304 |
| MM Used.................. 3975456 |
| MM Free.................. 1249240 |
| SAP Release.............. "640" |
| |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Пользователь, транзакция... |
| Client.............. 100 |
| User................ 510822 |
| Language key........ "R" |
| Transaction......... "MB25 " |
| Program............. "SAPDBMMIMRKPFRESB" |
| Screen.............. "SAPMSSY0 1000" |
| Screen line......... 6 |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Информация о месте прерывания |
| The termination occurred in the ABAP program "SAPDBMMIMRKPFRESB" in "PREFETCH". |
| The main program was "RM07RESL ". |
| |
| The termination occurred in line 110 of the source code of the (Include) |
| program "DBMMIMRKPFRESBF01" |
| of the source code of program "DBMMIMRKPFRESBF01" (when calling the editor |
| 1100). |
| Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in |
| the |
| procedure "PREFETCH" "(FORM)" but was not handled locally, not declared in the |
| RAISING clause of the procedure. |
| The procedure is in the program "SAPDBMMIMRKPFRESB ". Its source code starts in |
| line 9 |
| of the (Include) program "DBMMIMRKPFRESBF01 ". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Фрагмент исходного текста программы |
----------------------------------------------------------------------------------------------------
|Строк|ИсхднТкст |
----------------------------------------------------------------------------------------------------
| 80| def_clear aufnr. |
| 81| def_clear r_pspnr. |
| 82| def_clear anln1. |
| 83| def_clear anln2. |
| 84| def_clear nplnr. |
| 85| CLEAR p_vornr. |
| 86| def_clear umwrk. |
| 87| def_clear umlgo. |
| 88| def_clear kdauf. |
| 89| def_clear kdpos. |
| 90| def_clear kdein. |
| 91| ENDIF. |
| 92|* Generate SHKZG-range from checkboxes. |
| 93|* Remark: If no checkbox is set, the system also select ALL reservations |
| 94|* THIS IS NO PROGRAM ERROR!!! |
| 95| REFRESH r_shkzg. |
| 96| r_shkzg-sign = 'I'. |
| 97| r_shkzg-option = 'EQ'. |
| 98| IF p_issues = 'X' AND p_receip = space. |
| 99| r_shkzg-low = 'H'. |
| 100| APPEND r_shkzg. |
| 101| ENDIF. |
| 102| IF p_issues = space AND p_receip = 'X'. |
| 103| r_shkzg-low = 'S'. |
| 104| APPEND r_shkzg. |
| 105| ENDIF. |
| 106| IF p_issues = 'X' AND p_receip = 'X'. |
| 107| REFRESH r_shkzg. |
| 108| ENDIF. |
| 109|* Data selection. |
|>>>>>| SELECT rkpf~rsnum resb~rspos resb~rsart |
| 111| INTO CORRESPONDING FIELDS OF TABLE t_resbkey |
| 112| FROM rkpf INNER JOIN resb |
| 113| ON rkpf~mandt = resb~mandt AND rkpf~rsnum = resb~rsnum |
| 114| WHERE rkpf~rsnum IN rsnum |
| 115| AND resb~rspos IN rspos |
| 116| AND resb~rsart IN rsart |
| 117| AND rkpf~kostl IN kostl |
| 118| AND rkpf~aufnr IN aufnr |
| 119| AND rkpf~ps_psp_pnr IN r_pspnr |
| 120| AND rkpf~nplnr IN nplnr |
| 121| AND rkpf~anln1 IN anln1 |
| 122| AND rkpf~anln2 IN anln2 |
| 123| AND rkpf~umwrk IN umwrk |
| 124| AND rkpf~umlgo IN umlgo |
| 125| AND rkpf~kdauf IN kdauf |
| 126| AND rkpf~kdpos IN kdpos |
| 127| AND rkpf~kdein IN kdein |
| 128| AND resb~matnr IN matnr |
| 129| AND resb~werks IN werks |
---------------------------------------------------------------------------------------------------
Цитата:
[size=7]КрТекст
An SQL error occurred when accessing a table "MDRS "
[size]
p.s. версия системы ECC 5.0.
Вход
Регистрация
FAQ пользователя
Поиск
