BookmarkSubscribeRSS Feed
Shubham5497
Fluorite | Level 6

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:

Shubham5497_2-1696425261310.png

Validation Error:

Shubham5497_1-1696425091752.png

 

 

connection string configuration:

Shubham5497_0-1696424970215.png

 

Able to select the data from the same table:

Shubham5497_3-1696425607373.png

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

 

Thanks in advance for your efforts.

4 REPLIES 4
DeanTaplin
SAS Employee

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
Fluorite | Level 6

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 

Shubham5497_0-1696443006223.png

 

Thanks again for your help.

 

Shubham5497
Fluorite | Level 6

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
SAS Employee

Excellent, glad you got it resolved.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

Discussion stats
  • 4 replies
  • 732 views
  • 3 likes
  • 2 in conversation