Error while processing CCP request of user Jesse%20Zepeda

Jesse Zepeda — Mon, 21 Mar 2022 16:12:03 GMT

SSOID: jesse.zepeda

Error:
ProjectId : 862612535
select sso_id, c_ccp_status from users where id = '319349'
userDetails output = { "status" : "success", "message" : "", "http_code" : 200, "data" : { "type" : "users", "list_item_type" : "user", "size" : 1, "items" : [ { "type" : "user", "sso_id" : "jesse.zepeda", "c_ccp_status" : "Yes" } ] }, "metadata" : { } }
SSO ID : jesse.zepeda
ccp_status : Yes
panelistId = 998412307
FindPanelistRecord output : {"data":{"type":"Long","value":-1},"status":"success"}
recordId : -1
authorize panelist {"data":{"type":"Long","value":637834759210620660},"status":"success"}
recordId : 637834759210620660
accessLevelQuestion : Q217
ChangeResponse( 862612535, 637834759210620660, Q217, 3)
ChangeResponse accessLevel output : {"data":{"type":"error_data","value":"Error updating record 637834759210620660 column Q217 with value 3 ---> Invalid column name."},"status":"error"}
Error updating record 637834759210620660 column Q217 with value 3 ---> Invalid column name. at Mar 21, 2022 9:12:01 AM
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":"998412307","http_user_agent":"","user_key3":"","reminder3_date":"","ua_majorver":"","reminder1_status":"","thankyou_date":"","ua_family":"","modified":"3/21/2022 4:12:01 PM","initial_date":"","reminder2_status":"","reminder3_status":"","invite_status":"","thankyou_status":"","email":"jesse.zepeda@nexusis.com","user_key1":"","user_key2":"","remote_addr":"","last_page":"","iploc_lat":"","branched_out":"","started":"","completed":"","iploc_state":"","url":"https://www.ciscofeedback.vovici.com/se/705E3ECB336A6C3708DA0B55882556F40F","remote_host":"","recordid":"637834759210620660","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 ":"jesse.zepeda"}
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_P0862612535' 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_P0862612535' is specified more than once. at Mar 21, 2022 9:12:03 AM[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 Mar 21, 2022 9:12:03 AM

Time : Mar 21, 2022 9:12:03 AM

topic Error while processing CCP request of user Jesse%20Zepeda in CCP Error

Error while processing CCP request of user Jesse%20Zepeda