on 02-28-2009 10:16 AM
Hi all
when i enter Tcode fse2 and press f4, select any financial statment after execuiting it generate error
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Except. CX_SY_OPEN_SQL_DB
plz tell how can i resolve that issue
Regard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We solved it by 0001158109, 0001544367, 0001553851 notes.
DO sit with any ABAPer to get this done ....
Thanks
Aashish
Thanks all
problem has been solved our fi consultant and abaper close this
please need help ,i think i have the same probelm
Es ist eine Ausnahme aufgetreten, die weiter unten näher erläutert wi
Die Ausnahme, der die Klasse 'CX_SY_OPEN_SQL_DB' zugeordnet ist,
wurde in der Prozedur "FSV_TEXTS_CONVERT" "(FORM)" weder abgefangen,
noch durch eine RAISING-Klausel propagiert.
Clause RAISING manquante dans l'interface
Programme SAPLFAGL_FSV
Include LFAGL_FSVF01
Ligne 174
Type de module (FORM)
Nom du module FSV_TEXTS_CONVERT
Point de déclenchement de l'exception
Ligne 275
comparing ergsl.
call function 'FAGL_FSVTEXT_2_FAGL011_CONVERT'
exporting i_client = lt_t011t-mandt
i_versn = lt_t011t-versn
i_spras = lt_t011t-spras
tables it_x011t = lt_x011t
et_fagl_011tc = lt_fagl_011t.
endif.
endloop.
if not ( p_simulate_conversion is initial ).
only simulation >>> no update
exit. " >>>>>>> E X I T >>>>>>>>>>>
insert fagl_011qt
if not ( lt_fagl_011q[] is initial ).
insert fagl_011qt client specified
from table lt_fagl_011q.
if sy-subrc <> 0.
where i_versn get a data !!!!!
Hello Imran,
I had found some notes found for you for this error
Please sit with your functional and ABAPER and sort out which one is fit for your release.
The notes number are:
949194,1158109,851850,852935 and 960273
Hope that helps you
Rohit
Hi...
this table "FAGL_011TC" is duplicating values. Plz tell me can i delete enteries from this table.
regard
Hi,
I have solved it by using the NOTE 1158109.
Thanks,
Naveen.
Please refer to Notes 945698 and 615498.
They might help you otherwise can you send me the complete dump details
this is detail of error
Date and Time 28.02.2009 15:15:02
Short text
The ABAP/4 Open SQL array insert results in duplicate database records.
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLFAGL_FSV" had to be terminated because it has
come across a statement that unfortunately cannot be executed.
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in
procedure "FSV_TEXTS_CONVERT" "(FORM)", 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.
(With an ABAP/4 Open SQL single record insert in the same error
situation, processing does not terminate, but SY-SUBRC is set to 4.)
Missing RAISING Clause in Interface
Program SAPLFAGL_FSV
Row 174
Module type (FORM)
Module Name FSV_TEXTS_CONVERT
Trigger Location of Exception
Row 285
Source Code Extract
Line SourceCde
255 sort lt_x011t.
256 delete adjacent duplicates from lt_x011t
257 comparing ergsl.
258 call function 'FAGL_FSVTEXT_2_FAGL011_CONVERT'
259 exporting i_client = lt_t011t-mandt
260 i_versn = lt_t011t-versn
261 i_spras = lt_t011t-spras
262 tables it_x011t = lt_x011t
263 et_fagl_011tc = lt_fagl_011t.
264 endif.
265 endif.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.