[2024-12-28 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-28 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.811924 [namelookup_time] => 0.281398 [connect_time] => 0.292267 [pretransfer_time] => 0.507496 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3393 [speed_upload] => 100 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.811859 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 35330 ) [2024-12-28 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzNjI4NDQsImV4cCI6MTczNTM2MzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MzYyODQ0LCJhdF9oYXNoIjoiY3RNV3RLZ3F1d2h1bTdqZE9pRFVqUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.PGhOi09CP9pPV8p8l15Qy2OL8Y_2bSXpphsRWEfkHyu67h-ZlKgxknp7RFZ7YpQExm11kcWkGb6a-pbD7pVfjVGuToBI_ENQRCbyDp0wVvJjYPjLA9fRBUmF-fj5Wz8jf6RNJ0qkpky2gwLTR-Ob7DGTpDLaff9TBY5IIQSUcLHZP3qBQyckLjwAmVhNzOJ6SUV71bTw4dkHtPekCLBWE5D3JYET-e0Be9k2Co7nn2gflfrqZLBZpZN_qZp1ractGroI6VX6heKZlSPIwAjsOYkF9BTzPFuLfVIp7OpV_scpi2EXZxUbwqGj6V8APx0IHdKYkmwc_i902dcpC0HgTA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzNjI4NDQsImV4cCI6MTczNTM2NDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.yqSE_jCAA-_2qJoVXIe5NAD2yGxeBE0fn2u6THlsX9uT8dL8QEneoEbI3Mb2iQe-XzUG5aCDZSAz__-EObdUrWGiKxwsXT0Zs31keoumgz11VgrmouuCwhMA4EY1SAjVs579bisGNhUeRWR4UvHdgCD2bBlWgU2Ou7gMxytSLLERClAmgwk3s5zsNScAKB4vIecGBLesyQHixvXCUcCOBYzoBEDGJCL0vT0_Zk5eUaXngnH-JnzCuQeRZE_xnZQbwhDJDfZDnd5vHP6lUQi9kmHkHrRkM70hLjs9dzzu2EZFlE1z32X9zkoGu61HHidh2B-rxhccCUbX7Cs8RwyWwg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => _CHEsF9kpT7HqAI4k0tPbClnDqqolmWz37Pem3u5KTs [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzNjI4NDQsImV4cCI6MTczNTM2MzE0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1MzYyODQ0LCJhdF9oYXNoIjoiY3RNV3RLZ3F1d2h1bTdqZE9pRFVqUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.PGhOi09CP9pPV8p8l15Qy2OL8Y_2bSXpphsRWEfkHyu67h-ZlKgxknp7RFZ7YpQExm11kcWkGb6a-pbD7pVfjVGuToBI_ENQRCbyDp0wVvJjYPjLA9fRBUmF-fj5Wz8jf6RNJ0qkpky2gwLTR-Ob7DGTpDLaff9TBY5IIQSUcLHZP3qBQyckLjwAmVhNzOJ6SUV71bTw4dkHtPekCLBWE5D3JYET-e0Be9k2Co7nn2gflfrqZLBZpZN_qZp1ractGroI6VX6heKZlSPIwAjsOYkF9BTzPFuLfVIp7OpV_scpi2EXZxUbwqGj6V8APx0IHdKYkmwc_i902dcpC0HgTA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzNjI4NDQsImV4cCI6MTczNTM2NDY0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.yqSE_jCAA-_2qJoVXIe5NAD2yGxeBE0fn2u6THlsX9uT8dL8QEneoEbI3Mb2iQe-XzUG5aCDZSAz__-EObdUrWGiKxwsXT0Zs31keoumgz11VgrmouuCwhMA4EY1SAjVs579bisGNhUeRWR4UvHdgCD2bBlWgU2Ou7gMxytSLLERClAmgwk3s5zsNScAKB4vIecGBLesyQHixvXCUcCOBYzoBEDGJCL0vT0_Zk5eUaXngnH-JnzCuQeRZE_xnZQbwhDJDfZDnd5vHP6lUQi9kmHkHrRkM70hLjs9dzzu2EZFlE1z32X9zkoGu61HHidh2B-rxhccCUbX7Cs8RwyWwg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => _CHEsF9kpT7HqAI4k0tPbClnDqqolmWz37Pem3u5KTs [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-27 00:00:00 [2024-12-28 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,27) [2024-12-28 00:14:07] Production.INFO: Batch insert start [2024-12-28 00:14:07] Production.INFO: global counter1 [2024-12-28 00:14:07] Production.INFO: insertion start [2024-12-28 00:14:07] Production.INFO: last batch insert 1 [2024-12-28 00:14:07] Production.INFO: insertion end [2024-12-28 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('8e6823e0-c4da-11ef-998c-5bb899009e57') start [2024-12-28 00:14:07] Production.INFO: CALL prc_importPaymentAccounting ('8e6823e0-c4da-11ef-998c-5bb899009e57') end [2024-12-28 00:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-28 00:14:07] Production.INFO: 2 [2024-12-28 00:14:07] Production.ERROR: CronJobId end14 [2024-12-28 00:14:07] Production.INFO: ==13225== Releasing lock... [2024-12-28 00:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-28 00:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-28 06:14:04] Production.INFO: -- Xero Api Check -- [2024-12-28 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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.637298 [namelookup_time] => 0.281102 [connect_time] => 0.291313 [pretransfer_time] => 0.51659 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4322 [speed_upload] => 128 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.637236 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 36824 ) [2024-12-28 06:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzODQ0NDUsImV4cCI6MTczNTM4NDc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1Mzg0NDQ1LCJhdF9oYXNoIjoiYXZERVFkSXYwdXBXdDczS3lFaVdyZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.hEMlIWjL4NtklZuOqAhilvnOPzVomsBQ7ExLc3TCzUTUiKpe9Qj3foFh5cN0sMsWSevu25A6tPsSTp0Y9pk2H_vzIlfIZi-2deRc__SXhFihsVaeOgizZwNIfl8R0Ixj_kgNSziejhVS3h2f0pDNrTPf3Cs7qkXKpx6naxxUx0KA_g6LkcWkFAGzUsMEvzC51-RDRz2RlsSdsJVNJV7nzDJLZfTBo2e5SzOaa91GXC9GmUf6pz8mFH5m9uciyZurjHSQSf9LGP_3xflcAycKMkoejw3CLVGmB1-Lg8Puwcg6xVraUbV_Zyi9Z7uuo5PMfBvuTpJcbI5l5RgOfif3jg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzODQ0NDUsImV4cCI6MTczNTM4NjI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.PaY2If6VyHFfAljnVpWxZllWekMvzwCMMNxyeAp1rDAqJTtxjbmxGvpV6Rk1FlPyuBDV8n8CgyQfXvGRZa-aWPWoI2XneQoRA75T8ovcfeyJ9-3NKJ7BCTqrvslE2mJ1LOV_rAfXp-9t2GEQNgPsp6V_9ST41DIwo4ly6RZhslbGI-g9jXcJOALUdsZtKU-lseNnDT34svHjqL-68kY9gWwHTIs7y62XeYKQHJgNzt2WW1og7YDXKiKDlbXBJpu_NjKTW7X8cGljTt4IZnZATxYCJJN9FD7TQ6a6tq4OSC6j_55PM08zSj8Za0ysosdrnyeaEhMuQW8dLf6KUTLoiQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 8GiLPqvHlOLxQ2HadVihMbiOyBv1UQsh_gkR7AFbHAU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 06:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzODQ0NDUsImV4cCI6MTczNTM4NDc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1Mzg0NDQ1LCJhdF9oYXNoIjoiYXZERVFkSXYwdXBXdDczS3lFaVdyZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.hEMlIWjL4NtklZuOqAhilvnOPzVomsBQ7ExLc3TCzUTUiKpe9Qj3foFh5cN0sMsWSevu25A6tPsSTp0Y9pk2H_vzIlfIZi-2deRc__SXhFihsVaeOgizZwNIfl8R0Ixj_kgNSziejhVS3h2f0pDNrTPf3Cs7qkXKpx6naxxUx0KA_g6LkcWkFAGzUsMEvzC51-RDRz2RlsSdsJVNJV7nzDJLZfTBo2e5SzOaa91GXC9GmUf6pz8mFH5m9uciyZurjHSQSf9LGP_3xflcAycKMkoejw3CLVGmB1-Lg8Puwcg6xVraUbV_Zyi9Z7uuo5PMfBvuTpJcbI5l5RgOfif3jg [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzUzODQ0NDUsImV4cCI6MTczNTM4NjI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.PaY2If6VyHFfAljnVpWxZllWekMvzwCMMNxyeAp1rDAqJTtxjbmxGvpV6Rk1FlPyuBDV8n8CgyQfXvGRZa-aWPWoI2XneQoRA75T8ovcfeyJ9-3NKJ7BCTqrvslE2mJ1LOV_rAfXp-9t2GEQNgPsp6V_9ST41DIwo4ly6RZhslbGI-g9jXcJOALUdsZtKU-lseNnDT34svHjqL-68kY9gWwHTIs7y62XeYKQHJgNzt2WW1og7YDXKiKDlbXBJpu_NjKTW7X8cGljTt4IZnZATxYCJJN9FD7TQ6a6tq4OSC6j_55PM08zSj8Za0ysosdrnyeaEhMuQW8dLf6KUTLoiQ [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 8GiLPqvHlOLxQ2HadVihMbiOyBv1UQsh_gkR7AFbHAU [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 06:14:05] Production.ERROR: Invoice Payment Date 2024-12-27 00:00:00 [2024-12-28 06:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,27) [2024-12-28 06:14:07] Production.INFO: Batch insert start [2024-12-28 06:14:07] Production.INFO: global counter1 [2024-12-28 06:14:07] Production.INFO: insertion start [2024-12-28 06:14:07] Production.INFO: last batch insert 1 [2024-12-28 06:14:08] Production.INFO: insertion end [2024-12-28 06:14:08] Production.INFO: CALL prc_importPaymentAccounting ('d993b010-c50c-11ef-9c30-b515397bef3c') start [2024-12-28 06:14:08] Production.INFO: CALL prc_importPaymentAccounting ('d993b010-c50c-11ef-9c30-b515397bef3c') end [2024-12-28 06:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-28 06:14:08] Production.INFO: 2 [2024-12-28 06:14:08] Production.ERROR: CronJobId end14 [2024-12-28 06:14:08] Production.INFO: ==14471== Releasing lock... [2024-12-28 06:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-28 06:14:08] Production.INFO: 26 MB #Memory Used# [2024-12-28 12:14:03] Production.INFO: -- Xero Api Check -- [2024-12-28 12:14:05] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.254348 [namelookup_time] => 0.514243 [connect_time] => 0.525251 [pretransfer_time] => 0.893437 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2196 [speed_upload] => 65 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.254298 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 38294 ) [2024-12-28 12:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0MDYwNDUsImV4cCI6MTczNTQwNjM0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1NDA2MDQ1LCJhdF9oYXNoIjoiaFdkbVVWMVZEV0dmRlU5Y2NOT1hMZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.PB1h-7cuX9AuvElHeytrkV5if5eXSsdUbltIvlawaTAikN_eYaW2DKVBgCCboSThI2btfJt6ZSnfd0lpr5DiAYgRoE_KyzzLCOSgt7cljJll_a1QoTdrrd7UD_gm527nzkfNjEN0yz2VB7St3pbovYU4Z58JNZ9R0Auks3CMxPpdIKgPzVqJh3AhqVI6b0RgLnyR_GftIicyam3NK9N59mGzCw3uRtfsaGJhgOTTp77rMLlWResNqmsKN3JQZHn15a2TTo9nxixpa98LJPnoZg5q4wmvt1xZ82UruWY1y_2jAMNMrN4oaPw9AtB2CGymRtM9K_2O4LPZA2NKQUgTFA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0MDYwNDQsImV4cCI6MTczNTQwNzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.hecf7_m44GnHt--nxhyRg0y6BRErKbB3Et_6I7R_A8qZ2UP_AU1eHGx758cOkIGgDw1wl9AxIS7fO13husRcN1nY88Ksk0iD6pQ1nNMzPIZ4gM-Y670b3y7Pvt8mHDSXKJwQGkymf5XBjoKHQGnFCWdO4kI4xaNMt6am9u6KLmLIyiDxxcJe3alOJQMajtoe_KSAi8h54djAo4QXWV7uoRBoDrzlZsj41PioS673-YW0ibbSJiqgGq866c21JcDjSIsNV9hF23X_nwlwNXXVveOL6v0PU6ideksBDmH3h5KL4NxHGdVp4hUjixeF4K53N3yCr0oWGp3odgz_-ZqU-g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => UgLe8zYZC4jbhbEX2dw5tlHdAh6-8uglNjvaon4QEu8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 12:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0MDYwNDUsImV4cCI6MTczNTQwNjM0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1NDA2MDQ1LCJhdF9oYXNoIjoiaFdkbVVWMVZEV0dmRlU5Y2NOT1hMZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.PB1h-7cuX9AuvElHeytrkV5if5eXSsdUbltIvlawaTAikN_eYaW2DKVBgCCboSThI2btfJt6ZSnfd0lpr5DiAYgRoE_KyzzLCOSgt7cljJll_a1QoTdrrd7UD_gm527nzkfNjEN0yz2VB7St3pbovYU4Z58JNZ9R0Auks3CMxPpdIKgPzVqJh3AhqVI6b0RgLnyR_GftIicyam3NK9N59mGzCw3uRtfsaGJhgOTTp77rMLlWResNqmsKN3JQZHn15a2TTo9nxixpa98LJPnoZg5q4wmvt1xZ82UruWY1y_2jAMNMrN4oaPw9AtB2CGymRtM9K_2O4LPZA2NKQUgTFA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0MDYwNDQsImV4cCI6MTczNTQwNzg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.hecf7_m44GnHt--nxhyRg0y6BRErKbB3Et_6I7R_A8qZ2UP_AU1eHGx758cOkIGgDw1wl9AxIS7fO13husRcN1nY88Ksk0iD6pQ1nNMzPIZ4gM-Y670b3y7Pvt8mHDSXKJwQGkymf5XBjoKHQGnFCWdO4kI4xaNMt6am9u6KLmLIyiDxxcJe3alOJQMajtoe_KSAi8h54djAo4QXWV7uoRBoDrzlZsj41PioS673-YW0ibbSJiqgGq866c21JcDjSIsNV9hF23X_nwlwNXXVveOL6v0PU6ideksBDmH3h5KL4NxHGdVp4hUjixeF4K53N3yCr0oWGp3odgz_-ZqU-g [expires_in] => 1800 [token_type] => Bearer [refresh_token] => UgLe8zYZC4jbhbEX2dw5tlHdAh6-8uglNjvaon4QEu8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 12:14:05] Production.ERROR: Invoice Payment Date 2024-12-27 00:00:00 [2024-12-28 12:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,27) [2024-12-28 12:14:08] Production.INFO: Batch insert start [2024-12-28 12:14:08] Production.INFO: global counter1 [2024-12-28 12:14:08] Production.INFO: insertion start [2024-12-28 12:14:08] Production.INFO: last batch insert 1 [2024-12-28 12:14:08] Production.INFO: insertion end [2024-12-28 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('242ed9e0-c53f-11ef-b855-ab2c60a0bafd') start [2024-12-28 12:14:08] Production.INFO: CALL prc_importPaymentAccounting ('242ed9e0-c53f-11ef-b855-ab2c60a0bafd') end [2024-12-28 12:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-28 12:14:08] Production.INFO: 2 [2024-12-28 12:14:08] Production.ERROR: CronJobId end14 [2024-12-28 12:14:08] Production.INFO: ==12009== Releasing lock... [2024-12-28 12:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-28 12:14:08] Production.INFO: 26 MB #Memory Used# [2024-12-28 18:14:03] Production.INFO: -- Xero Api Check -- [2024-12-28 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.622152 [namelookup_time] => 0.287226 [connect_time] => 0.298058 [pretransfer_time] => 0.517983 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4428 [speed_upload] => 131 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.622076 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 41912 ) [2024-12-28 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0Mjc2NDQsImV4cCI6MTczNTQyNzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1NDI3NjQ0LCJhdF9oYXNoIjoiTW9LYmlwVGFIQUxKX1hZbUhFbzgyUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.vcRuxArSJLxoAetLyL3M4GuMBqWhYc-5CdW-O-4ReeAS85nT1bH7SPu5QRv9-OW46PYmod2hIqswfcIrOAiBdnXuCPp_2CAT8r-NmfBmQLdH4AkrlfdSRssq0nwVgr-M9PWSFx2kHWqhmhCf7OAyHyAEWNPePgt4tOIPUT5rNYalULvGc6kEXcRUyFswVpaSjD0mUm8w9VNjrpxreLJt8pT02yvTBZUn34CpdT1vpz1q5nFYW3SSNR8hWsGhVicvjnsWB8EwvMsPl34Ut_sKExHLjpcLX8eizKavJyzYwm_sGFucFHYvPj85FfSENs4StvbX4nDfM58AkJFm8rZZAA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0Mjc2NDQsImV4cCI6MTczNTQyOTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.KwLvckrmpLfffHjX58QLE4-e73-nM0X5lrWJqWv3nkXa7vl8J-lERnxnOVfBz2YXu1Q89xCiYbe-9pR1GMFYOpj7b_i7zyNiXSTcjj-dLGTC_7BTsnZk1JZuW5fE5knPXfZA2O3SxG_U1kmIAWGFhWoo-4TQprp4FzqbIl9eUOZ3URQtJJrQDKH9cylVASgi2PnJ3H3IRGXaIOw_wS-wa9jMy60LarZJ2nJMZB7xJDXFUoluce7CtrO2gAYmH-5NtbU_VDOwxf9Gass2VXkL2tSCQUxCUlp5wgcK4__8BcHW1JRiHF9DKH007b50OSZzG1bpZQhlEXBpjtTc5E8x3A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => DgAj1ZorAbXI2xx6h4rC9-ErJugW_f0kmle6hJ2VWLw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0Mjc2NDQsImV4cCI6MTczNTQyNzk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM1NDI3NjQ0LCJhdF9oYXNoIjoiTW9LYmlwVGFIQUxKX1hZbUhFbzgyUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.vcRuxArSJLxoAetLyL3M4GuMBqWhYc-5CdW-O-4ReeAS85nT1bH7SPu5QRv9-OW46PYmod2hIqswfcIrOAiBdnXuCPp_2CAT8r-NmfBmQLdH4AkrlfdSRssq0nwVgr-M9PWSFx2kHWqhmhCf7OAyHyAEWNPePgt4tOIPUT5rNYalULvGc6kEXcRUyFswVpaSjD0mUm8w9VNjrpxreLJt8pT02yvTBZUn34CpdT1vpz1q5nFYW3SSNR8hWsGhVicvjnsWB8EwvMsPl34Ut_sKExHLjpcLX8eizKavJyzYwm_sGFucFHYvPj85FfSENs4StvbX4nDfM58AkJFm8rZZAA [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzU0Mjc2NDQsImV4cCI6MTczNTQyOTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.KwLvckrmpLfffHjX58QLE4-e73-nM0X5lrWJqWv3nkXa7vl8J-lERnxnOVfBz2YXu1Q89xCiYbe-9pR1GMFYOpj7b_i7zyNiXSTcjj-dLGTC_7BTsnZk1JZuW5fE5knPXfZA2O3SxG_U1kmIAWGFhWoo-4TQprp4FzqbIl9eUOZ3URQtJJrQDKH9cylVASgi2PnJ3H3IRGXaIOw_wS-wa9jMy60LarZJ2nJMZB7xJDXFUoluce7CtrO2gAYmH-5NtbU_VDOwxf9Gass2VXkL2tSCQUxCUlp5wgcK4__8BcHW1JRiHF9DKH007b50OSZzG1bpZQhlEXBpjtTc5E8x3A [expires_in] => 1800 [token_type] => Bearer [refresh_token] => DgAj1ZorAbXI2xx6h4rC9-ErJugW_f0kmle6hJ2VWLw [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-28 18:14:04] Production.ERROR: Invoice Payment Date 2024-12-27 00:00:00 [2024-12-28 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,27) [2024-12-28 18:14:07] Production.INFO: Batch insert start [2024-12-28 18:14:07] Production.INFO: global counter1 [2024-12-28 18:14:07] Production.INFO: insertion start [2024-12-28 18:14:07] Production.INFO: last batch insert 1 [2024-12-28 18:14:07] Production.INFO: insertion end [2024-12-28 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('6e5de5c0-c571-11ef-9212-e9fbbd09b99c') start [2024-12-28 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('6e5de5c0-c571-11ef-9212-e9fbbd09b99c') end [2024-12-28 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-28 18:14:07] Production.INFO: 2 [2024-12-28 18:14:07] Production.ERROR: CronJobId end14 [2024-12-28 18:14:07] Production.INFO: ==12221== Releasing lock... [2024-12-28 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-28 18:14:07] Production.INFO: 26 MB #Memory Used#