Windows Task Scheduler is not able to create a pdf from EPM

Question

We are scheduling a distribution offline using windows task scheduler from EPM.

So basically it's a daily report. it creates the file from EPM (excel add in) and email to the users.

We have two formats: workbook and PDF.

The workbook works fine with distribute now and schedule distribution.

But the pdf format works fine only with distribute now option.

The schedule is not working with pdf format.

No errors, the task runs successful. But no file is getting created.

So we did a trace and it says "the pdf is still locked"

The weird thing is if we use a different user's Microsoft account(from different domain/client), it works perfectly. In all the above cases the EPM runs with the same user.(we only switched the Microsoft account)

The only time it worked is when we just switch the Microsoft excel account with a different domain user.

Office subscription is not an issue. Dcom is configured correctly. User has right privilege.

To be honest, i hit a dead end here.

Office subscription is not an issue.

Dcom is configured correctly.

User has right privilege.

Answer 1

Even though the issue hasn't been resolved completely, we have found a workaround.

Once you schedule the distribution, log out of the Microsoft excel.

Then the task will create the pdf and send it to the users

Answer 2

Windows privacy protection is blocking the pdf generation because of sensitivity labels.

The print option won't work because of this.

The solution is to use different virtual pdf printer other than Microsoft print to pdf