topic Re: Getting dump while displaying invoice. in Application Development and Automation Discussions

Getting dump while displaying invoice.

Former Member — Fri, 18 Jul 2008 03:38:33 GMT

Hi Friends,

I have created a credit memo and went to create a invoice and saved the invoice. But when I went to display that invoice I am getting a dump saying that

"The system attempted to open a cursor for a SELECT or OPEN CURSOR

statement but all 16 cursors were already in use.

The statement that failed accesses table "VBFA ".

The erroneous statement accesses table "VBFA ".

Dump Analysis:

012420 FORM vorgaenger_sonstiges TABLES i_vorgaenger STRUCTURE x_vorgaenger

012430 USING i_beleg i_position i_typ

012440 i_ebene i_mandant.

012450 * VBFA lesen

012460 IF i_position IS INITIAL.

> SELECT *

012480 FROM vbfa

012490 WHERE vbeln = i_beleg

012500 AND vbtyp_n = i_typ

012510 AND stufe = 0

012520 ORDER BY PRIMARY KEY.

012530 vbfa-stufe = i_ebene.

012540 vbfa-matnr+17 = 'X'.

012550 PERFORM vorgaenger_aufnehmen.

012560 PERFORM vorgaenger_ermitteln USING i_mandant

012570 vbfa_tab-vbelv

012580 vbfa_tab-posnv

012590 vbfa_tab-vbtyp_v

012600 vbfa_tab-logsys

012610 i_ebene.

012620 ENDSELECT.

Can any one guide me what is the error.

Please it s urgent.

Regards,

Niki.

Re: Getting dump while displaying invoice.

naveen_inuganti2 — Fri, 18 Jul 2008 04:13:38 GMT

Hi...,

You attempting OPEN CURSOR..,

So while using OPEN CURSOR syntax remember one thing....,only a limited number of database cursors can be open at the same time.

So to solve your problem you hav to close other OPEN CURSORS... with CLOSE CURSOR...statement,

> CLOSE CURSOR <cursor variable>.

Since only a limited number of database cursors can be open simultaneously, you should close all database cursors no longer required.

Try this..,

And Plz get back here with the way, you solved the problem.

Thanks,

Naveen.I

Re: Getting dump while displaying invoice.

Former Member — Fri, 18 Jul 2008 05:48:54 GMT

Hi naveen,

Thanks for ur replay.

But naveen i dont know where i want to close this cursor.

Can u please eloberate.

Regards.

niki.

Re: Getting dump while displaying invoice.

Former Member — Fri, 18 Jul 2008 06:34:19 GMT

Can any one help me.