VERIFIED SOLUTION i

Portrait HQ - Error 27506. Error executing SQL script PortraitDWSchema.sql during upgrade of Portrait Data Warehouse database


 

Issue

The Portrait Shared Server installer reports the following error when upgrading an existing (pre-v2.0) Portrait Data Warehouse (PDW) database:

Error 27506. Error executing SQL script PortraitDWSchema.sql. Line 682. Query timeout expired (0).


User-added image

Cause

This can occur when upgrading PDW databases containing large amounts of treatment log data (TREATMENT_OFFER_LOG), where creating new indexes on that data takes longer than 30 seconds.
 

Resolution

UPDATED: April 7, 2017
Patch TFS-31537 for the Portrait Shared Server installer (setup.exe).to HQ 2.0 fixes this issue. 

Please contact Software Support and request patch TFS-31537.