Hello All,
We are in process of upgrading from IFS9 to IFSCLOUD for one customer.
while importing the dumps on ifscloud 19c database we are getting scheduler errors.
Anyone come across the same issue before? How to tackle this or can be ignored?
Any help is appreciated here!
12-FEB-25 19:03:43.536: KUPW: ORA-39083: Object type PROCOBJ:"IFSAPP"."F1JOB_131" failed to create with error:
ORA-06550: line 12, column 113:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 12, column 20:
PL/SQL: SQL Statement ignored
ORA-06550: line 15, column 54:
PLS-00364: loop index variable 'ARG' use is invalid
ORA-06550: line 15, column 2:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
dbms_scheduler.create_job('"F1JOB_131"',
program_name=>'"RUN_JOB"',
start_date=>TO_TIMESTAMP_TZ('08-MAY-2022 01.48.23.000000000 PM EUROPE/BERLIN','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>
'sysdate + 5/86400'
, end_date=>NULL,
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments=>
'Transaction_SYS.Process_All_Pending__(7,''360 IN'',''%'',job_id_)'
);
sys.dbms_scheduler.set_attribute('"F1JOB_131"','NLS_ENV','NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_CHARACTERS=''. '' NLS_CALENDAR=''GREGORIAN'' NLS_
12-FEB-25 19:03:43.536: KUPW: ORA-39083: Object type PROCOBJ:"IFSAPP"."F1JOB_134" failed to create with error:
ORA-06550: line 12, column 113:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 12, column 20:
PL/SQL: SQL Statement ignored
ORA-06550: line 15, column 54:
PLS-00364: loop index variable 'ARG' use is invalid
ORA-06550: line 15, column 2:
PL/SQL: Statement ignored