[2024-12-21 00:14:03] Production.INFO: -- Xero Api Check -- [2024-12-21 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] => 858 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.87337 [namelookup_time] => 0.150526 [connect_time] => 0.16153 [pretransfer_time] => 0.481458 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3154 [speed_upload] => 93 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.87331 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 50424 ) [2024-12-21 00:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3NTgwNDQsImV4cCI6MTczNDc1ODM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NzU4MDQ0LCJhdF9oYXNoIjoiaUdocjBidUFuTTJMdTJmeEI2SE5uQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.rGTF7vw8Ej-QNJfjqr_caeNXWf0mlxX777PLtxjtVAOtwCrJB1Id-RKw0bem2u1h7iRqDciPMSRTd4lewvBBJ5JSNgMWt4DvWZdNjfpbItI6w8DwjEek5KSiNmDdCB6neIlpzhnHzDsrcI3-NAv5f77-S7nZ11tsJnXx6oKem1BpcERvWLKWfcW9uybzyttQihP7PPDSRNOTpk6LI2MERMtjRe4bp3vkzNS45dYnMlTWAeuQMFHLfSG5glU_qK6-WmTXIZqyEIhcbDZRSRMkKJSQ0b3_YuGyw06R8fRet0N9PEpMUAy9HRwKPNCAAdMQ9bW4zxCXBG2KCBArhb77Fw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3NTgwNDQsImV4cCI6MTczNDc1OTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.R-yWM5hn3WHusOo6faEkCGRo6kxTrBnHYYU-yIHsJttyW1Abqa6eamagi6nrRCnOsbOiXnmYVqYLw1o41v0eb9kYCOxq-U1kxQ7mqiutY68K7aahGhnT3IpvouzRkxpHekHDZdY_AaxJaeG6y3AF1_vdahPhiBn6cZo6U3oJbgADzRSsHnDvrNrPDq8XrSCqoEvsNcg-vB5azoHo4duyAmStgs0rxi73fwZ8tOVAfNQDHfAMwHACQqHCqF-StedshQsyoxVmWn6sgeoA7zwHB705hIeDRnDk8lH8j0xCEyTSyPykkplZ03uOjP4iYn_WAYjCkmIR1gVynQNalm_7tA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => gkWsY3QcOabKREGqhUDK4QolQdovgESXA1E6ZTGZQL8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 00:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3NTgwNDQsImV4cCI6MTczNDc1ODM0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0NzU4MDQ0LCJhdF9oYXNoIjoiaUdocjBidUFuTTJMdTJmeEI2SE5uQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.rGTF7vw8Ej-QNJfjqr_caeNXWf0mlxX777PLtxjtVAOtwCrJB1Id-RKw0bem2u1h7iRqDciPMSRTd4lewvBBJ5JSNgMWt4DvWZdNjfpbItI6w8DwjEek5KSiNmDdCB6neIlpzhnHzDsrcI3-NAv5f77-S7nZ11tsJnXx6oKem1BpcERvWLKWfcW9uybzyttQihP7PPDSRNOTpk6LI2MERMtjRe4bp3vkzNS45dYnMlTWAeuQMFHLfSG5glU_qK6-WmTXIZqyEIhcbDZRSRMkKJSQ0b3_YuGyw06R8fRet0N9PEpMUAy9HRwKPNCAAdMQ9bW4zxCXBG2KCBArhb77Fw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3NTgwNDQsImV4cCI6MTczNDc1OTg0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.R-yWM5hn3WHusOo6faEkCGRo6kxTrBnHYYU-yIHsJttyW1Abqa6eamagi6nrRCnOsbOiXnmYVqYLw1o41v0eb9kYCOxq-U1kxQ7mqiutY68K7aahGhnT3IpvouzRkxpHekHDZdY_AaxJaeG6y3AF1_vdahPhiBn6cZo6U3oJbgADzRSsHnDvrNrPDq8XrSCqoEvsNcg-vB5azoHo4duyAmStgs0rxi73fwZ8tOVAfNQDHfAMwHACQqHCqF-StedshQsyoxVmWn6sgeoA7zwHB705hIeDRnDk8lH8j0xCEyTSyPykkplZ03uOjP4iYn_WAYjCkmIR1gVynQNalm_7tA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => gkWsY3QcOabKREGqhUDK4QolQdovgESXA1E6ZTGZQL8 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 00:14:04] Production.ERROR: Invoice Payment Date 2024-12-20 00:00:00 [2024-12-21 00:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,20) [2024-12-21 00:14:06] Production.INFO: Batch insert start [2024-12-21 00:14:06] Production.INFO: global counter1 [2024-12-21 00:14:06] Production.INFO: insertion start [2024-12-21 00:14:06] Production.INFO: last batch insert 1 [2024-12-21 00:14:06] Production.INFO: insertion end [2024-12-21 00:14:06] Production.INFO: CALL prc_importPaymentAccounting ('657ee080-bf5a-11ef-b2b0-d957265db688') start [2024-12-21 00:14:06] Production.INFO: CALL prc_importPaymentAccounting ('657ee080-bf5a-11ef-b2b0-d957265db688') end [2024-12-21 00:14:06] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-21 00:14:06] Production.INFO: 2 [2024-12-21 00:14:06] Production.ERROR: CronJobId end14 [2024-12-21 00:14:06] Production.INFO: ==1679== Releasing lock... [2024-12-21 00:14:06] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-21 00:14:06] Production.INFO: 26 MB #Memory Used# [2024-12-21 06:14:03] Production.INFO: -- Xero Api Check -- [2024-12-21 06:14:04] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.505369 [namelookup_time] => 0.146695 [connect_time] => 0.159723 [pretransfer_time] => 0.384007 [size_upload] => 82 [size_download] => 2755 [speed_download] => 5451 [speed_upload] => 162 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.505324 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 51938 ) [2024-12-21 06:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3Nzk2NDQsImV4cCI6MTczNDc3OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0Nzc5NjQ0LCJhdF9oYXNoIjoiZDJkQUpoTzdEYklKQXRjYUlDWW5vUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.xGdtelR4lXkMMNINV_TEu7EWtaK8JfVlSS0PYSeWUCDz0I8BtP2EeIwhONl12Np0aJ78GuRv9EsNtcsei6gpUJaF6vVtCuhxLfsjX35YyfYRu7nHFcRcxKutUOor8nxNcI7uHz1PCc5TjqY-c8JqY8N64jpa2111dcwTuBpu7-U0NrZ7A1MT7NB-gzvE2jIp05ex0q9gT_aGUwck72UqVkLWFl5JSTNPKOqZJ8eGr5g56cqZcbTwF4TiZdcqlCGU0WFRCB8svjjXvEbUHQzGN6upr_FJym9Bz9XXolRrnIHtI7akTZizyg8Ix2Pmw2XTT_SrELWN41Q6aSsTIxQb0w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3Nzk2NDQsImV4cCI6MTczNDc4MTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.J7uIOiEeysP4IezRyzysCIDwD-zhsvx_vDwyeLP5L74hPVMoodTby161AInrf9rdLFrYiX7S3Thn4Gh9sSW-UfUzx7qKZiwO1JwEU1aE6S18IFLPmNDjz5QB7WMbyZDtigolWMTpV26uMCqXulw2lqAKq9AfIXnkwsZ4kQhvzko1J3mzgE6u6rBVynjD2M2FLHutxioVwNGD5ndo9Z400Z22cRYYOOUn5juCwsbH0-4q7eIL5WdwFNxWXSoAViqsDSBEeeiNH9izlLnhaPjxIy9Z7wLDOMHXrt9vgjFB0kkEEsyf3BaGq1jTiAdXz19IWEt1iqcKheW9axzZIJNMDg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 0AUXu-4hrmQJVoOJK7Nv63FtO_re6qgmniQTo_XGe9k [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 06:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3Nzk2NDQsImV4cCI6MTczNDc3OTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0Nzc5NjQ0LCJhdF9oYXNoIjoiZDJkQUpoTzdEYklKQXRjYUlDWW5vUSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.xGdtelR4lXkMMNINV_TEu7EWtaK8JfVlSS0PYSeWUCDz0I8BtP2EeIwhONl12Np0aJ78GuRv9EsNtcsei6gpUJaF6vVtCuhxLfsjX35YyfYRu7nHFcRcxKutUOor8nxNcI7uHz1PCc5TjqY-c8JqY8N64jpa2111dcwTuBpu7-U0NrZ7A1MT7NB-gzvE2jIp05ex0q9gT_aGUwck72UqVkLWFl5JSTNPKOqZJ8eGr5g56cqZcbTwF4TiZdcqlCGU0WFRCB8svjjXvEbUHQzGN6upr_FJym9Bz9XXolRrnIHtI7akTZizyg8Ix2Pmw2XTT_SrELWN41Q6aSsTIxQb0w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ3Nzk2NDQsImV4cCI6MTczNDc4MTQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.J7uIOiEeysP4IezRyzysCIDwD-zhsvx_vDwyeLP5L74hPVMoodTby161AInrf9rdLFrYiX7S3Thn4Gh9sSW-UfUzx7qKZiwO1JwEU1aE6S18IFLPmNDjz5QB7WMbyZDtigolWMTpV26uMCqXulw2lqAKq9AfIXnkwsZ4kQhvzko1J3mzgE6u6rBVynjD2M2FLHutxioVwNGD5ndo9Z400Z22cRYYOOUn5juCwsbH0-4q7eIL5WdwFNxWXSoAViqsDSBEeeiNH9izlLnhaPjxIy9Z7wLDOMHXrt9vgjFB0kkEEsyf3BaGq1jTiAdXz19IWEt1iqcKheW9axzZIJNMDg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => 0AUXu-4hrmQJVoOJK7Nv63FtO_re6qgmniQTo_XGe9k [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 06:14:04] Production.ERROR: Invoice Payment Date 2024-12-20 00:00:00 [2024-12-21 06:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,20) [2024-12-21 06:14:07] Production.INFO: Batch insert start [2024-12-21 06:14:07] Production.INFO: global counter1 [2024-12-21 06:14:07] Production.INFO: insertion start [2024-12-21 06:14:07] Production.INFO: last batch insert 1 [2024-12-21 06:14:07] Production.INFO: insertion end [2024-12-21 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('b037c390-bf8c-11ef-aad3-09347e715bd6') start [2024-12-21 06:14:07] Production.INFO: CALL prc_importPaymentAccounting ('b037c390-bf8c-11ef-aad3-09347e715bd6') end [2024-12-21 06:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-21 06:14:07] Production.INFO: 2 [2024-12-21 06:14:07] Production.ERROR: CronJobId end14 [2024-12-21 06:14:07] Production.INFO: ==32246== Releasing lock... [2024-12-21 06:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-21 06:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-21 12:14:03] Production.INFO: -- Xero Api Check -- [2024-12-21 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] => 855 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.644552 [namelookup_time] => 0.281733 [connect_time] => 0.285764 [pretransfer_time] => 0.517274 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4274 [speed_upload] => 127 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.644499 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.17 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 55510 ) [2024-12-21 12:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MDEyNDQsImV4cCI6MTczNDgwMTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODAxMjQ0LCJhdF9oYXNoIjoiaUtzUlJ4dmdzWkFQYzNvRVdPX1N2dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.uPLbb6xTsVEMuFKNmXMDQJJYcapnewdCT8EQ8zr8hK6sSBImtU5QfDFGzSOKVJLKjq0_MFNU9LwbYyyRo8nAx2IuZTOstBxtCNoXDWYzcFZkXK2mGqpwF2EXNBqTgLcfuvv4YbGTLmqB5dXePOj0Q-Mp9-2gRhhVdQoEVuA1UjIZhY0xeVYRv0VpC8ragpNmy0Whw2n3QHtk5EEH6JZhLCAZLrtIen1Qy-_yBsF8pOWjNqfROmp0hiecSHWLOpciIG8a4VIxBTPf4iUdDQRhTvZpVYIayeN1jcshrOP-HtzbVZhtUlBWdwJ97TcCzrREUiQcd6CXdsKM6kPHA8DsnQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MDEyNDQsImV4cCI6MTczNDgwMzA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.dFjYuxC9XR0GcJ8G-SIkqisUIuz72MdBPZSsNUmGUaJbc0JmAujJZabhKJ2MABP1LJkkw9D8V82P4Bw3jqVnyRqsz_ra6yHRl5pCgb5DahRkSnioP1RAuBGXo-L6hGukBORRrZDOxUJ_Dcr1uCzIkOPlwFqFJAr2YdfDq1VFRAOZTZNA3ILFL44g1p6u7OkTvZ8kLQqgG9tBGkMRtOqJ6OV_SzGYla1J3AxwOfPnuB2Cm_hYZyaB8k5f3WPxeFKN9n-mIa8ALN-rAI8heAzHQbH5wbiQRLDyTvIrC4CmwP7Ix6VcjMgZu5y-doDTzzXagRSVA8AyzIsPXJbX_jnjAg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GDOyZHAZ989I0AXGv4-Ikde4qaZAxtw47bwz57Ga4Ys [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MDEyNDQsImV4cCI6MTczNDgwMTU0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODAxMjQ0LCJhdF9oYXNoIjoiaUtzUlJ4dmdzWkFQYzNvRVdPX1N2dyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.uPLbb6xTsVEMuFKNmXMDQJJYcapnewdCT8EQ8zr8hK6sSBImtU5QfDFGzSOKVJLKjq0_MFNU9LwbYyyRo8nAx2IuZTOstBxtCNoXDWYzcFZkXK2mGqpwF2EXNBqTgLcfuvv4YbGTLmqB5dXePOj0Q-Mp9-2gRhhVdQoEVuA1UjIZhY0xeVYRv0VpC8ragpNmy0Whw2n3QHtk5EEH6JZhLCAZLrtIen1Qy-_yBsF8pOWjNqfROmp0hiecSHWLOpciIG8a4VIxBTPf4iUdDQRhTvZpVYIayeN1jcshrOP-HtzbVZhtUlBWdwJ97TcCzrREUiQcd6CXdsKM6kPHA8DsnQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MDEyNDQsImV4cCI6MTczNDgwMzA0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.dFjYuxC9XR0GcJ8G-SIkqisUIuz72MdBPZSsNUmGUaJbc0JmAujJZabhKJ2MABP1LJkkw9D8V82P4Bw3jqVnyRqsz_ra6yHRl5pCgb5DahRkSnioP1RAuBGXo-L6hGukBORRrZDOxUJ_Dcr1uCzIkOPlwFqFJAr2YdfDq1VFRAOZTZNA3ILFL44g1p6u7OkTvZ8kLQqgG9tBGkMRtOqJ6OV_SzGYla1J3AxwOfPnuB2Cm_hYZyaB8k5f3WPxeFKN9n-mIa8ALN-rAI8heAzHQbH5wbiQRLDyTvIrC4CmwP7Ix6VcjMgZu5y-doDTzzXagRSVA8AyzIsPXJbX_jnjAg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => GDOyZHAZ989I0AXGv4-Ikde4qaZAxtw47bwz57Ga4Ys [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 12:14:04] Production.ERROR: Invoice Payment Date 2024-12-20 00:00:00 [2024-12-21 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,20) [2024-12-21 12:14:06] Production.INFO: Batch insert start [2024-12-21 12:14:06] Production.INFO: global counter1 [2024-12-21 12:14:06] Production.INFO: insertion start [2024-12-21 12:14:06] Production.INFO: last batch insert 1 [2024-12-21 12:14:07] Production.INFO: insertion end [2024-12-21 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('fac57e20-bfbe-11ef-b870-09606f50267e') start [2024-12-21 12:14:07] Production.INFO: CALL prc_importPaymentAccounting ('fac57e20-bfbe-11ef-b870-09606f50267e') end [2024-12-21 12:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-21 12:14:07] Production.INFO: 2 [2024-12-21 12:14:07] Production.ERROR: CronJobId end14 [2024-12-21 12:14:07] Production.INFO: ==29676== Releasing lock... [2024-12-21 12:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-21 12:14:07] Production.INFO: 26 MB #Memory Used# [2024-12-21 18:14:04] Production.INFO: -- Xero Api Check -- [2024-12-21 18:14:05] Production.INFO: -- curl info --Array ( [url] => https://identity.xero.com/connect/token [content_type] => application/json; charset=UTF-8 [http_code] => 200 [header_size] => 857 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.072342 [namelookup_time] => 0.537253 [connect_time] => 0.548459 [pretransfer_time] => 0.836382 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2569 [speed_upload] => 76 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.072288 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 54862 ) [2024-12-21 18:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MjI4NDUsImV4cCI6MTczNDgyMzE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODIyODQ1LCJhdF9oYXNoIjoibjZDQXhnRTE2ZjhFLXZlMUZseTBxdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.nhMtEph7SOrLoLA7R_OlzVk7Sl9J7X50WDk4MynP8_NQJQ3mOrenWNoMRC1GnzM8QDgFJWesC7BITqrPoGR6pGrRmm_KqQK1uvlFA4Z9uROblXZzY1mGcaY-2KQ4yckNiZr5l9pUAgFY9yB8GaBV-keHj7gYA9_exIxP-mwVOy2uWTeXOQ4oNH1q5VZxk965aRPRAenpblaK6AxUJVgO7Rivgi2S1xSeKuJ8ng_UGaq-99632L7Fw-WOqqw4TjfGZ4FmozWLxgDb_RC2V7xnnyLcKkmCI_XoqZ9VSueanh2EWUfZ5f22ascFehtNmPSGxCRmwrakB-mcs1FTW4a89g [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MjI4NDUsImV4cCI6MTczNDgyNDY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.GBsm8SjqEbQVgBZyE2KWJQrOEMp8tdanb4GKVBU51TG2mbIZwCmzRyztDzpmhrxt6OAPNONlhKVU5DHYAnIEnymBN2UEMniguvB_9C8Hkcak7wAhG3bGiLHYr2w3cJ-LqOcc2M8ieK_6VKnlgYCB3djNE2UwDxm_Ka4yRJv0X8mLMC-48yDZ-KcTlLcJoRjvaIGr0smzE5HFcl4uN_q0we_6ky-CDflub2Igc377lSyT_MJpdhebJ1LJW3rY7wzvM0n7o4klpTkMofiZOH1NIRdcxOqFgyjoGPZ7jr22YCeVeBu7t5MHwEJFCaipSRZYb-dq0k4In28PElhQD2Kxxw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => quPDX88H3FwLLOOSpXyCnHVM3egU3TpA2zDtmfqGYq0 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 18:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MjI4NDUsImV4cCI6MTczNDgyMzE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM0ODIyODQ1LCJhdF9oYXNoIjoibjZDQXhnRTE2ZjhFLXZlMUZseTBxdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.nhMtEph7SOrLoLA7R_OlzVk7Sl9J7X50WDk4MynP8_NQJQ3mOrenWNoMRC1GnzM8QDgFJWesC7BITqrPoGR6pGrRmm_KqQK1uvlFA4Z9uROblXZzY1mGcaY-2KQ4yckNiZr5l9pUAgFY9yB8GaBV-keHj7gYA9_exIxP-mwVOy2uWTeXOQ4oNH1q5VZxk965aRPRAenpblaK6AxUJVgO7Rivgi2S1xSeKuJ8ng_UGaq-99632L7Fw-WOqqw4TjfGZ4FmozWLxgDb_RC2V7xnnyLcKkmCI_XoqZ9VSueanh2EWUfZ5f22ascFehtNmPSGxCRmwrakB-mcs1FTW4a89g [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzQ4MjI4NDUsImV4cCI6MTczNDgyNDY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.GBsm8SjqEbQVgBZyE2KWJQrOEMp8tdanb4GKVBU51TG2mbIZwCmzRyztDzpmhrxt6OAPNONlhKVU5DHYAnIEnymBN2UEMniguvB_9C8Hkcak7wAhG3bGiLHYr2w3cJ-LqOcc2M8ieK_6VKnlgYCB3djNE2UwDxm_Ka4yRJv0X8mLMC-48yDZ-KcTlLcJoRjvaIGr0smzE5HFcl4uN_q0we_6ky-CDflub2Igc377lSyT_MJpdhebJ1LJW3rY7wzvM0n7o4klpTkMofiZOH1NIRdcxOqFgyjoGPZ7jr22YCeVeBu7t5MHwEJFCaipSRZYb-dq0k4In28PElhQD2Kxxw [expires_in] => 1800 [token_type] => Bearer [refresh_token] => quPDX88H3FwLLOOSpXyCnHVM3egU3TpA2zDtmfqGYq0 [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2024-12-21 18:14:05] Production.ERROR: Invoice Payment Date 2024-12-20 00:00:00 [2024-12-21 18:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2024,12,20) [2024-12-21 18:14:07] Production.INFO: Batch insert start [2024-12-21 18:14:07] Production.INFO: global counter1 [2024-12-21 18:14:07] Production.INFO: insertion start [2024-12-21 18:14:07] Production.INFO: last batch insert 1 [2024-12-21 18:14:07] Production.INFO: insertion end [2024-12-21 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('45e12d50-bff1-11ef-b1b6-bf2cb0a73b28') start [2024-12-21 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('45e12d50-bff1-11ef-b1b6-bf2cb0a73b28') end [2024-12-21 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2024-12-21 18:14:07] Production.INFO: 2 [2024-12-21 18:14:07] Production.ERROR: CronJobId end14 [2024-12-21 18:14:07] Production.INFO: ==25355== Releasing lock... [2024-12-21 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2024-12-21 18:14:07] Production.INFO: 26 MB #Memory Used#