+1
Hi,
We have a SSL execution that works properly when started from the SSL Executions panel (right click - Execute).
But it fails when executed from a Job. The message in the Job log:
Version 6221.1
Any ideas?
BR
Anders
Best answer by anders.e.jonsson
View original
+5
Hi
What happens when you execute the execution package containing the SSL? Can you please share the execution package settings? Have you deployed the SSL instance after setting up the execution package?
In order to troubleshoot further, could you please try executing a job with only the SSL execution package (currently it looks like you are executing both MDW and SSL execution packages in one job)?
+1
Hi
When the execution package is executed in the SSL Execution panel it works fine.
These are the settings:
If I run the job with the SSL execution package as the only task, the result is the same. The execution fails, stating that the database doesn´t exist.
The database remains unaffected.
BR
Anders
+5
Hi
+1
Hi
I deleted the db in SSMS, and redeployed and executed.
But I’m afraid it was the same result as before when I executed the job. “The 'Database' with 'Name' = 'xx' doesn't exist in the collection.”
BR
Anders
+5
OK thanks for checking this. I will go ahead and create a support ticket for this, in order for us to investigate further.
+1
Hi,
It turned out to be an access problem. The account for the TimeXtender Execution Service was not authorized to process the SSAS database.
So the error message was a bit misleading.
/Anders
+5
Good to hear the issue has been resolved - by adding the user running the TimeXtender Execution Service under security properties for the SSAS database
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
