Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

error_number(); data services designer

Dear All,


I am using data services designer for ETL jobs.


When I try to insert a register that already exists I get "Error: ORA-00001: unique constraint (string.string) violated"


but the value of $BITA_VGB_ERR = error_number(); is 0  and 0 means no errors.


Which is the number return by error_number() captured by a CATCH OBJECT after an ORA_00001 ?


I GET 0 but 0 is no errors and I got ORA_00001


Thanks in advance-


Best Regards


Antonio





$BITA_VGB_JOB_NAME = job_name();

$BITA_VGB_ERR = error_number();

$BITA_VGB_ERR_CTX = error_context();

$BITA_VGB_ERR_MSG = error_message();

$BITA_VGB_ERR_TIME = error_timestamp();

$BITA_VGB_ERR_DATE =  ((year(error_timestamp())* 10000) + (month(error_timestamp())*100))+ day_in_month(error_timestamp());

$BITA_VGB_FILE_JOB_LOG = 'log_'||$BITA_VGB_JOB_NAME||$BITA_VGB_ERR_DATE || '.txt';

sql('BITA_DS_DEST','INSERT INTO BITA_DW_DM_CONTROL_ERRORES (NUM_ERR, JOB_NAME_ERR, CTX_ERR, MSG_ERR, FC_REGISTRO_BBDD, DATE_ERR) VALUES('||$BITA_VGB_ERR||',{$BITA_VGB_JOB_NAME}, {$BITA_VGB_ERR_CTX},{$BITA_VGB_ERR_MSG}, sysdate,'||$BITA_VGB_ERR_DATE||')');

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question