IAPro - Issue - Change Lock - service not starting.

Issue:

IAPro web application does not come only after restarting service. Error that is showing in logs relate to system Could not release lock.

Resolve:

Review the database IADATA - IAPRO_WEB_DATABASECHANGELOGLOCK table to verify the locked value = 0 and locked granted and locked by are null. If LOCKED value = 1 and LOCKEDGRANTED and LOCKEDBY are not null, then this is causing the startup problem.

Select * from IAPRO_WEB_DATABASECHANGELOGLOCK

Run sql command below to drop the table as this table will be recreated on startup.

DROP TABLE IAPRO_WEB_DATABASECHANGELOGLOCK

Start Service Steps

Logon to COBBLUETEAMPR01
open CI Manager application.

Select the IAPro Web - Production (which should show stopped or starting )
Select the red square to start service.
- If fixed the status will change from starting to running.

Go to URL https://iaproweb.ci.bellevue.wa.us:451/login to verify the site is online.

To review the vendor incident tickets for this issue, logon to the Unite Help desk site (https://unite.iapro.com/login) and search on tickets IAWD-010734 (which is the primary ticket) and IAWD-010736 which is a follow up ticket.

The user id and password are kept in keeper as well as a phone number 1.800.620.8504 x752 to call if further assistance is needed.