cancel
Showing results for 
Search instead for 
Did you mean: 

Batch script in Business Objects

former_member418791
Participant
0 Kudos

I am trying to run a batch script in SAP BI 4.2.I followed below steps to run btach script as program object

https://blogs.sap.com/2013/04/30/business-objects-program-object-what-we-can-do/

But when i try running this script from CMC,it is running for a long time without any status change.

Do i need modify or check anything before running .bat file in BO,let me know if i am missing anything.

Thanks,

Vikram

Accepted Solutions (1)

Accepted Solutions (1)

former_member182521
Active Contributor
0 Kudos

Does the script which you are running as program object is executable standalone? Does that user who runs BusinessObjects can execute the script without any access issues? If you can share the script, then we should be able to help you from ourside.

Thanks

Mani

former_member418791
Participant
0 Kudos

Hi Mani,

I tried logging in to BO server and execute the .exe file from command prompt,it is working fine and i got the expected output .txt file to home directory of .exe file

When i am running the same .exe as program object from CMC,the instance is getting success but when i check the output FRS the .txt file (procprogram_output) it is zero kb.

May i know what causes this issue and do i need to define any destination path for program objects ?

Thanks

former_member418791
Participant
0 Kudos

I am not able to attach the script here as it is in .exe format.

Do i need to make any changes to .exe file to create output file in BO environment.

If this is difficult is there way to schedule .exe file everyday from any server.The .exe file is not dependent on Business objects data

denis_konovalov
Active Contributor
0 Kudos

why are you looking in output FRS ??
if your executable creates the file - the file it creates will not be in FRS, it will be in location your executable specifies or in same location as executable.

BOE here is only running the exe you specify, its not storing its output or controls where it goes.

Answers (3)

Answers (3)

former_member182521
Active Contributor

Does the script which you are running as program object is executable standalone? Does that user who runs BusinessObjects can execute the script without any access issues? If you can share the script, then we should be able to help you from ourside.

Thanks

Mani

former_member418791
Participant
0 Kudos

Thank you all ,The issue is solved.

Joe_Peters
Active Contributor
0 Kudos

Things to try:

Log in to the BOE server as the user account that BO runs as, then execute the batch file and see if it completes successfully.

If so, I would add some debugging steps throughout the script, ex:

echo Starting step 5 >> c:\temp\batch.log

This should at least give you an indication about the source of the problem.

former_member418791
Participant
0 Kudos

I tried logging in to BO server and execute the .exe file from command prompt,it is working fine and i got the expected output .txt file to home directory of .exe file

When i am running the same .exe as program object from CMC,the instance is getting success but when i check the output FRS the .txt file (procprogram_output) it is zero kb.

May i know what causes this issue and do i need to define any destination path for program objects ?

Thanks

Joe_Peters
Active Contributor
0 Kudos

Try setting the Working Directory in the program object properties.

former_member418791
Participant
0 Kudos

I am not able to attach the script here as it is in .exe format.

Do i need to make any changes to .exe file to create output file in BO environment.

If this is difficult is there way to schedule .exe file everyday from any server.The .exe file is not dependent on Business objects data

Joe_Peters
Active Contributor
0 Kudos

Regarding whether changes are required in the program -- it depends on how it is referencing the output file. I suspect it's just writing to the current working directory, which is why I suggesting setting the Working Directory in the program object settings.

You can use Windows Scheduler instead.