When I'm tried to connect the laserfiche with oracle database throw ODBC and all test connections are successful in forms and ODBC, but when I clicked save the data source in laserfiche forms, I got these error :
An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]
Event log:
Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]
at E_Forms.Controllers.AuthorizationController.DataSourceSaveDatasource(Int32 dbType, String displayName, String server, String db, String user, String pw, Boolean edit, Int32 dbId)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_6.<BeginInvokeAction>b__4()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult)
Inner exception: System.OverflowException
Message: Arithmetic operation resulted in an overflow.
at System.Data.Odbc.OdbcDataReader.FirstResult()
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Laserfiche.Forms.EntityModels.Data.ODBCDBConnector.GetDataSet(String cmdTxt, ICollection`1 parameters, OdbcConnection connection)
at Laserfiche.Forms.EntityModels.Data.ODBCDBConnector.GetTable(String cmdTxt, ICollection`1 parameters)
at Laserfiche.Forms.EntityModels.Data.ODBCDBConnector.GetTableNames(String dbName)
at E_Forms.Models.ViewModels.DataSource.RegisterDataSource(Int32 dbType, String sourceDisplayName, String server, String db, String user, String pw, Boolean edit, Int32 dbId, TimeZoneInfo tz, List`1 BPsAffected)
at E_Forms.Controllers.AuthorizationController.DataSourceSaveDatasource(Int32 dbType, String displayName, String server, String db, String user, String pw, Boolean edit, Int32 dbId)
kindly find below the files attached.
Anyone faced that, please let me know how i can resolve the issue.