Krum_Ganev

Clearing activities with script

Discussion created by Krum_Ganev on Sep 15, 2017
Latest reply on Oct 4, 2017 by Wolfgang_Brueckler_1288
Hello All,

So far I implemented the following : 

VARA.SQLI.GET_RUNIDS
SELECT AH_Idnr  FROM GAED.AH WHERE trunc(AH_Timestamp4) <= to_date('2017-09-13','YYYY-MM-DD');
Note : this SQL statement was made on SQL Server, if you're using Oracle you'll need to convert the timestamp. 


SCRI.DEACTIVATE_TASKS
:SET &HND# = PREP_PROCESS_VAR(VARA.SQLI.GET_RUNIDS)
:PROCESS &HND#
:  SET &RUNID# = GET_PROCESS_LINE(&HND#,1)
:  SET &DEACT# = DEACTIVATE_UC_OBJECT(&RUNID#)
:  SET &TASKNAME# = GET_STATISTIC_DETAIL(&RUNID#, NAME)
:  PRINT Task &TASKNAME# with RunID &RUNID# has been deactivated
:ENDPROCESS

But when i execute the script Ive got bellow error :
U00020274 Wrong SQL statement in 'VARA.SQLI.GET_RUNIDS'. DB error: 'U00003754 Database-error in SQLI-variable: 'U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00933: SQL command not properly ended''

I had a chat with member of Database team and he confirm that this statement is correct and he is able to execute it.

Would you share your opinion? 
I suppose Im doing something wrong but can not find out what.

P.S. Ive tried to run this with and without DB service agent.

Much appreciated. 

Krum Ganev

Outcomes