Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

problem in job scheduling.

Go to solution
Former Member

‎2010 Aug 16 7:49 AM

0 Likes
696

Hi friends,

i have created a BAPI to create purchase order by picking excel files from system . Now i have schedulded this program(se38) by job scheduling (SM36) to run every minute , when i check job overview in SM37 it working fine , but the programm is not executing and its not picking files from folder ,IF i run same programm manually its working fine.

What can be problem?

Please help.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2010 Aug 16 8:00 AM

0 Likes
663

Dear Ishita,

In background job if you want to read file data then it should be only from application server...BG job cant read data from system..

So please explain...if not reading from application server (OPEN CLOSE DATASET) then its not possible ...

Hi friends,

i have created a BAPI to create purchase order by picking excel files from system . Now i have schedulded this program(se38) by job scheduling (SM36) to run every minute , when i check job overview in SM37 it working fine , but the programm is not executing and its not picking files from folder ,IF i run same programm manually its working fine.

What can be problem?

Please help.

Reply
6 REPLIES 6
Read only

Go to solution
Former Member

‎2010 Aug 16 7:52 AM

0 Likes
663

Hi Ishita,

Have you placed the excel file in Application server ( AL11 tcode). Is your program designed to upload from from application server using OPEN DATASET.

If you are using GUI_UPLOAD etc, then it works only in foreground & not in background. For background, you need to use OPEN DATASET.

Thanks,

Best regards,

Prashant

Read only

Go to solution
Former Member
In response to Former Member

‎2010 Aug 16 8:31 AM

0 Likes
663

Hi Prashant,

i m using function module 'ALSM_EXCEL_TO_INTERNAL_TABLE ' ,and yes my excel files are on my system not on application server , how can we put these files on application server.

Read only

Go to solution
Former Member
In response to Former Member

‎2010 Aug 16 8:38 AM

0 Likes
663

try to put file with tcode CG3Z to application server and then read that file using open datasets...

Read only

Go to solution
Former Member

‎2010 Aug 16 8:00 AM

0 Likes
664

Dear Ishita,

In background job if you want to read file data then it should be only from application server...BG job cant read data from system..

So please explain...if not reading from application server (OPEN CLOSE DATASET) then its not possible ...

Read only

Go to solution
Former Member
In response to Former Member

‎2010 Aug 16 8:23 AM

0 Likes
663

hi Sachin,

yes my excel file is on my system , may be that is the problem its not reading the file , is there any way to put the file in application server.

Read only

Go to solution
Former Member
In response to Former Member

‎2010 Aug 16 8:31 AM

0 Likes
663

Dear Ishita,

BG job will not read data from your system...

So please put your file on application server and write a code to read that file from application server and update the same from there in sap using open dataset and read dataset...

try to put file with tcode CG3Z to application server and then read that file using open datasets...

Edited by: Sachin Bidkar on Aug 16, 2010 9:35 AM