topic Re: Update query validation error in SAS Intelligence Decisioning in Decisioning

Update query validation error in SAS Intelligence Decisioning

Shubham5497 — Wed, 04 Oct 2023 13:23:09 GMT

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.

Re: Update query validation error in SAS Intelligence Decisioning

DeanTaplin — Wed, 04 Oct 2023 17:06:34 GMT

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?

Re: Update query validation error in SAS Intelligence Decisioning

Shubham5497 — Wed, 04 Oct 2023 18:10:44 GMT

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.

Re: Update query validation error in SAS Intelligence Decisioning

Shubham5497 — Wed, 04 Oct 2023 18:19:37 GMT

Hi @DeanTaplin Thanks for your help .

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

Thanks agin

Re: Update query validation error in SAS Intelligence Decisioning

DeanTaplin — Wed, 04 Oct 2023 18:50:14 GMT

Excellent, glad you got it resolved.