Error in Batch Job Sdbp_Job_Error_Log- ORA-06502: PL/SQL Numeric or Value Error: Character String Buffer too Small (Doc ID 1517723.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms



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

BEGIN

SDBP_RUN_ALL_BATCH(81,'01');--ALERT=['USERNAME']

END;


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

Cause

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