[2024-12-19 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-19 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] => 854 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.657351 [namelookup_time] => 0.289174 [connect_time] => 0.300363 [pretransfer_time] => 0.550527 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4191 [speed_upload] => 124 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.657292 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 37658 ) [2024-12-19 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ1ODUyNDQsImV4cCI6MTczNDU4NTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NTg1MjQ0LCJhdF9oYXNoIjoiRHE0c1BleEtpTU5VbFd0Qk1scWVGdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.XDTDkyBKlYDE2oFkMzrD2UbC-A_2rARdQxSo-_bYXD7a3rph5FGwNumPR6lpPWt3fOaxBBXi6ZQBXdEkFvYBIAOONdhLwjP_PIfndrBjI6sgb491k64t0i49lGp4ZPAvxX7SFKLvfAgpEvoQc2om1KrsihPqnV1LoQYv4vK-VHaAWMBcPBstS7o6TTalvLnMjvFJAbEPJpEFAo_8d-DxasyHXFrSp2Loa765dRqffxEG9tNp5bG8WWN6gMD85ww1T9M0pVK-nNAkILHAdhvIxj_tNnMBsWMS0UsT0VhCsLYt-cx3i9dATT5nOVTyBcVh8sqxpJ96-3k5zuGf8NhEbQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ1ODUyNDQsImV4cCI6MTczNDU4NzA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.aJm_8fMt7jINmBMFMdZ0IbVTYtcrYSDrNWdwqBpFCkVvCrC_p_ZL4gVVXo1B4xCyNRj3MXPtipzBoXVfgNQ-M_qxpRGvfffxnVrDAxP-wKK9lA8qzlLExZ2UMXf8Vts80uFO5CQjTSbc6FfDhoCy2KLDESeF8jmRgAY6oYXrEjzS7KkTSEcOpHzlBUqIUb-X4YqjXwIBGejsh1zObEAps41hUjj4DNGDSlsCxhWQpT5XszN67hWykdcJB5sCw0N8gVYDQ-7bcIUF5vK8QpeEfciU_MuEaxeB0we5e96A1xYKDCpOh9W1lPIBQ4bi4n2n4Yi3eWOCodqSb1bLgoos0A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => R4zmciUNoLGKfxLMgIlSYAHg-OvUiGwCCt9hLbPwRfc [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ1ODUyNDQsImV4cCI6MTczNDU4NTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NTg1MjQ0LCJhdF9oYXNoIjoiRHE0c1BleEtpTU5VbFd0Qk1scWVGdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.XDTDkyBKlYDE2oFkMzrD2UbC-A_2rARdQxSo-_bYXD7a3rph5FGwNumPR6lpPWt3fOaxBBXi6ZQBXdEkFvYBIAOONdhLwjP_PIfndrBjI6sgb491k64t0i49lGp4ZPAvxX7SFKLvfAgpEvoQc2om1KrsihPqnV1LoQYv4vK-VHaAWMBcPBstS7o6TTalvLnMjvFJAbEPJpEFAo_8d-DxasyHXFrSp2Loa765dRqffxEG9tNp5bG8WWN6gMD85ww1T9M0pVK-nNAkILHAdhvIxj_tNnMBsWMS0UsT0VhCsLYt-cx3i9dATT5nOVTyBcVh8sqxpJ96-3k5zuGf8NhEbQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ1ODUyNDQsImV4cCI6MTczNDU4NzA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.aJm_8fMt7jINmBMFMdZ0IbVTYtcrYSDrNWdwqBpFCkVvCrC_p_ZL4gVVXo1B4xCyNRj3MXPtipzBoXVfgNQ-M_qxpRGvfffxnVrDAxP-wKK9lA8qzlLExZ2UMXf8Vts80uFO5CQjTSbc6FfDhoCy2KLDESeF8jmRgAY6oYXrEjzS7KkTSEcOpHzlBUqIUb-X4YqjXwIBGejsh1zObEAps41hUjj4DNGDSlsCxhWQpT5XszN67hWykdcJB5sCw0N8gVYDQ-7bcIUF5vK8QpeEfciU_MuEaxeB0we5e96A1xYKDCpOh9W1lPIBQ4bi4n2n4Yi3eWOCodqSb1bLgoos0A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => R4zmciUNoLGKfxLMgIlSYAHg-OvUiGwCCt9hLbPwRfc [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-18 00:00:00 [2024-12-19 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,18) [2024-12-19 00:14:07] Production.INFO: Batch insert start [2024-12-19 00:14:07] Production.INFO: global counter1 [2024-12-19 00:14:07] Production.INFO: insertion start [2024-12-19 00:14:07] Production.INFO: last batch insert 1 [2024-12-19 00:14:07] Production.INFO: insertion end [2024-12-19 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('10aeb9a0-bdc8-11ef-91f4-65ff580f175b') start [2024-12-19 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('10aeb9a0-bdc8-11ef-91f4-65ff580f175b') end [2024-12-19 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-19 00:14:07] Production.INFO: 2 [2024-12-19 00:14:07] Production.ERROR: CronJobId end14 [2024-12-19 00:14:07] Production.INFO: ==17187== Releasing lock... [2024-12-19 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-19 00:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-19 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-19 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.892713 [namelookup_time] => 0.540556 [connect_time] => 0.551547 [pretransfer_time] => 0.79684 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3086 [speed_upload] => 91 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.892647 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 39154 ) [2024-12-19 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2MDY4NDQsImV4cCI6MTczNDYwNzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjA2ODQ0LCJhdF9oYXNoIjoiSm5KNnlFbDNRSEFOUk02SFg1bHczZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.GQ250M9rLviDpb4OZGx2N3jDzs0JwcbqqmF3vhoboE6AdEy50wMlBufkOxYTIdM-JiZtaIr6oTGfJVIBGIuX1-Jjq7RXRxhoRzNd6BVHueCz8ZvXqqbxkLWdiSuQ0ybeAQKyR4EtdYIFACx2bLXC3TQH12Tl3yuqY7ckMOuZUA7ol-FU4meXbrVdtkBtUls0wnDfM3FxBlkfmchhRg4GDUshXqCHkwLOjCwzXKk8S4Xp30dExuSOSv2r1j3w13xKSBaSBGZmpKq7ASBWv6d5_jDakrCT_MTeO5ahFafgRvCp5QnzhAZCYJCjkpGLNZZvrB9ERgC8xaafdDiDitFC9w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2MDY4NDQsImV4cCI6MTczNDYwODY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.qRhVD7K5P1LBysM9tIhPaLSftZLtG8SrDaSwY9t4KuVr7OqrjRZa3kFpGHC0CRsgAzlc48IPVqXpk4AMd0HHxhZuKGAW0QaHe7WDHYCoB1S-DFQj3tfCJNjiaYbp_3h0uiwlljQAM0yE536Fq0vkA6LfMjRLt8ufm5fOXXPHkdJREpb1e7EhLHAZJWCDzLpysmc_jWOgZpM6P40L0GQtyW7wmW7-tP3QDbda-Zz7KkfAa4PV2eSwg_E5jKFGjeC_wf289kr2qzr4o8mLKOx7pwUzE7xFuLAAV6E9CQRtZLraY39m0kRiDnA_Za31dA1uAWPxRAEcoDoClXf2kUidKA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => XARmtYoTmGNhKjv9YzWIMdTFnGuqfabEh2ESM2WZOBM [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2MDY4NDQsImV4cCI6MTczNDYwNzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjA2ODQ0LCJhdF9oYXNoIjoiSm5KNnlFbDNRSEFOUk02SFg1bHczZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.GQ250M9rLviDpb4OZGx2N3jDzs0JwcbqqmF3vhoboE6AdEy50wMlBufkOxYTIdM-JiZtaIr6oTGfJVIBGIuX1-Jjq7RXRxhoRzNd6BVHueCz8ZvXqqbxkLWdiSuQ0ybeAQKyR4EtdYIFACx2bLXC3TQH12Tl3yuqY7ckMOuZUA7ol-FU4meXbrVdtkBtUls0wnDfM3FxBlkfmchhRg4GDUshXqCHkwLOjCwzXKk8S4Xp30dExuSOSv2r1j3w13xKSBaSBGZmpKq7ASBWv6d5_jDakrCT_MTeO5ahFafgRvCp5QnzhAZCYJCjkpGLNZZvrB9ERgC8xaafdDiDitFC9w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2MDY4NDQsImV4cCI6MTczNDYwODY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.qRhVD7K5P1LBysM9tIhPaLSftZLtG8SrDaSwY9t4KuVr7OqrjRZa3kFpGHC0CRsgAzlc48IPVqXpk4AMd0HHxhZuKGAW0QaHe7WDHYCoB1S-DFQj3tfCJNjiaYbp_3h0uiwlljQAM0yE536Fq0vkA6LfMjRLt8ufm5fOXXPHkdJREpb1e7EhLHAZJWCDzLpysmc_jWOgZpM6P40L0GQtyW7wmW7-tP3QDbda-Zz7KkfAa4PV2eSwg_E5jKFGjeC_wf289kr2qzr4o8mLKOx7pwUzE7xFuLAAV6E9CQRtZLraY39m0kRiDnA_Za31dA1uAWPxRAEcoDoClXf2kUidKA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => XARmtYoTmGNhKjv9YzWIMdTFnGuqfabEh2ESM2WZOBM [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-18 00:00:00 [2024-12-19 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,18) [2024-12-19 06:14:07] Production.INFO: Batch insert start [2024-12-19 06:14:07] Production.INFO: global counter1 [2024-12-19 06:14:07] Production.INFO: insertion start [2024-12-19 06:14:07] Production.INFO: last batch insert 1 [2024-12-19 06:14:07] Production.INFO: insertion end [2024-12-19 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('5b5894a0-bdfa-11ef-be6c-853d7888bc81') start [2024-12-19 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('5b5894a0-bdfa-11ef-be6c-853d7888bc81') end [2024-12-19 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-19 06:14:07] Production.INFO: 2 [2024-12-19 06:14:07] Production.ERROR: CronJobId end14 [2024-12-19 06:14:07] Production.INFO: ==15632== Releasing lock... [2024-12-19 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-19 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-19 12:14:03] Production.INFO: -- Xero Api Check -- [2024-12-19 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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.834662 [namelookup_time] => 0.281784 [connect_time] => 0.292517 [pretransfer_time] => 0.6287 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3300 [speed_upload] => 98 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.834602 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 40616 ) [2024-12-19 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2Mjg0NDMsImV4cCI6MTczNDYyODc0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjI4NDQzLCJhdF9oYXNoIjoiMl9BaEZUNEQxYnhXdVR5SVcwYkV6dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.L5Q5lKVNJSLUq6Bzt0wGe4H3ft0JAWVbHQoNDmnSaFp7dC4vwpVEu-tmsXiNmujvE93k_DXXpq5vJNaEJ6m8Nc5PmXIP07wLBTjqIIngY_uWujlY3fSiT32AIMIcyK5sljpwpbKTMe_ZrNYyltPmbjKONVIc0f1JeS0ke-F9sE7fk7GynnaRA4J3qElhoFYIVKeDXQStC5GgWanYjxL9oOfgiYOsIg1f4Psiav-BPb-fk_0VaYvIX-OfIb6Wy7z3fP3WhLyWN3RoWobMpxhBTrERZhjj0QAPWCngtTkvYUm3qIemHOmIAndEBUUMkvmKYxPxwM_BfPYyBdFw8RP1NA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2Mjg0NDMsImV4cCI6MTczNDYzMDI0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.dBd924FqUF9BjNFjJWkraSoiq-LNtx-EokqnfTMZ1S0bYFDzn678TfX8M9cN8sskX4fG4W_ZTbNH1-jeiDjoFDVIh2qAqcy7JsoB7uH02aMibLRAaWzgNLUdkk9BxOzbhgE9DsbGoGTcnxckwAcCm_Z0vBmzJXNOpHZImJV8oyJtaCbndvMcuBXU90QA_NKABXavrjXocB_VNuhNZf557rk87_D5I_tCnFHPXUudVf8lDASmBkI9PB0lpMFNSxGNYN2tKT083wUWBqWqYj332jze-u73FM3oIOSupuXCyx7D1Km9ft3b50qYF6M_R_orsNbBQ4jnk-fR0BlMXyf1Wg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 3r7QGQQrxWP1ovNqWT7Et1rwhODgxLGd7pNegOqT_3o [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2Mjg0NDMsImV4cCI6MTczNDYyODc0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjI4NDQzLCJhdF9oYXNoIjoiMl9BaEZUNEQxYnhXdVR5SVcwYkV6dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.L5Q5lKVNJSLUq6Bzt0wGe4H3ft0JAWVbHQoNDmnSaFp7dC4vwpVEu-tmsXiNmujvE93k_DXXpq5vJNaEJ6m8Nc5PmXIP07wLBTjqIIngY_uWujlY3fSiT32AIMIcyK5sljpwpbKTMe_ZrNYyltPmbjKONVIc0f1JeS0ke-F9sE7fk7GynnaRA4J3qElhoFYIVKeDXQStC5GgWanYjxL9oOfgiYOsIg1f4Psiav-BPb-fk_0VaYvIX-OfIb6Wy7z3fP3WhLyWN3RoWobMpxhBTrERZhjj0QAPWCngtTkvYUm3qIemHOmIAndEBUUMkvmKYxPxwM_BfPYyBdFw8RP1NA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2Mjg0NDMsImV4cCI6MTczNDYzMDI0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.dBd924FqUF9BjNFjJWkraSoiq-LNtx-EokqnfTMZ1S0bYFDzn678TfX8M9cN8sskX4fG4W_ZTbNH1-jeiDjoFDVIh2qAqcy7JsoB7uH02aMibLRAaWzgNLUdkk9BxOzbhgE9DsbGoGTcnxckwAcCm_Z0vBmzJXNOpHZImJV8oyJtaCbndvMcuBXU90QA_NKABXavrjXocB_VNuhNZf557rk87_D5I_tCnFHPXUudVf8lDASmBkI9PB0lpMFNSxGNYN2tKT083wUWBqWqYj332jze-u73FM3oIOSupuXCyx7D1Km9ft3b50qYF6M_R_orsNbBQ4jnk-fR0BlMXyf1Wg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 3r7QGQQrxWP1ovNqWT7Et1rwhODgxLGd7pNegOqT_3o [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 12:14:04] Production.ERROR: Invoice Payment Date 2024-12-18 00:00:00 [2024-12-19 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,18) [2024-12-19 12:14:06] Production.INFO: Batch insert start [2024-12-19 12:14:06] Production.INFO: global counter1 [2024-12-19 12:14:06] Production.INFO: insertion start [2024-12-19 12:14:06] Production.INFO: last batch insert 1 [2024-12-19 12:14:06] Production.INFO: insertion end [2024-12-19 12:14:06] Production.INFO: CALL prc_importPaymentAccounting ('a5bed770-be2c-11ef-811a-5344b4739319') start [2024-12-19 12:14:06] Production.INFO: CALL prc_importPaymentAccounting ('a5bed770-be2c-11ef-811a-5344b4739319') end [2024-12-19 12:14:06] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-19 12:14:06] Production.INFO: 2 [2024-12-19 12:14:06] Production.ERROR: CronJobId end14 [2024-12-19 12:14:06] Production.INFO: ==13366== Releasing lock... [2024-12-19 12:14:06] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-19 12:14:06] Production.INFO: 26 MB #Memory Used# [2024-12-19 18:14:03] Production.INFO: -- Xero Api Check -- [2024-12-19 18: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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.868834 [namelookup_time] => 0.291729 [connect_time] => 0.29749 [pretransfer_time] => 0.603592 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3170 [speed_upload] => 94 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.868777 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 43056 ) [2024-12-19 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2NTAwNDQsImV4cCI6MTczNDY1MDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjUwMDQ0LCJhdF9oYXNoIjoiaUFLNElVTUNzellPMWduWTFfOWJDZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lfgjQcV7QS7bdMRfcnmq4ZswKbvnMm2tlJQrcsN-QD8J7Z_sgrkV6vd98EdyRVSaq2PlBTv5nxYEF-avb7QvXamhAvk30afHmFKsnMcYgzSxR_Soolvt5OICbhRcZmxaLahadbRVJmn1FA04fYuHgeJ6qswUz_u4YqGtjs0nzCRj_ejIWoFI461Yjpa59efSksjI34H5pZoqB-ApAimV-62WQy2a_ZaLlXG4OoyzorluyZuxaDSFqe42mLHxl-YbJSa0vVE6oq124jJ8Pwn4Ma5i-cKhsuc6_Eh2sVaJQTQSYBEYHV0mKuN7VxxOm_-Mr59iLPExjq1rpRMx6jN0-g [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2NTAwNDQsImV4cCI6MTczNDY1MTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DWqxodRVgOt5Vowfxye4Dn78h-L_FWc83avEjmPM66s4qnSvZ5Jc4nqKOQ2B4PqE4xxS9voX82sEPqwrpEwbp8bGZDtA_V_nB9E6lBaGR6TDPaBkUFcieg-1LRG1V9z7Ay6_wJ5-U9wgUa57JxR0C-jGLSCcnh6jOfnL_wfGyN-LR4UfCO6Ur0SHv51D9s7RfmQ_4zVF3urtz-uHIOmiE2xM3rrkCyphp-Iv0G3XsBBGZsQ-sy8MueifvQ3epcTmWAMU3iYr4GqEo3d0qGp4IMRohSwZ00Hpdnd_ilOjsphw7hs6lXXpNO5iz2p4f5ccos8weTCJJanE65XbVSu1iw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 0VAKYv5YCsxv1zqBR-tMiMqUuYdab80TREUKSlakr_A [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2NTAwNDQsImV4cCI6MTczNDY1MDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NjUwMDQ0LCJhdF9oYXNoIjoiaUFLNElVTUNzellPMWduWTFfOWJDZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lfgjQcV7QS7bdMRfcnmq4ZswKbvnMm2tlJQrcsN-QD8J7Z_sgrkV6vd98EdyRVSaq2PlBTv5nxYEF-avb7QvXamhAvk30afHmFKsnMcYgzSxR_Soolvt5OICbhRcZmxaLahadbRVJmn1FA04fYuHgeJ6qswUz_u4YqGtjs0nzCRj_ejIWoFI461Yjpa59efSksjI34H5pZoqB-ApAimV-62WQy2a_ZaLlXG4OoyzorluyZuxaDSFqe42mLHxl-YbJSa0vVE6oq124jJ8Pwn4Ma5i-cKhsuc6_Eh2sVaJQTQSYBEYHV0mKuN7VxxOm_-Mr59iLPExjq1rpRMx6jN0-g [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ2NTAwNDQsImV4cCI6MTczNDY1MTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DWqxodRVgOt5Vowfxye4Dn78h-L_FWc83avEjmPM66s4qnSvZ5Jc4nqKOQ2B4PqE4xxS9voX82sEPqwrpEwbp8bGZDtA_V_nB9E6lBaGR6TDPaBkUFcieg-1LRG1V9z7Ay6_wJ5-U9wgUa57JxR0C-jGLSCcnh6jOfnL_wfGyN-LR4UfCO6Ur0SHv51D9s7RfmQ_4zVF3urtz-uHIOmiE2xM3rrkCyphp-Iv0G3XsBBGZsQ-sy8MueifvQ3epcTmWAMU3iYr4GqEo3d0qGp4IMRohSwZ00Hpdnd_ilOjsphw7hs6lXXpNO5iz2p4f5ccos8weTCJJanE65XbVSu1iw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 0VAKYv5YCsxv1zqBR-tMiMqUuYdab80TREUKSlakr_A [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-19 18:14:04] Production.ERROR: Invoice Payment Date 2024-12-18 00:00:00 [2024-12-19 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,18) [2024-12-19 18:14:07] Production.INFO: Batch insert start [2024-12-19 18:14:07] Production.INFO: global counter1 [2024-12-19 18:14:07] Production.INFO: insertion start [2024-12-19 18:14:07] Production.INFO: last batch insert 1 [2024-12-19 18:14:07] Production.INFO: insertion end [2024-12-19 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('f0b124e0-be5e-11ef-a02c-ddc8d4f5f79c') start [2024-12-19 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('f0b124e0-be5e-11ef-a02c-ddc8d4f5f79c') end [2024-12-19 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-19 18:14:07] Production.INFO: 2 [2024-12-19 18:14:07] Production.ERROR: CronJobId end14 [2024-12-19 18:14:07] Production.INFO: ==12401== Releasing lock... [2024-12-19 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-19 18:14:07] Production.INFO: 26 MB #Memory Used#