Error in Batch Job Sdbp_Job_Error_Log- ORA-06502: PL/SQL Numeric or Value Error: Character String Buffer too Small
Last updated on MARCH 19, 2018
Applies to:Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.
The Batch job sdbp_job_error_log displays the following error:
ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue can be reproduced at will with the following steps:
1. Job Error Log is a stand alone job that sends an alert to a specified user when an error or a warning is encountered after running a job. Set up the following job in the Job Manager module:
job sdbp_job_error_log (x, y, sysdate-z);
where x = is the job number, y is the plant and z specifies the number of days, usually 1, to be
deducted from the current date.
2. Change the pre-existing jobs that are to be monitored for error logging - For example RUN ALL BATCH
The statement in the BEGIN-END clause tells the system which job needs to be executed. The string --ALERT=['USERNAME'] tells the application who to send the alert/email to if an error or warning is encountered. The user will receive an alert and/or e-mail notification, depending on user profile settings. The string --ALERT=[''] MUST EXIST for an alert/email to be sent to the indicated username.
3. Run the Batch job
4. Run Job Error Log Batch job
5. Check the log for Job Error Log - Error will be displayed
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms