This discussion is archived
0 Replies Latest reply: Jan 2, 2013 6:14 PM by 982606 RSS

Ora-20001 Invalid input parameter  =>parameter string(appended) ORA-06512 a

982606 Newbie
Currently Being Moderated
Hi, I am scheduler adminstrator. The oracle job is scheduled to run monthly. Currently it abended with Above error. The extra string is found with the parameter. The user is blaming the scheduler is appending an extra string to the parameter. The First user sent me this error log :
DECLARE
*
ERROR at line 1:
ORA-20001: |DATA_MAINTENANCE|Invalid Input Parameter |Group name =>
ERR$/THPDATA:/USR/BIN/FALSE
ORA-06512: at line 13

Then later clarify with more detail saying it is scheduler who throwing an error.

/bin/ksh /thpdb/data_scripts/job/data_maint_process_data_by_group -n ods_err_tables_qtrly -g ERR$/thpdata:/usr/bin/false^Jeaius

The job definition ends at ERR$.

The definition is: /thpdb/data_scripts/job/data_maint_process_data_by_group -n ods_err_tables_qtrly -g ERR$
I am not sure, and need help. There is no update occur in our scheduling application but not sure about the oracle yet. I believe this the db application error. Please help

Thanks for your help in advance!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points