[2025-01-09 00:14:03] Production.INFO: -- Xero Api Check -- [2025-01-09 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] => 1.331333 [namelookup_time] => 0.533268 [connect_time] => 0.621408 [pretransfer_time] => 1.116499 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2069 [speed_upload] => 61 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.331279 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.16.6.30 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 48606 ) [2025-01-09 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYzOTk2NDQsImV4cCI6MTczNjM5OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2Mzk5NjQ0LCJhdF9oYXNoIjoiZWI5ZExPSVJHOTVJVzY5Q3hoc0x5USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.uHRK_1AwVzNusaF0sGykGGhr7swiXuXCGh6aMpbYmPdbrG_I351iXNfD9p3Vj4dc0QBklN9g2iIRTTjvLV_Qn_kXs7zAeeJkYqzxvA0w_p_F4A1oYIGi5NXRxmMMi8s01NjX7_mEq8_2gSejrKYwgXT-0aHBdsMqCi78tBPZLpYtqhlg9gjD4huCSFFeE1yFwqPABog8pCszRPSvqj_zQgE3pnenkxEWVxUFAAMG5b1jQaprhcOQuTQzbONBkSy9bJ_ypEuwBBlx3hIS80NyaJgTLasZexiWPtVGuK0uzQeSJURf-z7KZZ0aUfNm9D1SiJKB2H-Ua3Wa-ttkgC-syw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYzOTk2NDQsImV4cCI6MTczNjQwMTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.K-vxSfINuqdT9v_Vzo4q7uJJDSpYYvkuN03X6VQn2rfENqLtL57Lt2JXHLdDyqm0uuNshO14oo82S6tWrH5iqh_ZNHqeBuA9zKdL4RoEpDLY2Y6InPs2DkrX_nZ8iqBhvwHx3tLissHCztQgIhJ0-JUlpxApMFmb9cb1_OgUTpJEIlAUqs9vUTGJRs5whhmtoqUmT9EyyeIhTnK0huwege1c9nHB1nsK_NO981EjKRLndnSFkr_CcJzsw2vfnj8b10DzwxL2WFqLIJ0hpJGN5qm7-urYPi5IvgW0Ak4ASK9T1XVCd-tIEkqxJ5YCBHonr49v8TgLoTsGizMg73A0-w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => dKx-5Dnc_kRR_IOQitaPf7hb13j7xngldWes_wlYgdQ [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYzOTk2NDQsImV4cCI6MTczNjM5OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2Mzk5NjQ0LCJhdF9oYXNoIjoiZWI5ZExPSVJHOTVJVzY5Q3hoc0x5USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.uHRK_1AwVzNusaF0sGykGGhr7swiXuXCGh6aMpbYmPdbrG_I351iXNfD9p3Vj4dc0QBklN9g2iIRTTjvLV_Qn_kXs7zAeeJkYqzxvA0w_p_F4A1oYIGi5NXRxmMMi8s01NjX7_mEq8_2gSejrKYwgXT-0aHBdsMqCi78tBPZLpYtqhlg9gjD4huCSFFeE1yFwqPABog8pCszRPSvqj_zQgE3pnenkxEWVxUFAAMG5b1jQaprhcOQuTQzbONBkSy9bJ_ypEuwBBlx3hIS80NyaJgTLasZexiWPtVGuK0uzQeSJURf-z7KZZ0aUfNm9D1SiJKB2H-Ua3Wa-ttkgC-syw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYzOTk2NDQsImV4cCI6MTczNjQwMTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.K-vxSfINuqdT9v_Vzo4q7uJJDSpYYvkuN03X6VQn2rfENqLtL57Lt2JXHLdDyqm0uuNshO14oo82S6tWrH5iqh_ZNHqeBuA9zKdL4RoEpDLY2Y6InPs2DkrX_nZ8iqBhvwHx3tLissHCztQgIhJ0-JUlpxApMFmb9cb1_OgUTpJEIlAUqs9vUTGJRs5whhmtoqUmT9EyyeIhTnK0huwege1c9nHB1nsK_NO981EjKRLndnSFkr_CcJzsw2vfnj8b10DzwxL2WFqLIJ0hpJGN5qm7-urYPi5IvgW0Ak4ASK9T1XVCd-tIEkqxJ5YCBHonr49v8TgLoTsGizMg73A0-w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => dKx-5Dnc_kRR_IOQitaPf7hb13j7xngldWes_wlYgdQ [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 00:14:04] Production.ERROR: Invoice Payment Date 2025-01-08 00:00:00 [2025-01-09 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,08) [2025-01-09 00:14:07] Production.INFO: Batch insert start [2025-01-09 00:14:07] Production.INFO: global counter1 [2025-01-09 00:14:07] Production.INFO: insertion start [2025-01-09 00:14:07] Production.INFO: last batch insert 1 [2025-01-09 00:14:07] Production.INFO: insertion end [2025-01-09 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('8bbcdc90-ce48-11ef-88f4-df1bd8159209') start [2025-01-09 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('8bbcdc90-ce48-11ef-88f4-df1bd8159209') end [2025-01-09 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-09 00:14:07] Production.INFO: 2 [2025-01-09 00:14:07] Production.ERROR: CronJobId end14 [2025-01-09 00:14:07] Production.INFO: ==32189== Releasing lock... [2025-01-09 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-09 00:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-09 06:14:03] Production.INFO: -- Xero Api Check -- [2025-01-09 06: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] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.369974 [namelookup_time] => 0.527068 [connect_time] => 0.62386 [pretransfer_time] => 1.099105 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2010 [speed_upload] => 59 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.369904 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.16.6.14 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 59810 ) [2025-01-09 06:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0MjEyNDUsImV4cCI6MTczNjQyMTU0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDIxMjQ1LCJhdF9oYXNoIjoiNHoyenBEV3JVRU5US3VSX0pfZzV2QSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.CtMlFJ7Uf0A8DVFKcQ0yQFwRBe9XNJ_ggkmBxrqhOpPx-bSNZQMSLLm1p-QrJ0gSeq-xYrfdxvJPOTDl4C3ihF3z9RNTTyTD4G0SsznZtnIKwlf73z0yzCuvfWne4r2Ox1G5vtO3xPQr9NR6Zt5gdWI9ECJPxlBzhXKpiI-Il7FqppyDxN_gAzYtS5U05_8pD82ChuhBkytbo81FJXLxMQRYOBSI3ZKiV-YkjhEcksf5Rlmm9LEaWyTjWVlohW9oDgRBNDfTW_m5cL3fikjbihom1YIXF1volHvWb_OHvh3w9RLNaN18b0wF3QFkvLB6vbuwPYPnLEiRBPiI_PhDiQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0MjEyNDUsImV4cCI6MTczNjQyMzA0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Evvkj0m0EP0tIxQjtI2YTIgZAImeMNYyxbUDLY2a5td2TIPUskWE10O1sNRfDJfu_o7q1KDQhIVnGslZ8Qi4Ory2AsNzdY0jBBQytWoPJt63IwsNyE1cBXqWjLAspVANs3zK0km6T1JyMVvBmmRTwmm70AE_bldRh8GeHTmzWZ8CqWhPO4Sys5gHFrmf18DrUQ0ZE9m4EZVqdlWTeG3Dbxc288OC5L2cQDfutijvMusu4O6v10wXEI12vvwwJLZo4Was8MPEfc_XCB1tguLjC1xSXuNluXqEPYmwSiokGlkajkdpVxPwvkhzOs2mdYl0JegWic4Uvcz-NtefZ_XJDA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => LmEDnpDSSLkFdn3K-r9bePzs-CH1DSsr606XYDpepvw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 06:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0MjEyNDUsImV4cCI6MTczNjQyMTU0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDIxMjQ1LCJhdF9oYXNoIjoiNHoyenBEV3JVRU5US3VSX0pfZzV2QSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.CtMlFJ7Uf0A8DVFKcQ0yQFwRBe9XNJ_ggkmBxrqhOpPx-bSNZQMSLLm1p-QrJ0gSeq-xYrfdxvJPOTDl4C3ihF3z9RNTTyTD4G0SsznZtnIKwlf73z0yzCuvfWne4r2Ox1G5vtO3xPQr9NR6Zt5gdWI9ECJPxlBzhXKpiI-Il7FqppyDxN_gAzYtS5U05_8pD82ChuhBkytbo81FJXLxMQRYOBSI3ZKiV-YkjhEcksf5Rlmm9LEaWyTjWVlohW9oDgRBNDfTW_m5cL3fikjbihom1YIXF1volHvWb_OHvh3w9RLNaN18b0wF3QFkvLB6vbuwPYPnLEiRBPiI_PhDiQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0MjEyNDUsImV4cCI6MTczNjQyMzA0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Evvkj0m0EP0tIxQjtI2YTIgZAImeMNYyxbUDLY2a5td2TIPUskWE10O1sNRfDJfu_o7q1KDQhIVnGslZ8Qi4Ory2AsNzdY0jBBQytWoPJt63IwsNyE1cBXqWjLAspVANs3zK0km6T1JyMVvBmmRTwmm70AE_bldRh8GeHTmzWZ8CqWhPO4Sys5gHFrmf18DrUQ0ZE9m4EZVqdlWTeG3Dbxc288OC5L2cQDfutijvMusu4O6v10wXEI12vvwwJLZo4Was8MPEfc_XCB1tguLjC1xSXuNluXqEPYmwSiokGlkajkdpVxPwvkhzOs2mdYl0JegWic4Uvcz-NtefZ_XJDA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => LmEDnpDSSLkFdn3K-r9bePzs-CH1DSsr606XYDpepvw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 06:14:05] Production.ERROR: Invoice Payment Date 2025-01-08 00:00:00 [2025-01-09 06:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,08) [2025-01-09 06:14:07] Production.INFO: Batch insert start [2025-01-09 06:14:07] Production.INFO: global counter1 [2025-01-09 06:14:07] Production.INFO: insertion start [2025-01-09 06:14:07] Production.INFO: last batch insert 1 [2025-01-09 06:14:07] Production.INFO: insertion end [2025-01-09 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('d6867c40-ce7a-11ef-ba48-6d6c1b29da54') start [2025-01-09 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('d6867c40-ce7a-11ef-ba48-6d6c1b29da54') end [2025-01-09 06:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-09 06:14:08] Production.INFO: 2 [2025-01-09 06:14:08] Production.ERROR: CronJobId end14 [2025-01-09 06:14:08] Production.INFO: ==29407== Releasing lock... [2025-01-09 06:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-09 06:14:08] Production.INFO: 26 MB #Memory Used# [2025-01-09 12:14:03] Production.INFO: -- Xero Api Check -- [2025-01-09 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] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.700633 [namelookup_time] => 0.309863 [connect_time] => 0.321298 [pretransfer_time] => 0.546234 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3932 [speed_upload] => 117 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.700574 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 58066 ) [2025-01-09 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NDI4NDQsImV4cCI6MTczNjQ0MzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDQyODQ0LCJhdF9oYXNoIjoiQTdXajlZTXZadEtXYm5JV0dvNGFRZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.ynZNwQ35HULDyQE6IMlXzSwarBo-n-DDAMk9e1t_89ADPON9bKKwpQQ0cQBjCNPtfKkvRzq4jpYXuMWS-ouVtRoVP1qOJkbqVlkDlQF5vR3ptJ1cgIGeOLtWTfrNCHeR96oeDI2s_F-y-SWVGbKeKuB9SK6Mq-4OdbrJVYxMJ0fdp-2M8FHuzibPSmYEVmJDLmO-PaL20Da5TMR4CTjxQH2DZLMuiZ_O2ATL7DpRb5nE90AShqsUNcu33rDrHutcsrJOoy9gOT_HU7yx_XaCYT1gi-IWU779rRk-eb_dYsnvbbGRxl6mWM_o6fMzEzZYAYJ6eVDXUvnRsvooCKywWQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NDI4NDQsImV4cCI6MTczNjQ0NDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Y5gWJKDOwmnqyzolUFkYwTcNyYicGgo4T-xrjkLyZVC3Lw_UN1R3xW7svk8CJ4Wf8EC7hUneOYMeto2O2yxuAIXUjsTCyFCMFSk6KQQe736gv8jvJv5ukD_wyfJg6DPfpahjBszrnwM7evwmgSlAQlR7K57erl53JCTqiwYkX7xTZXlKt3bDFg0UdRJ0WQoFWJAcSH8Le3CF6PFdo0MrEaz6xE26MRcRqpqe5cNvfgn44ZSwKqN4mfFkTL_apGc5LGKfyMlP3z7Kes53mBekwwSNTIylju2QFuzi3fQSfO1Eq3UNPoVRpLruYiRCdbil3V-MvoMCUMmLQBckpRENUA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => ZqZfAJ5pa6YCekFjN84dPNupf4JeP6QesUQaH79-oeE [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NDI4NDQsImV4cCI6MTczNjQ0MzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDQyODQ0LCJhdF9oYXNoIjoiQTdXajlZTXZadEtXYm5JV0dvNGFRZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.ynZNwQ35HULDyQE6IMlXzSwarBo-n-DDAMk9e1t_89ADPON9bKKwpQQ0cQBjCNPtfKkvRzq4jpYXuMWS-ouVtRoVP1qOJkbqVlkDlQF5vR3ptJ1cgIGeOLtWTfrNCHeR96oeDI2s_F-y-SWVGbKeKuB9SK6Mq-4OdbrJVYxMJ0fdp-2M8FHuzibPSmYEVmJDLmO-PaL20Da5TMR4CTjxQH2DZLMuiZ_O2ATL7DpRb5nE90AShqsUNcu33rDrHutcsrJOoy9gOT_HU7yx_XaCYT1gi-IWU779rRk-eb_dYsnvbbGRxl6mWM_o6fMzEzZYAYJ6eVDXUvnRsvooCKywWQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NDI4NDQsImV4cCI6MTczNjQ0NDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Y5gWJKDOwmnqyzolUFkYwTcNyYicGgo4T-xrjkLyZVC3Lw_UN1R3xW7svk8CJ4Wf8EC7hUneOYMeto2O2yxuAIXUjsTCyFCMFSk6KQQe736gv8jvJv5ukD_wyfJg6DPfpahjBszrnwM7evwmgSlAQlR7K57erl53JCTqiwYkX7xTZXlKt3bDFg0UdRJ0WQoFWJAcSH8Le3CF6PFdo0MrEaz6xE26MRcRqpqe5cNvfgn44ZSwKqN4mfFkTL_apGc5LGKfyMlP3z7Kes53mBekwwSNTIylju2QFuzi3fQSfO1Eq3UNPoVRpLruYiRCdbil3V-MvoMCUMmLQBckpRENUA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => ZqZfAJ5pa6YCekFjN84dPNupf4JeP6QesUQaH79-oeE [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 12:14:04] Production.ERROR: Invoice Payment Date 2025-01-08 00:00:00 [2025-01-09 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,08) [2025-01-09 12:14:07] Production.INFO: Batch insert start [2025-01-09 12:14:07] Production.INFO: global counter1 [2025-01-09 12:14:07] Production.INFO: insertion start [2025-01-09 12:14:07] Production.INFO: last batch insert 1 [2025-01-09 12:14:07] Production.INFO: insertion end [2025-01-09 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('20d44ee0-cead-11ef-93a3-55f0fa7251c9') start [2025-01-09 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('20d44ee0-cead-11ef-93a3-55f0fa7251c9') end [2025-01-09 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-09 12:14:07] Production.INFO: 2 [2025-01-09 12:14:07] Production.ERROR: CronJobId end14 [2025-01-09 12:14:07] Production.INFO: ==25491== Releasing lock... [2025-01-09 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-09 12:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-09 18:14:03] Production.INFO: -- Xero Api Check -- [2025-01-09 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] => 1.248071 [namelookup_time] => 0.522442 [connect_time] => 0.611866 [pretransfer_time] => 1.012262 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2207 [speed_upload] => 65 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.247993 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.16.6.30 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 52978 ) [2025-01-09 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NjQ0NDUsImV4cCI6MTczNjQ2NDc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDY0NDQ1LCJhdF9oYXNoIjoiUjlaQnB4V2tqUExJMEZaMExGQ0Z3dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.AwVivQEMyhpXy-iQF9D1Xd5cfZ_crMSyzMkyEM17Ph52uhOfuFsV-RxztJAwB2zB-gxvhVWz7kELFRUAuCPRmz66qoGfdlqzKGX5SJpKLJZPXhyWi6Uvd1iVnyza56T77c1JXVQaN1ASRwGBc966PdgXxZr-eeX1dwv72aO6ldE02wXfWVqHERL4Dqa8w0rIHNkQYw81S8blldlmkbiRl-WLhN9BcLA-knCUdrhGQ3pi5SGnRY-845zZGfgvjIP1yQ7aztCcZeT_5fYDqIi-1gGSLLkhLqEwVgevCbruJLpIQ5nNPo0HpCKo33A6aJVn8lvsWvtG-NE2T01KzQPudQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NjQ0NDQsImV4cCI6MTczNjQ2NjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.cjFU3D4Q9WB7oPRyHYffWVJXobnvlxFy4uHVnyBn9zhUrrzSgmvnpP_r2lILDW3Tpt8wCb6E8OcXF2z8eqpiNKDbYxKwyZb-U-bU3XRt9CQOqNn1HLll9ospcOdU5bFPxlrJ_3NhzxwxZ65ty_DFa_v_EOlI_h7PE0WQ4iT5FEgflaoHNR6ClZrRWTpzWEd5A8g4R-ljSVlVUNikKYL_jYYzqDblaofuV9QTyqWTKpyryrXd53gnsBZdjxk8RO9eSnGc5PDy1DK5Q5tVsJUrQ2WhEzUnM45HCe1yYFwlzqrxgWxgEwMejgAOCnA-876zc2Quhk5UyrerSz26Cyau5g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 7qmCNR3o_iCl01PYWS1i6qRClplzP-vf2d_V5tqBGIk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NjQ0NDUsImV4cCI6MTczNjQ2NDc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NDY0NDQ1LCJhdF9oYXNoIjoiUjlaQnB4V2tqUExJMEZaMExGQ0Z3dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.AwVivQEMyhpXy-iQF9D1Xd5cfZ_crMSyzMkyEM17Ph52uhOfuFsV-RxztJAwB2zB-gxvhVWz7kELFRUAuCPRmz66qoGfdlqzKGX5SJpKLJZPXhyWi6Uvd1iVnyza56T77c1JXVQaN1ASRwGBc966PdgXxZr-eeX1dwv72aO6ldE02wXfWVqHERL4Dqa8w0rIHNkQYw81S8blldlmkbiRl-WLhN9BcLA-knCUdrhGQ3pi5SGnRY-845zZGfgvjIP1yQ7aztCcZeT_5fYDqIi-1gGSLLkhLqEwVgevCbruJLpIQ5nNPo0HpCKo33A6aJVn8lvsWvtG-NE2T01KzQPudQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY0NjQ0NDQsImV4cCI6MTczNjQ2NjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.cjFU3D4Q9WB7oPRyHYffWVJXobnvlxFy4uHVnyBn9zhUrrzSgmvnpP_r2lILDW3Tpt8wCb6E8OcXF2z8eqpiNKDbYxKwyZb-U-bU3XRt9CQOqNn1HLll9ospcOdU5bFPxlrJ_3NhzxwxZ65ty_DFa_v_EOlI_h7PE0WQ4iT5FEgflaoHNR6ClZrRWTpzWEd5A8g4R-ljSVlVUNikKYL_jYYzqDblaofuV9QTyqWTKpyryrXd53gnsBZdjxk8RO9eSnGc5PDy1DK5Q5tVsJUrQ2WhEzUnM45HCe1yYFwlzqrxgWxgEwMejgAOCnA-876zc2Quhk5UyrerSz26Cyau5g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 7qmCNR3o_iCl01PYWS1i6qRClplzP-vf2d_V5tqBGIk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-09 18:14:05] Production.ERROR: Invoice Payment Date 2025-01-08 00:00:00 [2025-01-09 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,08) [2025-01-09 18:14:08] Production.INFO: Batch insert start [2025-01-09 18:14:08] Production.INFO: global counter1 [2025-01-09 18:14:08] Production.INFO: insertion start [2025-01-09 18:14:08] Production.INFO: last batch insert 1 [2025-01-09 18:14:08] Production.INFO: insertion end [2025-01-09 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('6bb674e0-cedf-11ef-8d92-83efa59363a9') start [2025-01-09 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('6bb674e0-cedf-11ef-8d92-83efa59363a9') end [2025-01-09 18:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-09 18:14:08] Production.INFO: 2 [2025-01-09 18:14:08] Production.ERROR: CronJobId end14 [2025-01-09 18:14:08] Production.INFO: ==22121== Releasing lock... [2025-01-09 18:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-09 18:14:08] Production.INFO: 26 MB #Memory Used#