on 03-31-2010 9:53 PM
Pessoal,
agora na parte da tarde a nossa NFe de Produção parou de funcionar. Todas as notas que são criadas no SAP vão para o GRC e ficam com o status Process Status: Added to Batch 04. Na transação ST22, o job NF-E: BATCH POCESSING que está associado ao programa /XNFE/PROCESS_REPORTS, se encontra com o status de cancelamento devido ao erro abaixo:
ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC
Job cancelled
The ABAP/4 Open SQL array insert results in duplicate database records.
The current ABAP program "/XNFE/SAPLNFE_HIST_DB" had to be terminated because it has come across a statement that unfortunately cannot be executed.
procedure "/XNFE/NFE_HIST_UPDATE_DB" "(FUNCTION)", nor was it propagated by a
RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
If you use an ABAP/4 Open SQL array insert to insert a record in
the database and that record already exists with the same key,
this results in a termination.
Alguém já viu isso?
Abs,
Sérgio Salomã
Segue mais detalhes:
FUNCTION /xnfe/nfe_hist_update_db.
*"----
""Verbuchungsfunktionsbaustein:
*"
""Lokale Schnittstelle:
*" IMPORTING
*" VALUE(IT_NFE_HIST) TYPE /XNFE/NFE_HIST_T OPTIONAL
*" EXCEPTIONS
*" INSERT_ERROR
*"----
IF NOT it_nfe_hist IS INITIAL.
INSERT /xnfe/nfe_hist FROM TABLE it_nfe_hist. <----- aqui ocorre o dump
IF NOT sy-subrc IS INITIAL.
MESSAGE a001(/xnfe/app) WITH 'INSERT' 'XNFE/NFE_HIST'
RAISING insert_error.
ENDIF.
ENDIF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bom dia Ariel,
Este dump por duplicidade normalmente acontece no seguinte cenário:
- Mais de um application server no GRC com diferença de timestamp entre eles
- Support do GRC antigo
Atenciosamente, Fernando Da Rós
PS: Prefira postar uma nova thread descrevendo os detalhs do problema que enfrenta.
User | Count |
---|---|
11 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.