[2024-12-23 00:14:04] Production.INFO: -- Xero Api Check -- [2024-12-23 00: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] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.756572 [namelookup_time] => 0.284397 [connect_time] => 0.28921 [pretransfer_time] => 0.603848 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3641 [speed_upload] => 108 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.756507 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 36024 ) [2024-12-23 00:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MzA4NDUsImV4cCI6MTczNDkzMTE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTMwODQ1LCJhdF9oYXNoIjoiTmV5Rzg1b2s0UFI1RnZIWGEwRmRYUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.neys2NK5FfV-QAiePgP8lwr5kzOYQmVvyKHh63P-sH0R8s7e9VgNq7oDV7-WU21ufa94P6P3vI00uHKjjBkp84GjsNBfRUDZt7UOWM_bHd8kH18hft3ZPRb54ljKdUvxu8gwne10zeapd3zacQaOAlEbt_kDSxIJLK87Oz--TqkpSsejMtOwXWK4JBHleNQtKNQlHkrbF6zY2szA6D-N6hXrCDjhk7gDw4WFiRliyc9g6eiumPMsLldJ1r9dCeBQtAusTrzmjLe5O79YKBszbDRlBO-OKdfolQC6k8sHf93yQI7gx91-DD5a8y4zH1q-rjW-aK0_y-YhFCBkT0vwTA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MzA4NDUsImV4cCI6MTczNDkzMjY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.S5up5AVn3yhYJvL8M6NS4KU1kjZJyYFgPP_Zc_u-zugtpDA4xAwwf1rwWtADZedmGbEA1Nx04fIf8k9YozH6Gb3Hgr6bdSOkTxz2u4ScB1qLHonaTXXt-CsMUj64LPglXevVVeogHobDafVAH6VAsXTwcECCex0OX7h-2A5BjSr9sC7j2wYGojCyqv1b3ohrmgHtGzH9H8A2qhCsnexqWUTj23c_6jixdsSsVl96V8-pKPU0kj6kDbyDQSnfPSNoHZf8KaaLeIimgneajdZ-eOS19RknaSGjRubaHjSUumRnK6tDuD6oO-N7htJoqdM_zjD_dcpJCN9BA7H65VXifQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => _1xrqH0RIT0C1eJdcwlSW-YwGOBfJ3nK8Gm6Hv5o9IU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 00:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MzA4NDUsImV4cCI6MTczNDkzMTE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTMwODQ1LCJhdF9oYXNoIjoiTmV5Rzg1b2s0UFI1RnZIWGEwRmRYUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.neys2NK5FfV-QAiePgP8lwr5kzOYQmVvyKHh63P-sH0R8s7e9VgNq7oDV7-WU21ufa94P6P3vI00uHKjjBkp84GjsNBfRUDZt7UOWM_bHd8kH18hft3ZPRb54ljKdUvxu8gwne10zeapd3zacQaOAlEbt_kDSxIJLK87Oz--TqkpSsejMtOwXWK4JBHleNQtKNQlHkrbF6zY2szA6D-N6hXrCDjhk7gDw4WFiRliyc9g6eiumPMsLldJ1r9dCeBQtAusTrzmjLe5O79YKBszbDRlBO-OKdfolQC6k8sHf93yQI7gx91-DD5a8y4zH1q-rjW-aK0_y-YhFCBkT0vwTA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MzA4NDUsImV4cCI6MTczNDkzMjY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.S5up5AVn3yhYJvL8M6NS4KU1kjZJyYFgPP_Zc_u-zugtpDA4xAwwf1rwWtADZedmGbEA1Nx04fIf8k9YozH6Gb3Hgr6bdSOkTxz2u4ScB1qLHonaTXXt-CsMUj64LPglXevVVeogHobDafVAH6VAsXTwcECCex0OX7h-2A5BjSr9sC7j2wYGojCyqv1b3ohrmgHtGzH9H8A2qhCsnexqWUTj23c_6jixdsSsVl96V8-pKPU0kj6kDbyDQSnfPSNoHZf8KaaLeIimgneajdZ-eOS19RknaSGjRubaHjSUumRnK6tDuD6oO-N7htJoqdM_zjD_dcpJCN9BA7H65VXifQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => _1xrqH0RIT0C1eJdcwlSW-YwGOBfJ3nK8Gm6Hv5o9IU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 00:14:05] Production.ERROR: Invoice Payment Date 2024-12-22 00:00:00 [2024-12-23 00:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,22) [2024-12-23 00:14:07] Production.INFO: Batch insert start [2024-12-23 00:14:07] Production.INFO: global counter1 [2024-12-23 00:14:07] Production.INFO: insertion start [2024-12-23 00:14:07] Production.INFO: last batch insert 1 [2024-12-23 00:14:07] Production.INFO: insertion end [2024-12-23 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('bad36300-c0ec-11ef-ad87-5768f5665ed1') start [2024-12-23 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('bad36300-c0ec-11ef-ad87-5768f5665ed1') end [2024-12-23 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-23 00:14:07] Production.INFO: 2 [2024-12-23 00:14:07] Production.ERROR: CronJobId end14 [2024-12-23 00:14:07] Production.INFO: ==13900== Releasing lock... [2024-12-23 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-23 00:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-23 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-23 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] => 854 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.903623 [namelookup_time] => 0.556677 [connect_time] => 0.570523 [pretransfer_time] => 0.809846 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3048 [speed_upload] => 90 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.90356 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 37558 ) [2024-12-23 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NTI0NDQsImV4cCI6MTczNDk1Mjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTUyNDQ0LCJhdF9oYXNoIjoiRkhuRGhzcHM3N29ZZ3dtczFFQVFLQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Dn4B9N5hg56IfmXlVHRernOpoYYU_lOXzClRWSNXX4d70iR4YJ39GUVva84kVuQebav03w4_89XE5PnM00Y7Xm43bNqOAAHMSWeAxUbB5h1SrOfRV5N7fi89W-QF2eAjVXkcGmYKXNf27lTSWWLFVV5O6ltCWuBbHCXYnCvRLzn4qKLV6ZF1VQ81iF2qEFrEV2I5_CQzycjIk4MrHIeuJfnTyXB12iZDjFdfLPFFbHtFlK6qhHwG3kLFup7CI2vJvPXn_98QxOAlmaLAfZHbYIiPX6QXHKDNtHW-Jp0eASTn2LdFyyqrDRG5hv4fwCJtfMwRb2okeHvgFB7wymnXiA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NTI0NDQsImV4cCI6MTczNDk1NDI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.hBj6UUTXv7qxJdUmTrDcZXpYnx2eNZ7HwiKhg2ySPof1G2QLisiQilxV_2gdW5_5AGPVQEthrMNxCwBn-1ooJ4EvsCLonTkC52eB8ZaaHN8ryDOy2NhFEdCByDQ9ya0mTxtRTQ5YgrcJTfM_rQxb9AN_-bmKDHCpMHuU8WZIXWd-9xCYoibHfpjRP5PbCaq3Hb7es3YzBk1LWGw1qdy3sjAXlM0yItq-AOBaFGTnwUX0DzeP7DSaf-jmdPsVHVxtqJvH1VntEQdZH3SF4Sfn8JrgHdcslbkFGFLTbsLiIy3-xPNreVNdrWBiaj6JsF9c9QWuxmze2CcUR0HJnvR0ow [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 3tjILNJiYkkJNPzwlRkfrMgH7omLimPh77myVMCENRk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NTI0NDQsImV4cCI6MTczNDk1Mjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTUyNDQ0LCJhdF9oYXNoIjoiRkhuRGhzcHM3N29ZZ3dtczFFQVFLQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Dn4B9N5hg56IfmXlVHRernOpoYYU_lOXzClRWSNXX4d70iR4YJ39GUVva84kVuQebav03w4_89XE5PnM00Y7Xm43bNqOAAHMSWeAxUbB5h1SrOfRV5N7fi89W-QF2eAjVXkcGmYKXNf27lTSWWLFVV5O6ltCWuBbHCXYnCvRLzn4qKLV6ZF1VQ81iF2qEFrEV2I5_CQzycjIk4MrHIeuJfnTyXB12iZDjFdfLPFFbHtFlK6qhHwG3kLFup7CI2vJvPXn_98QxOAlmaLAfZHbYIiPX6QXHKDNtHW-Jp0eASTn2LdFyyqrDRG5hv4fwCJtfMwRb2okeHvgFB7wymnXiA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NTI0NDQsImV4cCI6MTczNDk1NDI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.hBj6UUTXv7qxJdUmTrDcZXpYnx2eNZ7HwiKhg2ySPof1G2QLisiQilxV_2gdW5_5AGPVQEthrMNxCwBn-1ooJ4EvsCLonTkC52eB8ZaaHN8ryDOy2NhFEdCByDQ9ya0mTxtRTQ5YgrcJTfM_rQxb9AN_-bmKDHCpMHuU8WZIXWd-9xCYoibHfpjRP5PbCaq3Hb7es3YzBk1LWGw1qdy3sjAXlM0yItq-AOBaFGTnwUX0DzeP7DSaf-jmdPsVHVxtqJvH1VntEQdZH3SF4Sfn8JrgHdcslbkFGFLTbsLiIy3-xPNreVNdrWBiaj6JsF9c9QWuxmze2CcUR0HJnvR0ow [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 3tjILNJiYkkJNPzwlRkfrMgH7omLimPh77myVMCENRk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-22 00:00:00 [2024-12-23 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,22) [2024-12-23 06:14:07] Production.INFO: Batch insert start [2024-12-23 06:14:07] Production.INFO: global counter1 [2024-12-23 06:14:07] Production.INFO: insertion start [2024-12-23 06:14:07] Production.INFO: last batch insert 1 [2024-12-23 06:14:07] Production.INFO: insertion end [2024-12-23 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('051fba10-c11f-11ef-ae24-ef4ea881c3ca') start [2024-12-23 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('051fba10-c11f-11ef-ae24-ef4ea881c3ca') end [2024-12-23 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-23 06:14:07] Production.INFO: 2 [2024-12-23 06:14:07] Production.ERROR: CronJobId end14 [2024-12-23 06:14:07] Production.INFO: ==12630== Releasing lock... [2024-12-23 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-23 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-23 12:14:04] Production.INFO: -- Xero Api Check -- [2024-12-23 12: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] => 858 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.327778 [namelookup_time] => 0.526061 [connect_time] => 0.528089 [pretransfer_time] => 0.859836 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2074 [speed_upload] => 61 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.327723 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 36934 ) [2024-12-23 12:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NzQwNDUsImV4cCI6MTczNDk3NDM0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTc0MDQ1LCJhdF9oYXNoIjoieDJzUVk3bUlKOVA5ejdHSU8ybVR1dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.a3UveSTZiyW8Lq7ptkyytDVwKWw7HTDs-s55ELvyjJFCgc1-YATK_dKGaHAna7YpWq8B_NdrKculiV7to8BLCBQyK1QB7yrLLLcewnDnQlq6IOVUrLmuYCSXRljk1_ASNmnhOaUpDR-qFegF0MfG-tLzfJZbK7csQ_rsKuBxT7zWwNb4osACwsPOEq60iPLDPFNU8W13mUJOkURUSA4bHi8GLWqsCgGC4tgqlkw-oGq2GCMLVAQwhGDgc3_zqd7vwFBZlTkhIFuVkKg8ULxW5bulKnnKgJRIUgnFFonWTPLQ9J_UstYd6keZa9wxAC05GsGITyySzWx7eY3vDV0Rfg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NzQwNDUsImV4cCI6MTczNDk3NTg0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.w3HgY3uetpEZm7zXA3whxV8RsV7-r_ZoP3sM9iR3XOFha_WcfHUXhWzEkknORmgZLUKo8vOJBZJPnaLjhKbLlHISp6p07fxyDgHPVBQq6xLUbH7CM4A51vnGzBfu8fP5xGYINSlFv7BmJtNgbgdARDey9FtP0xsi_QUf2zFZWYqFSFZRqUkNUt9p8ZifG6bKfXA2852Xz5qz9ZNS_x_CDY5z70jCABjJl5ukmEfupXwK7ovhz4RMPOJQ0lhhsN-XDQzr0thEiTLGVPKSEuPkdYyZt9WS5fTBJ9UAl7-TaEQA_89D8tI-W4HdKlX8Ch-xyv6TKGqfoFuRBT7kQvsh7g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => AHSli2LT_Mtgj5Zk1U-AisXYGDq9747NcmlE8Z_KoIk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 12:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NzQwNDUsImV4cCI6MTczNDk3NDM0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTc0MDQ1LCJhdF9oYXNoIjoieDJzUVk3bUlKOVA5ejdHSU8ybVR1dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.a3UveSTZiyW8Lq7ptkyytDVwKWw7HTDs-s55ELvyjJFCgc1-YATK_dKGaHAna7YpWq8B_NdrKculiV7to8BLCBQyK1QB7yrLLLcewnDnQlq6IOVUrLmuYCSXRljk1_ASNmnhOaUpDR-qFegF0MfG-tLzfJZbK7csQ_rsKuBxT7zWwNb4osACwsPOEq60iPLDPFNU8W13mUJOkURUSA4bHi8GLWqsCgGC4tgqlkw-oGq2GCMLVAQwhGDgc3_zqd7vwFBZlTkhIFuVkKg8ULxW5bulKnnKgJRIUgnFFonWTPLQ9J_UstYd6keZa9wxAC05GsGITyySzWx7eY3vDV0Rfg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5NzQwNDUsImV4cCI6MTczNDk3NTg0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.w3HgY3uetpEZm7zXA3whxV8RsV7-r_ZoP3sM9iR3XOFha_WcfHUXhWzEkknORmgZLUKo8vOJBZJPnaLjhKbLlHISp6p07fxyDgHPVBQq6xLUbH7CM4A51vnGzBfu8fP5xGYINSlFv7BmJtNgbgdARDey9FtP0xsi_QUf2zFZWYqFSFZRqUkNUt9p8ZifG6bKfXA2852Xz5qz9ZNS_x_CDY5z70jCABjJl5ukmEfupXwK7ovhz4RMPOJQ0lhhsN-XDQzr0thEiTLGVPKSEuPkdYyZt9WS5fTBJ9UAl7-TaEQA_89D8tI-W4HdKlX8Ch-xyv6TKGqfoFuRBT7kQvsh7g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => AHSli2LT_Mtgj5Zk1U-AisXYGDq9747NcmlE8Z_KoIk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 12:14:05] Production.ERROR: Invoice Payment Date 2024-12-22 00:00:00 [2024-12-23 12:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,22) [2024-12-23 12:14:08] Production.INFO: Batch insert start [2024-12-23 12:14:08] Production.INFO: global counter1 [2024-12-23 12:14:08] Production.INFO: insertion start [2024-12-23 12:14:08] Production.INFO: last batch insert 1 [2024-12-23 12:14:08] Production.INFO: insertion end [2024-12-23 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('5053f300-c151-11ef-ad34-9960b1b80833') start [2024-12-23 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('5053f300-c151-11ef-ad34-9960b1b80833') end [2024-12-23 12:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-23 12:14:08] Production.INFO: 2 [2024-12-23 12:14:08] Production.ERROR: CronJobId end14 [2024-12-23 12:14:08] Production.INFO: ==20680== Releasing lock... [2024-12-23 12:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-23 12:14:08] Production.INFO: 26 MB #Memory Used# [2024-12-23 18:14:03] Production.INFO: -- Xero Api Check -- [2024-12-23 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] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.151065 [namelookup_time] => 0.531406 [connect_time] => 0.537924 [pretransfer_time] => 0.864096 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2393 [speed_upload] => 71 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.151004 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38414 ) [2024-12-23 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5OTU2NDQsImV4cCI6MTczNDk5NTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTk1NjQ0LCJhdF9oYXNoIjoiY3pobVphdTRlcU5fd3g3cnVQLTdyZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.pFPqzvnefmM2QTvJpur3TsPpv89665VSjp8tTva_fSECzTdgCZyYtzzerC7BOTbrZEu-I-uFO5Epy8DagaWYJDnb7lrU8BOJMrmv4MxJ2aLN5xegbjU1BRcytRnDvTXpoaa7Zzwh2_uNhY54iF3LX8M2ntRssMgGj-pQ-C6K5ci-mVRMJ6Rwecqa-B9pDs6qK5IZ_UZLJOGLmEc7yuY85yPwZQtyj8Aa81TDQjGUMAd9dQCHTdZwf3uxLvqLW7-pRKzfVhf8aKsCqJZHkAE0gbclnB_bt08As_hQG5Ap5lW-XwQlRTK8ttGE0-HbouJW5mDGKop7yilBUryZMMMwIQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5OTU2NDQsImV4cCI6MTczNDk5NzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.upzYWslYXt4n8yY__ZF5LLZk9KJOq4ox9x2hdfrztFHQwCO_8kaL4Zv_GM9bFm7K6ufvrf4v-qbG4s3MeTge06sJK21DOOcG38ujrh7VNyEEuF_GA_f4l2-CCwW3DdnuK0bsFNnVU-HyHjvON9kQavn9Am-OfZ2JDwU2Dzrkwz49ZoX9YLgctrtHA6Qi5MNgIYuefHS0K0owc2Cvmgimcz_nuqoGpVSkqfcBlw-9ggv8Q5sVH1yucPqzG2cd1myt_zpeIDEnEswlxobUs4dZD8QjdKsxYXbJLwZbYSWISVCK9t1RcWeMxogEH7rpNHTp_7SHRK_j0Pf7VcOi0MKD6g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 5jaDZVV44lbaY8EBq0wsYXRL_OnIQkeWGsZtRUt5_R4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5OTU2NDQsImV4cCI6MTczNDk5NTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTk1NjQ0LCJhdF9oYXNoIjoiY3pobVphdTRlcU5fd3g3cnVQLTdyZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.pFPqzvnefmM2QTvJpur3TsPpv89665VSjp8tTva_fSECzTdgCZyYtzzerC7BOTbrZEu-I-uFO5Epy8DagaWYJDnb7lrU8BOJMrmv4MxJ2aLN5xegbjU1BRcytRnDvTXpoaa7Zzwh2_uNhY54iF3LX8M2ntRssMgGj-pQ-C6K5ci-mVRMJ6Rwecqa-B9pDs6qK5IZ_UZLJOGLmEc7yuY85yPwZQtyj8Aa81TDQjGUMAd9dQCHTdZwf3uxLvqLW7-pRKzfVhf8aKsCqJZHkAE0gbclnB_bt08As_hQG5Ap5lW-XwQlRTK8ttGE0-HbouJW5mDGKop7yilBUryZMMMwIQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5OTU2NDQsImV4cCI6MTczNDk5NzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.upzYWslYXt4n8yY__ZF5LLZk9KJOq4ox9x2hdfrztFHQwCO_8kaL4Zv_GM9bFm7K6ufvrf4v-qbG4s3MeTge06sJK21DOOcG38ujrh7VNyEEuF_GA_f4l2-CCwW3DdnuK0bsFNnVU-HyHjvON9kQavn9Am-OfZ2JDwU2Dzrkwz49ZoX9YLgctrtHA6Qi5MNgIYuefHS0K0owc2Cvmgimcz_nuqoGpVSkqfcBlw-9ggv8Q5sVH1yucPqzG2cd1myt_zpeIDEnEswlxobUs4dZD8QjdKsxYXbJLwZbYSWISVCK9t1RcWeMxogEH7rpNHTp_7SHRK_j0Pf7VcOi0MKD6g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 5jaDZVV44lbaY8EBq0wsYXRL_OnIQkeWGsZtRUt5_R4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-23 18:14:04] Production.ERROR: Invoice Payment Date 2024-12-22 00:00:00 [2024-12-23 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,22) [2024-12-23 18:14:07] Production.INFO: Batch insert start [2024-12-23 18:14:07] Production.INFO: global counter1 [2024-12-23 18:14:07] Production.INFO: insertion start [2024-12-23 18:14:07] Production.INFO: last batch insert 1 [2024-12-23 18:14:07] Production.INFO: insertion end [2024-12-23 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('9a91a9e0-c183-11ef-8181-252dff612e79') start [2024-12-23 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('9a91a9e0-c183-11ef-8181-252dff612e79') end [2024-12-23 18:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-23 18:14:08] Production.INFO: 2 [2024-12-23 18:14:08] Production.ERROR: CronJobId end14 [2024-12-23 18:14:08] Production.INFO: ==20594== Releasing lock... [2024-12-23 18:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-23 18:14:08] Production.INFO: 26 MB #Memory Used#