tabular model cube processes full fine manually but not from sql agent
-
Hi we just migrated to a 2019 standard edition sql server from 2016 std. Two of my 3 tabular model cubes process full from my sql agent job. One doesnt. The error i see in sql agent is really long with nothing meaningful to me. I've posted it below. All 3 process under the same sql server agent service account in the job. the ssas command shows below the error. when i rt click the cube and choose process full it runs fine. The compatibility level i see on all 3 in VS from where i deployed is 2016 but i do see 2019 azure as a choice in the drop down.
- This topic was modified 9 months, 2 weeks ago by stan.
-
As the error message suggests, the JSON is invalid. You have three open braces and only two closing braces.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
First thought, check if security and permissions for the Agents Service account are identical on all instances.
😎
-
thx phil
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply