Documentation error

Errors generated by the scheduler program are displayed on the error message window.

Screenshot PL/SQL scheduler window W02 Error message

The above screenshot displays error OSC-10026.
An error message can have variable parts; this is the text between double quotes. The above message has two variable parts, the first variable part has value PLSQL5 and the second variable part has value SO_TEST_SCRIPT5.

Back to top 

Error index

10000  10001  10002  10003  10004  10005  10006  10007  10008  10009  10010  10011  10012  10013  10014  10015  10016  10017  10018  10019  10020  10021  10022  10023  10024  10025  10026  10027  10028  10029  10030  10031  10032  10033  10034  10035  10036  10037  10038  10039  10040  10041  10042  10043  10044  10045  10046  10047  10048  10049  10050  10051  10052  10053  10054  10055  10056  10057  10058  10059  10060  10061  10062  10063  10064  10065  10066  10067  10068  10069  10070  10071  10072  10073  10074  10075  10076  10077  10078  10079  10080  10081  10082  10083  10084 

Back to top 

Scheduler errors

In the next table all scheduler error messages are listed.

Error Description
OSC-10000
SCRIPT PARAMETER "%1"."%2"."%3" VALUE LENGTH "%4" EXCEEDS MAXIMUM "%5"
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
%4 = Scheduler task parameter value.
%5 = The maximum length of the varchar2 parameter.
The script parameter defines a maximum length %5 but the scheduler task parameter string value has a length of %4.
OSC-10001
SCRIPT PARAMETER "%1"."%2"."%3" VALUE IS MANDATORY
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
The script parameter is mandatory but no scheduler task parameter value was given.
OSC-10002
SCRIPT PARAMETER "%1"."%2"."%3" VALUE CANNOT BE NULL
%1 = Scheduler script.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
The scheduler task parameter value cannot be NULL.
OSC-10004
SCRIPT PARAMETER "%1"."%2"."%3" VALUE "%4" HAS MORE DIGITS THAN ALLOWED "%5"
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
%4 = Scheduler task parameter value.
%5 = Scheduler script parameter digits.
The scheduler task parameter number value has too many digits.
OSC-10005
SCRIPT PARAMETER "%1"."%2"."%3" VALUE "%4" NO DECIMALS ALLOWED
%1 = Scheduler script owner
%2 = Scheduler script name
%3 = Scheduler script parameter name
%4 = Scheduler task parameter value.
The scheduler task parameter number value cannot contain decimals.
OSC-10006
SCRIPT PARAMETER "%1"."%2"."%3" VALUE "%4" TOO MANY DECIMALS "%5"
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
%4 = Scheduler task parameter value.
%5 = Scheduler script parameter decimals.
The scheduler task parameter number value has too much decimals.
OSC-10007
SCRIPT PARAMETER "%1"."%2"."%3" VALUE WRONG DATATYPE "%4" (NEEDED "%5")
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
%4 = Scheduler task parameter datatype.
%5 = The scheduler script parameter datatype.
The scheduler task parameter value has the wrong datatype.
OSC-10008
SCRIPT "%1"."%2" DOES NOT EXIST
OSC-10009
SCRIPT PARAMETER "%1"."%2"."%3" DOES NOT EXIST FOR TASK "%4"
OSC-10010
SCHEDULER USER "%1" CANNOT ACCESS SCRIPT "%2"."%3"
%1 = Scheduler user name.
%2 = Scheduler script owner.
%3 = Scheduler script name.
The user cannot create or change a scheduler task with this script.
OSC-10011
NO SCHEDULE DATE POSSIBLE
A new schedule date could not be calculated.
OSC-10012
SCRIPT PARAMETER "%1"."%2"."%3" CANNOT HAVE A TIME PART
%1 = Scheduler script owner.
%2 = Scheduler script name.
%3 = Scheduler script parameter name.
The scheduler task parameter date value has a time part but it should only contain a date.
OSC-10013
USER "%1" IS NOT REGISTERED
%1 = Oracle database user.
The user is not registered as a scheduler user.
OSC-10014
ORACLE SQL ERROR INSERT SCHEDULER TASK "%1"
%1 = Error message.
An oracle error occured while creating a scheduler task.
Also check the scheduler server log for extra errors.
OSC-10015
SCRIPT "%1"."%2" IS BLOCKED
%1 = Scheduler script owner.
%2 = Scheduler script name.
The scheduler script is blocked so no scheduler tasks can be created or changed for this script.
OSC-10016
TASK "%1" WITH STATUS "%2" CANNOT BE KILLED
%1 = Scheduler task id.
%2 = Scheduler task status.
The task could not be killed.
OSC-10017
SCHEDULER USER "%1" IS BLOCKED
%1 = Scheduler user name.
The user is blocked so no scheduler tasks with scheduler scripts created by this user can be scheduled or changed.
OSC-10018
TASK "%1" DOES NOT EXIST
%1 = Scheduler task id.
The task does not exist.
OSC-10019
TASK "%1" WITH STATUS "%2" CANNOT BE CHANGED
%1 = Scheduler task id.
%2 = Scheduler task status.
A task can only be changed if the scheduler task status is Scheduled or Hold.
OSC-10020
SCHEDULER USER "%1" HAS READ ACCESS
%1 = Scheduler user name.
The user only has read access and can only view data but not update anything.
OSC-10021
TASK "%1" CANNOT BE SKIPPED; LAST SCHEDULE AT "%2"
%1 = Scheduler task id.
%2 = The last date and time the task can be scheduled.
The task cannot be skipped because the maximum tasks has been reached.
OSC-10022
TASK "%1" IS A CHILD TASK; PARAMETERS CANNOT BE CHANGED
%1 = Scheduler task id.
The parameter values cannot be changed if a scheduler task is a child task (the task is started from within another task).
OSC-10023
SCHEDULE TIME "%1" HAS NOT FORMAT HH24:MI:SS
%1 = Value schedule time parameter.
Time format must be HH24:MI:SS.
OSC-10024
CANNOT COMBINE RESTART ON ERROR AND OVERTIME ERROR
Restart on error and overtime error cannot be set at the same time.
OSC-10025
FLOW TASK "%1" DOES NOT EXIST
%1 = Scheduler task id.
The task does not exist.
OSC-10026
SCRIPT "%1"."%2" IS STILL IN USE
%1 = Scheduler script owner.
%2 = Scheduler script name.
The script cannot be deleted because one or more scheduler tasks exist.
Delete the tasks manually before trying to delete the script again.
OSC-10027
USER "%1" IS NOT ALLOWED TO GRANT SCRIPTS OWNED BY "%2"
%1 = Scheduler user name.
%2 = Scheduler user name.
A user must have the administrator privilege when it wants to grant scheduler scripts from another user.
OSC-10028
USER "%1" HAS NO DEVELOPER PRIVILEGE
%1 = Scheduler user name.
A user must have the developer privilege before it can create, change, delete or grant scheduler scripts.
OSC-10029
ORACLE USER "%1" DOES NOT EXIST
%1 = Oracle user name.
The oracle user does not exist in the database.
OSC-10030
SCHEDULER USER "%1" HAS NO ADMINISTRATOR PRIVILEGES
%1 = Scheduler user name.
For the requested action the scheduler user needs the administrator privilege.
OSC-10031
SCHEDULER INSTALLATION USER "%1" CANNOT BE DELETED
%1 = Scheduler user name.
The scheduler installation user must always stay registered as a scheduler user.
OSC-10032
SCHEDULER USER "%1" CANNOT BE DELETED; ONE OR MORE SCRIPTS EXIST
%1 = Scheduler user name.
The user cannot be deleted because still scheduler scripts exists created by this user.
Note that these scripts in turn can only be deleted if no more scheduler tasks exist for these scripts.
OSC-10033
SCHEDULER USER "%1" HAS NO RIGHTS TO SCHEDULE "%2"
%1 = Scheduler user name.
%2 = Schedule privilege.
The user needs the associated schedule privilege to create or change the scheduler task.
OSC-10034
QUEUE NAME IS NULL
OSC-10035
CANNOT DELETE QUEUE "%1"; USED AS DEFAULT IN "%2" SCRIPT(S)
%1 = Scheduler queue name.
%2 = Number of scheduler scripts.
The scheduler queue could not be deleted because it is used as a scheduler script default queue.
OSC-10036
CANNOT DELETE QUEUE "%1"; USED IN "%2" TASK(S)
%1 = Scheduler queue name.
%2 = Number of scheduler tasks.
The scheduler queue could not be deleted because one or more scheduler tasks are created in this queue.
Delete the tasks before deleting the queue.
OSC-10037
NO QUEUE SPECIFIED
No scheduler queue is given. Each scheduler task must be scheduled in a queue.
OSC-10038
QUEUE "%1" DOES NOT EXIST
%1 = Scheduler queue name.
The queue does not exist.
OSC-10039
SCRIPT NAME "%1" TOO LONG
%1 = Scheduler script name.
The name of the script can have a maximum length of thirty characters.
OSC-10040
QUEUE NAME "%1" TOO LONG
%1 = Scheduler queue name.
The name of a queue has a maximum length of 32 characters.
OSC-10041
SCRIPT PROCEDURE "%1" TOO LONG
%1 = Script procedure.
The script procedure can have a maximum length of 64 characters.
OSC-10042
SCRIPT CHECK PROCEDURE "%1" TOO LONG
%1 = Scheduler script check procedure.
The script check procedure can have a maximum length of 64 characters.
OSC-10043
SCRIPT CREATE OR REPLACE NOT CORRECT INITIALIZED
Before a scheduler script can be created or changed the procedure so_script.init_create must be called.
OSC-10044
SCRIPT NAME IS NULL
OSC-10045
CANNOT CREATE PROCEDURE WHEN SCRIPT NAME EQUALS PROCEDURE NAME
A PL/SQL database procedure for the scheduler script cannot be created when it has the same name as the PL/SQL program that is executed.
OSC-10046
SCRIPT PARAMETER NAME IS NULL
OSC-10047
SCRIPT PARAMETER NAME "%1" TOO LONG
%1 = Scheduler script parameter name.
The name of a script parameter can have a maximum length of 32 characters.
OSC-10048
SCRIPT PARAMETER "%1" VARCHAR2 LENGTH "%2" INVALID
%1 = Scheduler script parameter name.
%2 = Scheduler script parameter length.
The maximum length of a varchar2 parameter value must lie between 1 and 4000
OSC-10049
SCRIPT PARAMETER "%1" NUMBER DIGITS "%2" INVALID
%1 = Scheduler script parameter name.
%2 = Scheduler script parameter digits.
The maximum number of digits of a number parameter value must lie between 1 and 38.
OSC-10050
SCRIPT PARAMETER "%1" NUMBER DECIMALS "%2" INVALID
%1 = Scheduler script parameter name.
%2 = Scheduler script parameter decimals.
The number of decimals of a number parameter must lie between 0 and 38
OSC-10051
SCRIPT PARAMETER "%1" NUMBER DECIMALS "%2" GREATER THAN DIGITS "%3"
%1 = Scheduler script parameter name.
%2 = Scheduler script parameter decimals.
%3 = Scheduler script parameter digits.
The number of decimals must be smaller than the number of digits.
OSC-10052
SCRIPT PARAMETER "%1" MUST HAVE A DEFAULT EXPRESSION
%1 = Scheduler script parameter name.
If a parameter is not mandatory and at the same time is not nullable it must have a default expression.
OSC-10053
WRONG LICENSE "%1" DATABASE "%2" COMPANY "%3"
%1 = License number.
%2 = Database name.
%3 = Company name.
Software with the wrong license is installed in the database.
OSC-10054
PROGRAM MUST BE EXECUTED UNDER SCHEDULER OWNER "%1"
%1 = Scheduler user name.
The PL/SQL code must be executed under the installation user.
OSC-10055
LICENSE "%1" DATABASE "%2" COMPANY "%3" EXPIRED AT "%4"
%1 = License number.
%2 = Database name.
%3 = Company name.
%4 = Expire date.
The license has expired for this particular database.
OSC-10056
SCRIPT PARAMETER "%1" MUST BE VISIBLE
%1 = Scheduler script parameter name.
If a parameter is mandatory and no parameter default is specified it must be visible.
OSC-10057
SCRIPT PARAMETER "%1" DEFAULT "%2" TOO LONG
%1 = Scheduler script parameter name.
%2 = Scheduler script parameter default.
The default expression has a maximum length of hundred characters.
OSC-10058
TASK "%1" DOES NOT HAVE A FLOW
%1 = Scheduler task id.
The scheduler task is not part of a flow.
OSC-10059
SCRIPT "%1"."%2" CAN ONLY BE SCHEDULED AS A CHILD
%1 = Scheduler script owner.
%2 = Scheduler script name.
The script can only be submitted from within a running task because the scheduler script childtask always is set.
OSC-10060
COULD NOT CREATE DATABASE PROCEDURE SCRIPT "%1"."%2" "%3"
%1 = Scheduler script.
%2 = Scheduler script name.
%3 = Database error.
The PL/SQL database procedure for this script could not be created.
OSC-10061
NO SCRIPT PARAMETER DEFINED
Before the list of values can be added a script parameter must be defined.
OSC-10062
PARAMETER LIST VALUE DATATYPE "%1" DIFFERS FROM PARAMETER DATATYPE "%2"
OSC-10063
SOFTWARE RELEASE SERVER "%1" NOT COMPATIBLE WITH CLIENT RELEASE "%2"
%1 = Scheduler server release.
%2 = Scheduler client release.
The scheduler server software in the database is not compatible with the full client program.
Use the correct client version compatible wih the server software. The client program can be freely downloaded.
OSC-10064
USER SESSION NOT CORRECT INITIALIZED
The user database session was not correctly initialized. Check the previous error messages.
OSC-10065
SCHEDULER FUNCTIONALITY CAN ONLY BE USED WITHIN A RUNNING TASK
An attempt was made to use scheduler software (a PL/SQL procedure or function call) that can only be used within a running task.
OSC-10066
TASK "%1" SUSPEND IS DISABLED
%1 = Scheduler task id.
Before a scheduler task can be suspended the suspend option must be enabled.
OSC-10067
TASK "%1" WITH STATUS "%2" CANNOT BE SUSPENDED
%1 = Scheduler task id.
%2 = Scheduler task status.
The task has enabled the suspend option but is not running anymore.
OSC-10068
TASK "%1" CANNOT BE RESTARTED
%1 = Scheduler task id.
The task could not be restarted.
OSC-10069
DESTINATION NAME IS NULL
Each new task output destination must have a name.
OSC-10070
DESTINATION NAME "%1" TOO LONG
%1 = Task output destination.
The name of an new task output destination may not exceed 32 characters.
OSC-10071
DESTINATION "%1" DOES NOT EXIST
OSC-10072
INVALID DESTINATION IDENTIFIER "%1"
%1 = Task output destination identifier.
An invalid task output destination identifier is used.
OSC-10073
UNABLE TO ACTIVATE TASK "%1"
%1 = Scheduler task id.
The scheduler server is not able to activate the scheduler task. The error can be found in the scheduler server log.
OSC-10074
UNABLE TO SEND DATA TO SCHEDULER SERVER (PIPE ERROR "%1")
%1 = Oracle pipe error.
Check the oracle documentation to correct the error.
OSC-10075
COULD NOT CREATE PIPE FOR WAITING TASK (SQLERRM "%1")
%1 = Oracle sql error message.
Check the oracle documentation to correct the error.
OSC-10076
COULD NOT REMOVE PIPE FOR WAITING TASK (SQLERRM "%1")
%1 = Oracle sql error message.
Check the oracle documentation to correct the error.
OSC-10077
SERVER PROCESS ERROR ON RECEIVING MESSAGE FROM PIPE (SQLERRM "%1")
%1 = Oracle sql error message.
Check the oracle documentation to correct the error.
OSC-10078
RESULT VALUE "%1" SERVER PIPE RECEIVE MESSAGE
%1 = Oracle pipe error.
Check the oracle documentation to correct the error.
OSC-10079
SERVER PIPE UNPACK MESSAGE FAILED (SQLERRM "%1")
%1 = Oracle sql error message.
Check the oracle documentation to correct the error.
OSC-10080
CORRUPT HEADER SERVER PIPE MESSAGE "%1"
%1 = Pipe message.
The scheduler server received an invalid message.
OSC-10081
SCHEDULER USER "%1" CANNOT CHANGE HIS OWN PRIVILEGES
%1 = Scheduler user name.
A user cannot grant or revoke privileges to himself.
OSC-10082
TASK REPEAT TILL TIME "%1" HAS NOT FORMAT HH24:MI:SS
%1 = Value task schedule repeat till parameter.
Time format must be HH24:MI:SS.
OSC-10083
SCRIPT NAME "%1" CONTAINS ILLEGAL CHARACTERS "%2"
%1 = Scheduler script name.
%2 = The illegal characters.
The scheduler script name is not valid; remove the illegal characters.
OSC-10084
SCRIPT PARAMETER NAME "%1" CONTAINS ILLEGAL CHARACTERS "%2"
%1 = Scheduler script parameter name.
%2 = The illegal characters.
The scheduler script parameter name is not valid; remove the illegal characters.
Back to top 

Oracle errors

During scheduling and running tasks also oracle errors may pop up. Below is a short list of errors that may occur and what to do with them.
Other errors can be found on the internet.

Error Description
ORA-00018
MAXIMUM NUMBER OF SESSIONS EXCEEDED
The maximum allowable sessions of the database has been reached.
Increase the value of the oracle initialization parameter sessions. See the installation parameters how to do this.
ORA-01017
INVALID USERNAME/PASSWORD; LOGON DENIED
The username and passord combination is not correct or the oracle user does not exists.
Back to top