Overview
Collecting information from users can be difficult, through use of third-party platforms or otherwise, especially when attempting to integrate this data with your current system. This app allows you to create, send, and receive custom surveys to users directly in your Appian environment, allowing you to use this data throughout your environment as needed. This version of the Survey App uses a Record-centric approach, which allows for quicker and easier implementation.
Key Features & Functionality
Real-time reporting on survey results including drill-down by question
Hi Dai, we just got that group removed and the error should not be showing up anymore. Looking forward to hearing how your import goes!
Absolutely! I think the error is arising because the environment in which we built the app had the Group Administrators group, and the SRVY Administrators group was dependent on that. I will work to get this group removed from the import and should have an update soon. In the meantime, I believe the easiest fix would be to 1) import the app with errors, 2) manually create a SRVY Administrators group and then 3) add that Group ID to the SRVY_ADMIN_GROUP_ID Constant manually within the app itself.
If you end up trying this route, please let me know if this resolves the issue for now.
Thanks for getting back to me Chance. This is the error on inspection ...
SRVY Administrators
The group [id= uuid=_e-0000dad0-86b0-8000-7e02-010000010000_54] was not imported because a required precedent is missing: group [uuid=_e-0000d7dc-7dea-8000-4593-010000010000_7 location=Group Administrators] cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)
I have updated the customization file with group id's that already exist plus tried with the customization file that has no changes in it to see what happens and the error is the same.
Hi Dai,I see that the name of the zip file containing the Survey App was changed from submission to posting onto the App Market (it was initially Survey_App_22.3.zip).
What error are you getting upon import? And were you also including the Import Customization file? Otherwise, the import will not work.
- Chance
App doesn't import and is named incorrectly vs documentation
I need to know whether a survey produced in this app can be used by non Appian users please?
Hello,
I'm facing some issues importing this application to Appian 22.1 (getting some errors). Is this still available for latest versions ?
I fixed the issue with the SQL Query and wrote it in this format to create the view.
CREATE OR REPLACE FORCE VIEW APPIANETASC_BLAB_WRITE.SRVY_SURVEYRESPONSESVIEW
(
ID,
SURVEYID,
SURVEYEEUSERNAME,
RESPONSEDATETIME,
ISUPDATED,
ISIGNORED,
STATUS,
QUESTIONID,
QUESTIONTYPE,
QUESTIONLABEL,
ANSWERVALUE,
QUESTIONOPTIONID
)
AS
SELECT CONVERT (
'id',
response."surveyId"
|| ':'
|| question."questionId"
|| ( CASE
WHEN answer."answerid" IS NULL THEN -1
ELSE answer."answerid"
END
|| CASE
WHEN VALUE."answervalueid" IS NULL THEN -2
ELSE VALUE."answervalueid"
END),
'UTF8'),
response."surveyId",
response."surveyeeusername",
response."responsedatetime",
response."isupdated",
response."isignored",
response."status",
question."questionId",
question."type" "questionType",
question."label" "questionLabel",
VALUE."value" "answerValue",
questionoption."questionoptionid"
FROM "SRVY_SurveyResponse" response
LEFT JOIN "SRVY_SurveyAnswer" answer
ON response."responseid" = answer."surveyResponseId"
LEFT JOIN "SRVY_SurveyAnswerValue" VALUE
ON answer."answerid" = VALUE."surveyAnswerId"
JOIN "SRVY_SurveyQuestion" question
ON answer."questionId" = question."questionId"
LEFT JOIN
"SRVY_SurveyQuestionOption" questionoption
ON VALUE."value" = questionoption."value"
AND answer."questionId" = questionoption."surveyQuestionId";
But , now I get an error when I click on Responses View in the Record --> 2018-12-21 19:47:52,470 [ajp-nio-8009-exec-9] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=921, uuid=66256e67-ee8a-412d-b851-9634390896c6, name=Survey, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=d8579ffe-2fa5-421c-940d-ba2eaa0feaa2@_a-0000dad0-86bd-8000-7e03-010000010000_3187] and id 1
com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error in rule 'srvy_getsurveyresultsforsurveyid' (called by rules 'srvy_uigridshowsurveydata' > 'srvy_uirecordresultsview') at function a!queryEntity_18r3: An error occurred while retrieving the data. (APNX-1-4198-000)
Caused by: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'srvy_getsurveyresultsforsurveyid' (called by rules 'srvy_uigridshowsurveydata' > 'srvy_uirecordresultsview') at function a!queryEntity_18r3: An error occurred while retrieving the data. (APNX-1-4198-000)
Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data. (APNX-1-4261-002)
Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unexpected error executing query (type: [SurveyResponsesViewDT21324], query: [queryentity expression], order by: [[Sort[surveyeeUsername asc]]], filters:[(surveyId = TypedValue[it=1,v=1])]) (APNX-1-4164-028)
Caused by: org.hibernate.QueryTimeoutException: could not execute query
Caused by: java.sql.SQLException: ORA-01482: unsupported character set
When I look at the error , it seems to be coming from the CONVERT statement in Oracle.
Anyone knows how to fix this error?