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 to Adaptive Server 15.7.

The TIPSA 0x4000 flag is used by the LOB compression feature in Adaptive Server 15.7. After an upgrade to Adaptive Server 15.7, an LOB column with this flag set will be mistakenly treated as a compressed LOB column, which will result in unexpected errors. Use the following command to correct the flag issue after an upgrade to Adaptive Server 15.7.

dbcc rebuild_text()