Versions: all versions of dspCompose
Issue:
In dspCompose, when uploading an Excel file to a request, the following error is generated:
"Access to the path 'C:\Inetpub\virtualroot\RADDev\Web\UserArea\15e424d7-ff2d-414a-be30-a777ed24e56b\Files' is denied."
Please note that the error must contain the exact path shown above for the following solution to be applicable.
Resolution:
1. Navigate to dspCompose / Configuration / Parameters and validate the Parameters record. This will update the FileLocationFullPath column in the cMass.dbo.ztParam table with the correct Path. All subsequent requests should now be created with the correct path.
2. For any requests that have already been created, use SQL Server Management Studio to update the paths in the ExcelTemplateFileName and ExcelDataFileName fields in the cMass.dbo.ttRequestRole table to the value in the FileLocationFullPath of the cMass.dbo.ztParam table