Survey responses don't get stored in asmt_metric_result table

Rashid Yakhyaev · ‎12-29-2020

Hello!

After an upgrade to Paris patch 3, we are experiencing problems with our survey. The responses do not get stored in the asmt_metric_result table anymore.

The survey works and the users responses are created but not stored, for some weird reason.

Has anyone else ran into the same problem? I have checked the known error portal but can't find anything there either.

Any advice is appreciated!

Rashid Yakhyaev · ‎01-04-2021

Just had a chat with ServiceNow. The survey had "Anonymize responses" set to true, which means that you have to have a "guest" user/account on the instance, which we did not have. So we created a user with the id "guest" and firstname Guest and now everything works as it should

View solution in original post

Ct111 · ‎01-01-2021

Hello,

Can you crosscheck whether the survey is created in Global scope or any other scope.

Because one member faced one issue when the survey was created in Human Resource Service Portal scope , as a result we had to give him some additional roles just for him to view all the survey responses....

OR

Do you have sufficeinet roles to veiw surveys... As you said that surveys are gettign created but you dont see responses... so are you checking the below path for responses...?

LINK

Mark my ANSWER as CORRECT and HELPFUL if it helps

Rashid Yakhyaev · ‎01-03-2021

Hi,

The survey is in the global record and roles do not seem to be the issue, however I noticed that the "evaluation type" under the "assessment metric types" is "Survey" and not "Assessment", maybe that could be the issue?

Ct111 · ‎01-03-2021

Is any of your instance in prior version ? I mean your prod environment might be in prev version so compare everything in that with this dev version and see the difference....

Rashid Yakhyaev · ‎01-03-2021

All the instances have the same version, paris patch 3 and all instances have the same problem.