cancel
Showing results for 
Search instead for 
Did you mean: 

Error when executing Python script in Data Services

Former Member
0 Kudos

Request you to check and help to understand on how we can execute the python script from SAP BO DS.

EXEC ( 'CMD.exe','C:\Python27\PYTHON.EXE C:\\DWH\TS_PREDICTIVE\Pyton_script\case_creation.py',1 );case-creation.jpg

25972 20400 JOB 27/07/2017 10:41:17 Reading job <4aeec765_6a4d_42cd_b7c2_9709ca42686a> from the repository; Server version is <14.2.8.1354>; Repository version is

25972 20400 JOB 27/07/2017 10:41:17 <14.2.8.0000>.

25972 20400 JOB 27/07/2017 10:41:17 Current directory of job <4aeec765_6a4d_42cd_b7c2_9709ca42686a> is <C:\SAP BusinessObjects\Data Services\bin>.

25972 20400 JOB 27/07/2017 10:41:18 Starting job on job server host <NIRAHMAN-SAP>, port <3500>.

25972 20400 JOB 27/07/2017 10:41:19 Job <sql_update_by_script> of runid <201707271041182597220400> is initiated by user <SYSTEM>.

25972 20400 JOB 27/07/2017 10:41:19 Processing job <sql_update_by_script>.

25972 20400 JOB 27/07/2017 10:41:19 Optimizing job <sql_update_by_script>.

25972 20400 JOB 27/07/2017 10:41:19 Job <sql_update_by_script> is started.

25972 20400 JOB 27/07/2017 10:41:19 Job <sql_update_by_script> is terminated due to error <50306>.

Let me know in case you need any additional information that can help me here.

In case the script is manually triggered, it works normally but not automatically.

Related article for the error we got:

https://archive.sap.com/discussions/thread/3916720

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

We have the same problem here. We tried lots of combinations;

exec('D:\B2\getBoardDataTruck.bat', ' ', 0);

exec('cmd','D:\\B2\\getBoardDataTruck.bat',0);

exec('cmd','C:\Program Files\Python311\python.exe D:\\B2\\getBoardDataTruck.bat',0);

exec('C:\Program Files\Python311\python.exe','D:\B2\getBoardDataTruck.py',0);

exec('cmd /c D:\\B2\\getBoardDataTruck.bat', 0);

exec('cmd','cmd /c D:\B2\getBoardDataTruck.bat', 0);

None of them worked and Script is terminated due to error <50306>.

Did you find a solution?