LFF2400-DataSourceConnectionError - Connecting Oracle ODBC Connection with Forms 10.3.1

asked on May 1, 2018 • Show version history

Dears

I have an issue while creating a data source from forms.

Forms Version: 10.3.1.553

Oracle ODBC created for 64 bit, and tested and working fine.

But when I try to create a connection from Forms Data Sources, I provide the following:

DBMS Type: ODBC

Data Source Name: as written in ODBC

Account: as written in ODBC

Password: as tested in ODBC

Pressing Create button, shows the following error:

An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]

Event Viewer:

An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]

Details:
URL: /Forms/api/datasource/test
Error: DataSourceConnectionError
Date: 5/1/2018 1:00:23 PM (Arab Standard Time)
HTTP Status Code: 400
Business Process ID: 0
User: Forms Agent
IP: 127.0.0.1
Browser: Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko
Business Process Name:

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.TestDatasource(Int32 dbType, String server, String db, String user, String password, Int32 dbId)
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)

Inner exception: System.IO.FileNotFoundException
Message: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
   at Laserfiche.Forms.EntityModels.Data.OracleDBConnector..ctor(String server, String uid, String pwd)
   at Laserfiche.Forms.CommonUtils.OdbcConnector..ctor(DataBaseType dbType, String server, String database, String uid, String pwd)
   at Laserfiche.Forms.CommonUtils.OdbcConnector.GetODBCConnection(WindowsImpersonationContext& ctx, IntPtr& tokenPtr, DataBaseType databaseType, String server, String db, String user, String pw)
   at E_Forms.Models.ViewModels.DataSource.TestDatasource(Int32 dbId, Int32 dbType, String server, String db, String user, String password)
   at E_Forms.Controllers.AuthorizationController.TestDatasource(Int32 dbType, String server, String db, String user, String password, Int32 dbId)

0 0

replied on May 7, 2018

Dear Miruna

After installing ODAC, the configurations is done succesfully. but we are facing another issue while trying to ( Add or Remove Processes ) for the datasource, it shows the following error:

There must be at least one table or stored procedure in the sql database to assign it to a business process.[LFF337-NoTableStoredProcedureAssigned].

I checked with Database team, they already have views in that database??

Regards

0 0

replied on May 7, 2018

Are the views in the schema for the Oracle user specified in the data source configuration? If not, have they been aliased in this user's schema? Oracle users don't see data in other users' schemas by default.

0 0

replied on September 17, 2018

Hi Miruna,

Would you be able to elaborate further on this procedure?

0 0

replied on November 6, 2018

There were issues on permissions level, thanks all for your support

0 0

Question

Question

LFF2400-DataSourceConnectionError - Connecting Oracle ODBC Connection with Forms 10.3.1

Answer

Replies

Sign in to reply to this post.