[2024-12-22 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-22 00:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.97693 [namelookup_time] => 0.528841 [connect_time] => 0.546052 [pretransfer_time] => 0.866094 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2820 [speed_upload] => 83 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.976855 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 58410 ) [2024-12-22 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NDQ0NDQsImV4cCI6MTczNDg0NDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODQ0NDQ0LCJhdF9oYXNoIjoiWC1CNDl4cUNuaUNfZTJKVGcyNzNBdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lJpaTyRH9NeMsPj5OkzEAEg-Op5LZuEtj2VJ24LiwtvIDU4NWQ3fb0t9M9HKMO7BbRS3hbjv_TnUovdu_zHbozB9P3kqWDJfBaBJ5ejlYFJ0Et-Eue1HXuZmsbp44BPmpfdxZT_-52oLQsvfHV7hueirR4j5OOlrJWS4EEvyXVs92N2PArK0N2hpGTz7ozXPbLZAC6Srx4_IJuoWHX9c2O7jkyuHjplXxtgnvPGhTb3rV-6Geb3coJmVoNb5QUjcuW2xwCxujKgrzM13UzEy-A8xGZCxlsCodlIiQ5m6SRRMHwWNm-VXu2kbPc1rjp7KLqrsMhZznk1QsiCO-Gmqpg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NDQ0NDQsImV4cCI6MTczNDg0NjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DGxAhXdlRw0fbvfVhcKOL1GbDL3MVJONluxaQ4C9r5Nbuhy63VDeLYLKSrwyEjThxWWPQLpYP8os0DRsPpa0t1pTSy7XRKVKKTD1AgP9fXjyVs0erRBJlQKxnH519s6SinVNXilr-E-tPeGNIkrP-p4BlFAy1ahJVIp7MMcbUu5f6eTxxguDz7F4VTBrdxwqhbRFMafPDBtNmY_Ao6KWrbv9Hj6fj1WCOKJSm8cVBol8el-GgTRWdHvxKtyIFet_1cX_M79pLNSq6RCh7N_lXHvlGX4xdVpdZoSryXmYtmSdA6w3GzmVm-H7CFhQCZNKexOrYQPSzfRz5bLStz-QtA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => bDV4AWjJ3U1iuIrVj8dpcMe0eK5rE9XHoWjANpdIqrE [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NDQ0NDQsImV4cCI6MTczNDg0NDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODQ0NDQ0LCJhdF9oYXNoIjoiWC1CNDl4cUNuaUNfZTJKVGcyNzNBdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.lJpaTyRH9NeMsPj5OkzEAEg-Op5LZuEtj2VJ24LiwtvIDU4NWQ3fb0t9M9HKMO7BbRS3hbjv_TnUovdu_zHbozB9P3kqWDJfBaBJ5ejlYFJ0Et-Eue1HXuZmsbp44BPmpfdxZT_-52oLQsvfHV7hueirR4j5OOlrJWS4EEvyXVs92N2PArK0N2hpGTz7ozXPbLZAC6Srx4_IJuoWHX9c2O7jkyuHjplXxtgnvPGhTb3rV-6Geb3coJmVoNb5QUjcuW2xwCxujKgrzM13UzEy-A8xGZCxlsCodlIiQ5m6SRRMHwWNm-VXu2kbPc1rjp7KLqrsMhZznk1QsiCO-Gmqpg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NDQ0NDQsImV4cCI6MTczNDg0NjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DGxAhXdlRw0fbvfVhcKOL1GbDL3MVJONluxaQ4C9r5Nbuhy63VDeLYLKSrwyEjThxWWPQLpYP8os0DRsPpa0t1pTSy7XRKVKKTD1AgP9fXjyVs0erRBJlQKxnH519s6SinVNXilr-E-tPeGNIkrP-p4BlFAy1ahJVIp7MMcbUu5f6eTxxguDz7F4VTBrdxwqhbRFMafPDBtNmY_Ao6KWrbv9Hj6fj1WCOKJSm8cVBol8el-GgTRWdHvxKtyIFet_1cX_M79pLNSq6RCh7N_lXHvlGX4xdVpdZoSryXmYtmSdA6w3GzmVm-H7CFhQCZNKexOrYQPSzfRz5bLStz-QtA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => bDV4AWjJ3U1iuIrVj8dpcMe0eK5rE9XHoWjANpdIqrE [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-21 00:00:00 [2024-12-22 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,21) [2024-12-22 00:14:07] Production.INFO: Batch insert start [2024-12-22 00:14:07] Production.INFO: global counter1 [2024-12-22 00:14:07] Production.INFO: insertion start [2024-12-22 00:14:07] Production.INFO: last batch insert 1 [2024-12-22 00:14:07] Production.INFO: insertion end [2024-12-22 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('905153a0-c023-11ef-8199-3ba9f6369ffa') start [2024-12-22 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('905153a0-c023-11ef-8199-3ba9f6369ffa') end [2024-12-22 00:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-22 00:14:08] Production.INFO: 2 [2024-12-22 00:14:08] Production.ERROR: CronJobId end14 [2024-12-22 00:14:08] Production.INFO: ==23994== Releasing lock... [2024-12-22 00:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-22 00:14:08] Production.INFO: 26 MB #Memory Used# [2024-12-22 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-22 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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.950005 [namelookup_time] => 0.523944 [connect_time] => 0.525629 [pretransfer_time] => 0.797085 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2899 [speed_upload] => 86 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.949928 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 59880 ) [2024-12-22 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NjYwNDQsImV4cCI6MTczNDg2NjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODY2MDQ0LCJhdF9oYXNoIjoib2txalYzVkZaakhVNkNDZ2ExOUZKQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.TWPGbfJohkEkIbPTvc0aCFBDkkcu0GJ8m-G41W1eMoV6cfLxUCGHqK2Biqnnvxqqh7oiFNwvjjGH9bjeOuTgXS3jXs1lyEsh4qGfWt7JoATS5hQ-FUMRksEdsd0DObo1hAGLUK_TR_2gj_s-9jl1COapKVyC5v5m2Qwt9G7VjAOZmCnDasXEQGwllDKcvAga0AzaqJ1lMOfc17UEb0Gqg_OMGcBBY-k3cl3ZKDKCAOWCvkM4bKDxaWm2nhqSetujV8bE7x0UHCz6U-CbxvasNzuskT3BukW0u-dK34ey3U1IAEuAU-XiUUvxXvHawYSn1fb2uEP5VbtfG0mLyLWUbw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NjYwNDQsImV4cCI6MTczNDg2Nzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.IZ9p8wOD4Tjc8vJTqK_-FPicyCFSpJoLhZoOteolz10ADkT34i6DabVcMW08oQk_7JPxymwBxn_MYNYxXS_w9Qqp-QU7dzzANwQV6Uu-jfS-rKzdFB7UFSw0G5RD8qZyNWzuqz75F4o7GqZh10UAVyoOJHigQTKE8Riwdh_Uv7V1qyx-fZ07Ric4v7nZYR-IPjO3RVmdc2Z-8Y-c45036-d_OQYFLlb4e1uN7A6y4X_sV7czKJFrDlE6r_9h3EPaSlwzccBLGheDCAqfBo6vFAZCljFfvkbCkqN9fZsnhFfTG-PJBFFc_j4Xpg8mWsM5xRTJ810TRjk9ZSvzQUtU3w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 1GUuhjhKcZfIoDVZejq39XcBXB3AZTTOWdNH1uvh8No [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NjYwNDQsImV4cCI6MTczNDg2NjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODY2MDQ0LCJhdF9oYXNoIjoib2txalYzVkZaakhVNkNDZ2ExOUZKQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.TWPGbfJohkEkIbPTvc0aCFBDkkcu0GJ8m-G41W1eMoV6cfLxUCGHqK2Biqnnvxqqh7oiFNwvjjGH9bjeOuTgXS3jXs1lyEsh4qGfWt7JoATS5hQ-FUMRksEdsd0DObo1hAGLUK_TR_2gj_s-9jl1COapKVyC5v5m2Qwt9G7VjAOZmCnDasXEQGwllDKcvAga0AzaqJ1lMOfc17UEb0Gqg_OMGcBBY-k3cl3ZKDKCAOWCvkM4bKDxaWm2nhqSetujV8bE7x0UHCz6U-CbxvasNzuskT3BukW0u-dK34ey3U1IAEuAU-XiUUvxXvHawYSn1fb2uEP5VbtfG0mLyLWUbw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4NjYwNDQsImV4cCI6MTczNDg2Nzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.IZ9p8wOD4Tjc8vJTqK_-FPicyCFSpJoLhZoOteolz10ADkT34i6DabVcMW08oQk_7JPxymwBxn_MYNYxXS_w9Qqp-QU7dzzANwQV6Uu-jfS-rKzdFB7UFSw0G5RD8qZyNWzuqz75F4o7GqZh10UAVyoOJHigQTKE8Riwdh_Uv7V1qyx-fZ07Ric4v7nZYR-IPjO3RVmdc2Z-8Y-c45036-d_OQYFLlb4e1uN7A6y4X_sV7czKJFrDlE6r_9h3EPaSlwzccBLGheDCAqfBo6vFAZCljFfvkbCkqN9fZsnhFfTG-PJBFFc_j4Xpg8mWsM5xRTJ810TRjk9ZSvzQUtU3w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 1GUuhjhKcZfIoDVZejq39XcBXB3AZTTOWdNH1uvh8No [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-21 00:00:00 [2024-12-22 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,21) [2024-12-22 06:14:07] Production.INFO: Batch insert start [2024-12-22 06:14:07] Production.INFO: global counter1 [2024-12-22 06:14:07] Production.INFO: insertion start [2024-12-22 06:14:07] Production.INFO: last batch insert 1 [2024-12-22 06:14:07] Production.INFO: insertion end [2024-12-22 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('dadfaa50-c055-11ef-9fdd-35d9263f200b') start [2024-12-22 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('dadfaa50-c055-11ef-9fdd-35d9263f200b') end [2024-12-22 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-22 06:14:07] Production.INFO: 2 [2024-12-22 06:14:07] Production.ERROR: CronJobId end14 [2024-12-22 06:14:07] Production.INFO: ==21054== Releasing lock... [2024-12-22 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-22 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-22 12:14:04] Production.INFO: -- Xero Api Check -- [2024-12-22 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] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.720565 [namelookup_time] => 0.155536 [connect_time] => 0.16651 [pretransfer_time] => 0.421643 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3823 [speed_upload] => 113 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.72051 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 33104 ) [2024-12-22 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4ODc2NDQsImV4cCI6MTczNDg4Nzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODg3NjQ0LCJhdF9oYXNoIjoiY0ZIRXg5bHVzZ3BZZEgxamxLaHg0dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.geoEUfkr9fv-emx4wmY_GOHEU2CuGj33celbQ4-9ojJvBW5IZYkqcO4i7mfkYUesDEytpTcmpzjFHyKlkDsoSUYgrvcfhDKsOLeDEPGYIDArl2alsXN8Kj-IAzRCUmCSaCEpq1JDOL-rWJGXnSxZi3eHCDWGGDd2IpPNoFautdVrdjH3G8HtKVr6i4VjyqzUB2XiruZQCUFWuFGEIeYRHil00j1d8PqRlzExtEgjH2NDpZgmyp-pxCYx8CjFRtrIq7Vooj1ydaZQCQKiaI4Qj_-goawRATLT7QNFy7-2l8LSYwaLUzlfzJUwzqOp3lCSS37Lg5m-e3of6ZEqfMc_yA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4ODc2NDQsImV4cCI6MTczNDg4OTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Qj6vGbesz-ZQD7dfIdbka9ZAwHF32FCjsUsxVABQL5wogojdcEUkF6b-IKTf_cdaiCVMt7SCIyp-beMjGOCHEY1AbvOjqYqWS6t0bq6hcyd61vhiBfRusfCeugEHpOLO_g-VHtVCbPTS0Dtc_HYCJVLDXUeotm8xhr6Y8c8rlEe3WQHPi1erjpw09y7u7T1AR6rwCYQJrDzGy0WQUiQa8Os85ZakRhWNSUYSR4Ehx-6f-k2YGFz2uGM1Mp78lnhUXaaOK3IBqQ0TODPHJTFA--h5CR6FjJ7xXw8IsqGKh83vIDhNQKn8XLrGfvP-7LhkdVsf8wGt9kBk-U0CmoCRgA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GK114x8Z2El4aOdabUnDdTIsfpGur17mx8NoXbMBJHw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4ODc2NDQsImV4cCI6MTczNDg4Nzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODg3NjQ0LCJhdF9oYXNoIjoiY0ZIRXg5bHVzZ3BZZEgxamxLaHg0dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.geoEUfkr9fv-emx4wmY_GOHEU2CuGj33celbQ4-9ojJvBW5IZYkqcO4i7mfkYUesDEytpTcmpzjFHyKlkDsoSUYgrvcfhDKsOLeDEPGYIDArl2alsXN8Kj-IAzRCUmCSaCEpq1JDOL-rWJGXnSxZi3eHCDWGGDd2IpPNoFautdVrdjH3G8HtKVr6i4VjyqzUB2XiruZQCUFWuFGEIeYRHil00j1d8PqRlzExtEgjH2NDpZgmyp-pxCYx8CjFRtrIq7Vooj1ydaZQCQKiaI4Qj_-goawRATLT7QNFy7-2l8LSYwaLUzlfzJUwzqOp3lCSS37Lg5m-e3of6ZEqfMc_yA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4ODc2NDQsImV4cCI6MTczNDg4OTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.Qj6vGbesz-ZQD7dfIdbka9ZAwHF32FCjsUsxVABQL5wogojdcEUkF6b-IKTf_cdaiCVMt7SCIyp-beMjGOCHEY1AbvOjqYqWS6t0bq6hcyd61vhiBfRusfCeugEHpOLO_g-VHtVCbPTS0Dtc_HYCJVLDXUeotm8xhr6Y8c8rlEe3WQHPi1erjpw09y7u7T1AR6rwCYQJrDzGy0WQUiQa8Os85ZakRhWNSUYSR4Ehx-6f-k2YGFz2uGM1Mp78lnhUXaaOK3IBqQ0TODPHJTFA--h5CR6FjJ7xXw8IsqGKh83vIDhNQKn8XLrGfvP-7LhkdVsf8wGt9kBk-U0CmoCRgA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GK114x8Z2El4aOdabUnDdTIsfpGur17mx8NoXbMBJHw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 12:14:04] Production.ERROR: Invoice Payment Date 2024-12-21 00:00:00 [2024-12-22 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,21) [2024-12-22 12:14:07] Production.INFO: Batch insert start [2024-12-22 12:14:07] Production.INFO: global counter1 [2024-12-22 12:14:07] Production.INFO: insertion start [2024-12-22 12:14:07] Production.INFO: last batch insert 1 [2024-12-22 12:14:07] Production.INFO: insertion end [2024-12-22 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2588f980-c088-11ef-98fc-158f667cb7e6') start [2024-12-22 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2588f980-c088-11ef-98fc-158f667cb7e6') end [2024-12-22 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-22 12:14:07] Production.INFO: 2 [2024-12-22 12:14:07] Production.ERROR: CronJobId end14 [2024-12-22 12:14:07] Production.INFO: ==19201== Releasing lock... [2024-12-22 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-22 12:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-22 18:14:03] Production.INFO: -- Xero Api Check -- [2024-12-22 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] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.228276 [namelookup_time] => 0.532241 [connect_time] => 0.533428 [pretransfer_time] => 0.847316 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2242 [speed_upload] => 66 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.228223 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 34550 ) [2024-12-22 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MDkyNDQsImV4cCI6MTczNDkwOTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTA5MjQ0LCJhdF9oYXNoIjoiWGNQLVN5MGwtOXRGdGFRSE1vamNYdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.AwUMmlOu5nn29PLh7S6nWqDNDcpVszeFGsWKsWb71RrEc7X4BtRKxHbQriP4dGeM_R1NphEvjLKmaJFimius_sdo3sCL4H3L8ufMP8gyBsBR_VBG7aqrKj1y8NzesaKwCiAuLZ4Vxe96gdWKAHSkY9eLkd_Ff2jmnoFhX6xtpPZTP8fjoaAD-DKgF11gJPimbSt5zNM7-4IZs30QVsIRK5lhDyLyTqoJRKk1tJJarEv97wwco8vTcxny7J_XmvIJHXJWD2Fy0cl7VYBDcaEG7aGeA_YJEY3uIvR-g7UECbf11bS7w_qKnmibiWjFN0p9XwyPO1VPvuMMBSywQhg5ig [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MDkyNDQsImV4cCI6MTczNDkxMTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.l3vEEA9jSy6J5lnrBMrPmBsYc8mbOmfMiqAN-xLaxVHgo0o_dkLyBwB-ZnrjinpaAJjk8E7Hktw-SHT0xz5MBslmEXlQEZQgxzoSpzVc7SK7Z99ElTq5rlyiC2uO_o8y4Yu3UKQ8GKs7HSLIYkTIgdNX7e18NjLYSMt7OJnPMxKrvCvw42RsNJgdJBTK_eYNeeSPIf9RJPs50V_Go00TgpshGr75htmqCG8qN034dccVMNrsnsTYFIws-ZPUJVitcWdivzO8kgb16coa7LFOXTjwaWBI2Secm8LWVSd3j7XRixTM4WJ_ogy9iW-xVjn-Mn4BxCgTZ44UwcBGzQixfg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => Os8zDZdf6NhXBpEHo_pzrityQx2hobfg0Ow0nbXsv2g [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MDkyNDQsImV4cCI6MTczNDkwOTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0OTA5MjQ0LCJhdF9oYXNoIjoiWGNQLVN5MGwtOXRGdGFRSE1vamNYdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.AwUMmlOu5nn29PLh7S6nWqDNDcpVszeFGsWKsWb71RrEc7X4BtRKxHbQriP4dGeM_R1NphEvjLKmaJFimius_sdo3sCL4H3L8ufMP8gyBsBR_VBG7aqrKj1y8NzesaKwCiAuLZ4Vxe96gdWKAHSkY9eLkd_Ff2jmnoFhX6xtpPZTP8fjoaAD-DKgF11gJPimbSt5zNM7-4IZs30QVsIRK5lhDyLyTqoJRKk1tJJarEv97wwco8vTcxny7J_XmvIJHXJWD2Fy0cl7VYBDcaEG7aGeA_YJEY3uIvR-g7UECbf11bS7w_qKnmibiWjFN0p9XwyPO1VPvuMMBSywQhg5ig [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ5MDkyNDQsImV4cCI6MTczNDkxMTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.l3vEEA9jSy6J5lnrBMrPmBsYc8mbOmfMiqAN-xLaxVHgo0o_dkLyBwB-ZnrjinpaAJjk8E7Hktw-SHT0xz5MBslmEXlQEZQgxzoSpzVc7SK7Z99ElTq5rlyiC2uO_o8y4Yu3UKQ8GKs7HSLIYkTIgdNX7e18NjLYSMt7OJnPMxKrvCvw42RsNJgdJBTK_eYNeeSPIf9RJPs50V_Go00TgpshGr75htmqCG8qN034dccVMNrsnsTYFIws-ZPUJVitcWdivzO8kgb16coa7LFOXTjwaWBI2Secm8LWVSd3j7XRixTM4WJ_ogy9iW-xVjn-Mn4BxCgTZ44UwcBGzQixfg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => Os8zDZdf6NhXBpEHo_pzrityQx2hobfg0Ow0nbXsv2g [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-22 18:14:05] Production.ERROR: Invoice Payment Date 2024-12-21 00:00:00 [2024-12-22 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,21) [2024-12-22 18:14:08] Production.INFO: Batch insert start [2024-12-22 18:14:08] Production.INFO: global counter1 [2024-12-22 18:14:08] Production.INFO: insertion start [2024-12-22 18:14:08] Production.INFO: last batch insert 1 [2024-12-22 18:14:08] Production.INFO: insertion end [2024-12-22 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('704d0ee0-c0ba-11ef-a3ef-a557ffb1dfe2') start [2024-12-22 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('704d0ee0-c0ba-11ef-a3ef-a557ffb1dfe2') end [2024-12-22 18:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-22 18:14:08] Production.INFO: 2 [2024-12-22 18:14:08] Production.ERROR: CronJobId end14 [2024-12-22 18:14:08] Production.INFO: ==16493== Releasing lock... [2024-12-22 18:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-22 18:14:08] Production.INFO: 26 MB #Memory Used#