Skip to main content
Question

scheduler error while import of dumps from ifs9 database to ifscloud database

  • February 13, 2025
  • 1 reply
  • 16 views

hardik
Hero (Partner)
Forum|alt.badge.img+9
  • Hero (Partner)
  • 78 replies

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

1 reply

hardik
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • 78 replies
  • February 13, 2025

do we have to recreate the scheduler jobs?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings