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