When running the report, dowloading or uploading template to/from Azure Blob Storage you might get the following error.
EnableSharingOfValidStorageConnectionString is false. Fetching a valid storage connection string has been disabled.
The problem is caused by MS change backported to 10.0.40 and 10.0.41 in mid-August. Here is the public announcement from August 22th.
Finance and Operations Apps - End of support for sharing storage account connection strings via public API
Last known good versions are 10.0.40 (10.0.1935.92) and 10.0.41 (10.0.2015.32 Preview 2). On these environments the problem will appear if EnableSharingOfValidStorageConnectionString flight is not enabled.
Currently this flight is enabled on all Tier2+ environments (Prod, Sandbox, UDE). For tenants created after 19.8. MS will gradually start disabling it.
On Tier1 environments (CHE and local devbox) it is not enabled by default, but you can enable it by inserting it in the SysFlighting table by running the following SQL query and restarting AOS:
INSERT INTO SYSFLIGHTING (FLIGHTNAME, ENABLED, FLIGHTSERVICEID) VALUES(‘EnableSharingOfValidStorageConnectionString’, 1, 12719367)
If the above SQL query does not enable the flight (seen on one customer CHE), run the following:
declare @flightName NVARCHAR(100) = ‘EnableSharingOfValidStorageConnectionString’;
IF NOT EXISTS (SELECT TOP 1 1 FROM SysFlighting WHERE flightName = @flightName)
INSERT INTO SYSFLIGHTING(FLIGHTNAME,ENABLED, FLIGHTSERVICEID,PARTITION)
SELECT @flightName, 1, 12719367,RECID FROM DBO.[PARTITIONS];
ELSE
UPDATE SysFlighting SET enabled = 1, flightServiceId = 12719367 WHERE flightName = @flightName;
select * from SysFlighting where flightName = ‘EnableSharingOfValidStorageConnectionString’;
On Tier2+ environment you will usually not see this flight in the SysFlighting table, but it is still enabled as these environments use a different flighting service. If the problem still appears and you have SQL access, try adding it to SysFlighting table as described above and restart the environment.
Docentric is preparing a hotfix release 3.4.8.4 that works also without this flight enabled.
MS is planning more changes related to Azure Storage access. We are in touch with them and are doing our best to proactively detect and solve possible compatibility issues before they affect our customers.