04-22-2018 03:06 AM
I have one data query which I have scheduled at 10am and it's working fine and its data get updated also but after 2pm it's showing error showing that data source is not accessible this data query working fine from last six months but last week I have changed its scheduling time after that it's showing error and this data query has row level security also .
I have also attached the snapshot of error here.
Thanks in advance.
04-22-2018 03:12 AM
Go to the Tables tab in SAS VA Administrator and check the status of the table - is it loaded into LASR? If it is not loaded then you will need to reload it. Also check the log of your scheduled load to see why it didn't load.
04-22-2018 08:43 AM
Did you check if the server restart is causing this issue. Contact you Admin when the server is restarted, maybe your table is not loaded after the server is restarted.