topic Re: Regarding Time Out error while uploading data using BAPI in Application Development and Automation Discussions

Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 06:18:06 GMT

Hi,

I have developed Upload Program for creating STO's using BAPI_PO_CREATE1,after creating STO's ,for this STO's OBD numbers are created automatically and stored in LIPS table.Now i want to display STO ,OBD,Quantity in ALV report.

For this i will fetch OBD from LIPS table based on PO,here it takes more time and gives runtime error in Production.can anyone tell me ow to solve this?

Thanks

Re: Regarding Time Out error while uploading data using BAPI

former_member218298 — Fri, 03 Jan 2014 07:12:23 GMT

Hi Sai Ganesha,

You may have to limit your Select on LIPS with more parameters in the WHERE clause like using both Reference document number and Item in your SELECT.

Can you provide your SELECT on LIPS which is causing the runtime error so that the viewers will be able to help you better.

Regards,

Leenu

Re: Regarding Time Out error while uploading data using BAPI

former_member187748 — Fri, 03 Jan 2014 07:21:04 GMT

Hi Sai,

i will sujjest you to use inner join for the same, LIPS is a transparent table so use

inner join on LIPS and other transparent table you have used, this will limit your time out

problem, hope it will help you.

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 07:41:15 GMT

Hi Sanjeev,

Here i am using one Transparent table and one internal table,We can't use innerjoin on internal tables...

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 07:46:18 GMT

Hi Sai,

It is not problem of the select query! what is dump says. The secondary index is available in LIPS for preceding document.

I think so you are wrtten the select statement in the loop and end loop.

better to paste your code here.!

select vbeln posnr qty from LIPS where vgbel = sto po number.

Exactly how you are collecting!

Rg, Kiran

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 07:49:50 GMT

Hi Sai,

This is wrong! why 15 seconds - just use 3 seconds or 2. since you are handling inside the loop to update for several STO's

WAIT UP TO 15 SECONDS.
   """"""""""""""""""""""""""""""""""""""
* sort it_po by po.
   IF it_po IS NOT INITIAL.
     SELECT vbeln
            matnr
            vgbel
            lfimg
            FROM lips
            INTO TABLE it_lips
            FOR ALL ENTRIES IN it_po
            WHERE vgbel = it_po-po
            and erdat = sy-datum. " avoid this from the select (use the secondary index only )
   ENDIF.

if required DELETE IT_LIPS[] WHERE ERDAT NE SY-DATUM.

Re: Regarding Time Out error while uploading data using BAPI

arivazhagan_sivasamy — Fri, 03 Jan 2014 07:55:00 GMT

Hi Sai Ganesha,

Are you trying save PO and get the report simultaneously?

If yes, it will take more time.. Because you are executing commit.

So, once you save the Po and comeout. Then run the report.

If No, please check whenever using for all entries option, internal table content.

Arivazhagan S

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 08:35:23 GMT

Hi Kiran,,

If i put Wait upto 2 or 3 seconds within the loop.It will take..more time for each STO,So that i have put outside the loop.

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 08:44:45 GMT

Hi Sai,

Just try the select and avoid the ERDAT from where clause. If you will find the much difference!

check the ST05 ALSO.

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 08:49:51 GMT

Actually i didn't put ERDAT field in Live program...For testing purpose i have included..

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 09:14:43 GMT

Hi Sai,

The select statement is fine, Even working fine to get the outbound deliveries for STO's.

Have you debug the program in PRD! what exactly the time consuming statement!

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 09:43:39 GMT

No Kiran,I didn't run this program in Production....Actually DC people are running this in production..

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 09:46:09 GMT

Hi Sai,

Just get the temporary debug access and trace the exact issue in the program

I think this is the better way to trace the error/correction, rather than assuming more things

Rg, Kiran

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 10:00:28 GMT

Yah...Kiran,but if i will run this in production for testing purpose,it is creating STO's and OBD's..DC people are run this program in the early morning.

This is the runtime error.

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 10:13:42 GMT

Is there any possibility to findout the program name based on Runtime errors in ST22?

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 10:21:38 GMT

Yes, You can check the dumps and in which point it is happening!

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 10:24:17 GMT

How to findout the report name using dumb error?

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 10:26:56 GMT

Hi Check the ST22 selection!

you have the program name and user ID....

Re: Regarding Time Out error while uploading data using BAPI

Former Member — Fri, 03 Jan 2014 11:17:17 GMT

Yes Kiran...I have found that...But still fetching data from LIPS table it is giving Time_Out error.How can i solve this issue?

Re: Regarding Time Out error while uploading data using BAPI

deependra_shekhawat3 — Fri, 03 Jan 2014 11:41:38 GMT

Hi Sai,

Why don't you use EKBE table, which confirms delivery creation against STO. You can check delivery by passing EKBE-VGABE = '8' and output BELNR is OTB. May be performance also could be boost up while passing EKBE-BELNR to LIPS-VBELN , as it is key field.

Thanks

Deependra