Skip to main content
Kofax

ORA-01461 can bind a LONG value only for insert into a LONG column error when adding a Notification Schedule to the Support Group

18690

QAID # 18690 Published

Question / Problem:

In the User Console when adding a Notification Schedule to the Support Group an exception is reported and the Notification Schedule record is not saved.

The error message is:

ORA-01461: can bind a LONG value only for insert into a LONG column

How can this issue be resolved?

Answer / Solution:

This issue can occur in KM 6.7 when using Oracle for the KM database.

To resolve this issue do one of the following:

  • Using SQL Developer, increase the GROUPID column in the CALLSCHEDULE table from nvarchar(10) to nvarchar(50)
  • Execute the following SQL statement:
    • ALTER Table CALLSCHEDULE Modify GROUPID NVARCHAR2(50);

Complete error message:

Exception message: Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at
System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at
System.Web.UI.Page.ProcessRequest(HttpContext context) at
ASP.administration_notifications_group_scheduleedit_aspx.ProcessRequest(HttpContext context) at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Inner message: Database error
Stack trace: at Reveille.Administration.Notifications.Group.ScheduleEdit.SaveCallSchedule(Int32 id, String groupID,
String employeeID, DateTime fromDate, DateTime toDate, DateTime fromTime,
DateTime toTime, Byte supportLevel) at Reveille.Administration.Notifications.Group.ScheduleEdit.btnSave_Click(Object sender,
EventArgs e) at Infragistics.WebUI.WebDataInput.WebImageButton.OnClick(Int32 action) at
Infragistics.WebUI.WebControls.Buttons.WebButtonBase.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
Inner message: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column

Applies to: 

Product Version
MONITOR 6.7

Keywords: 01461, ORA01461