{"level":"error","message":"getAgentProjects error: {\"code\":\"ER_TABLEACCESS_DENIED_ERROR\",\"errno\":1142,\"sqlMessage\":\"SELECT command denied to user 'kent4654_leichliterk2'@'localhost' for table 'user'\",\"sqlState\":\"42000\",\"index\":0,\"sql\":\"CALL `agent_project_list`('12461');\"}","timestamp":"2024-05-08T23:58:04.385Z"}
{"level":"error","message":"getAgentProjects error: {\"code\":\"ER_TABLEACCESS_DENIED_ERROR\",\"errno\":1142,\"sqlMessage\":\"SELECT command denied to user 'kent4654_leichliterk2'@'localhost' for table 'user'\",\"sqlState\":\"42000\",\"index\":0,\"sql\":\"CALL `agent_project_list`('12461');\"}","timestamp":"2024-05-08T23:58:12.647Z"}
{"level":"error","message":"getAgentProjects error: {\"code\":\"ER_TABLEACCESS_DENIED_ERROR\",\"errno\":1142,\"sqlMessage\":\"SELECT command denied to user 'kent4654_leichliterk2'@'localhost' for table 'user'\",\"sqlState\":\"42000\",\"index\":0,\"sql\":\"CALL `agent_project_list`('12461');\"}","timestamp":"2024-05-08T23:58:17.488Z"}
{"level":"error","message":"remind error: {\"status\":400,\"response\":{\"req\":{\"method\":\"POST\",\"url\":\"https://sign.zoho.com/api/v1/requests/370101000000269117/remind\",\"headers\":{\"authorization\":\"Zoho-oauthtoken 1000.da482dcf81330a21840d2470fe88237d.7da70fd1b5081f4609f09d01c191d2ed\"}},\"header\":{\"server\":\"ZGS\",\"date\":\"Wed, 29 May 2024 23:58:34 GMT\",\"content-type\":\"application/json;charset=UTF-8\",\"content-length\":\"57\",\"connection\":\"close\",\"set-cookie\":[\"87c72598ae=d5d65a16bb0c273380ee13d651a0bbf6; Path=/\",\"JSESSIONID=DFB5D8CD75C14525FF9A53A309601B1F; Path=/; HttpOnly\",\"zscsrfcookie=d33096ef-0604-42ed-869c-6e3a313903de;path=/;Secure;priority=high\",\"_zcsr_tmp=d33096ef-0604-42ed-869c-6e3a313903de;path=/;SameSite=Strict;Secure;priority=high\"],\"x-content-type-options\":\"nosniff\",\"cache-control\":\"private,no-cache,no-store,max-age=0,must-revalidate\",\"pragma\":\"no-cache\",\"expires\":\"Thu, 01 Jan 1970 00:00:00 GMT\",\"x-frame-options\":\"SAMEORIGIN\",\"x-download-options\":\"noopen\"},\"status\":400,\"text\":\"{\\\"code\\\":1,\\\"message\\\":\\\"Reminder failed\\\",\\\"status\\\":\\\"failure\\\"}\"}}","timestamp":"2024-05-29T23:58:34.359Z"}
{"level":"error","message":"extendExpiry error: {\"status\":400,\"response\":{\"req\":{\"method\":\"PUT\",\"url\":\"https://sign.zoho.com/api/v1/requests/370101000000269117/extend\",\"data\":{\"expire_by\":\"12 June 2024\"},\"headers\":{\"authorization\":\"Zoho-oauthtoken 1000.da482dcf81330a21840d2470fe88237d.7da70fd1b5081f4609f09d01c191d2ed\",\"content-type\":\"application/x-www-form-urlencoded\"}},\"header\":{\"server\":\"ZGS\",\"date\":\"Wed, 29 May 2024 23:58:49 GMT\",\"content-type\":\"application/json;charset=UTF-8\",\"content-length\":\"68\",\"connection\":\"close\",\"set-cookie\":[\"87c72598ae=e53a0a34d10ef42dbab7677f741a960c; Path=/\",\"JSESSIONID=954F2C358F63F3DFC3C81A907B868D00; Path=/; HttpOnly\",\"zscsrfcookie=38032277-c13b-44a7-ae00-713bfb48041a;path=/;Secure;priority=high\",\"_zcsr_tmp=38032277-c13b-44a7-ae00-713bfb48041a;path=/;SameSite=Strict;Secure;priority=high\"],\"x-content-type-options\":\"nosniff\",\"cache-control\":\"private,no-cache,no-store,max-age=0,must-revalidate\",\"pragma\":\"no-cache\",\"expires\":\"Thu, 01 Jan 1970 00:00:00 GMT\",\"x-frame-options\":\"SAMEORIGIN\",\"x-download-options\":\"noopen\"},\"status\":400,\"text\":\"{\\\"code\\\":8038,\\\"message\\\":\\\"Invalid Document Status\\\",\\\"status\\\":\\\"failure\\\"}\"}}","timestamp":"2024-05-29T23:58:49.502Z"}
{"level":"error","message":"extendExpiry error: {\"status\":400,\"response\":{\"req\":{\"method\":\"PUT\",\"url\":\"https://sign.zoho.com/api/v1/requests/370101000000268055/extend\",\"data\":{\"expire_by\":\"12 June 2024\"},\"headers\":{\"authorization\":\"Zoho-oauthtoken 1000.da482dcf81330a21840d2470fe88237d.7da70fd1b5081f4609f09d01c191d2ed\",\"content-type\":\"application/x-www-form-urlencoded\"}},\"header\":{\"server\":\"ZGS\",\"date\":\"Wed, 29 May 2024 23:58:53 GMT\",\"content-type\":\"application/json;charset=UTF-8\",\"content-length\":\"68\",\"connection\":\"close\",\"set-cookie\":[\"87c72598ae=e53a0a34d10ef42dbab7677f741a960c; Path=/\",\"JSESSIONID=7638F4D3A7242B4E476744C84D71DEEF; Path=/; HttpOnly\",\"zscsrfcookie=e26b6b97-7d7b-4e1a-96cf-f4c90429ad05;path=/;Secure;priority=high\",\"_zcsr_tmp=e26b6b97-7d7b-4e1a-96cf-f4c90429ad05;path=/;SameSite=Strict;Secure;priority=high\"],\"x-content-type-options\":\"nosniff\",\"cache-control\":\"private,no-cache,no-store,max-age=0,must-revalidate\",\"pragma\":\"no-cache\",\"expires\":\"Thu, 01 Jan 1970 00:00:00 GMT\",\"x-frame-options\":\"SAMEORIGIN\",\"x-download-options\":\"noopen\"},\"status\":400,\"text\":\"{\\\"code\\\":8038,\\\"message\\\":\\\"Invalid Document Status\\\",\\\"status\\\":\\\"failure\\\"}\"}}","timestamp":"2024-05-29T23:58:53.369Z"}
{"level":"error","message":"remind error: {\"status\":400,\"response\":{\"req\":{\"method\":\"POST\",\"url\":\"https://sign.zoho.com/api/v1/requests/370101000000242015/remind\",\"headers\":{\"authorization\":\"Zoho-oauthtoken 1000.73622f87aef4e8e4d33998f14a3eaa45.cd52d1cc74dbbd0415922007de5267e1\"}},\"header\":{\"server\":\"ZGS\",\"date\":\"Wed, 05 Jun 2024 22:08:17 GMT\",\"content-type\":\"application/json;charset=UTF-8\",\"content-length\":\"57\",\"connection\":\"close\",\"set-cookie\":[\"87c72598ae=170bdbcc28f3cd1fa52b5ec9639d86c0; Path=/\",\"JSESSIONID=20C75AAB74AB995F87FB028FAD8634D3; Path=/; HttpOnly\",\"zscsrfcookie=4bb5fa16-3418-4b80-9568-6b537db73eb6;path=/;Secure;priority=high\",\"_zcsr_tmp=4bb5fa16-3418-4b80-9568-6b537db73eb6;path=/;SameSite=Strict;Secure;priority=high\"],\"x-content-type-options\":\"nosniff\",\"cache-control\":\"private,no-cache,no-store,max-age=0,must-revalidate\",\"pragma\":\"no-cache\",\"expires\":\"Thu, 01 Jan 1970 00:00:00 GMT\",\"x-frame-options\":\"SAMEORIGIN\",\"x-download-options\":\"noopen\"},\"status\":400,\"text\":\"{\\\"code\\\":1,\\\"message\\\":\\\"Reminder failed\\\",\\\"status\\\":\\\"failure\\\"}\"}}","timestamp":"2024-06-05T22:08:17.512Z"}
{"level":"error","message":"remind error: {\"status\":400,\"response\":{\"req\":{\"method\":\"POST\",\"url\":\"https://sign.zoho.com/api/v1/requests/370101000000235559/remind\",\"headers\":{\"authorization\":\"Zoho-oauthtoken 1000.73622f87aef4e8e4d33998f14a3eaa45.cd52d1cc74dbbd0415922007de5267e1\"}},\"header\":{\"server\":\"ZGS\",\"date\":\"Wed, 05 Jun 2024 22:18:44 GMT\",\"content-type\":\"application/json;charset=UTF-8\",\"content-length\":\"57\",\"connection\":\"close\",\"set-cookie\":[\"87c72598ae=cc6f7ed99e97eeab00ca49378c2b5819; Path=/\",\"JSESSIONID=5D36515F252530DAF7F9E68F33DDA996; Path=/; HttpOnly\",\"zscsrfcookie=419320e8-7689-4236-a057-d641954822fd;path=/;Secure;priority=high\",\"_zcsr_tmp=419320e8-7689-4236-a057-d641954822fd;path=/;SameSite=Strict;Secure;priority=high\"],\"x-content-type-options\":\"nosniff\",\"cache-control\":\"private,no-cache,no-store,max-age=0,must-revalidate\",\"pragma\":\"no-cache\",\"expires\":\"Thu, 01 Jan 1970 00:00:00 GMT\",\"x-frame-options\":\"SAMEORIGIN\",\"x-download-options\":\"noopen\"},\"status\":400,\"text\":\"{\\\"code\\\":1,\\\"message\\\":\\\"Reminder failed\\\",\\\"status\\\":\\\"failure\\\"}\"}}","timestamp":"2024-06-05T22:18:44.454Z"}
{"level":"error","message":"updateTempProject error: {\"code\":\"ER_BAD_NULL_ERROR\",\"errno\":1048,\"sqlMessage\":\"Column 'owner_email' cannot be null\",\"sqlState\":\"23000\",\"index\":0,\"sql\":\"CALL `update_temp_project`('{\\\\\\\"id\\\\\\\":79,\\\\\\\"agent_id\\\\\\\":\\\\\\\"40000\\\\\\\",\\\\\\\"status\\\\\\\":\\\\\\\"inprogress\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"proj_name\\\\\\\":\\\\\\\"Trump Palace\\\\\\\",\\\\\\\"np_capacity\\\\\\\":\\\\\\\"14448\\\\\\\",\\\\\\\"address1\\\\\\\":\\\\\\\"1600 Pennsylvania Ave\\\\\\\",\\\\\\\"address2\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"suite\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"city\\\\\\\":\\\\\\\"Washington D.C.\\\\\\\",\\\\\\\"state\\\\\\\":{\\\\\\\"value\\\\\\\":9,\\\\\\\"name\\\\\\\":\\\\\\\"District of Columbia\\\\\\\",\\\\\\\"abbreviation\\\\\\\":\\\\\\\"DC\\\\\\\"},\\\\\\\"zip\\\\\\\":\\\\\\\"00890\\\\\\\",\\\\\\\"p_address1\\\\\\\":\\\\\\\"16010 Pennsylvania Ave\\\\\\\",\\\\\\\"p_address2\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"p_suite\\\\\\\":\\\\\\\"23444\\\\\\\",\\\\\\\"p_city\\\\\\\":\\\\\\\"Washington\\\\\\\",\\\\\\\"p_state\\\\\\\":{\\\\\\\"value\\\\\\\":9,\\\\\\\"name\\\\\\\":\\\\\\\"District of Columbia\\\\\\\",\\\\\\\"abbreviation\\\\\\\":\\\\\\\"DC\\\\\\\"},\\\\\\\"p_zip\\\\\\\":\\\\\\\"00890\\\\\\\",\\\\\\\"separate_location\\\\\\\":true}}');\"}","timestamp":"2024-09-02T16:15:14.997Z"}
{"level":"error","message":"update_solar_project error: {\"code\":\"ER_TRUNCATED_WRONG_VALUE_FOR_FIELD\",\"errno\":1366,\"sqlMessage\":\"Incorrect integer value: ' ' for column 'orientation' at row 1\",\"sqlState\":\"HY000\",\"index\":0,\"sql\":\"CALL `update_solar_project`('{\\\\\\\"id\\\\\\\":357,\\\\\\\"proj_name\\\\\\\":\\\\\\\"Trump Palace\\\\\\\",\\\\\\\"agent_id\\\\\\\":40000,\\\\\\\"address1\\\\\\\":\\\\\\\"1600 Pennsylvania Ave\\\\\\\",\\\\\\\"address2\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"suite\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"city\\\\\\\":\\\\\\\"Washington D.C.\\\\\\\",\\\\\\\"state\\\\\\\":\\\\\\\"DC\\\\\\\",\\\\\\\"zip\\\\\\\":\\\\\\\"89009\\\\\\\",\\\\\\\"country\\\\\\\":\\\\\\\"USA\\\\\\\",\\\\\\\"pref_email\\\\\\\":\\\\\\\"kamala@trump.com\\\\\\\",\\\\\\\"separate_location\\\\\\\":1,\\\\\\\"utility\\\\\\\":\\\\\\\"Washington Utility Company\\\\\\\",\\\\\\\"net_metering\\\\\\\":1,\\\\\\\"nm_connection_date\\\\\\\":null}', '{\\\\\\\"np_capacity\\\\\\\":14448,\\\\\\\"p_address1\\\\\\\":\\\\\\\"16010 Pennsylvania Ave\\\\\\\",\\\\\\\"p_address2\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"p_suite\\\\\\\":\\\\\\\"23444\\\\\\\",\\\\\\\"p_city\\\\\\\":\\\\\\\"Washington\\\\\\\",\\\\\\\"p_state\\\\\\\":\\\\\\\"DC\\\\\\\",\\\\\\\"p_zip\\\\\\\":\\\\\\\"89000\\\\\\\",\\\\\\\"p_country\\\\\\\":\\\\\\\"USA\\\\\\\",\\\\\\\"in_service\\\\\\\":\\\\\\\"2069-12-12T06:00:00.000Z\\\\\\\",\\\\\\\"life_expectancy\\\\\\\":\\\\\\\"20\\\\\\\",\\\\\\\"installer_name\\\\\\\":null,\\\\\\\"installer_phone\\\\\\\":null,\\\\\\\"installer_email\\\\\\\":null,\\\\\\\"last_serv_date\\\\\\\":\\\\\\\"2069-12-02T06:00:00.000Z\\\\\\\",\\\\\\\"defects\\\\\\\":1,\\\\\\\"defects_desc\\\\\\\":null,\\\\\\\"function\\\\\\\":1,\\\\\\\"function_desc\\\\\\\":null,\\\\\\\"inverter_manufacturer\\\\\\\":\\\\\\\"Duracell\\\\\\\",\\\\\\\"inverter_other\\\\\\\":\\\\\\\"Duracell\\\\\\\",\\\\\\\"inverter_SN\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"inverter_MN\\\\\\\":null,\\\\\\\"panel_desc\\\\\\\":null,\\\\\\\"panel_MN\\\\\\\":null,\\\\\\\"panel_qty\\\\\\\":null,\\\\\\\"inst_type\\\\\\\":\\\\\\\"Fixed - roof mount\\\\\\\",\\\\\\\"tilt\\\\\\\":null,\\\\\\\"orientation\\\\\\\":\\\\\\\" \\\\\\\",\\\\\\\"storage\\\\\\\":0,\\\\\\\"storage_man\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"storage_MN\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"storage_SN\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"storage_capacity\\\\\\\":0}');\"}","timestamp":"2024-09-02T16:25:09.399Z"}