Symptom
You may also see the following entry in the LnlLogError.log, in the OnGuard logs folder. The Machine: and Account: values may vary.
Severity: Error
Component: PFx\Application Server\Startup
Where: a.a.d.lnl_b.a
Process: Lnl.OG.UTCConversion.Utility
Machine: ACCESSCT-SERVER
Account: ACCESSCT-SERVER\Administrator
User ID:
Description: The operation failed because the database returned the following error:
Invalid object name 'LENEL.DB_TYPE_MAP'.
Details: Database error executing a select. (SELECT DB_TYPE_MAP."DB_TYPE_MAPID",DB_TYPE_MAP."TYPE_VALUE",DB_TYPE_MAP."USE_TYPEID_FOR_VALUE",DB_TYPE_MAP."DB_TABLE_MAPID",DB_TYPE_MAP."PERSIST_TYPEID",DB_TYPE_MAP."DB_TYPE_MAPID_BASE",DB_TYPE_MAP."DB_COLUMN_MAPID_TYPE",DB_TYPE_MAP."DB_PROPERTY_MAPID_INTERNAL" FROM LENEL.DB_TYPE_MAP DB_TYPE_MAP ORDER BY DB_TYPE_MAP."DB_TYPE_MAPID")
Stack Trace:
at a.c.a.a.lnl_b.a(SqlStatement[] A_0)
at a.c.a.a.lnl_b..ctor(ICursorMapper A_0, SelectInfo A_1)
at Lnl.Persistence.Server.Database.DatabaseMapper.b(SelectInfo A_0, Boolean A_1, Boolean A_2)
at Lnl.Persistence.Server.Database.DatabaseMapper.j(SelectInfo A_0)
at Lnl.Persistence.Server.Database.DatabaseMapper.ExecuteQuery(RetrieveCriteria criteria)
at Lnl.Persistence.Server.PersistenceManagerImpl.ExecuteQuery(RetrieveCriteria criteria, IPersistenceContext context)
at Lnl.Persistence.Server.PersistenceManager.ExecuteQuery(RetrieveCriteria criteria, IPersistenceContext context)
at Lnl.Persistence.Server.PersistenceManager.ExecuteQuery(RetrieveCriteria criteria)
at a.a.d.lnl_f.a()
at a.a.d.lnl_f.b()
at a.a.d.lnl_b.a(PersistenceManager A_0, RelationalDatabase A_1, ArrayList A_2)
Resolution
To resolve the issue, follow either Solution Path 1 or Solution Path 2 below, or both, depending on which one is the issue.
Solution Path 1:
1) On the computer where the Universal Time Conversion utility is running, open the application.config file for editing.
2) Locate the following text in the application.config file:
add key="SchemaOwner" value="lenel"
3) Change the text in step 2 to look like the following:
add key="SchemaOwner" value="dbo"
4) Save and close the file.
5) Launch the Universal Time Conversion utility again. At this point, you should be prompted for the password for the OnGuard SA account.
Solution Path 2:
The Universal Time Conversion utility uses the Application Server. On Windows Server 2003 or 2008, the password for the 'lenel' database user must meet strong password requirements. Lenel's default password for the 'lenel' database user will not work.
If the database username and password are explicitly specified in the application.config file, this file must be updated to reflect the new, strong password for the 'lenel' database user.
Note that the password is required to meet strong password requirements only for the duration the Universal Time Conversion utility is executing. After execution is complete, the password can be reverted back, if desired.
Applies To
OnGuard 2009 (6.3.249) or laterSQL Server (All versions)
