Question / Problem:
When upgrading an OPMT environment from KTA 220.127.116.11 to 18.104.22.168 the SCNJ form is not working anymore.
The following error is logged when trying to upload a document:
ThinClientServiceImpl.GetImageMaskedCommon() error: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'.
No error is logged during the installation.
The column IsDeleted is indeed missing in the documents DB BinaryObject table.
The issue seems to happens when having an 22.214.171.124 R1 system and trying to update.
Answer / Solution:
This is a known issue which is logged in Bug 1622279: 26323253 - Tenant remains active when applying OPMT 126.96.36.199 on top of 188.8.131.52
If we apply 184.108.40.206 directly onto 220.127.116.11, the tenant is marked as “Active Pending Upgrade”, we must then upgrade the tenants via VM - and the tenants are correctly upgraded,
However if we apply 18.104.22.168 onto 22.214.171.124, the tenant remains active and the upgrade scripts are therefore not executed against the tenant (as this is done via TMS)
Workaround is to run the convert data layer script again manually or the tenant's status can be updated so that we have to upgrade it via TMS . After this the column is added and the scan form is working again.
|Kofax Total Agility||7.8.0|