Сделал експорт манданта с профилем SAP_APPL, на другом сервере в STMS добавил два запроса (LPSKT00054, LPSKX00054), делаю перенос.
Первым переносится запрос LPSKT00054.
Во время выполнения вылетает:
Code:
Основной импорт
Запрос на перенос : LPSKT00054
Система : LTS
tp-путь : tp
Версия и Release : 305.13.07 46D
46C
Запуск импорта R3TRTABU/SAPDMC/LSMCUST ...
0 entries from /SAPDMC/LSMCUST (200) deleted.
5457227 5457227
COMMIT (269061).
0 entries from /SAPDMC/LSMCUST (200) deleted.
Завершение импорта R3TRTABU/SAPDMC/LSMCUST
Запуск импорта R3TRTABUACCTIT ...
[developertra,00000] Fri Jul 27 18:54:17 2007 95760927 112.460946
[dbsloci. ,00000] *** ERROR => ORA-4031 occured; SQL statement is ==>
5975 112.466921
[developertra,00000] INSERT INTO ACCTIT ( MANDT , AWTYP , AWREF , AWORG , POSNR , KSTAT , AWREF_REV , AW\
1046 112.467967
[developertra,00000] ORG_REV , BUKRS , BELNR , GJAHR , BLDAT , BUDAT , WWERT , VALUT , MONAT , BLART ,\
1129 112.469096
[developertra,00000] XBLNR , VORGN , PRVRG , PRVRG_SV , KTOSL , UMSKZ , BSCHL , SHKZG , PSWSL , PSWBT\
950 112.470046
[developertra,00000] , KOART , KUNNR , LIFNR , SAKNR , HKONT , ALTKT , GVTYP , SGTXT , GSBER , KOSTL\
560 112.470606
[developertra,00000] , KOKRS , PERNR , BPMNG , BPRME , AUFNR , ANLN1 , ANLN2 , ANBWA , RMVCT , ABUKR\
533 112.471139
[developertra,00000] , AIBN1 , AIBN2 , MATNR , MENGE , MEINS , WERKS , BWART , PARGB , GSBER_GP , BU\
550 112.471689
[developertra,00000] ZID , HOART , HRKFT , HKMAT , IMKEY , KSTRG , PAOBJNR , PRCTR , PPRCTR , PS_PSP_PN\
534 112.472223
[developertra,00000] R , NPLNR , AUFPL , VBELN , KDAUF , KDPOS , KZVBR , KZBWS , SOBKZ , VBUND , BWKE\
524 112.472747
[developertra,00000] Y , BWTAR , VNAME , EGRUP , BTYPE , EBELN , EBELP , ZEKKN , RECID , VPTNR , XBIL\
518 112.473265
[developertra,00000] K , XUMSW , KZBEW , TBTKZ , XUMBW , SCOPE , AUTYP , XMFRW , BKLAS , BWMOD , MTAR\
519 112.473784
[developertra,00000] T , KZUML , XPKON , KOAID , EPRCTR , FIKRS , FIPOS , FISTL , GEBER , KBLNR , KBL\
524 112.474308
[developertra,00000] POS , LOTKZ , STTAX , BEMOT , CO_KAKST , CO_KAAUF , CO_KAPRO , CO_KAKTR , CO_KANPL \
559 112.474867
[developertra,00000] , CO_KAIMO , CO_KAKDA , CO_KAERG , CO_KAABS , CO_KAPRZ , CO_KASAT , ZZTEXT , BUSTW ,\
528 112.475395
[developertra,00000] ZEILE , URZEILE , PSTYP , FKBER , ERFMG , ERFME , DABRZ , APLZL , BUPLA , SECCO\
519 112.475914
[developertra,00000] , LOKKT , LSTAR , PRZNR , XNEGP , MAT_KDAUF , MAT_KDPOS , MAT_PSPNR , LOGVO , XBGB\
520 112.476434
[developertra,00000] B , TPKNZ , AUFPS ) VALUES ( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 , :A8 , :A9 , :A10 ,\
520 112.476954
[developertra,00000] :A11 , :A12 , :A13 , :A14 , :A15 , :A16 , :A17 , :A18 , :A19 , :A20 , :A21 , :A22 , :A23 , :A24 , :\
517 112.477471
[developertra,00000] A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A3\
5033 112.482504
[developertra,00000] 9 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 \
546 112.483050
[developertra,00000] , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , \
509 112.483559
[developertra,00000] :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A\
525 112.484084
[developertra,00000] 82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96\
523 112.484607
[developertra,00000] , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A10\
520 112.485127
[developertra,00000] 9 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , \
563 112.485690
[developertra,00000] :A122 , :A123 , :A124 , :A125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A13\
528 112.486218
[developertra,00000] 4 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 );
523 112.486741
[dbtrtab ,06295] ***LOG BY4=>sql error 4031 performing INS on table ACCTIT
7266 112.494007
[dbtrtab ,06295] ***LOG BY0=>ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,unknown object,libra
4835 112.498842
SQL-ошибка 4031 при доступе к ACCTIT: ORA-04031: unable to allocate 4096 bytes of shared
sap_dext вызван с № сообщения 4:
DBE_INTERNALERROR
db call info
function: db_xrtab
fcode: RT_MI_LOAD
tabname: ACCTIT
keylen: 875
key: 200MKPF 49000000012004 0000000029 010L$ 1 20042004093020040930200409302004102909WA
retcode: 4
SQL-ошибка 4031 при доступе к : ORA-04031: unable to allocate 4096 bytes of shared
Основной импорт
Дата и время заверш.: 20070727185417
Ошыбка только в памяти (SHARED_POOL_RESERVED_SIZE, POOL_SIZE, LARGE_POOL_SIZE), или я чтото делаю не так? Как лечить?