Maintenance
Upgrading to V8
V8 Upgrade File Parameters Showing As Invalid
7 min
overview after upgrading to activate v8, some file parameters may show as invalid when viewed in activate studio or in the web portal this is typically caused by file parameter rows in the database missing a value in the valueguid column symptoms file parameters display as invalid file links generated from parameters do not resolve correctly the parameter appears to have a stored file value, but activate cannot interpret it as a valid file reference cause for file parameters, activate v8 expects the database row to include a guid reference in the valueguid column in affected records valuebinary is populated (file content exists) valueguid is null or empty (file reference is missing) value contains a pipe separated string that includes the file guid resolution step 1 identify the affected parameter locate the parameter record in the activate database select from parameter where parameterid = \<parameterid> confirm whether valuebinary is present valueguid is missing step 2 extract the guid from the value column in affected records, the value column typically contains a pipe separated list that includes file name file guid file size extract the guid value from this string step 3 update valueguid update the parameter row to set valueguid to the extracted guid update parameter set valueguid = '\<guid>' where parameterid = \<parameterid> step 4 validate the fix after updating valueguid retrieve the file url from the parameter (as generated by activate) test the url in the web portal to confirm the file loads correctly notes and considerations this issue is most commonly seen during upgrades to activate v8 where historical file parameters were stored without a populated valueguid if multiple parameters are affected, identify a repeatable method to extract and populate the correct guid values always confirm that the guid you apply matches the intended file content