Question / Problem:
When upgrading an OPMT environment from KTA 188.8.131.52 to 184.108.40.206 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 220.127.116.11 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 18.104.22.168 on top of 22.214.171.124
If we apply 126.96.36.199 directly onto 188.8.131.52, 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 184.108.40.206 onto 220.127.116.11, 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|