The creation of reports in ARM fails

1. The login process in the background is slow enough to make the token used for reporting to expire before all calls are done.
2. If only scheduled reports are failing, the user that scheduled the reports is not present in AD anymore or is disabled.

• Add the following configuration switch in C:\ProgramData\protected-networks.com\8MAN\cfg\pnServer.config.xml. You can add it before the last </config>. The configuration file is found on the ARM server.

<debugging.ott.expiration type="System.Int32">120</debugging.ott.expiration> 

• Restart the ARM Service
• Try to run the report again.

• Please add the following switch in the pnServer.config.xml file in the same way mentioned above.

<options.referalChasingOption>None</options.referalChasingOption>

• Save the file and restart the ARM service.
• Try the login again.
• Try to run the reports again.

• If there are only a few scheduled reports, we would recommend to just recreate them manually.
• If there are a lot of scheduled reports affected and they were all scheduled by the same user, please execute the following script on the ARM database to change the report owner in bulk.

BEGIN TRANSACTION

		DECLARE @ScheduledReportOwnerUserName NVARCHAR(MAX);
		DECLARE @ScheduledReportOwnerDomainName NVARCHAR(MAX);
		
		SET @ScheduledReportOwnerUserName= 'robert.mustermann'
		SET @ScheduledReportOwnerDomainName= 'pneng'

		IF OBJECT_ID(N'tempdb..#Temp') IS NOT NULL
		BEGIN
			DROP TABLE #Temp
		END

		CREATE TABLE #Temp
		(
			ReportId nvarchar(255)
		);

	BEGIN TRY

		Insert into #Temp
		select _value from _jobconfig_object_values
		where _property = 'scheduledreportid'

		UPDATE v SET v._value = @ScheduledReportOwnerUserName
		FROM _jobconfig_object_values jov
		INNER JOIN _jobconfig_object_values v on v._id = jov._id
		WHERE 
		jov._property='scheduledreportid' and jov._value in (select * from #Temp) 
		and 
		(v._property='reportusername' or v._property='ownerusername');

		UPDATE v SET v._value = @ScheduledReportOwnerDomainName
		FROM _jobconfig_object_values jov
		INNER JOIN _jobconfig_object_values v on v._id = jov._id
		WHERE 
		jov._property='scheduledreportid' and jov._value in (select * from #Temp) 
		and 
		(v._property='owneruserdomainname' or v._property='reportuserdomainname')

		COMMIT TRANSACTION
		DROP TABLE #Temp

	END TRY

	BEGIN CATCH
		THROW;
		IF @@TRANCOUNT > 0
		BEGIN
			ROLLBACK TRANSACTION
		END
	END CATCH