You are viewing limited content. For full access, please sign in.

Question

Question

LFF502-UnexpectedError search rules is empty

asked on June 26, 2018

Hi all,

 

One of our customer have an error with the search rules.

It looks like the database is empty.

This is worked before.

 

My table exist and I have records inside.

 

From Laserfiche Form, my database is connected but I can't select the columns. The fields are empty (they were filled before).

 

From Event Viewer, I have this error.

Une erreur inattendue s'est produite. [LFF502-UnexpectedError]

Details:
URL: 
Error: UnexpectedError
Date: 25/06/2018 16:09:12 (Hawaii)
HTTP Status Code: 500
Business Process ID: 0
Business Process Name: 

Other:
Compteur de pièces jointes : 0

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: Une erreur inattendue s'est produite. [LFF502-UnexpectedError]


Inner exception: System.Threading.ThreadAbortException
Message: Le thread a été abandonné.
   à System.Threading.Monitor.Enter(Object obj)
   à System.Data.SqlClient.SqlConnectionPoolGroupProviderInfo.AliasCheck(String server)
   à System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
   à System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   à System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   à System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   à System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   à System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   à System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   à System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   à System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   à System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   à System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   à System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   à System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   à System.Data.SqlClient.SqlConnection.Open()
   à System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   à System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
   à System.Data.Entity.Infrastructure.DbExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
   à System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
   à System.Data.Entity.Core.EntityClient.EntityConnection.Open()
   à System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
   à System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   à System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   à System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   à System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   à System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   à Forms.Persistence.EntityFramework.Repositories.OptionRepository._GetAttachmentCounterEntry()
   à Forms.Persistence.EntityFramework.Repositories.OptionRepository.SetAttachmentCounterAndCommit(Int64 counterValue)
   à E_Forms.MvcApplication.<>c__DisplayClass6_0.<Application_End>b__0()

 

The services are started.

 

I don't know why I can't select my columns.

 

Someone have some explications?

 

Thanks in advance.

Regards

0 0

Answer

SELECTED ANSWER
replied on June 26, 2018 Show version history

Hi Olivier,

The error log indicates the connection from Forms to your database failed. We can check whether the connection to your database server is still valid by the following steps (Forms 10.3.1.552).

1. Click on your name on the right top corner, choose "Administration"

2. On the page, select "Data Sources" on the left panel

Then there will be a list of the data sources on your main page, that is the connections to the db from Forms

3. Click on your database, for example "TEP" in your this case

4. On your right top corner, click on Edit,

5. a dialog of the connection will show up, click on "Test Connection" button, to see whether the database connection in Forms is still valid. If you get the error as below, you can update your settings accordingly.

 

Let me know whether this fixes the exception.

1 0
replied on June 28, 2018

Hi Ming, you right,

 

My client deleted the account that could connect to the database XD

Thank you very much.

 

Regards

 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.