This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Problem logging in any 1IM application

Hello!

 

Today we were working as usual in 1IM and we got a problem compiling the database related with a script that we haven't touched for days. After this, now we can not log in in any 1IM application (the connectivity with the database is working and if we put a wrong password we got the typical login error) and we get the following error:

 

[810099] Assembly could not be loaded from buffer passed down.

Could not load file or assembly '1517568 bytes loaded from VI.DB, Version=7.1.2016.901, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxx' or one of its dependencies. An attempt was made to load a program with an incorrect format.
Bad IL format.

 

Any recommendation will be appreciated. Thanks,

Adri

Parents
  • The last info we get from the eventlog of the app is the following:

    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting MultiLanguageColumnDeps/global from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting CultureChain/en-US from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting MultiLanguage/QBM-D0A474E06FE2420D99D375DE94EB5CB3,en-US from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (SqlLog 8b3f683f-95f7-43eb-a098-7c5a60f2ea25) : (1 ms) - select a.AssemblyName, a.Class, a.InitialData, a.Caption, p.Ident_Product
    from DialogAuthentifier a with (nolock)
    join DialogProductHasAuthentifier pha with (nolock) on a.UID_DialogAuthentifier = pha.UID_DialogAuthentifier
    join QBMProduct p with (nolock) on pha.UID_DialogProduct = p.UID_DialogProduct
    and p.Ident_Product = N'Manager'
    and pha.IsInActive = 0
    where a.IsEnabled = 1 and a.Ident_DialogAuthentifier = N'DialogUser'

    I can not identify if the problem is for this query, because similar queries seem to work.

    I would like to raise my question again: It is ok to delete an entry in the DialogScriptAssembly table? Will it be created after compiling the DB again?

    And another question: Is there any way to compile the DB without logging in any 1IM application?

    Thanks!
Reply
  • The last info we get from the eventlog of the app is the following:

    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting MultiLanguageColumnDeps/global from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting CultureChain/en-US from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (StopWatch SW) : Getting MultiLanguage/QBM-D0A474E06FE2420D99D375DE94EB5CB3,en-US from cache. done in 0ms.
    2018-04-12 12:42:23.1441 DEBUG (SqlLog 8b3f683f-95f7-43eb-a098-7c5a60f2ea25) : (1 ms) - select a.AssemblyName, a.Class, a.InitialData, a.Caption, p.Ident_Product
    from DialogAuthentifier a with (nolock)
    join DialogProductHasAuthentifier pha with (nolock) on a.UID_DialogAuthentifier = pha.UID_DialogAuthentifier
    join QBMProduct p with (nolock) on pha.UID_DialogProduct = p.UID_DialogProduct
    and p.Ident_Product = N'Manager'
    and pha.IsInActive = 0
    where a.IsEnabled = 1 and a.Ident_DialogAuthentifier = N'DialogUser'

    I can not identify if the problem is for this query, because similar queries seem to work.

    I would like to raise my question again: It is ok to delete an entry in the DialogScriptAssembly table? Will it be created after compiling the DB again?

    And another question: Is there any way to compile the DB without logging in any 1IM application?

    Thanks!
Children
No Data