on 11-14-2017 1:33 PM
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:
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.