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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.