[2025-01-11 00:14:03] Production.INFO: -- Xero Api Check -- [2025-01-11 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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.507308 [namelookup_time] => 0.527191 [connect_time] => 0.625033 [pretransfer_time] => 1.06643 [size_upload] => 82 [size_download] => 2755 [speed_download] => 1827 [speed_upload] => 54 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.507245 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.22.251.42 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 59500 ) [2025-01-11 00:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1NzI0NDUsImV4cCI6MTczNjU3Mjc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NTcyNDQ1LCJhdF9oYXNoIjoiOEpxV2NlelVUYlpaMVJldFBramJEQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Hp9X3U2h_1j1WKKhWC2FXCk8qEMk21IGX8GRJsaG5DfA7hKBpVl4ISetVHU91B_a7fqhdkj1sUw3haemEdsvnf9LIgm8A0qQNbs0fPipmiZvdgUgeqnMZWMNA8ptvtRVtfLFFdpGOaAs-dewR60eu-7_anWbO12K561Fw9mtDkVtt0RHTE2wH6gy-08MbE6hDyIun44M8fBDJFMQdh7wtVjT8J2rzI8dgjTEwpMFbu-62288PouBGMo4PDXHp3wG8iGzWRi7Edv33Ga5W4KMAZB1ys3XzP49Olw_LBMNiVHXx5ZYLuh6Ukm4tSDPhtX-Dh17iTAG8nOVwYnbQT6MyA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1NzI0NDUsImV4cCI6MTczNjU3NDI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.RFWieFInc-fH9JRq38sHK0Nn69yi9plxUIm9vIj_m8P0h4dDC9J_AKMtNHVzRLwTp6qQMqhTGkHNWsTD0JEPrAUF9nG60e-2hNuwbHmtckZ8l2EpQL_JIqV6KUMTUFjyR4u0xtIsjtxcg_cfWu6SYPyK2J8BvIFMNsO_VVEMX2Yq6fBP-x2e-0XAZGyNrTrRdvlqvZluFJ4pkMSqeEbUxsyela3_eI8vLV1bKtfk831tvXjZTuRogC05DahwPHqKxr-OEXJGnxpwkRucO5yx67cQY-yuo8VLTBRFz2x_DTO6rDbYJaWi-qqbPcCftg-H1C2SA4M1grlamiKUHpHvXQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => MOLUhSphLCoffHd2St6fEIH4kpc0Hf-NtbUmVE8atRg [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 00:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1NzI0NDUsImV4cCI6MTczNjU3Mjc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NTcyNDQ1LCJhdF9oYXNoIjoiOEpxV2NlelVUYlpaMVJldFBramJEQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Hp9X3U2h_1j1WKKhWC2FXCk8qEMk21IGX8GRJsaG5DfA7hKBpVl4ISetVHU91B_a7fqhdkj1sUw3haemEdsvnf9LIgm8A0qQNbs0fPipmiZvdgUgeqnMZWMNA8ptvtRVtfLFFdpGOaAs-dewR60eu-7_anWbO12K561Fw9mtDkVtt0RHTE2wH6gy-08MbE6hDyIun44M8fBDJFMQdh7wtVjT8J2rzI8dgjTEwpMFbu-62288PouBGMo4PDXHp3wG8iGzWRi7Edv33Ga5W4KMAZB1ys3XzP49Olw_LBMNiVHXx5ZYLuh6Ukm4tSDPhtX-Dh17iTAG8nOVwYnbQT6MyA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1NzI0NDUsImV4cCI6MTczNjU3NDI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.RFWieFInc-fH9JRq38sHK0Nn69yi9plxUIm9vIj_m8P0h4dDC9J_AKMtNHVzRLwTp6qQMqhTGkHNWsTD0JEPrAUF9nG60e-2hNuwbHmtckZ8l2EpQL_JIqV6KUMTUFjyR4u0xtIsjtxcg_cfWu6SYPyK2J8BvIFMNsO_VVEMX2Yq6fBP-x2e-0XAZGyNrTrRdvlqvZluFJ4pkMSqeEbUxsyela3_eI8vLV1bKtfk831tvXjZTuRogC05DahwPHqKxr-OEXJGnxpwkRucO5yx67cQY-yuo8VLTBRFz2x_DTO6rDbYJaWi-qqbPcCftg-H1C2SA4M1grlamiKUHpHvXQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => MOLUhSphLCoffHd2St6fEIH4kpc0Hf-NtbUmVE8atRg [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 00:14:05] Production.ERROR: Invoice Payment Date 2025-01-10 00:00:00 [2025-01-11 00:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,10) [2025-01-11 00:14:07] Production.INFO: Batch insert start [2025-01-11 00:14:07] Production.INFO: global counter1 [2025-01-11 00:14:07] Production.INFO: insertion start [2025-01-11 00:14:07] Production.INFO: last batch insert 1 [2025-01-11 00:14:07] Production.INFO: insertion end [2025-01-11 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('e0b648c0-cfda-11ef-ada5-8720400d62c1') start [2025-01-11 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('e0b648c0-cfda-11ef-ada5-8720400d62c1') end [2025-01-11 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-11 00:14:07] Production.INFO: 2 [2025-01-11 00:14:07] Production.ERROR: CronJobId end14 [2025-01-11 00:14:07] Production.INFO: ==12762== Releasing lock... [2025-01-11 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-11 00:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-11 06:14:03] Production.INFO: -- Xero Api Check -- [2025-01-11 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.638389 [namelookup_time] => 0.287269 [connect_time] => 0.298241 [pretransfer_time] => 0.515609 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4315 [speed_upload] => 128 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.638329 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38026 ) [2025-01-11 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1OTQwNDQsImV4cCI6MTczNjU5NDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NTk0MDQ0LCJhdF9oYXNoIjoiVHg1WThNT2h5NjVJZjJzdUlCb0xKZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.EwkCoc8Uq69jOnVWPMSMXFN838xe2-leIoFGvkURv0WwDi9bj-PTHwSo4Fys_IDAucB-5A1kogaUUNNUBp2DSg9Hpu-ob6X-8uVWdMWkmvgNsnXpx9WV0Um55dBC-3WFMXlS0tzi6eEEljGFBOaOKZCpZ98WNcxYAMGdNgn4DxkMz1RS-aqU13SETKSh6ChtQgX-l9DsTAsrctCcWOAyaFreSrTc7Bxe1V0uME1sq5tN4zN6IwgxCq_8zFMEWAtgK99Q5YkBZxIa-Nrw9FsXGihTbuIda2qrH_ZcQpDANwcok5ZDERA72E9wozLgRmjUOmO9wfXx0q3SmDelrCxDuQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1OTQwNDQsImV4cCI6MTczNjU5NTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.pmfkyp9Rcb8bJga1OYWfKkN7dkO1JYs0b0kbzlIwvr0gcrG0-avtNoKzbLq5OnvJX2oTHG8MahKmKyXBEu77daXqzQISQgR3tYUbztjwnj_mJ9JyZ1IpnQckkP-xZXmW01IRRE4Zq72FDkP9BeAqxXE_bTbQjb6zUvpqsaGgJZFUMap1qNqFSo5dhughJiQWnLOi7Bd8LD92L-AbbyuoP8q9LoD8TAutG-aFXnEW_r24OMw6sB5g2VFxbdD-NKvulfZ8zy6eY77S983SH-77qyWpXTczJ1SqGWyXkhWNDhhCCNSVryawc4F9onhykPK5mLzOtCy4rhWFNUzfmLqniQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => -i-BWrjwpONEQ0R_7ODlCBqvDFn0PY-5uD7qSsr5Rx0 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1OTQwNDQsImV4cCI6MTczNjU5NDM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NTk0MDQ0LCJhdF9oYXNoIjoiVHg1WThNT2h5NjVJZjJzdUlCb0xKZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.EwkCoc8Uq69jOnVWPMSMXFN838xe2-leIoFGvkURv0WwDi9bj-PTHwSo4Fys_IDAucB-5A1kogaUUNNUBp2DSg9Hpu-ob6X-8uVWdMWkmvgNsnXpx9WV0Um55dBC-3WFMXlS0tzi6eEEljGFBOaOKZCpZ98WNcxYAMGdNgn4DxkMz1RS-aqU13SETKSh6ChtQgX-l9DsTAsrctCcWOAyaFreSrTc7Bxe1V0uME1sq5tN4zN6IwgxCq_8zFMEWAtgK99Q5YkBZxIa-Nrw9FsXGihTbuIda2qrH_ZcQpDANwcok5ZDERA72E9wozLgRmjUOmO9wfXx0q3SmDelrCxDuQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY1OTQwNDQsImV4cCI6MTczNjU5NTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.pmfkyp9Rcb8bJga1OYWfKkN7dkO1JYs0b0kbzlIwvr0gcrG0-avtNoKzbLq5OnvJX2oTHG8MahKmKyXBEu77daXqzQISQgR3tYUbztjwnj_mJ9JyZ1IpnQckkP-xZXmW01IRRE4Zq72FDkP9BeAqxXE_bTbQjb6zUvpqsaGgJZFUMap1qNqFSo5dhughJiQWnLOi7Bd8LD92L-AbbyuoP8q9LoD8TAutG-aFXnEW_r24OMw6sB5g2VFxbdD-NKvulfZ8zy6eY77S983SH-77qyWpXTczJ1SqGWyXkhWNDhhCCNSVryawc4F9onhykPK5mLzOtCy4rhWFNUzfmLqniQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => -i-BWrjwpONEQ0R_7ODlCBqvDFn0PY-5uD7qSsr5Rx0 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 06:14:04] Production.ERROR: Invoice Payment Date 2025-01-10 00:00:00 [2025-01-11 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,10) [2025-01-11 06:14:07] Production.INFO: Batch insert start [2025-01-11 06:14:07] Production.INFO: global counter1 [2025-01-11 06:14:07] Production.INFO: insertion start [2025-01-11 06:14:07] Production.INFO: last batch insert 1 [2025-01-11 06:14:07] Production.INFO: insertion end [2025-01-11 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2aeb48f0-d00d-11ef-b78e-dff832ef8435') start [2025-01-11 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2aeb48f0-d00d-11ef-b78e-dff832ef8435') end [2025-01-11 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-11 06:14:07] Production.INFO: 2 [2025-01-11 06:14:07] Production.ERROR: CronJobId end14 [2025-01-11 06:14:07] Production.INFO: ==12543== Releasing lock... [2025-01-11 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-11 06:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-11 12:14:03] Production.INFO: -- Xero Api Check -- [2025-01-11 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] => 859 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.261707 [namelookup_time] => 0.532889 [connect_time] => 0.627619 [pretransfer_time] => 1.006866 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2183 [speed_upload] => 64 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.261649 [redirect_time] => 0 [redirect_url] => [primary_ip] => 95.101.74.121 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 41798 ) [2025-01-11 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MTU2NDQsImV4cCI6MTczNjYxNTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjE1NjQ0LCJhdF9oYXNoIjoiQTVHOWdfT194U0pqREwtQnJjN2duZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.DQhlLIy_87YlfRANGtBiwfXqRDEHh-nVEZ3qMp4NcaMhs9ObOYNUA579xG8RpNhs-UNtvd_hWoOfpQQUmnHZZzJhCOyiswhYn5VfUcKWDQ0tatk6ion4sIqmyYNI04hY_pvpSsK2p6WzI_HwNLfUnS9qPThJIMl_M0oaMGQXgwW-tc-nfk8m1WmeFN6raVALjCeSLtFj6OUx34pp7AtePIt-I68990659m6x5x9bpepPSpRFKWXeJEWYCzcNoxCFaBZTq3nHAB7gWh8e5tCuvgAODMDlDa6Ab29IblQDUUmLu5HcHF7YlDf1lYtKZZrJlg0tC-3aEAT6xdxbCYhN0Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MTU2NDQsImV4cCI6MTczNjYxNzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.wQLR85kEfLgsVlHUi91th9ZU5qeR9tu1RqlrZXUpbHBWD7UaXzu8BhE7JGKk5bmU2kqapVIqV89lXy27x4ei_Dz7MGSbYq3m4j3LC8TLXho9DTmY_Y6Jo_ZWXDowa4XoIbdzJ3nB8nVmmb3C-xmhOaF295FvQToiZBb6_KTyGuksLPT31VghasvjIk6E7eBEqbnVDIZfMHcuHU4e6zTeoUaOrhYRpp65pRvbIndVegvNrJWGgm1ZtRccd3U81WP01UGGQAWpWOSt52jYVAUTUvRXmNTt_dVjuUrDnoXefIFBKB12nIY9xyNXQzihzGH10SsoWOpVabFEfEjefw7Bgw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GO8PCVsmKvUU6nHIoEYQaGd9UKld7ardPqaGs-WU0Ds [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MTU2NDQsImV4cCI6MTczNjYxNTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjE1NjQ0LCJhdF9oYXNoIjoiQTVHOWdfT194U0pqREwtQnJjN2duZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.DQhlLIy_87YlfRANGtBiwfXqRDEHh-nVEZ3qMp4NcaMhs9ObOYNUA579xG8RpNhs-UNtvd_hWoOfpQQUmnHZZzJhCOyiswhYn5VfUcKWDQ0tatk6ion4sIqmyYNI04hY_pvpSsK2p6WzI_HwNLfUnS9qPThJIMl_M0oaMGQXgwW-tc-nfk8m1WmeFN6raVALjCeSLtFj6OUx34pp7AtePIt-I68990659m6x5x9bpepPSpRFKWXeJEWYCzcNoxCFaBZTq3nHAB7gWh8e5tCuvgAODMDlDa6Ab29IblQDUUmLu5HcHF7YlDf1lYtKZZrJlg0tC-3aEAT6xdxbCYhN0Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MTU2NDQsImV4cCI6MTczNjYxNzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.wQLR85kEfLgsVlHUi91th9ZU5qeR9tu1RqlrZXUpbHBWD7UaXzu8BhE7JGKk5bmU2kqapVIqV89lXy27x4ei_Dz7MGSbYq3m4j3LC8TLXho9DTmY_Y6Jo_ZWXDowa4XoIbdzJ3nB8nVmmb3C-xmhOaF295FvQToiZBb6_KTyGuksLPT31VghasvjIk6E7eBEqbnVDIZfMHcuHU4e6zTeoUaOrhYRpp65pRvbIndVegvNrJWGgm1ZtRccd3U81WP01UGGQAWpWOSt52jYVAUTUvRXmNTt_dVjuUrDnoXefIFBKB12nIY9xyNXQzihzGH10SsoWOpVabFEfEjefw7Bgw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GO8PCVsmKvUU6nHIoEYQaGd9UKld7ardPqaGs-WU0Ds [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 12:14:04] Production.ERROR: Invoice Payment Date 2025-01-10 00:00:00 [2025-01-11 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,10) [2025-01-11 12:14:07] Production.INFO: Batch insert start [2025-01-11 12:14:07] Production.INFO: global counter1 [2025-01-11 12:14:07] Production.INFO: insertion start [2025-01-11 12:14:07] Production.INFO: last batch insert 1 [2025-01-11 12:14:07] Production.INFO: insertion end [2025-01-11 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('75ae2350-d03f-11ef-a147-21352fbb969e') start [2025-01-11 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('75ae2350-d03f-11ef-a147-21352fbb969e') end [2025-01-11 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-11 12:14:07] Production.INFO: 2 [2025-01-11 12:14:07] Production.ERROR: CronJobId end14 [2025-01-11 12:14:07] Production.INFO: ==10537== Releasing lock... [2025-01-11 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-11 12:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-11 18:14:03] Production.INFO: -- Xero Api Check -- [2025-01-11 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.167459 [namelookup_time] => 0.281347 [connect_time] => 0.292315 [pretransfer_time] => 0.609534 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2359 [speed_upload] => 70 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.167405 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 40954 ) [2025-01-11 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MzcyNDQsImV4cCI6MTczNjYzNzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjM3MjQ0LCJhdF9oYXNoIjoiclp1RzhGTUJKek9mc2pHSnBfaTdGUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UVsJtcASzvTNLjkbOeIXQSzPzFD9H9QQRPsja_sRQuIUsdAUMywMdZJViRN-DZG9j0nhupK5F6sLzojvBFIjzRVDaTmasW9y44Pmn6mf_MnKiiLVYkNlqxPoo98bpth4zjMrpK-gRSB-77LnLGZ_orBG_0293BUlfO_vvURAalpMjrjEfC_Tvd2mJ5GasF3EYyV0CbLqA9k_Rdy_tOYhm-_Hke6G8_fBsOJXW11WtcGyXXAA7vbMPmpsCrJ3p115I0m12sFnlWgbT7aDnz40uo7lDAOwxKVnd6pdh1UpOpcxy2I14sFM1YmuZ2Y3rNgCDlLS1IE3AspznQ7mbdxS-Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MzcyNDQsImV4cCI6MTczNjYzOTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Vo5skF1Cft6kGug5iWV0b3b3OC52dDqg3KUdqzO3o-M3UwspdtcjM6M4KFOIsdgW5t6TPJKKnQbGWKyhCmWRyd5eY5cdnN1UGEuyodB3shgsVd-P9Ywq8j3FK4-79UY2YRC6bVqlRoXDXC7vQy5sb_2DFdmnCxdN8lohK3EWzLBvqfA3r39Ns93mtdEf4JONWaJP32j3X0iKuz9C7mNnoK8_wOJq2AZxwjiCrm98lXZ0e240DGPBLFo3JqzSsTC70W_gc-BshRGvRl1KRCDOH0qam71j5UrRdVzlagJZHQgIEd-SM2Ot76WlVQTjqyDqQk-T949vgnU2JdozmZi1hw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => OwyDhcAk7Z0pRAMQ3VhHhzb6BkUg31l33PNwgG5yf20 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MzcyNDQsImV4cCI6MTczNjYzNzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjM3MjQ0LCJhdF9oYXNoIjoiclp1RzhGTUJKek9mc2pHSnBfaTdGUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UVsJtcASzvTNLjkbOeIXQSzPzFD9H9QQRPsja_sRQuIUsdAUMywMdZJViRN-DZG9j0nhupK5F6sLzojvBFIjzRVDaTmasW9y44Pmn6mf_MnKiiLVYkNlqxPoo98bpth4zjMrpK-gRSB-77LnLGZ_orBG_0293BUlfO_vvURAalpMjrjEfC_Tvd2mJ5GasF3EYyV0CbLqA9k_Rdy_tOYhm-_Hke6G8_fBsOJXW11WtcGyXXAA7vbMPmpsCrJ3p115I0m12sFnlWgbT7aDnz40uo7lDAOwxKVnd6pdh1UpOpcxy2I14sFM1YmuZ2Y3rNgCDlLS1IE3AspznQ7mbdxS-Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2MzcyNDQsImV4cCI6MTczNjYzOTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Vo5skF1Cft6kGug5iWV0b3b3OC52dDqg3KUdqzO3o-M3UwspdtcjM6M4KFOIsdgW5t6TPJKKnQbGWKyhCmWRyd5eY5cdnN1UGEuyodB3shgsVd-P9Ywq8j3FK4-79UY2YRC6bVqlRoXDXC7vQy5sb_2DFdmnCxdN8lohK3EWzLBvqfA3r39Ns93mtdEf4JONWaJP32j3X0iKuz9C7mNnoK8_wOJq2AZxwjiCrm98lXZ0e240DGPBLFo3JqzSsTC70W_gc-BshRGvRl1KRCDOH0qam71j5UrRdVzlagJZHQgIEd-SM2Ot76WlVQTjqyDqQk-T949vgnU2JdozmZi1hw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => OwyDhcAk7Z0pRAMQ3VhHhzb6BkUg31l33PNwgG5yf20 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-11 18:14:05] Production.ERROR: Invoice Payment Date 2025-01-10 00:00:00 [2025-01-11 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,10) [2025-01-11 18:14:07] Production.INFO: Batch insert start [2025-01-11 18:14:07] Production.INFO: global counter1 [2025-01-11 18:14:07] Production.INFO: insertion start [2025-01-11 18:14:07] Production.INFO: last batch insert 1 [2025-01-11 18:14:07] Production.INFO: insertion end [2025-01-11 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('c07a39a0-d071-11ef-bcd6-c1e0c71c8b90') start [2025-01-11 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('c07a39a0-d071-11ef-bcd6-c1e0c71c8b90') end [2025-01-11 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-11 18:14:07] Production.INFO: 2 [2025-01-11 18:14:07] Production.ERROR: CronJobId end14 [2025-01-11 18:14:07] Production.INFO: ==9742== Releasing lock... [2025-01-11 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-11 18:14:07] Production.INFO: 26 MB #Memory Used#