Update query validation error in SAS Intelligence Decisioning

[Shubham5497]

Hi All,

I am stuck with one problem don't know how to resolve this issue.

I am trying to update the table data by using data query in sas intelligence decisioning but when I am trying to validate the query I am getting below error however I am able to select the data from the same table.

update code:

Validation Error:

connection string configuration:

Able to select the data from the same table:

Am I missing something  or need to do any additional configuration ?

Thanks in advance for your efforts.

[DeanTaplin]

Assuming you're using Viya 4 can you check the logs for the sas-microanalytic-score pod? That might give a clue why the update failed. Also was there a reason the table and column name are quoted in the update statement?

[Shubham5497]

Hi @DeanTaplin  Thanks for your reply.

No, it's the Viya 3.5 version and I tried to understand the issue from the log but couldn't able to understand the exact issue.

for reference, I am attaching the log file.

I have created the libname which points to the location :/sasdata

below is the screenshot of the permission 

Thanks again for your help.

[Shubham5497]

Hi @DeanTaplin  Thanks for your help .

Issue got resolved after setting the read ,write and execute permission for files inside the directory.

Thanks agin

[DeanTaplin]

Excellent, glad you got it resolved.