A user is attempting to complete a workflow step and recieving the error "PL/SQL: numeric or value error: character string buffer too small"
Completing the step in director gives the following stack trace info in the details. Unfortunately this is all in Bentley procedures so it is difficult to troubleshoot since I cannot view the contents. Anyone ever run into this?
PL/SQL: numeric or value error: character string buffer too small
(From DbEventHandler: 'ebh_approve_package').
<Cast from Oracle.DataAccess.Client.OracleException>Oracle.DataAccess.Client.OracleException ORA-20512: PL/SQL: numeric or value error: character string buffer too small\n\n(From DbEventHandler: '{0}').params[{ebh_approve_package}]ORA-06512: at "EBFCMS.EBP_RAISE_DB_EVENT", line 296ORA-06512: at "EBFCMS.EBP_WORK_COMPLETE", line 75ORA-06512: at line 1 at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at eB.Service.Index.Database.Command.Execute() at eB.Service.Index.IndexWriter.WorkComplete(String session, Int32 wsId)
Exception Stack Trace:{--- Begin of exception stack trace ---PL/SQL: numeric or value error: character string buffer too small
--- Begin of exception stack trace --- at System.Environment.get_StackTrace() at eB.Common.BaseException.ToString() at eB.Application.DataAdministrator.ErrorDialog.FormatException(Exception ex) at eB.Application.DataAdministrator.ErrorDialog..ctor(IWin32Window parent, String message, Exception ex, String moreInfo) at eB.Application.DataAdministrator.ErrorDialog..ctor(IWin32Window parent, String message, Exception ex) at eB.Application.DataAdministrator.Globals.ShowProxyError(Int32 errorCode) at eB.Application.DataAdministrator.FormWorkSteps.complete_Click() at eB.Application.DataAdministrator.ObjFormScrollControl.ExecuteToolbar(Int32 toolbarOption) at eB.Application.DataAdministrator.Browse.ExecuteToolbar(Int32 toolbarOption) at eB.Application.DataAdministrator.MainForm.barItemAction_Click(Object sender, EventArgs e) at Syncfusion.Windows.Forms.Tools.XPMenus.BarItem.OnItemClicked(EventArgs args) at Syncfusion.Windows.Forms.Tools.XPMenus.BarItem.PerformClick() at Syncfusion.Windows.Forms.Tools.XPMenus.BarRenderer.OnMouseUp(MouseEventArgs e) at Syncfusion.Windows.Forms.Tools.XPMenus.BarControlInternal.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at Syncfusion.Windows.Forms.Tools.XPMenus.BarControlInternal.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at eB.Application.DataAdministrator.MainForm.Main(String[] args)--- End of exception stack trace ---System.Exception: <Cast from Oracle.DataAccess.Client.OracleException>Oracle.DataAccess.Client.OracleException ORA-20512: PL/SQL: numeric or value error: character string buffer too small\n\n(From DbEventHandler: '{0}').params[{ebh_approve_package}]ORA-06512: at "EBFCMS.EBP_RAISE_DB_EVENT", line 296ORA-06512: at "EBFCMS.EBP_WORK_COMPLETE", line 75ORA-06512: at line 1 at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at eB.Service.Index.Database.Command.Execute() at eB.Service.Index.IndexWriter.WorkComplete(String session, Int32 wsId)--- End of exception stack trace ---}Inner Exception: <Cast from Oracle.DataAccess.Client.OracleException>Oracle.DataAccess.Client.OracleException ORA-20512: PL/SQL: numeric or value error: character string buffer too small\n\n(From DbEventHandler: '{0}').params[{ebh_approve_package}]ORA-06512: at "EBFCMS.EBP_RAISE_DB_EVENT", line 296ORA-06512: at "EBFCMS.EBP_WORK_COMPLETE", line 75ORA-06512: at line 1 at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at eB.Service.Index.Database.Command.Execute() at eB.Service.Index.IndexWriter.WorkComplete(String session, Int32 wsId) Stack Trace: { --- Begin of exception stack trace --- System.Exception: <Cast from Oracle.DataAccess.Client.OracleException>Oracle.DataAccess.Client.OracleException ORA-20512: PL/SQL: numeric or value error: character string buffer too small\n\n(From DbEventHandler: '{0}').params[{ebh_approve_package}]ORA-06512: at "EBFCMS.EBP_RAISE_DB_EVENT", line 296ORA-06512: at "EBFCMS.EBP_WORK_COMPLETE", line 75ORA-06512: at line 1 at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at eB.Service.Index.Database.Command.Execute() at eB.Service.Index.IndexWriter.WorkComplete(String session, Int32 wsId) --- End of exception stack trace --- }}
Hi Ryan,
I am doing some research on this error. So far I found same error has been reported before (by Eric Cota, and it was when doing document copies). At that time the errors were related to :
1. Title of documents too long (in some cases Eric identified blank spaces appended to the doc titles)
2. Documents had a large number of Copies (this was an earlier issue , 14.6.2)
Can you check if either of those are relevant to the step that user is trying to complete? I understand this is not a doc copy task you are trying , but I can see same SPs being used so worth checking , I think.
I will continue researching on your error, but wanted to share what I found so far.
thanks,
Address: Bentley | 10052 Mesa Ridge Court Suite100 | San Diego | CA | 92121 | USA
The longest title of a related document appears to be 128 characters. What is too long?
There are two document copies on each of the documents related to the workflow.
Answer Verified By: Carma De Villiers