[2025-01-12 00:14:04] Production.INFO: -- Xero Api Check -- [2025-01-12 00:14:06] 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.914739 [namelookup_time] => 0.544661 [connect_time] => 0.630216 [pretransfer_time] => 1.079894 [size_upload] => 82 [size_download] => 2755 [speed_download] => 1438 [speed_upload] => 42 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.914673 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.17.107.107 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 33630 ) [2025-01-12 00:14:06] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2NTg4NDYsImV4cCI6MTczNjY1OTE0NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjU4ODQ2LCJhdF9oYXNoIjoiZWdXaWd0UGJjN19HWWkzXzN6MnRSdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.rMegoy1l27TWF37G92bk7sNlL5qaZrNWUsnGNlsqbpSWUDInHYMZBki2BqOPZzz7PVMPzUz1JVsp649j9W6EZgv_kLxdZaumpt0BzaMeLxBrOkl8mKSUZeMgBUCwWrg1_zv7Q08FtVOQrD1UUun9kbH7k8FdoRLbRTv40nuJPMpOoLv-GXlVyNcj-evJGnSc_TJqooP_ac0keDoo5XA7eH_reYRUHiyYPGaDgN7NNu7wARfqlEafsQxDod5LGu9q7kw2x5_bS8TpMbHwue8TBSfwBtkZZ05TwTeeD-kKgxo_UU09W-8B3pQpD7tWRyW7WcT_xqyU45W9Ox2uRTFINQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2NTg4NDYsImV4cCI6MTczNjY2MDY0NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.rzvvbhhPnLiiGNh5FdKyBQ-XX4XwcjeJI0n3G378apG2GqYZ6FgrId4RAU_YHOX1M_Bzxm61QLecCgO10s_le_7ZfKAb-KZDjb1k0HvMVofVJcHp_NLQsfa6ORYp4WpcUwisI1IOP6gfFOe2NvpBa1oddZj8h8Nso9Vn1Sc2R5XzWVtogVqmYw0zQZlOzZ-w1Z0HfwWDTyAlzszJV3ebRQHi3fQgICg-cP0eUmUGOOC9Y5Ul9r5ER4xGYIBDypUSfBURMPxOsofyZrZdUXBhXOtt6JzEHMLV6a8VMp_cD2T5FHvEx78EFjn1QzgjMv_QG8ZZUES5_vSYGXGCaS2-nw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => DmIhU9MYJSj1_eLpa7oBEOHNvMiKKcmKZB_oE59WZME [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 00:14:06] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2NTg4NDYsImV4cCI6MTczNjY1OTE0NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjU4ODQ2LCJhdF9oYXNoIjoiZWdXaWd0UGJjN19HWWkzXzN6MnRSdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.rMegoy1l27TWF37G92bk7sNlL5qaZrNWUsnGNlsqbpSWUDInHYMZBki2BqOPZzz7PVMPzUz1JVsp649j9W6EZgv_kLxdZaumpt0BzaMeLxBrOkl8mKSUZeMgBUCwWrg1_zv7Q08FtVOQrD1UUun9kbH7k8FdoRLbRTv40nuJPMpOoLv-GXlVyNcj-evJGnSc_TJqooP_ac0keDoo5XA7eH_reYRUHiyYPGaDgN7NNu7wARfqlEafsQxDod5LGu9q7kw2x5_bS8TpMbHwue8TBSfwBtkZZ05TwTeeD-kKgxo_UU09W-8B3pQpD7tWRyW7WcT_xqyU45W9Ox2uRTFINQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2NTg4NDYsImV4cCI6MTczNjY2MDY0NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.rzvvbhhPnLiiGNh5FdKyBQ-XX4XwcjeJI0n3G378apG2GqYZ6FgrId4RAU_YHOX1M_Bzxm61QLecCgO10s_le_7ZfKAb-KZDjb1k0HvMVofVJcHp_NLQsfa6ORYp4WpcUwisI1IOP6gfFOe2NvpBa1oddZj8h8Nso9Vn1Sc2R5XzWVtogVqmYw0zQZlOzZ-w1Z0HfwWDTyAlzszJV3ebRQHi3fQgICg-cP0eUmUGOOC9Y5Ul9r5ER4xGYIBDypUSfBURMPxOsofyZrZdUXBhXOtt6JzEHMLV6a8VMp_cD2T5FHvEx78EFjn1QzgjMv_QG8ZZUES5_vSYGXGCaS2-nw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => DmIhU9MYJSj1_eLpa7oBEOHNvMiKKcmKZB_oE59WZME [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 00:14:06] Production.ERROR: Invoice Payment Date 2025-01-11 00:00:00 [2025-01-12 00:14:06] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,11) [2025-01-12 00:14:09] Production.INFO: Batch insert start [2025-01-12 00:14:09] Production.INFO: global counter1 [2025-01-12 00:14:09] Production.INFO: insertion start [2025-01-12 00:14:09] Production.INFO: last batch insert 1 [2025-01-12 00:14:09] Production.INFO: insertion end [2025-01-12 00:14:09] Production.INFO: CALL prc_importPaymentAccounting ('0bc83000-d0a4-11ef-9ade-0b607ba84711') start [2025-01-12 00:14:09] Production.INFO: CALL prc_importPaymentAccounting ('0bc83000-d0a4-11ef-9ade-0b607ba84711') end [2025-01-12 00:14:09] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-12 00:14:09] Production.INFO: 2 [2025-01-12 00:14:09] Production.ERROR: CronJobId end14 [2025-01-12 00:14:09] Production.INFO: ==10124== Releasing lock... [2025-01-12 00:14:09] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-12 00:14:09] Production.INFO: 26 MB #Memory Used# [2025-01-12 06:14:03] Production.INFO: -- Xero Api Check -- [2025-01-12 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.529244 [namelookup_time] => 0.275933 [connect_time] => 0.27726 [pretransfer_time] => 0.467521 [size_upload] => 82 [size_download] => 2755 [speed_download] => 5205 [speed_upload] => 154 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.529182 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 45974 ) [2025-01-12 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2ODA0NDQsImV4cCI6MTczNjY4MDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjgwNDQ0LCJhdF9oYXNoIjoiUXhSRktlZ0dhOE00VVdsR0lsMFZQZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.jOeCnr3gY0TmrKNalo3TTycEkZuKKcBGdxpHEmm_ajmD5B8msjwk32UNla0d2p_43px3gbkY2hDXSPg-DBeoaQIOJWBRqnlHRiOH7HOad1Oi_RpVT-gWl7NmXVmVz2RO0mHubHl8ciCI3-JMSvuh94dcbc1tEh3vJPZN0gx933Zmqyu4FhRxSPPVgniqc-Rv6hMUnjCHUB8ZCxXk74zAz4UIc8ULNexhJb_CLA98cH6kl_PVyVRXYayZJoklquCWJSdpIbaQDF7dNDVnO5l4zeuL9ibj5V5IdlJawtDdNgan3F8GqbidE2BSe8-PpJAxIR0x4w8RVPQoipyKiTrIiQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2ODA0NDQsImV4cCI6MTczNjY4MjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Tbext5v46Fls1dqtTaNy22ejswKdLpYEkzcsmUFaipxj6YqKNDiWWSqLL0Qg8Y5QjGq361cVx-mry5qpnzXhD4D0G2_SJe2TjIV0Ze_ApVDQMCvha1pCoPRbdHq59Rt1YJ_CiYrEq-2Xt5A4UTJ90vKPOGgaPCx3Ei-FcM2hmZ9N_DaekFr6WbOM9q9Z0BL-1xHhRoqQik7iyNqX0gokM7B1sWcbAVMQN9kLYUS035Mr2ck9hcSmF5yp5zOdY9EfpleU1rq7IaxXuDdKXR3te3eM65L0ermk1qGG2obrcEE6KPOA2vQpDHXF1CZnyC9goucjzWjRu1-szUIcCKfhkg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => oOGcgbaeI36njcj9qCo97jIjGzR3yo67o2IA9HKcNME [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2ODA0NDQsImV4cCI6MTczNjY4MDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NjgwNDQ0LCJhdF9oYXNoIjoiUXhSRktlZ0dhOE00VVdsR0lsMFZQZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.jOeCnr3gY0TmrKNalo3TTycEkZuKKcBGdxpHEmm_ajmD5B8msjwk32UNla0d2p_43px3gbkY2hDXSPg-DBeoaQIOJWBRqnlHRiOH7HOad1Oi_RpVT-gWl7NmXVmVz2RO0mHubHl8ciCI3-JMSvuh94dcbc1tEh3vJPZN0gx933Zmqyu4FhRxSPPVgniqc-Rv6hMUnjCHUB8ZCxXk74zAz4UIc8ULNexhJb_CLA98cH6kl_PVyVRXYayZJoklquCWJSdpIbaQDF7dNDVnO5l4zeuL9ibj5V5IdlJawtDdNgan3F8GqbidE2BSe8-PpJAxIR0x4w8RVPQoipyKiTrIiQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY2ODA0NDQsImV4cCI6MTczNjY4MjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Tbext5v46Fls1dqtTaNy22ejswKdLpYEkzcsmUFaipxj6YqKNDiWWSqLL0Qg8Y5QjGq361cVx-mry5qpnzXhD4D0G2_SJe2TjIV0Ze_ApVDQMCvha1pCoPRbdHq59Rt1YJ_CiYrEq-2Xt5A4UTJ90vKPOGgaPCx3Ei-FcM2hmZ9N_DaekFr6WbOM9q9Z0BL-1xHhRoqQik7iyNqX0gokM7B1sWcbAVMQN9kLYUS035Mr2ck9hcSmF5yp5zOdY9EfpleU1rq7IaxXuDdKXR3te3eM65L0ermk1qGG2obrcEE6KPOA2vQpDHXF1CZnyC9goucjzWjRu1-szUIcCKfhkg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => oOGcgbaeI36njcj9qCo97jIjGzR3yo67o2IA9HKcNME [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 06:14:04] Production.ERROR: Invoice Payment Date 2025-01-11 00:00:00 [2025-01-12 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,11) [2025-01-12 06:14:07] Production.INFO: Batch insert start [2025-01-12 06:14:07] Production.INFO: global counter1 [2025-01-12 06:14:07] Production.INFO: insertion start [2025-01-12 06:14:07] Production.INFO: last batch insert 1 [2025-01-12 06:14:07] Production.INFO: insertion end [2025-01-12 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('554ce900-d0d6-11ef-85cc-d9d48322fefc') start [2025-01-12 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('554ce900-d0d6-11ef-85cc-d9d48322fefc') end [2025-01-12 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-12 06:14:07] Production.INFO: 2 [2025-01-12 06:14:07] Production.ERROR: CronJobId end14 [2025-01-12 06:14:07] Production.INFO: ==8717== Releasing lock... [2025-01-12 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-12 06:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-12 12:14:03] Production.INFO: -- Xero Api Check -- [2025-01-12 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] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.238774 [namelookup_time] => 0.533489 [connect_time] => 0.624769 [pretransfer_time] => 0.996797 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2223 [speed_upload] => 66 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.238711 [redirect_time] => 0 [redirect_url] => [primary_ip] => 92.122.154.81 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38900 ) [2025-01-12 12:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MDIwNDQsImV4cCI6MTczNjcwMjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NzAyMDQ0LCJhdF9oYXNoIjoidi1wS0VjTjlTS2czb2lzUVNQWE1aUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lZBWnyqxLIV_gr8N2bs2tnbo0N3P7ORo6cviFN7jbVD17yIIYQSiMB5QSl9YSnidB2PFb40W7BOaOKBCh57oSPbKGWRtZt_t4XhffPmBf1-lBH3JIXRRIMxpkJl3lMFH1UFNA9Njlj9gosM9W6ROuVRvEFMEMLp_FAiMHkr4BRAi3PhlnoQXhLln1VPvkYLuTG9B2Qriv3A3v4pRdpkKqptu_QWnGFZDGmbw0moOanEqmrRfL3uBPUCR6JvXYxOPN-KXg7ebM_cqPuj5CXvGXIWzMZNWGH2fGzmKV9bt0k-eftCroDXH3cestvvvxGaSoZPc6BpKBcpSrxHIgjepmw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MDIwNDQsImV4cCI6MTczNjcwMzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.D_Gw-KTDJXN11taDLX1ebmAeunWbWZ7ylFnrdbkXDH-IevH6x1LUTbCKN3bVurhQ1XYM5Bc1a6kBMinxRcEkWvZwxpXfnuTLr9aXlR0s92hgNUCrymZPHNit1PInvNZhwr7SPeiYx8WD3Epq8vIk-gPJqenmg2Oc0rtlbouJSePENnBPNKcr22y0ALEtbPMvkFzkBk31V16wCdnqVUSF_46B_mZqFFBHfbgO8i8-neF9TOuhlceyrx2m6yKM3D2E1t4Osy-gxfOn71efihBR_VHWI6pdIJKYrg4TQQ1A44xHYvIv59rvhgaYNv0Q_-_JxjZwWgqZIaM8iPZZ7lTukA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => zPknLReVI79jHt2r0mltkR4KNJtVimc0yDvf8LIt_6w [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 12:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MDIwNDQsImV4cCI6MTczNjcwMjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NzAyMDQ0LCJhdF9oYXNoIjoidi1wS0VjTjlTS2czb2lzUVNQWE1aUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lZBWnyqxLIV_gr8N2bs2tnbo0N3P7ORo6cviFN7jbVD17yIIYQSiMB5QSl9YSnidB2PFb40W7BOaOKBCh57oSPbKGWRtZt_t4XhffPmBf1-lBH3JIXRRIMxpkJl3lMFH1UFNA9Njlj9gosM9W6ROuVRvEFMEMLp_FAiMHkr4BRAi3PhlnoQXhLln1VPvkYLuTG9B2Qriv3A3v4pRdpkKqptu_QWnGFZDGmbw0moOanEqmrRfL3uBPUCR6JvXYxOPN-KXg7ebM_cqPuj5CXvGXIWzMZNWGH2fGzmKV9bt0k-eftCroDXH3cestvvvxGaSoZPc6BpKBcpSrxHIgjepmw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MDIwNDQsImV4cCI6MTczNjcwMzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.D_Gw-KTDJXN11taDLX1ebmAeunWbWZ7ylFnrdbkXDH-IevH6x1LUTbCKN3bVurhQ1XYM5Bc1a6kBMinxRcEkWvZwxpXfnuTLr9aXlR0s92hgNUCrymZPHNit1PInvNZhwr7SPeiYx8WD3Epq8vIk-gPJqenmg2Oc0rtlbouJSePENnBPNKcr22y0ALEtbPMvkFzkBk31V16wCdnqVUSF_46B_mZqFFBHfbgO8i8-neF9TOuhlceyrx2m6yKM3D2E1t4Osy-gxfOn71efihBR_VHWI6pdIJKYrg4TQQ1A44xHYvIv59rvhgaYNv0Q_-_JxjZwWgqZIaM8iPZZ7lTukA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => zPknLReVI79jHt2r0mltkR4KNJtVimc0yDvf8LIt_6w [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 12:14:05] Production.ERROR: Invoice Payment Date 2025-01-11 00:00:00 [2025-01-12 12:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,11) [2025-01-12 12:14:07] Production.INFO: Batch insert start [2025-01-12 12:14:07] Production.INFO: global counter1 [2025-01-12 12:14:07] Production.INFO: insertion start [2025-01-12 12:14:07] Production.INFO: last batch insert 1 [2025-01-12 12:14:07] Production.INFO: insertion end [2025-01-12 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('a0523560-d108-11ef-8db9-4dc011691e0d') start [2025-01-12 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('a0523560-d108-11ef-8db9-4dc011691e0d') end [2025-01-12 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-12 12:14:07] Production.INFO: 2 [2025-01-12 12:14:07] Production.ERROR: CronJobId end14 [2025-01-12 12:14:07] Production.INFO: ==8813== Releasing lock... [2025-01-12 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-12 12:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-12 18:14:03] Production.INFO: -- Xero Api Check -- [2025-01-12 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] => 852 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.183858 [namelookup_time] => 0.527497 [connect_time] => 0.614483 [pretransfer_time] => 0.97186 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2327 [speed_upload] => 69 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.183777 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.21.67.32 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 45802 ) [2025-01-12 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MjM2NDQsImV4cCI6MTczNjcyMzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NzIzNjQ0LCJhdF9oYXNoIjoiYW4tNHhYeERqbjBwTzFHVWZscHBBdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.qGMuczkLxMV8I3MiJdFs4JoNfmpcFrQuHRmUPyuXlX8IIR1Yi_oiNlk5JJGnU7hWxSd2u6IRvU_MJ9gvXXVbfOk8rx0Zy2jFQO5ewYxxaUeiHhbyYHbKT3zoI0Ot51WDDZ3D0OguVzNoFPS0uh0w0b7C0Tc5NIyi1LNp5_XR_JtKkT4VUdbYmmGVc3PXqxGPjTKkNs7rJZTEW9BzekQRowxCpVLb6xhZa9fe0JnqfZEXqu9lBjCH2PacHl4UfGFL3VuppMMLUFCG9Hl5bp49M3RY6Z8Z-zV1JTpwz-XP7A-Ptul1_ou_jWvhw0XfuLOktSbW-khBiyuaHgpVbYEnvg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MjM2NDQsImV4cCI6MTczNjcyNTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.THqTWauwsziUME66lQjdVvy3aBaaeDDd7tHtEOT1nZ9jJfth6IRRKu54zksQ4JsLneLkU-xBfOs981jpef-wn21u9pTurVC6lZ0FZUx46S5JtsqZuhuoQRbGatcD0mZMUmMLdFG1HUSKFoPno4cVZFVemc98fAr4kP2mlSkiJwS5226i6PGClF9wtRrj6ylG-qfQ4UL0k6O47LZi6WLgV9qpK-gMTK2sHDgf0SrByWZBSClPIu27tZ9-Za6aKgRs2pQ8s45zuqncqx5USX-tvVh0IpVHcnjR0GQiL8k2hhzoFdceQpda5amUnAvYv9_VW0YUmhxcovMDHkoBQDq4xA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => vJmMrk7ke8E_zs8mRTsDucwuLIdYZyNYwS4OCv7ABQ8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MjM2NDQsImV4cCI6MTczNjcyMzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2NzIzNjQ0LCJhdF9oYXNoIjoiYW4tNHhYeERqbjBwTzFHVWZscHBBdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.qGMuczkLxMV8I3MiJdFs4JoNfmpcFrQuHRmUPyuXlX8IIR1Yi_oiNlk5JJGnU7hWxSd2u6IRvU_MJ9gvXXVbfOk8rx0Zy2jFQO5ewYxxaUeiHhbyYHbKT3zoI0Ot51WDDZ3D0OguVzNoFPS0uh0w0b7C0Tc5NIyi1LNp5_XR_JtKkT4VUdbYmmGVc3PXqxGPjTKkNs7rJZTEW9BzekQRowxCpVLb6xhZa9fe0JnqfZEXqu9lBjCH2PacHl4UfGFL3VuppMMLUFCG9Hl5bp49M3RY6Z8Z-zV1JTpwz-XP7A-Ptul1_ou_jWvhw0XfuLOktSbW-khBiyuaHgpVbYEnvg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzY3MjM2NDQsImV4cCI6MTczNjcyNTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.THqTWauwsziUME66lQjdVvy3aBaaeDDd7tHtEOT1nZ9jJfth6IRRKu54zksQ4JsLneLkU-xBfOs981jpef-wn21u9pTurVC6lZ0FZUx46S5JtsqZuhuoQRbGatcD0mZMUmMLdFG1HUSKFoPno4cVZFVemc98fAr4kP2mlSkiJwS5226i6PGClF9wtRrj6ylG-qfQ4UL0k6O47LZi6WLgV9qpK-gMTK2sHDgf0SrByWZBSClPIu27tZ9-Za6aKgRs2pQ8s45zuqncqx5USX-tvVh0IpVHcnjR0GQiL8k2hhzoFdceQpda5amUnAvYv9_VW0YUmhxcovMDHkoBQDq4xA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => vJmMrk7ke8E_zs8mRTsDucwuLIdYZyNYwS4OCv7ABQ8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-12 18:14:05] Production.ERROR: Invoice Payment Date 2025-01-11 00:00:00 [2025-01-12 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,11) [2025-01-12 18:14:08] Production.INFO: Batch insert start [2025-01-12 18:14:08] Production.INFO: global counter1 [2025-01-12 18:14:08] Production.INFO: insertion start [2025-01-12 18:14:08] Production.INFO: last batch insert 1 [2025-01-12 18:14:08] Production.INFO: insertion end [2025-01-12 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('eadee250-d13a-11ef-9d00-81a83604b090') start [2025-01-12 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('eadee250-d13a-11ef-9d00-81a83604b090') end [2025-01-12 18:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-12 18:14:08] Production.INFO: 2 [2025-01-12 18:14:08] Production.ERROR: CronJobId end14 [2025-01-12 18:14:08] Production.INFO: ==5956== Releasing lock... [2025-01-12 18:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-12 18:14:08] Production.INFO: 26 MB #Memory Used#