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.
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?
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.
Hi @DeanTaplin Thanks for your help .
Issue got resolved after setting the read ,write and execute permission for files inside the directory.
Thanks agin
Excellent, glad you got it resolved.