User ID: lukeberkheiser
SSOID: lukeberkheiser
Error:
ProjectId : 524964635
select sso_id, c_ccp_status from users where login = 'lukeberkheiser'
userDetails output = {
"status" : "success",
"message" : "",
"http_code" : 200,
"data" : {
"type" : "users",
"list_item_type" : "user",
"size" : 1,
"items" : [ {
"type" : "user",
"sso_id" : "lukeberkheiser",
"c_ccp_status" : "Yes"
} ]
},
"metadata" : { }
}
SSO ID : lukeberkheiser
ccp_status : Yes
panelistId = 443827163
FindPanelistRecord output : {"data":{"type":"Long","value":-1},"status":"success"}
recordId : -1
authorize panelist {"data":{"type":"Long","value":637788633017329243},"status":"success"}
recordId : 637788633017329243
accessLevelQuestion : Q217
ChangeResponse( 524964635, 637788633017329243, Q217, 2)
ChangeResponse accessLevel output : {"data":{"type":"error_data","value":"Error updating record 637788633017329243 column Q217 with value 2 ---> Invalid column name."},"status":"error"}
Error updating record 637788633017329243 column Q217 with value 2 ---> Invalid column name. at Jan 26, 2022 10:55:02 PM
participant info output : {"data":{"type":"JSONObject","value":{"initial_status":"","close_date":"","reminder2_date":"","reminder4_status":"","os_family":"","over_quota":"","iploc_zipcode":"","modifier":"","device_type":"","iploc_city":"","panelistid":"443827163","http_user_agent":"","user_key3":"","reminder3_date":"","ua_majorver":"","reminder1_status":"","thankyou_date":"","ua_family":"","modified":"1/27/2022 6:55:01 AM","initial_date":"","reminder2_status":"","reminder3_status":"","invite_status":"","thankyou_status":"","email":"luke.berkheiser@nagra.com","user_key1":"","user_key2":"","remote_addr":"","last_page":"","iploc_lat":"","branched_out":"","started":"","completed":"","iploc_state":"","url":"https://www.ciscofeedback.vovici.com/se/705E3ECB1F4A531B08D9E161F0C7A65B73","remote_host":"","recordid":"637788633017329243","last_page_number":"","campaign_status":"","culture":"","http_referer":"","iploc_country":"","reminder4_date":"","os_name":"","reminder1_date":"","iploc_long":""}},"status":"success"}
surveyStartedDate :
surveyCompletedDate :
preloadData : {"Q1_1 ":"lukeberkheiser"}
preloadSurveyData(ssoId) output : {"data":{"type":"error_data","value":"Server was unable to process request. ---> Column names in each table must be unique. Column name 'Q1_1' in table 'G1885224651_P0524964635' is specified more than once."},"status":"error"}Server was unable to process request. ---> Column names in each table must be unique. Column name 'Q1_1' in table 'G1885224651_P0524964635' is specified more than once. at Jan 26, 2022 10:55:03 PM[No error description was available.]
----
FTL stack trace ("~" means nesting-related):
- Failed at: #stop [in template "ccp-survey.ftl" at line 128, column 27]
---- at Jan 26, 2022 10:55:03 PM
Time : Jan 26, 2022 10:55:03 PM
