[2024-12-24 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-24 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] => 854 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.843704 [namelookup_time] => 0.529612 [connect_time] => 0.53178 [pretransfer_time] => 0.731063 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3265 [speed_upload] => 97 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.843642 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 39892 ) [2024-12-24 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMTcyNDQsImV4cCI6MTczNTAxNzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDE3MjQ0LCJhdF9oYXNoIjoidkNKZ3l1MHhVamtiODRjZWlMTXNkZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.KmT8YDy42wAu0xscWTcaFGDj53FIe_RoVYkULNtvsT2lwNQbAw8-1Bjj_lsIozTqcZsdMO450Y8LTtyHXFgGf7JetcwkSn0_G1Y1mbaRjo4aSYKpIQhCym0XgxC0gJzMjSyWciNd4-c9khIBjNkvIWronOyJloGGI0hX8iiE7u-mtaYiYuvkWEWBNeDeIH0xBzvglDkuIQhVN7H8Kz9yxEvaPfxEBySt8MeWgiKPDJC5_WjKr54UORYBUxPhgf_KGTHa6MEeT6xFeW5qEYDWD9Ud7jEpPX8FihP4q6QGWO2-sfKbly9Y0zwJ9MGRlshctqgEOf6QXOjx0lMUCjKdZg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMTcyNDQsImV4cCI6MTczNTAxOTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.cKXJkcbfO1nE1I_uR6--9K7afipa-pGCjcCfn0WaBuDgD3um17E-lZQ0IINdrDINgW_TKYUoRfPCt0QAR8XGutAEz4n-iShKJB-VIYjIpZ4yoomyJfPHjb83rLqsUQpIAcOWZO7gtXDzGNJOQFSsmZeVY03YJWMJ23T_MmDRH_oXaJ47RMGNZ_Mq5PEUKn65eI1zkwZWcPyGCIXUn9BlNsyu6CS-PYC4GmLjT7BPfitpyEj2AYESVBMPkH92Vs0q-514rzASGdGwK3XXYPwhg0lS3SiubUfBYaKb6oU_06-cfJJ9cGh1GOGhlTd7-IMhSbqoZrptbcu5eqsZARdE7w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GpNRNC0WHmYZTF1D5XVqKXcC7-IiifvRGRI4RxOrHfI [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMTcyNDQsImV4cCI6MTczNTAxNzU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDE3MjQ0LCJhdF9oYXNoIjoidkNKZ3l1MHhVamtiODRjZWlMTXNkZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.KmT8YDy42wAu0xscWTcaFGDj53FIe_RoVYkULNtvsT2lwNQbAw8-1Bjj_lsIozTqcZsdMO450Y8LTtyHXFgGf7JetcwkSn0_G1Y1mbaRjo4aSYKpIQhCym0XgxC0gJzMjSyWciNd4-c9khIBjNkvIWronOyJloGGI0hX8iiE7u-mtaYiYuvkWEWBNeDeIH0xBzvglDkuIQhVN7H8Kz9yxEvaPfxEBySt8MeWgiKPDJC5_WjKr54UORYBUxPhgf_KGTHa6MEeT6xFeW5qEYDWD9Ud7jEpPX8FihP4q6QGWO2-sfKbly9Y0zwJ9MGRlshctqgEOf6QXOjx0lMUCjKdZg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMTcyNDQsImV4cCI6MTczNTAxOTA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.cKXJkcbfO1nE1I_uR6--9K7afipa-pGCjcCfn0WaBuDgD3um17E-lZQ0IINdrDINgW_TKYUoRfPCt0QAR8XGutAEz4n-iShKJB-VIYjIpZ4yoomyJfPHjb83rLqsUQpIAcOWZO7gtXDzGNJOQFSsmZeVY03YJWMJ23T_MmDRH_oXaJ47RMGNZ_Mq5PEUKn65eI1zkwZWcPyGCIXUn9BlNsyu6CS-PYC4GmLjT7BPfitpyEj2AYESVBMPkH92Vs0q-514rzASGdGwK3XXYPwhg0lS3SiubUfBYaKb6oU_06-cfJJ9cGh1GOGhlTd7-IMhSbqoZrptbcu5eqsZARdE7w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GpNRNC0WHmYZTF1D5XVqKXcC7-IiifvRGRI4RxOrHfI [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-23 00:00:00 [2024-12-24 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,23) [2024-12-24 00:14:07] Production.INFO: Batch insert start [2024-12-24 00:14:07] Production.INFO: global counter1 [2024-12-24 00:14:07] Production.INFO: insertion start [2024-12-24 00:14:07] Production.INFO: last batch insert 1 [2024-12-24 00:14:07] Production.INFO: insertion end [2024-12-24 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('e5087720-c1b5-11ef-b157-db8c6ed71102') start [2024-12-24 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('e5087720-c1b5-11ef-b157-db8c6ed71102') end [2024-12-24 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-24 00:14:07] Production.INFO: 2 [2024-12-24 00:14:07] Production.ERROR: CronJobId end14 [2024-12-24 00:14:07] Production.INFO: ==19335== Releasing lock... [2024-12-24 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-24 00:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-24 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-24 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] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.620561 [namelookup_time] => 0.27752 [connect_time] => 0.288501 [pretransfer_time] => 0.509627 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4439 [speed_upload] => 132 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.62051 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 41368 ) [2024-12-24 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMzg4NDQsImV4cCI6MTczNTAzOTE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDM4ODQ0LCJhdF9oYXNoIjoiTm9TX1RLVHhBelI5eWhaNElWbXVNUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.W6SDFPSy2CSzGAgcYbADxHhZJJgUaH5JBYfHNpw9HkNG6BDMLPCWgDLf8oYLMJ4ivtUExWdjVmUUEz-I1-LmwwPw3tl4fenqZRifAR8OldMl7H_xRT_Z3H9XKrYJrMmgkDGbA4oErS6PgR_G3G1DEa8xpZISgtQTRMrIbTXYIG0sUqgHlhXoQ3Fx1CjwuUY4SVB8KC6vqCV_ANqx-qaGG1hFco_hNdHc9X8-W86qW8ZT44FhK-14oI1VbxoLwZm9QUxZZYzt99yPkIz37ByPbew9l-TL7uQ4jV6lrGzwpO3vja7aNmpv3TbW7gx92oQgt1QX2z0kGtpqT74bKfKwow [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMzg4NDQsImV4cCI6MTczNTA0MDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DsootyVoEdcR7HrY2E5tdslmiQq7LnmyT9gwUvOUFfJ2_LvWqdll9shSSTEkNS5ukwL3YgRGgNImwqUzIavIBI1itcLf-dPJb2VqaE3zvnfaFvdcYhf2vWCcdJdRXNe6j1rqQ-5l40pXfDCCi0TSX8xx760tHZgouXvMAL-HX8vqR2-Fmgpq7g9rmQhmcu0yDBjCtJbtTjWY_6QTFvKmYYTOfoKSrXzmsqsh7f8CO_ovc0MALZ92BSy5D9NEzydDY-ZqlFpgeIIJwQO4VAqQoVUBXXM3mPa94L9f8L0lO4JqI_WOh07fLp06oPUz3Nni-yCqB083PaoJEMP3m6nVEg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => NFgRqJJj2HBZ1rp4a-s1j6y9MZoj8zsRLndYTFs31b4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMzg4NDQsImV4cCI6MTczNTAzOTE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDM4ODQ0LCJhdF9oYXNoIjoiTm9TX1RLVHhBelI5eWhaNElWbXVNUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.W6SDFPSy2CSzGAgcYbADxHhZJJgUaH5JBYfHNpw9HkNG6BDMLPCWgDLf8oYLMJ4ivtUExWdjVmUUEz-I1-LmwwPw3tl4fenqZRifAR8OldMl7H_xRT_Z3H9XKrYJrMmgkDGbA4oErS6PgR_G3G1DEa8xpZISgtQTRMrIbTXYIG0sUqgHlhXoQ3Fx1CjwuUY4SVB8KC6vqCV_ANqx-qaGG1hFco_hNdHc9X8-W86qW8ZT44FhK-14oI1VbxoLwZm9QUxZZYzt99yPkIz37ByPbew9l-TL7uQ4jV6lrGzwpO3vja7aNmpv3TbW7gx92oQgt1QX2z0kGtpqT74bKfKwow [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwMzg4NDQsImV4cCI6MTczNTA0MDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.DsootyVoEdcR7HrY2E5tdslmiQq7LnmyT9gwUvOUFfJ2_LvWqdll9shSSTEkNS5ukwL3YgRGgNImwqUzIavIBI1itcLf-dPJb2VqaE3zvnfaFvdcYhf2vWCcdJdRXNe6j1rqQ-5l40pXfDCCi0TSX8xx760tHZgouXvMAL-HX8vqR2-Fmgpq7g9rmQhmcu0yDBjCtJbtTjWY_6QTFvKmYYTOfoKSrXzmsqsh7f8CO_ovc0MALZ92BSy5D9NEzydDY-ZqlFpgeIIJwQO4VAqQoVUBXXM3mPa94L9f8L0lO4JqI_WOh07fLp06oPUz3Nni-yCqB083PaoJEMP3m6nVEg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => NFgRqJJj2HBZ1rp4a-s1j6y9MZoj8zsRLndYTFs31b4 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-23 00:00:00 [2024-12-24 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,23) [2024-12-24 06:14:07] Production.INFO: Batch insert start [2024-12-24 06:14:07] Production.INFO: global counter1 [2024-12-24 06:14:07] Production.INFO: insertion start [2024-12-24 06:14:07] Production.INFO: last batch insert 1 [2024-12-24 06:14:07] Production.INFO: insertion end [2024-12-24 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2f82f590-c1e8-11ef-890f-9b8b7d80f099') start [2024-12-24 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('2f82f590-c1e8-11ef-890f-9b8b7d80f099') end [2024-12-24 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-24 06:14:07] Production.INFO: 2 [2024-12-24 06:14:07] Production.ERROR: CronJobId end14 [2024-12-24 06:14:07] Production.INFO: ==17006== Releasing lock... [2024-12-24 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-24 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-24 12:14:03] Production.INFO: -- Xero Api Check -- [2024-12-24 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.946297 [namelookup_time] => 0.280223 [connect_time] => 0.291176 [pretransfer_time] => 0.613139 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2911 [speed_upload] => 86 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.946229 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 42864 ) [2024-12-24 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwNjA0NDQsImV4cCI6MTczNTA2MDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDYwNDQ0LCJhdF9oYXNoIjoiSkZGb1p4X0JTbUl1aTBVUkRyUFE2dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.RXIanYclAGkon7iLNNYhsZYXR78xmqcOPd1Ix-WTlA88PjK2z_y9ixtoj9DvsHb6vrt2_zQ2WEiSv2Vidb6v6KqxMqkh3ZCJoGgC99rqOPPeUdYueBpk-8MEEV6n_KKbEY8oHLAvwWyM4_gjqx7nZL1EtYtySo10vKuFdYMZLJyklRXjgKKTpYweNBAfQS_MLAQ_hATOAb8qG68xR3auBcnQU9NwVP8SP9P7vqH1woukU2lr_I_fd1-sa8UYqcT9sx0Mf2DhL1BrDRzhruyLYfnCv28vVTCSIyBT_Bm8t7DIzUblGrbeQr_8bbmmqTPh0GOJ7WiC6n-iH3Nk-_9LNQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwNjA0NDQsImV4cCI6MTczNTA2MjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.NS4LOblf04Mf8a35QeL5EaTTc8MnuKkinnYxFc0K3fIfi6gf0JKaVVqmURMKEnN149HCDROnN9iBAyD_seMfIa2jTBwwecKYSURCAisi6xR9PIlzMKQSsvYE_GIIoKHWxv_qGk_3I3NXzkuTw8FG7KnW_oEnLMy_q68PAXrt5ueqiEfAeWp4_uKbw8bBIq3LNa3uLAFBSAISk_BmvM6Uz7AEOKh9b6OWI8jVaVO_yiMvgfDgh0QwWI1t3eKvcovsgyO24HEdrv8aHXXn_78noAXuEdFEyHc75rQkwq60_XVFvpgEJOP6KjKk79JIql1CUhaA5gR-01uzO-RWO6KZ-w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 2Dt12-Cg7mrZQjWpsYUWfU95-9LIUwzTQgkLcPxlZDU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwNjA0NDQsImV4cCI6MTczNTA2MDc0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDYwNDQ0LCJhdF9oYXNoIjoiSkZGb1p4X0JTbUl1aTBVUkRyUFE2dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.RXIanYclAGkon7iLNNYhsZYXR78xmqcOPd1Ix-WTlA88PjK2z_y9ixtoj9DvsHb6vrt2_zQ2WEiSv2Vidb6v6KqxMqkh3ZCJoGgC99rqOPPeUdYueBpk-8MEEV6n_KKbEY8oHLAvwWyM4_gjqx7nZL1EtYtySo10vKuFdYMZLJyklRXjgKKTpYweNBAfQS_MLAQ_hATOAb8qG68xR3auBcnQU9NwVP8SP9P7vqH1woukU2lr_I_fd1-sa8UYqcT9sx0Mf2DhL1BrDRzhruyLYfnCv28vVTCSIyBT_Bm8t7DIzUblGrbeQr_8bbmmqTPh0GOJ7WiC6n-iH3Nk-_9LNQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwNjA0NDQsImV4cCI6MTczNTA2MjI0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.NS4LOblf04Mf8a35QeL5EaTTc8MnuKkinnYxFc0K3fIfi6gf0JKaVVqmURMKEnN149HCDROnN9iBAyD_seMfIa2jTBwwecKYSURCAisi6xR9PIlzMKQSsvYE_GIIoKHWxv_qGk_3I3NXzkuTw8FG7KnW_oEnLMy_q68PAXrt5ueqiEfAeWp4_uKbw8bBIq3LNa3uLAFBSAISk_BmvM6Uz7AEOKh9b6OWI8jVaVO_yiMvgfDgh0QwWI1t3eKvcovsgyO24HEdrv8aHXXn_78noAXuEdFEyHc75rQkwq60_XVFvpgEJOP6KjKk79JIql1CUhaA5gR-01uzO-RWO6KZ-w [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 2Dt12-Cg7mrZQjWpsYUWfU95-9LIUwzTQgkLcPxlZDU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 12:14:04] Production.ERROR: Invoice Payment Date 2024-12-23 00:00:00 [2024-12-24 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,23) [2024-12-24 12:14:07] Production.INFO: Batch insert start [2024-12-24 12:14:07] Production.INFO: global counter1 [2024-12-24 12:14:07] Production.INFO: insertion start [2024-12-24 12:14:07] Production.INFO: last batch insert 1 [2024-12-24 12:14:07] Production.INFO: insertion end [2024-12-24 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('7a150db0-c21a-11ef-b33f-23a66e57ebf4') start [2024-12-24 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('7a150db0-c21a-11ef-b33f-23a66e57ebf4') end [2024-12-24 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-24 12:14:07] Production.INFO: 2 [2024-12-24 12:14:08] Production.ERROR: CronJobId end14 [2024-12-24 12:14:08] Production.INFO: ==16510== Releasing lock... [2024-12-24 12:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-24 12:14:08] Production.INFO: 26 MB #Memory Used# [2024-12-24 18:14:04] Production.INFO: -- Xero Api Check -- [2024-12-24 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] => 854 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.727001 [namelookup_time] => 0.281764 [connect_time] => 0.292751 [pretransfer_time] => 0.612226 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3789 [speed_upload] => 112 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.726949 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 44306 ) [2024-12-24 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwODIwNDQsImV4cCI6MTczNTA4MjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDgyMDQ0LCJhdF9oYXNoIjoiVHpiRmNzTGNTS01URm5lZjY1ZjlwdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.e1CTooRlLJ8IB_-ZmnbikqSopzFG4V9tZflbkD7uZiQHMzN7-8329zLxmZLALrnrBnqaAYBPXIE4C9EeMgk98Iyg9jC4zzAZDXhOJ9iqDcVpcD1w6uM4wmKSXZDuJpTDQeDv41va4Dq2tgI2_n6kZWM4T9wBjXo3UNoTGtnyRyJYud-UxlKma5zn8_o6xbGWvcgotl3IAZ_gPdGToAaWFDjKR5joEgEhMXpj54MJWqzevLZhNPjDAeC7eXMbF3HxO43qawm0ho9qR0xJhUusiH4HuVvMvZlJWWlXe8JifKx5m58G06QFoXrrlz6Qz1HduBzf8nCjQuKNOovuU6MB2Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwODIwNDQsImV4cCI6MTczNTA4Mzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.AK_q2wNDKljSO6QKI-niUL2rbtH0d4nNGX2SgGiihSXMlz7ph9eG_OzAB6ukDDp-7etQsusgy0Td96y9WV3qDl6DacVPpPlDifwVCnw1OsGGn_uLvMql3uW1CIQwTLkVuB4SsCsH7x6bJqAW1qjKTZdiyS6T5zpQeHIfZuVmHMpP9KFerVdtIwpXHuB-TeSuQ0-z88KaJlGcExn4u-hTLdxeCr8VbGZWUosB3E2T3mxrHFnHlHE8MOj_nAxj3UhDDO_YjutcRakDorm6yhFxWVNYaUlSOtrCFmjUsc227pz3xAVFBKewp-nS9ecVQV5fVoxu9uIWTK8woh6srKVW1g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => k7dnxrML4VPpgcTmPnN883W5sbmi6MauQwLk7YeoXHg [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwODIwNDQsImV4cCI6MTczNTA4MjM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MDgyMDQ0LCJhdF9oYXNoIjoiVHpiRmNzTGNTS01URm5lZjY1ZjlwdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.e1CTooRlLJ8IB_-ZmnbikqSopzFG4V9tZflbkD7uZiQHMzN7-8329zLxmZLALrnrBnqaAYBPXIE4C9EeMgk98Iyg9jC4zzAZDXhOJ9iqDcVpcD1w6uM4wmKSXZDuJpTDQeDv41va4Dq2tgI2_n6kZWM4T9wBjXo3UNoTGtnyRyJYud-UxlKma5zn8_o6xbGWvcgotl3IAZ_gPdGToAaWFDjKR5joEgEhMXpj54MJWqzevLZhNPjDAeC7eXMbF3HxO43qawm0ho9qR0xJhUusiH4HuVvMvZlJWWlXe8JifKx5m58G06QFoXrrlz6Qz1HduBzf8nCjQuKNOovuU6MB2Q [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUwODIwNDQsImV4cCI6MTczNTA4Mzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.AK_q2wNDKljSO6QKI-niUL2rbtH0d4nNGX2SgGiihSXMlz7ph9eG_OzAB6ukDDp-7etQsusgy0Td96y9WV3qDl6DacVPpPlDifwVCnw1OsGGn_uLvMql3uW1CIQwTLkVuB4SsCsH7x6bJqAW1qjKTZdiyS6T5zpQeHIfZuVmHMpP9KFerVdtIwpXHuB-TeSuQ0-z88KaJlGcExn4u-hTLdxeCr8VbGZWUosB3E2T3mxrHFnHlHE8MOj_nAxj3UhDDO_YjutcRakDorm6yhFxWVNYaUlSOtrCFmjUsc227pz3xAVFBKewp-nS9ecVQV5fVoxu9uIWTK8woh6srKVW1g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => k7dnxrML4VPpgcTmPnN883W5sbmi6MauQwLk7YeoXHg [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-24 18:14:04] Production.ERROR: Invoice Payment Date 2024-12-23 00:00:00 [2024-12-24 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,23) [2024-12-24 18:14:08] Production.INFO: Batch insert start [2024-12-24 18:14:08] Production.INFO: global counter1 [2024-12-24 18:14:08] Production.INFO: insertion start [2024-12-24 18:14:08] Production.INFO: last batch insert 1 [2024-12-24 18:14:08] Production.INFO: insertion end [2024-12-24 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('c4db07a0-c24c-11ef-a59b-db2bfa666334') start [2024-12-24 18:14:08] Production.INFO: CALL prc_importPaymentAccounting ('c4db07a0-c24c-11ef-a59b-db2bfa666334') end [2024-12-24 18:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-24 18:14:08] Production.INFO: 2 [2024-12-24 18:14:08] Production.ERROR: CronJobId end14 [2024-12-24 18:14:08] Production.INFO: ==14361== Releasing lock... [2024-12-24 18:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-24 18:14:08] Production.INFO: 26 MB #Memory Used#