topic Re: Program not working ib background in Application Development and Automation Discussions

Program not working ib background

Former Member — Fri, 12 Nov 2010 09:34:53 GMT

Moderator message: background/foreground/GUI problems = FAQ, please search before posting.

Hi All,

I have a program which is not working in background.It actuly takes the file and using GUI_upload i upload it into ITAb and then modify the database table based on this. But when i process this in foreground it working and updating the table.But when i scedule in background the job is getting over in 1-2 sec and not updating the table.

Please help me. below is the code for your refrence:

data:begin of i_tab occurs 0,

Bp1 like DATAbase table,

Bp2 like database table,

trf1 type string,
trf2 type string,

status type string,

end of i_tab.

data: BP_ver type STANDARD TABLE OF DATAbase table with header line ,

w_ver type ZVERS_BUT050_CUR .

DATA: it_tab type filetable,

gd_subrc TYPE i,

file_name TYPE string,

path TYPE string.

DATA : lw_file TYPE file_table.

DATA: LIN TYPE I.

&----

*Input File

SELECTION-SCREEN begin of block blk with frame title text-100.

SELECTION-SCREEN SKIP 2.

parameters : p_file like rlgrap-filename .

SELECTION-SCREEN end of block blk.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CLEAR: file_name.

CALL METHOD cl_gui_frontend_services=>file_open_dialog

EXPORTING

window_title = 'Select only Text File'

default_filename = '*.txt'

multiselection = ' '

CHANGING

file_table = it_tab

rc = gd_subrc.

READ TABLE it_tab INTO lw_file INDEX 1.

file_name = lw_file.

p_file = file_name.

&----

START-OF-SELECTION.

*Upload the file

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = FILE_NAME

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

HEADER_LENGTH = 0
READ_BY_LINE = 'X'
DAT_MODE = ' '
CODEPAGE = ' '

TABLES

DATA_TAB = i_tab

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at i_tab.

if i_tab-status = 'Yes'.

i_tab-status = 'V'.

else.

i_tab-status = 'I'.

endif.

modify i_tab.

endloop.

&----

if i_tab is not INITIAL.

select * from DATAbase table into CORRESPONDING FIELDS OF TABLE BP_ver FOR ALL ENTRIES IN i_tab

where PARTNER1 = i_tab-Bp1 and PARTNER2 = i_tab-bp2 .

endif.

*Update the table

loop at BP_ver .

clear i_tab.

read TABLE i_tab with key bp1 = BP_ver-PARTNER1 bp2 = BP_ver-PARTNER2 .

if i_tab-bp1 = w_ver-PARTNER1 and i_tab-bp2 = w_ver-PARTNER2.

BP_ver-PARTNER1 = i_tab-bp1 .

BP_ver-PARTNER2 = i_tab-bp2 .

BP_ver-Z_CURRENTLY_VALI = i_tab-status .

modify BP_ver TRANSPORTING Z_CURRENTLY_VALI .

endif.

endloop.

update DATAbase table from table bp_ver[] .

&----

if sy-SUBRC eq 0.

commit work.

message 'Table DATAbase table Updated Sucsussfully' type 'S'.

else.

message 'Table Not Updated !!! Check the file data or input' type 'S'.

endif.

Edited by: Thomas Zloch on Nov 12, 2010 11:03 AM

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:37:40 GMT

Hi,

Look at the coding in FM GUI_UPLOAD ... This does not work in background ....

Batch mode is not supported

IF sy-batch = 'X'.

MESSAGE ID 'FES' TYPE 'E' NUMBER '002' RAISING NO_BATCH.

ENDIF.

Regards,

Srini.

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:38:08 GMT

You can't use GUI_UPLOAD in a background job as it's designed to load files from the presentation server which isn'r accessible from a background job.

For background processing you should use OPEN DATASET on a file that you've loaded to the application server.

You could add a switch in your program to allow it to run in foreground and background.

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:39:12 GMT

Hi,

You have to use the OPEN DATASET command to read your file. The GUI_upload FM does not work in background.

Best regards

George Zervas

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:40:06 GMT

Hi ,

Thanks for the reply.

GUI_upload is not suported in batchmode then which FM we can use to upload in background.

Please help me your inputs are realy helping me.

Mahesh

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:42:25 GMT

As I said in my reply you need to put the file on the application server and then use the OPEN DATASET, READ DATSET and CLOSE DATASET commands to process the file.

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:42:49 GMT

hi Thanks for the reply.

I need to upload the file from my desktop to a table so how to use opendataset to upload the file from presentation in background. please help me with the code.

Mahesh

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:46:23 GMT

Hi,

I don't think there is any way to upload data from desktop in back ground.

Regards,

Srini.

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:47:46 GMT

You can still load the data to your internal table and update the database in background but you can't use GUI_UPLOAD - you have to use the dataset processing commands.

Re: Program not working ib background

Former Member — Fri, 12 Nov 2010 09:54:31 GMT

Hi,

You need to put the file at application server. Use tcode - CG3Z

Then as said by other use, OPEN, READ and CLOSE dataset commands.

There is no ways to upload the file from presentation server for a background job.

Regards

Munish Garg