[2025-01-02 00:14:03] Production.INFO: -- Xero Api Check -- [2025-01-02 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] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.929906 [namelookup_time] => 0.276844 [connect_time] => 0.287804 [pretransfer_time] => 0.538065 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2962 [speed_upload] => 88 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.929849 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38718 ) [2025-01-02 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU3OTQ4NDQsImV4cCI6MTczNTc5NTE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1Nzk0ODQ0LCJhdF9oYXNoIjoiX2RxTDFsU1FyV0xLQnF5RmxNYU91USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.WWSUequj8kM0lbEY8V3T9Lx4mEvTc34iOac1Zj4on0qHEGWp2Cmk4iDaFViXs7S2H6sRaCfM3Q9KdPo4vnUbpMNNx7Ouiw1ttTQN1_Gxm9VEBfH71w7YG0JCk2DKzGBrHT0K1-CRY3w_Ht9Q1Jk89hhMxckxF-FZ8eDE_-V1le7-9LlKkXXcbf4eAc-EhP0z6WukUtcHml13yMxUs4-1JpqygcLg7T9gW003hz4x-nRhV5cO-ahJshmt66uLxrAFBJT73aRkhUT7xIQv09fD386maMi5E6bZ-FixLtKH6eqcGswvrc4d1deaU9hTY4UYWF0pZ0e0JJEyiEYQCLKFag [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU3OTQ4NDQsImV4cCI6MTczNTc5NjY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.jW_29-ncIBf0ULc9--HAmF5YGyDJZ2-UIJtsG1T7u5v6gQmDPuKrm21-Hk3WVVOVTCzwfRTezDY5reK2erkyXKF7QQ99SWLi8THICD4SSFBWxaXb_kkPLC10Lv4FCSXNeQea27VllbNTHRpdRz68CxXOEjP_YsfZ1ifYL-abQ-f9N78nGlJ5-ZOqcPybrv_uHHYKNamEwoRIE3sXxHXyds3fXXrMwcC7FGQ4kmud1cHi13n01eW-bGgMaAQg7zniWzt9l5dzeLPuNMTaL7qUSjXbt8AD_U3b3WKaVP127jnnBj6a9de18pw2-3IfsVrh9SGV6_gGufGM4W1KqfXDBA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => C6i975U0B1SzUBOWSf4ZO-eAWUltjvdKcKrdHQGGz4Y [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU3OTQ4NDQsImV4cCI6MTczNTc5NTE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1Nzk0ODQ0LCJhdF9oYXNoIjoiX2RxTDFsU1FyV0xLQnF5RmxNYU91USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.WWSUequj8kM0lbEY8V3T9Lx4mEvTc34iOac1Zj4on0qHEGWp2Cmk4iDaFViXs7S2H6sRaCfM3Q9KdPo4vnUbpMNNx7Ouiw1ttTQN1_Gxm9VEBfH71w7YG0JCk2DKzGBrHT0K1-CRY3w_Ht9Q1Jk89hhMxckxF-FZ8eDE_-V1le7-9LlKkXXcbf4eAc-EhP0z6WukUtcHml13yMxUs4-1JpqygcLg7T9gW003hz4x-nRhV5cO-ahJshmt66uLxrAFBJT73aRkhUT7xIQv09fD386maMi5E6bZ-FixLtKH6eqcGswvrc4d1deaU9hTY4UYWF0pZ0e0JJEyiEYQCLKFag [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU3OTQ4NDQsImV4cCI6MTczNTc5NjY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.jW_29-ncIBf0ULc9--HAmF5YGyDJZ2-UIJtsG1T7u5v6gQmDPuKrm21-Hk3WVVOVTCzwfRTezDY5reK2erkyXKF7QQ99SWLi8THICD4SSFBWxaXb_kkPLC10Lv4FCSXNeQea27VllbNTHRpdRz68CxXOEjP_YsfZ1ifYL-abQ-f9N78nGlJ5-ZOqcPybrv_uHHYKNamEwoRIE3sXxHXyds3fXXrMwcC7FGQ4kmud1cHi13n01eW-bGgMaAQg7zniWzt9l5dzeLPuNMTaL7qUSjXbt8AD_U3b3WKaVP127jnnBj6a9de18pw2-3IfsVrh9SGV6_gGufGM4W1KqfXDBA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => C6i975U0B1SzUBOWSf4ZO-eAWUltjvdKcKrdHQGGz4Y [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 00:14:04] Production.ERROR: Invoice Payment Date 2025-01-01 00:00:00 [2025-01-02 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,01) [2025-01-02 00:14:07] Production.INFO: Batch insert start [2025-01-02 00:14:07] Production.INFO: global counter1 [2025-01-02 00:14:07] Production.INFO: insertion start [2025-01-02 00:14:07] Production.INFO: last batch insert 1 [2025-01-02 00:14:07] Production.INFO: insertion end [2025-01-02 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('62815200-c8c8-11ef-8ad0-0558dcea1e45') start [2025-01-02 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('62815200-c8c8-11ef-8ad0-0558dcea1e45') end [2025-01-02 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-02 00:14:07] Production.INFO: 2 [2025-01-02 00:14:07] Production.ERROR: CronJobId end14 [2025-01-02 00:14:07] Production.INFO: ==6190== Releasing lock... [2025-01-02 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-02 00:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-02 06:14:04] Production.INFO: -- Xero Api Check -- [2025-01-02 06:14:05] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.958094 [namelookup_time] => 0.551991 [connect_time] => 0.555196 [pretransfer_time] => 0.833207 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2875 [speed_upload] => 85 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.95803 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38104 ) [2025-01-02 06:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MTY0NDQsImV4cCI6MTczNTgxNjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODE2NDQ0LCJhdF9oYXNoIjoiSnYybUxoRjUxUk5JM2MzdnhPclYtUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.bviUjB5obE78v4vXLgpbhxTeaR-pqIJbDzlk-WACJDGwdH4_mr8Ru_-LzEGdm9vWXAqoGWzBoj-U0hAZkLgqNr3OtrT1waoBnOfE5aluK6B1MVWk_KXz45KNMa0g3ZMl2vmPIPQOF_RjZWh8melEjONynnb-VZqASK4aSUr5pTV3POHvdU2krMzCdsQBuCcRiBMQf1h0TtU2os6aEGBAG7jok2fd-7ZpMxuqx5N7fL4xfS3Et5ODy7zDYKzeT31as41uRvINrJA7ZTlsMpx40EbD6uXZgO5mXExkGczjbu1_l4eoEZ_ry0q4jLRUMfv54vSBCmMQctzHzaWBcbIxfQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MTY0NDQsImV4cCI6MTczNTgxODI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.A24_BJfyR6jDIHOmDnHoY8WJNvrAN1ZMz986uN_kuUUkb3plAtmE_zZu815ugPSfuwuVbTBTRT7IBx-4xC8C649kSceuXsXLnq9ybXATCmGKjQNG_eJ41Lg_zcivvke4cd-yypXjIJhIKmLpCplyT9MW-rExMa4frfUtgOox2uPsRM9UipFYmxYSs-Kznd4_rPI0seOgpZWtc3xjQ9vYhPAlwl8ptr-TL-gQbHR2wLA-EZK3UZwJFER7eWprdpkNgmvLrnRfZ8i93gQzeol9tZVS0CmBltOA4M9TcKbcslo9zRJpiKWG-KT8WzalldIS_lt7ajLIOktLBE8K8YOwLQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => WORjpHLD_RbN1SFPwPfIzbfxDR9qeMQAp3f63ZZkl7Q [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 06:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MTY0NDQsImV4cCI6MTczNTgxNjc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODE2NDQ0LCJhdF9oYXNoIjoiSnYybUxoRjUxUk5JM2MzdnhPclYtUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.bviUjB5obE78v4vXLgpbhxTeaR-pqIJbDzlk-WACJDGwdH4_mr8Ru_-LzEGdm9vWXAqoGWzBoj-U0hAZkLgqNr3OtrT1waoBnOfE5aluK6B1MVWk_KXz45KNMa0g3ZMl2vmPIPQOF_RjZWh8melEjONynnb-VZqASK4aSUr5pTV3POHvdU2krMzCdsQBuCcRiBMQf1h0TtU2os6aEGBAG7jok2fd-7ZpMxuqx5N7fL4xfS3Et5ODy7zDYKzeT31as41uRvINrJA7ZTlsMpx40EbD6uXZgO5mXExkGczjbu1_l4eoEZ_ry0q4jLRUMfv54vSBCmMQctzHzaWBcbIxfQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MTY0NDQsImV4cCI6MTczNTgxODI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.A24_BJfyR6jDIHOmDnHoY8WJNvrAN1ZMz986uN_kuUUkb3plAtmE_zZu815ugPSfuwuVbTBTRT7IBx-4xC8C649kSceuXsXLnq9ybXATCmGKjQNG_eJ41Lg_zcivvke4cd-yypXjIJhIKmLpCplyT9MW-rExMa4frfUtgOox2uPsRM9UipFYmxYSs-Kznd4_rPI0seOgpZWtc3xjQ9vYhPAlwl8ptr-TL-gQbHR2wLA-EZK3UZwJFER7eWprdpkNgmvLrnRfZ8i93gQzeol9tZVS0CmBltOA4M9TcKbcslo9zRJpiKWG-KT8WzalldIS_lt7ajLIOktLBE8K8YOwLQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => WORjpHLD_RbN1SFPwPfIzbfxDR9qeMQAp3f63ZZkl7Q [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 06:14:05] Production.ERROR: Invoice Payment Date 2025-01-01 00:00:00 [2025-01-02 06:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,01) [2025-01-02 06:14:07] Production.INFO: Batch insert start [2025-01-02 06:14:07] Production.INFO: global counter1 [2025-01-02 06:14:07] Production.INFO: insertion start [2025-01-02 06:14:07] Production.INFO: last batch insert 1 [2025-01-02 06:14:07] Production.INFO: insertion end [2025-01-02 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('ad8d8d90-c8fa-11ef-8967-579f346bf348') start [2025-01-02 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('ad8d8d90-c8fa-11ef-8967-579f346bf348') end [2025-01-02 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-02 06:14:07] Production.INFO: 2 [2025-01-02 06:14:07] Production.ERROR: CronJobId end14 [2025-01-02 06:14:07] Production.INFO: ==3909== Releasing lock... [2025-01-02 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-02 06:14:07] Production.INFO: 26 MB #Memory Used# [2025-01-02 12:14:03] Production.INFO: -- Xero Api Check -- [2025-01-02 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] => 1.025377 [namelookup_time] => 0.274101 [connect_time] => 0.280273 [pretransfer_time] => 0.603536 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2686 [speed_upload] => 79 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.025304 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 39554 ) [2025-01-02 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MzgwNDQsImV4cCI6MTczNTgzODM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODM4MDQ0LCJhdF9oYXNoIjoic0YxZm8tY1BGc2Q1M29sYVA2QnAtQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.eDCJGMzNvdTgrouiOeR-_2FGplmTnjNBJ0u7KZgYlW23EKD22FYRyBikuVBazH9Vg5wgbzWeha7_RKISbJew5WrnQhQf1SbCVcsEbzO7m3K7mKWXg94RuL2BQTsdRHwyhSHq2AhApHm71MT_q4I82THNkSDmVXgACPnEPc-i047Wy5aH5K8zr3ms6zw6O1k0HtbC6POwCSeIG7o6cvCiRfrgaKgbd6kkR041wE4FKVUk8UEpsltbRLj63N-dOUPxEPM2ya0F9N0qG6z5XU2-yWaYLutvUEyrox8MruQz6pMrd6dEjN5b8IRhwcX534YemmZks3DDKuKoKElMAlMmeg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MzgwNDQsImV4cCI6MTczNTgzOTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.usdjG_lbyRwqFmvPdlLtkkyCOoVgEtywSh1tWA5L73jcGroqmS5rIm06pEntHkB9YQ-zyblUbVThDdB_e3n9r1yap4l8apEOVcPEe0T-Qp_Gkk4tAxV_U3NVBRow332irW3WZr_q7c1A_W9lJ7dVe0IcuDA-W1F7MQoYMns8SRaB_z7iARAnrVM8InKvzGWfLLAO7N8nad2y1xmbQBbQQc0xUC3002dFA2IjdmaWR30IG-6xu3DqhdZ2XsQJ5hBkxxuk9R-y-_fDHaDdKqAvMwy7DcFpSv34GQ9GbXAvrK0yrz6ItjmJPx5uSk6GJRF4EDF7Qng7agxNtNEyLcnh2A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => MJI3CW6zxumTsHpqHUhdb6isUuP9L-WJrSzcrzUz9aw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MzgwNDQsImV4cCI6MTczNTgzODM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODM4MDQ0LCJhdF9oYXNoIjoic0YxZm8tY1BGc2Q1M29sYVA2QnAtQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.eDCJGMzNvdTgrouiOeR-_2FGplmTnjNBJ0u7KZgYlW23EKD22FYRyBikuVBazH9Vg5wgbzWeha7_RKISbJew5WrnQhQf1SbCVcsEbzO7m3K7mKWXg94RuL2BQTsdRHwyhSHq2AhApHm71MT_q4I82THNkSDmVXgACPnEPc-i047Wy5aH5K8zr3ms6zw6O1k0HtbC6POwCSeIG7o6cvCiRfrgaKgbd6kkR041wE4FKVUk8UEpsltbRLj63N-dOUPxEPM2ya0F9N0qG6z5XU2-yWaYLutvUEyrox8MruQz6pMrd6dEjN5b8IRhwcX534YemmZks3DDKuKoKElMAlMmeg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4MzgwNDQsImV4cCI6MTczNTgzOTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.usdjG_lbyRwqFmvPdlLtkkyCOoVgEtywSh1tWA5L73jcGroqmS5rIm06pEntHkB9YQ-zyblUbVThDdB_e3n9r1yap4l8apEOVcPEe0T-Qp_Gkk4tAxV_U3NVBRow332irW3WZr_q7c1A_W9lJ7dVe0IcuDA-W1F7MQoYMns8SRaB_z7iARAnrVM8InKvzGWfLLAO7N8nad2y1xmbQBbQQc0xUC3002dFA2IjdmaWR30IG-6xu3DqhdZ2XsQJ5hBkxxuk9R-y-_fDHaDdKqAvMwy7DcFpSv34GQ9GbXAvrK0yrz6ItjmJPx5uSk6GJRF4EDF7Qng7agxNtNEyLcnh2A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => MJI3CW6zxumTsHpqHUhdb6isUuP9L-WJrSzcrzUz9aw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 12:14:04] Production.ERROR: Invoice Payment Date 2025-01-01 00:00:00 [2025-01-02 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,01) [2025-01-02 12:14:07] Production.INFO: Batch insert start [2025-01-02 12:14:07] Production.INFO: global counter1 [2025-01-02 12:14:07] Production.INFO: insertion start [2025-01-02 12:14:07] Production.INFO: last batch insert 1 [2025-01-02 12:14:08] Production.INFO: insertion end [2025-01-02 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('f80b70a0-c92c-11ef-8da5-5142ae81bbc5') start [2025-01-02 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('f80b70a0-c92c-11ef-8da5-5142ae81bbc5') end [2025-01-02 12:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-02 12:14:08] Production.INFO: 2 [2025-01-02 12:14:08] Production.ERROR: CronJobId end14 [2025-01-02 12:14:08] Production.INFO: ==2937== Releasing lock... [2025-01-02 12:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-02 12:14:08] Production.INFO: 26 MB #Memory Used# [2025-01-02 18:14:03] Production.INFO: -- Xero Api Check -- [2025-01-02 18:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.899681 [namelookup_time] => 0.27057 [connect_time] => 0.281292 [pretransfer_time] => 0.720807 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3062 [speed_upload] => 91 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.89961 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 41000 ) [2025-01-02 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4NTk2NDQsImV4cCI6MTczNTg1OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODU5NjQ0LCJhdF9oYXNoIjoiZnZpN21hMjYxMUt6OUhyZzJzSjBIQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.avu5Hu0n4mEFAVCC3GaQvOUuzLsYhzqIP79DBOI5edj0NO8urUonlqPP9WmnnbqldsgzpZIhms5R2TryyjtSlwBOduYvPWwSVVqiWoVvzkfAuuf6c-8o8-e39-Wa28Zm-CHee1XVa2vMYOE1gbJ7Lf6Fm0khUaWlgHdjqb98kGitn7zIlIZLiq9bUnqzNAJ93TDPFfgLxyCGd-7RicQemVu7WYTRIWRZoRiNMKAR1vTf0NcavSJO9_vEk7cmBt4UxnRklFhOslyZmRE7QTMnP9-1nZL7pJIOO1lcy6lTDJvTcTmp-RzNBKk3qYSMe-DMglMrn-wcseaef9XvLXgVlQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4NTk2NDQsImV4cCI6MTczNTg2MTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.IU26INdPnS4aEgMVz5eGI5DuorIHndgQdNwO_81BHxe-2JwzkaTaDvFpEFNTO78DBYkKOu8Akn6oWf-jKVHoB7Rfa0J4qG1zZuTUPTML6KwYjTDiMS93aJ0IP5DX-xX_BNHh-eVtaYMz3qmIECeXfM30PMyDxUwAvgd-EaYUyIYLeV4lIw7hLMDwllAgHYSV9Bze5Z6IFnn7iefbL92vGR9LmcCedxMFT0KL01wJHkNzWIVnXt-VyOvA8rcWzCc2_cInZH0PeXja_hy7fWDeGKRKd9FyzA7e2ykG6cs39Bq5OQu7V2WqLMtV_btWU1D36DmOGZQXaGzJSkHwkQyvQg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 8FF56jgV9P1dHkB0E0Jtc3AXCkTaFeWXBLtjrzjU1Zk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4NTk2NDQsImV4cCI6MTczNTg1OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1ODU5NjQ0LCJhdF9oYXNoIjoiZnZpN21hMjYxMUt6OUhyZzJzSjBIQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.avu5Hu0n4mEFAVCC3GaQvOUuzLsYhzqIP79DBOI5edj0NO8urUonlqPP9WmnnbqldsgzpZIhms5R2TryyjtSlwBOduYvPWwSVVqiWoVvzkfAuuf6c-8o8-e39-Wa28Zm-CHee1XVa2vMYOE1gbJ7Lf6Fm0khUaWlgHdjqb98kGitn7zIlIZLiq9bUnqzNAJ93TDPFfgLxyCGd-7RicQemVu7WYTRIWRZoRiNMKAR1vTf0NcavSJO9_vEk7cmBt4UxnRklFhOslyZmRE7QTMnP9-1nZL7pJIOO1lcy6lTDJvTcTmp-RzNBKk3qYSMe-DMglMrn-wcseaef9XvLXgVlQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU4NTk2NDQsImV4cCI6MTczNTg2MTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.IU26INdPnS4aEgMVz5eGI5DuorIHndgQdNwO_81BHxe-2JwzkaTaDvFpEFNTO78DBYkKOu8Akn6oWf-jKVHoB7Rfa0J4qG1zZuTUPTML6KwYjTDiMS93aJ0IP5DX-xX_BNHh-eVtaYMz3qmIECeXfM30PMyDxUwAvgd-EaYUyIYLeV4lIw7hLMDwllAgHYSV9Bze5Z6IFnn7iefbL92vGR9LmcCedxMFT0KL01wJHkNzWIVnXt-VyOvA8rcWzCc2_cInZH0PeXja_hy7fWDeGKRKd9FyzA7e2ykG6cs39Bq5OQu7V2WqLMtV_btWU1D36DmOGZQXaGzJSkHwkQyvQg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 8FF56jgV9P1dHkB0E0Jtc3AXCkTaFeWXBLtjrzjU1Zk [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-02 18:14:04] Production.ERROR: Invoice Payment Date 2025-01-01 00:00:00 [2025-01-02 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,01) [2025-01-02 18:14:07] Production.INFO: Batch insert start [2025-01-02 18:14:07] Production.INFO: global counter1 [2025-01-02 18:14:07] Production.INFO: insertion start [2025-01-02 18:14:07] Production.INFO: last batch insert 1 [2025-01-02 18:14:07] Production.INFO: insertion end [2025-01-02 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('426ca5b0-c95f-11ef-8754-1faed26af9b6') start [2025-01-02 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('426ca5b0-c95f-11ef-8754-1faed26af9b6') end [2025-01-02 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-02 18:14:07] Production.INFO: 2 [2025-01-02 18:14:07] Production.ERROR: CronJobId end14 [2025-01-02 18:14:07] Production.INFO: ==32622== Releasing lock... [2025-01-02 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-02 18:14:07] Production.INFO: 26 MB #Memory Used#