[2024-12-17 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-17 00:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.680994 [namelookup_time] => 0.267511 [connect_time] => 0.278351 [pretransfer_time] => 0.565667 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4045 [speed_upload] => 120 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.680925 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 55968 ) [2024-12-17 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MTI0NDQsImV4cCI6MTczNDQxMjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDEyNDQ0LCJhdF9oYXNoIjoiNEEwSG5waHZMY053eUlGQlhpLTd5ZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.eOzqoIL9lLr3zZtxUgjnwumIRdLADkp6_Cusu7DjbGJMl8yHgDHtYWyulSEn0_gtyJrG1ijsaM7tCnKI6u3j-MK7DT0DFilnUAfRcYCfTq3HUqRL56obk_At55bYov7kLtit1OA2DvC_u_B3bmW4xjXjMxtPsW9s3SPzRO8kFQjSLSJJ6U3PazjIQ3k1sr532nBUrqu4Vcqb7WILFWfGCXcJKd2MCryYP7JmFnM8H5IPnT6x_8Bh1NoPgUbsge_bekUb7-ShC_23IsyF62sZEK0fMDfTHw5uU85A6m1wjdsJ_okdSWedjxeGCGzHoCpoa9SPSNVw9I_MVWzkzTFM7Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MTI0NDQsImV4cCI6MTczNDQxNDI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.FGuxqbxnwqNshBQphEhZxnZCbPqxj5NueNWwroGO1dkHHPMwTcQas-oGeVQztkmSY0eCSdRzzBmZb3I4IUMKdlfnnURg5JqxGSgv4pdxr8CEUDv4w4FyGn2vG77T0FxxFy1f8-0suDyXjiWvMoDfuL54_4XnxLAQQsMByOmQi8vtlH8KXoBpZICmbqkZIdRrH3wMYbl39Z70jjhg8TgXXbCPV-0jBbixiPTyfDW_E4iDUXxYZh0Qvo4WucdhIjaxiZzZovOw09aN4368WdZQbHwXSoZG8l-rio3_bY4ZXSOEOgm376m8rZeDtRyXABMHbc3HSMTwyKQs4-r9UeB7Bg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => QqsDy5CreGhtllovvkQSe93A1fmW8SZTyiiBfk7-CBM [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MTI0NDQsImV4cCI6MTczNDQxMjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDEyNDQ0LCJhdF9oYXNoIjoiNEEwSG5waHZMY053eUlGQlhpLTd5ZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.eOzqoIL9lLr3zZtxUgjnwumIRdLADkp6_Cusu7DjbGJMl8yHgDHtYWyulSEn0_gtyJrG1ijsaM7tCnKI6u3j-MK7DT0DFilnUAfRcYCfTq3HUqRL56obk_At55bYov7kLtit1OA2DvC_u_B3bmW4xjXjMxtPsW9s3SPzRO8kFQjSLSJJ6U3PazjIQ3k1sr532nBUrqu4Vcqb7WILFWfGCXcJKd2MCryYP7JmFnM8H5IPnT6x_8Bh1NoPgUbsge_bekUb7-ShC_23IsyF62sZEK0fMDfTHw5uU85A6m1wjdsJ_okdSWedjxeGCGzHoCpoa9SPSNVw9I_MVWzkzTFM7Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MTI0NDQsImV4cCI6MTczNDQxNDI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.FGuxqbxnwqNshBQphEhZxnZCbPqxj5NueNWwroGO1dkHHPMwTcQas-oGeVQztkmSY0eCSdRzzBmZb3I4IUMKdlfnnURg5JqxGSgv4pdxr8CEUDv4w4FyGn2vG77T0FxxFy1f8-0suDyXjiWvMoDfuL54_4XnxLAQQsMByOmQi8vtlH8KXoBpZICmbqkZIdRrH3wMYbl39Z70jjhg8TgXXbCPV-0jBbixiPTyfDW_E4iDUXxYZh0Qvo4WucdhIjaxiZzZovOw09aN4368WdZQbHwXSoZG8l-rio3_bY4ZXSOEOgm376m8rZeDtRyXABMHbc3HSMTwyKQs4-r9UeB7Bg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => QqsDy5CreGhtllovvkQSe93A1fmW8SZTyiiBfk7-CBM [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-16 00:00:00 [2024-12-17 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,16) [2024-12-17 00:14:06] Production.INFO: Batch insert start [2024-12-17 00:14:06] Production.INFO: global counter1 [2024-12-17 00:14:06] Production.INFO: insertion start [2024-12-17 00:14:06] Production.INFO: last batch insert 1 [2024-12-17 00:14:06] Production.INFO: insertion end [2024-12-17 00:14:06] Production.INFO: CALL prc_importPaymentAccounting ('bbd6b680-bc35-11ef-92a7-a3d85a6e83ca') start [2024-12-17 00:14:06] Production.INFO: CALL prc_importPaymentAccounting ('bbd6b680-bc35-11ef-92a7-a3d85a6e83ca') end [2024-12-17 00:14:06] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-17 00:14:06] Production.INFO: 2 [2024-12-17 00:14:07] Production.ERROR: CronJobId end14 [2024-12-17 00:14:07] Production.INFO: ==31100== Releasing lock... [2024-12-17 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-17 00:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-17 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-17 06:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.585309 [namelookup_time] => 0.278091 [connect_time] => 0.28283 [pretransfer_time] => 0.469153 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4706 [speed_upload] => 140 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.585223 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 55358 ) [2024-12-17 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MzQwNDQsImV4cCI6MTczNDQzNDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDM0MDQ0LCJhdF9oYXNoIjoiUWNTcEU3eHE4UkV6d0FXcGVHZXhzUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.fYV7BStsqatQ-reu3-Ovugz5kmUu9sV6OCTHd_uUN2sZDmplNOdk2gOP2UIx2m6-kJCRko6DRRq0fQ5-jqMaKyadWDZLAFdR0boXinV3fvEtpKROt6MWCV8n_wBOmB0II7NCpXI4GPkPFJ9GMlGmaPBMHTEytfzfixkK0IMhPSW1bzCxqpmI8THybUhyNy5l0c_RDc9f63ipJ4Vkn3xGCWlXexnUZTV09ct7tPg7Ska_MhhsC_lwrgk_dblazN7cCKm_iFvHfC70IRJ81aTACRig3jP6KxpWVmtMF4cHsgCGIE9tDaVqQ1FkNQoZGI2Oe6QLz7BFjJMDO9hDPSJKEg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MzQwNDQsImV4cCI6MTczNDQzNTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.S0dYNy6ckQIyoy4n6dTp3mesqdLPsf0XTS_nre6MzLXj_PN1-cpUY2GwSkYglgRZnGwWk4W9KBljRE8C14pqrRUK4NvbbKU_864kZ_h03_4THXIDDN-1JM_PYsq5dhN6Gvt1NhztpFpDtTsoRgtTnmACO0fE2ir0IO94k6u6MA44knnG2NyseaDL88_85fqYeyUUoOz3QGM49urYURvkO4YNUitliERyB7pBufwPZ7I3xZdGhq0Z89cQgbqU75bFNqBD_4yxZAV37HVasxC5aOs2w-IvK8zdZWUNedEFRLOMZR3XHZboNxWsHCgYnGqkAZVeDo-ttjL3WltXOCO9mQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => C7J83YFW9P2xlb0NrRW4NcClPANShM2MWcbEVyFWvF4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MzQwNDQsImV4cCI6MTczNDQzNDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDM0MDQ0LCJhdF9oYXNoIjoiUWNTcEU3eHE4UkV6d0FXcGVHZXhzUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.fYV7BStsqatQ-reu3-Ovugz5kmUu9sV6OCTHd_uUN2sZDmplNOdk2gOP2UIx2m6-kJCRko6DRRq0fQ5-jqMaKyadWDZLAFdR0boXinV3fvEtpKROt6MWCV8n_wBOmB0II7NCpXI4GPkPFJ9GMlGmaPBMHTEytfzfixkK0IMhPSW1bzCxqpmI8THybUhyNy5l0c_RDc9f63ipJ4Vkn3xGCWlXexnUZTV09ct7tPg7Ska_MhhsC_lwrgk_dblazN7cCKm_iFvHfC70IRJ81aTACRig3jP6KxpWVmtMF4cHsgCGIE9tDaVqQ1FkNQoZGI2Oe6QLz7BFjJMDO9hDPSJKEg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0MzQwNDQsImV4cCI6MTczNDQzNTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.S0dYNy6ckQIyoy4n6dTp3mesqdLPsf0XTS_nre6MzLXj_PN1-cpUY2GwSkYglgRZnGwWk4W9KBljRE8C14pqrRUK4NvbbKU_864kZ_h03_4THXIDDN-1JM_PYsq5dhN6Gvt1NhztpFpDtTsoRgtTnmACO0fE2ir0IO94k6u6MA44knnG2NyseaDL88_85fqYeyUUoOz3QGM49urYURvkO4YNUitliERyB7pBufwPZ7I3xZdGhq0Z89cQgbqU75bFNqBD_4yxZAV37HVasxC5aOs2w-IvK8zdZWUNedEFRLOMZR3XHZboNxWsHCgYnGqkAZVeDo-ttjL3WltXOCO9mQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => C7J83YFW9P2xlb0NrRW4NcClPANShM2MWcbEVyFWvF4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-16 00:00:00 [2024-12-17 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,16) [2024-12-17 06:14:07] Production.INFO: Batch insert start [2024-12-17 06:14:07] Production.INFO: global counter1 [2024-12-17 06:14:07] Production.INFO: insertion start [2024-12-17 06:14:07] Production.INFO: last batch insert 1 [2024-12-17 06:14:07] Production.INFO: insertion end [2024-12-17 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('0671b490-bc68-11ef-812a-255313b7ebfd') start [2024-12-17 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('0671b490-bc68-11ef-812a-255313b7ebfd') end [2024-12-17 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-17 06:14:07] Production.INFO: 2 [2024-12-17 06:14:07] Production.ERROR: CronJobId end14 [2024-12-17 06:14:07] Production.INFO: ==28798== Releasing lock... [2024-12-17 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-17 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-17 12:14:03] Production.INFO: -- Xero Api Check -- [2024-12-17 12:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.79075 [namelookup_time] => 0.282598 [connect_time] => 0.283859 [pretransfer_time] => 0.479708 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3484 [speed_upload] => 103 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.790703 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 56822 ) [2024-12-17 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NTU2NDQsImV4cCI6MTczNDQ1NTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDU1NjQ0LCJhdF9oYXNoIjoiTXpISmw1Tm9RbEZpQ0FucnF0NXBIdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UKEFgjzanpG6oMF1oNj3UETkKR8GVd2dauCH6wiGfj3uY-Ojq4kqeWlXwlc4X9-bkbv8dI0A7hAjGOpKtmR28JsPRzuHZpT1LdRCjNG4hIK7Nr3g2ZLpnBL0goBCqqJ2EMfwAt8u7-tT8s7RSFRgPhTn9k7Yp4UiIx460koSnG0PM4C_xx890w62iSLy0RGCxiFa_7oUyOhMLgzDIG3LFg_Psd-KvUHMEGQYkDseZRakdNyxKnVgVOZBq6Vxaw3MOui8Uvv_Q2ESM1pAexOTwGiuUgeTXmmwIG41OXCzEPUUQnabC5f9x9hsakpQUo_PoLfr18wbV9zErqDdqAzt2Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NTU2NDQsImV4cCI6MTczNDQ1NzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.XaEpzF3S2sr-e5DCUdFI-1bRooaHQe-VburLWpjhsDxp4tkKPn7mvXZYkykahB1v4yY88UAP8ctteP5d7b0f7kQgy-Z6SNdaxJ1u1SwTY644NAvl6p33iWGzSCwtZXwmmakDOHX6JujNtVO9WDHuTj-8vS9QfvyjjTC9Sm9x7XEZsLKz0AjlkMDV0yVv39wQsC4u4PeS1iY_3rrw9eBqJYQ1is-GLVWfvXwv_asaQrQNNkIL_Sk2jBQUD-IGviRqbIIR3eI_J9GmLG1GMmFZxPLB7IcMLjEvsu3NfhwSC7XdeA7KMkhlexsvfoEP4y9FsL5hB-AfPYcxPpNZwnL8pQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => x4B6RH6j0t5oUQ39W5Zy9KaYbPWrn_y3Ersh1n9Szx4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NTU2NDQsImV4cCI6MTczNDQ1NTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDU1NjQ0LCJhdF9oYXNoIjoiTXpISmw1Tm9RbEZpQ0FucnF0NXBIdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UKEFgjzanpG6oMF1oNj3UETkKR8GVd2dauCH6wiGfj3uY-Ojq4kqeWlXwlc4X9-bkbv8dI0A7hAjGOpKtmR28JsPRzuHZpT1LdRCjNG4hIK7Nr3g2ZLpnBL0goBCqqJ2EMfwAt8u7-tT8s7RSFRgPhTn9k7Yp4UiIx460koSnG0PM4C_xx890w62iSLy0RGCxiFa_7oUyOhMLgzDIG3LFg_Psd-KvUHMEGQYkDseZRakdNyxKnVgVOZBq6Vxaw3MOui8Uvv_Q2ESM1pAexOTwGiuUgeTXmmwIG41OXCzEPUUQnabC5f9x9hsakpQUo_PoLfr18wbV9zErqDdqAzt2Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NTU2NDQsImV4cCI6MTczNDQ1NzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.XaEpzF3S2sr-e5DCUdFI-1bRooaHQe-VburLWpjhsDxp4tkKPn7mvXZYkykahB1v4yY88UAP8ctteP5d7b0f7kQgy-Z6SNdaxJ1u1SwTY644NAvl6p33iWGzSCwtZXwmmakDOHX6JujNtVO9WDHuTj-8vS9QfvyjjTC9Sm9x7XEZsLKz0AjlkMDV0yVv39wQsC4u4PeS1iY_3rrw9eBqJYQ1is-GLVWfvXwv_asaQrQNNkIL_Sk2jBQUD-IGviRqbIIR3eI_J9GmLG1GMmFZxPLB7IcMLjEvsu3NfhwSC7XdeA7KMkhlexsvfoEP4y9FsL5hB-AfPYcxPpNZwnL8pQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => x4B6RH6j0t5oUQ39W5Zy9KaYbPWrn_y3Ersh1n9Szx4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 12:14:04] Production.ERROR: Invoice Payment Date 2024-12-16 00:00:00 [2024-12-17 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,16) [2024-12-17 12:14:06] Production.INFO: Batch insert start [2024-12-17 12:14:06] Production.INFO: global counter1 [2024-12-17 12:14:06] Production.INFO: insertion start [2024-12-17 12:14:06] Production.INFO: last batch insert 1 [2024-12-17 12:14:06] Production.INFO: insertion end [2024-12-17 12:14:06] Production.INFO: CALL prc_importPaymentAccounting ('510c1f50-bc9a-11ef-a8a1-27efebdc8975') start [2024-12-17 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('510c1f50-bc9a-11ef-a8a1-27efebdc8975') end [2024-12-17 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-17 12:14:07] Production.INFO: 2 [2024-12-17 12:14:07] Production.ERROR: CronJobId end14 [2024-12-17 12:14:07] Production.INFO: ==27038== Releasing lock... [2024-12-17 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-17 12:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-17 18:14:04] Production.INFO: -- Xero Api Check -- [2024-12-17 18:14:05] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.837998 [namelookup_time] => 0.272765 [connect_time] => 0.282151 [pretransfer_time] => 0.630201 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3287 [speed_upload] => 97 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.837944 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 60690 ) [2024-12-17 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NzcyNDQsImV4cCI6MTczNDQ3NzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDc3MjQ0LCJhdF9oYXNoIjoiaEROVkpWWFFEczUyQzRHRm04NWdqZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.GfxnB2p7yn8CJClE5S54a5Rl0p2WWrl5RPwmsWVp4G0Mf6Y344pAfLEcMIaaYUM54_dnlOZUn3sjRTFhvWfx7voGx_zKSHnfgmZVeS7VluSVIzR9VmW7G2qvYfHAT3vZ1tBJfuibslH8bcQH24IwJLcFO_hKeyFUW7HC9Uq0GQQgxbgIcFzC14JlJQFf9WigEzZl6Y4xAJO4cWkWSmgmJdmr8LNB1ECwVm0moVsLmaAq6HuRUW4qx1KyBLFvspXNlXBBlpqmz-AIQ70Zv1LBilaApyOCtG5JbbMrxNvHgMkk0DVVe9zXDjOgtzYs1PbawNRpoezErJ9A3O5i7qfThg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NzcyNDQsImV4cCI6MTczNDQ3OTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.U5GDD9oA5E8r797Sxj5WubejC-NTrSarcCwiBWH_2EhvJhQQB0FyyoOEyLJS-G7iJuSXxl-CvCyHgBL0vnDRaYF5KnAeKq9FiYGgxdZzTB-BulSsE8Hb33_sHtEaMwPaYBy9ODghjVLSj8d3i830Sb6pSTc5ML7Px1JCyprbnKAgJ1YWOSnVYHDBIuug56GDe8iz9T6qYr29g8NgmrV_OW7fjc3CtcI_VKmIAZkslP9v1GPYCsZSogcMnZAJvCxI6rDMkQxAe7mIlzzmWD07Pcuz24_GEjcGfsWV19W0zKPQeIJ1b6b4FlxE6PCBHppOxNy-Oapk7xbwODkTJbrIvg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 5tWBF15tOPYZak5I7is9xeyyoG1RMhWD81d1cbJXHGk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NzcyNDQsImV4cCI6MTczNDQ3NzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NDc3MjQ0LCJhdF9oYXNoIjoiaEROVkpWWFFEczUyQzRHRm04NWdqZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.GfxnB2p7yn8CJClE5S54a5Rl0p2WWrl5RPwmsWVp4G0Mf6Y344pAfLEcMIaaYUM54_dnlOZUn3sjRTFhvWfx7voGx_zKSHnfgmZVeS7VluSVIzR9VmW7G2qvYfHAT3vZ1tBJfuibslH8bcQH24IwJLcFO_hKeyFUW7HC9Uq0GQQgxbgIcFzC14JlJQFf9WigEzZl6Y4xAJO4cWkWSmgmJdmr8LNB1ECwVm0moVsLmaAq6HuRUW4qx1KyBLFvspXNlXBBlpqmz-AIQ70Zv1LBilaApyOCtG5JbbMrxNvHgMkk0DVVe9zXDjOgtzYs1PbawNRpoezErJ9A3O5i7qfThg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ0NzcyNDQsImV4cCI6MTczNDQ3OTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.U5GDD9oA5E8r797Sxj5WubejC-NTrSarcCwiBWH_2EhvJhQQB0FyyoOEyLJS-G7iJuSXxl-CvCyHgBL0vnDRaYF5KnAeKq9FiYGgxdZzTB-BulSsE8Hb33_sHtEaMwPaYBy9ODghjVLSj8d3i830Sb6pSTc5ML7Px1JCyprbnKAgJ1YWOSnVYHDBIuug56GDe8iz9T6qYr29g8NgmrV_OW7fjc3CtcI_VKmIAZkslP9v1GPYCsZSogcMnZAJvCxI6rDMkQxAe7mIlzzmWD07Pcuz24_GEjcGfsWV19W0zKPQeIJ1b6b4FlxE6PCBHppOxNy-Oapk7xbwODkTJbrIvg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 5tWBF15tOPYZak5I7is9xeyyoG1RMhWD81d1cbJXHGk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-17 18:14:05] Production.ERROR: Invoice Payment Date 2024-12-16 00:00:00 [2024-12-17 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,16) [2024-12-17 18:14:07] Production.INFO: Batch insert start [2024-12-17 18:14:07] Production.INFO: global counter1 [2024-12-17 18:14:07] Production.INFO: insertion start [2024-12-17 18:14:07] Production.INFO: last batch insert 1 [2024-12-17 18:14:07] Production.INFO: insertion end [2024-12-17 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('9c1dd1f0-bccc-11ef-a025-2355017a250b') start [2024-12-17 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('9c1dd1f0-bccc-11ef-a025-2355017a250b') end [2024-12-17 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-17 18:14:07] Production.INFO: 2 [2024-12-17 18:14:07] Production.ERROR: CronJobId end14 [2024-12-17 18:14:07] Production.INFO: ==25367== Releasing lock... [2024-12-17 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-17 18:14:07] Production.INFO: 26 MB #Memory Used#