TIPSA Flag 0x4000 Error After Upgrade

The flag 0x4000 in TIPSA is set in Adaptive Server versions earlier than 15.7. This flag can cause unexpected errors after an upgrade.

The TIPSA 0x4000 flag is used by the LOB compression feature in Adaptive Server 15.7. After an upgrade to Adaptive Server 15.7 and later, an LOB column for which this flag was set in earlier versions is mistakenly treated as a compressed LOB column, which results in unexpected errors. To correct the flag issue after an upgrading to Adaptive Server 15.7 and later, use:

dbcc rebuild_text()