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