BOBJ DataProviderSQL Occasionally Shows "#SECURITY"

[TDeWitt]

I have a report that runs on a schedule with three different parameters (daily, monthly, current).  On a tab, I have the DataProviderSQL() function that populates the SQL for the FreehandSQL statement.

Infrequently, the DataProviderSQL() returns "#SECURITY" when run on the schedule.  No modifications were made to the report.  Out of the three reports run daily, the "Monthly" has this error.  There was one other day that two of the reports had the error.

The only references I have found online deal with security permissions.  This schedule is run by the system and is successful the majority of the time, but occasionally throws the error.

Any insight?

Thanks!

[amitrathi239]

Verify if the user account used for scheduled instances has the same access permissions as the account used for refreshing the report.

[TDeWitt]

Thanks for the reply.

The account used for scheduling on 10/30 is the same as the account on 10/29 and 11/01. The results came through as expected on the 29th and 1st, but did not work on the 30th.