Post reply

tabular model cube processes full fine manually but not from sql agent

  • February 18, 2024 at 2:32 pm

    Go to Answer

    #4380655

    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.

    screenshotofarcubeerroronnewserver

    arcommand

     

    • This topic was modified 1 year, 6 months ago by stan.

  • February 18, 2024 at 2:42 pm

    Answer

    #4380658

    As the error message suggests, the JSON is invalid. You have three open braces and only two closing braces.

    • This reply was modified 1 year, 6 months ago by Phil Parkin.

  • February 18, 2024 at 2:51 pm

    #4380661

    First thought, check if security and permissions for the Agents Service account are identical on all instances.

    😎

     

  • February 18, 2024 at 2:56 pm

    #4380662

    thx phil

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply