[2025-01-07 00:14:04] Production.INFO: -- Xero Api Check -- [2025-01-07 00: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] => 1.548256 [namelookup_time] => 0.535971 [connect_time] => 0.625308 [pretransfer_time] => 1.091299 [size_upload] => 82 [size_download] => 2755 [speed_download] => 1779 [speed_upload] => 52 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.548169 [redirect_time] => 0 [redirect_url] => [primary_ip] => 2.22.251.19 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 34266 ) [2025-01-07 00:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyMjY4NDUsImV4cCI6MTczNjIyNzE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjI2ODQ1LCJhdF9oYXNoIjoiaXZtbTg2UHBMWWVFSVJvWVo4U3d2USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UqxMkuNxL9TT-70pu6SQxqUsbfVIYF4qdB075i-UdsNqwOrfyrTzszdrRWnLuptSqqsAapVJwVojyL1IbbNOR0_CC5lanhhATeFEGrVskTkj09Ug6MtXPRdhfgvStwj3OXmajVkBX789xCB-E5PwiyfOeKEWT54oue53PrT4InFCt-_YHaxvuyMglzOLJsRQ6uQMDhR5ONPz0e2PsCIKw1ar8jUh5_sXXl00PX6_eVmUR7A8FjpsFvDznubUdSvlzmqiRCXSLB8cdYlsXjoOpHEHRUkW1-mzmsSx8X1bJMLD0x87JSaF4XcUwdSb2WJYEpslTv8qNQ7Y3djnesgM2w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyMjY4NDUsImV4cCI6MTczNjIyODY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.JQLnsgTakpGflSReaC0XFSip0t5g-jjfAP6SvWhEplzJbQbXFNRHpE60bXaz3sqjy9wXlt2KcBdaVeuyWLcHDQMORfvSBixdGvQ3VxwdrxBQR064FHwVv5rDBssDJlpgflUWMDtn8LE96xSHEZLgkkmGY4fnWBgqI0Tu5i-qrytn1A3m186j3njI3bWYlCgPHQjLBLRRg6T-2kjyYkWbNgondFzA1SH4S8YuNgVhdfb5fzCAP1DvyWHxf_pa_zj_XH9qCwD8X2vIwsM7kjl9ZJRKOTxl55PUucBdK4nYRIvykL1rHFzLK6srhc0jQSF61chURd-TKYMpXyZiqnIVZA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => pBQsKhiuVCiA0dZ51lMSaj34NK2NNaCAA2bdICuDHsI [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 00:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyMjY4NDUsImV4cCI6MTczNjIyNzE0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjI2ODQ1LCJhdF9oYXNoIjoiaXZtbTg2UHBMWWVFSVJvWVo4U3d2USIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.UqxMkuNxL9TT-70pu6SQxqUsbfVIYF4qdB075i-UdsNqwOrfyrTzszdrRWnLuptSqqsAapVJwVojyL1IbbNOR0_CC5lanhhATeFEGrVskTkj09Ug6MtXPRdhfgvStwj3OXmajVkBX789xCB-E5PwiyfOeKEWT54oue53PrT4InFCt-_YHaxvuyMglzOLJsRQ6uQMDhR5ONPz0e2PsCIKw1ar8jUh5_sXXl00PX6_eVmUR7A8FjpsFvDznubUdSvlzmqiRCXSLB8cdYlsXjoOpHEHRUkW1-mzmsSx8X1bJMLD0x87JSaF4XcUwdSb2WJYEpslTv8qNQ7Y3djnesgM2w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyMjY4NDUsImV4cCI6MTczNjIyODY0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.JQLnsgTakpGflSReaC0XFSip0t5g-jjfAP6SvWhEplzJbQbXFNRHpE60bXaz3sqjy9wXlt2KcBdaVeuyWLcHDQMORfvSBixdGvQ3VxwdrxBQR064FHwVv5rDBssDJlpgflUWMDtn8LE96xSHEZLgkkmGY4fnWBgqI0Tu5i-qrytn1A3m186j3njI3bWYlCgPHQjLBLRRg6T-2kjyYkWbNgondFzA1SH4S8YuNgVhdfb5fzCAP1DvyWHxf_pa_zj_XH9qCwD8X2vIwsM7kjl9ZJRKOTxl55PUucBdK4nYRIvykL1rHFzLK6srhc0jQSF61chURd-TKYMpXyZiqnIVZA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => pBQsKhiuVCiA0dZ51lMSaj34NK2NNaCAA2bdICuDHsI [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 00:14:05] Production.ERROR: Invoice Payment Date 2025-01-06 00:00:00 [2025-01-07 00:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,06) [2025-01-07 00:14:08] Production.INFO: Batch insert start [2025-01-07 00:14:08] Production.INFO: global counter1 [2025-01-07 00:14:08] Production.INFO: insertion start [2025-01-07 00:14:08] Production.INFO: last batch insert 1 [2025-01-07 00:14:08] Production.INFO: insertion end [2025-01-07 00:14:08] Production.INFO: CALL prc_importPaymentAccounting ('3785b5d0-ccb6-11ef-af07-11642dc2b3c0') start [2025-01-07 00:14:08] Production.INFO: CALL prc_importPaymentAccounting ('3785b5d0-ccb6-11ef-af07-11642dc2b3c0') end [2025-01-07 00:14:08] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-07 00:14:08] Production.INFO: 2 [2025-01-07 00:14:08] Production.ERROR: CronJobId end14 [2025-01-07 00:14:08] Production.INFO: ==12136== Releasing lock... [2025-01-07 00:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-07 00:14:08] Production.INFO: 26 MB #Memory Used# [2025-01-07 06:14:04] Production.INFO: -- Xero Api Check -- [2025-01-07 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] => 859 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.371639 [namelookup_time] => 0.542652 [connect_time] => 0.630557 [pretransfer_time] => 1.009786 [size_upload] => 82 [size_download] => 2755 [speed_download] => 2008 [speed_upload] => 59 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 1.371597 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.72.248.213 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 57040 ) [2025-01-07 06:14:05] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNDg0NDUsImV4cCI6MTczNjI0ODc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjQ4NDQ1LCJhdF9oYXNoIjoiZmxkNE9ISDdnc2xYSHJZQmppN25XZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Gcy6jysybQD1g6xYxVCPT2uGzsM3oSHOs3NNgu7mBE70vt94trHtf5Dpjkm-rMzglysQvO72LAnT6NH-2NqDrpn7DxDdjAgvGLyBRD4yzmIyXJlXNC_i9SgbzE8qAEk9LzRh3q7x9y5B4nEBHK5qTPqRHJhbNdIBOsOgDVSlKV7CpM2hvGrfnp8uPrTv8yKRSI-SWYGiItu_D1Ru0oKpywcFDPi5NIUjeF1vMFKD0CH44j8MabUzUvnAS4pp-LuX36eELhsvwRkaYSB4-JNXibrwhm9oh7TaKcW47XJJ2YTLn3eq_ikTvuRlMLJ6OEB9ZCwpIgGMPZcx2fw77vdM0w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNDg0NDUsImV4cCI6MTczNjI1MDI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.m7dwS7_5eS8N45afn7VaiayZSkjhpmSV6PaySEZZJYF7QS7E_hB7P1_EJzzQR-k2d-hF7L9nmjO6EM3LMaJla7Q3znIoq0U2gftHTvnQjfNAbl0D-BNm6wxs7T0EVeNhqL74uB2Qvowep-bKPt-oovfa5Wwk0_AOrv8AqiFKJKNV5hK-uii4KJO8k9d-SbQmD4MCWuPwBSAneg93mHPVPTB-8ihP7gMwXbZhjJxjrKLlDrR-CVCtjyTgqme5OLgwNJLSMYLGZ-19Hg6ucy2kaj0CR5iZ-Axh6QNNWoSdc7NnvDQbw9A1inp1nAXrVhPjgJoJ1199vRSldinE0i3vZg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => hC1dZXrKe26Ntp0oAmJdG9C0LgO6y2-XfzNGY5lQL9Y [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 06:14:05] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNDg0NDUsImV4cCI6MTczNjI0ODc0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjQ4NDQ1LCJhdF9oYXNoIjoiZmxkNE9ISDdnc2xYSHJZQmppN25XZyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.Gcy6jysybQD1g6xYxVCPT2uGzsM3oSHOs3NNgu7mBE70vt94trHtf5Dpjkm-rMzglysQvO72LAnT6NH-2NqDrpn7DxDdjAgvGLyBRD4yzmIyXJlXNC_i9SgbzE8qAEk9LzRh3q7x9y5B4nEBHK5qTPqRHJhbNdIBOsOgDVSlKV7CpM2hvGrfnp8uPrTv8yKRSI-SWYGiItu_D1Ru0oKpywcFDPi5NIUjeF1vMFKD0CH44j8MabUzUvnAS4pp-LuX36eELhsvwRkaYSB4-JNXibrwhm9oh7TaKcW47XJJ2YTLn3eq_ikTvuRlMLJ6OEB9ZCwpIgGMPZcx2fw77vdM0w [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNDg0NDUsImV4cCI6MTczNjI1MDI0NSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.m7dwS7_5eS8N45afn7VaiayZSkjhpmSV6PaySEZZJYF7QS7E_hB7P1_EJzzQR-k2d-hF7L9nmjO6EM3LMaJla7Q3znIoq0U2gftHTvnQjfNAbl0D-BNm6wxs7T0EVeNhqL74uB2Qvowep-bKPt-oovfa5Wwk0_AOrv8AqiFKJKNV5hK-uii4KJO8k9d-SbQmD4MCWuPwBSAneg93mHPVPTB-8ihP7gMwXbZhjJxjrKLlDrR-CVCtjyTgqme5OLgwNJLSMYLGZ-19Hg6ucy2kaj0CR5iZ-Axh6QNNWoSdc7NnvDQbw9A1inp1nAXrVhPjgJoJ1199vRSldinE0i3vZg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => hC1dZXrKe26Ntp0oAmJdG9C0LgO6y2-XfzNGY5lQL9Y [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 06:14:05] Production.ERROR: Invoice Payment Date 2025-01-06 00:00:00 [2025-01-07 06:14:05] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,06) [2025-01-07 06:14:08] Production.INFO: Batch insert start [2025-01-07 06:14:08] Production.INFO: global counter4 [2025-01-07 06:14:08] Production.INFO: insertion start [2025-01-07 06:14:08] Production.INFO: last batch insert 4 [2025-01-07 06:14:08] Production.INFO: insertion end [2025-01-07 06:14:08] Production.INFO: CALL prc_importPaymentAccounting ('81f8bea0-cce8-11ef-af4a-c586e405f206') start [2025-01-07 06:14:08] Production.INFO: CALL prc_importPaymentAccounting ('81f8bea0-cce8-11ef-af4a-c586e405f206') end [2025-01-07 06:14:08] Production.INFO: array ( 0 => array ( 'Message' => '3 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-07 06:14:08] Production.INFO: 2 [2025-01-07 06:14:08] Production.ERROR: CronJobId end14 [2025-01-07 06:14:08] Production.INFO: ==10083== Releasing lock... [2025-01-07 06:14:08] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-07 06:14:08] Production.INFO: 26 MB #Memory Used# [2025-01-07 12:14:03] Production.INFO: -- Xero Api Check -- [2025-01-07 12:14:03] 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.64951 [namelookup_time] => 0.292734 [connect_time] => 0.293963 [pretransfer_time] => 0.495457 [size_upload] => 82 [size_download] => 2755 [speed_download] => 4241 [speed_upload] => 126 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.649441 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.53.4.33 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 44190 ) [2025-01-07 12:14:03] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNzAwNDMsImV4cCI6MTczNjI3MDM0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjcwMDQzLCJhdF9oYXNoIjoiWXlNVGdYU2VSek4ySFhZODYzM2htQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.OM6EvdwP3I8PPcp70bAOQJuuz4kH1jtSuwmCbuDYnxNS0pr5cnuPLr_NUezUVAReFD6YaaXGfAMaVJ0G1oF58cXMbQODKR-Lnzyv_hROIy6z3ecCqLpsDUG-UJfbC-0t0hVUEaTcYddVk5cq2PdbPa6nHeHA1IGOOSddaoTd0w9FLvvlUpDQBHYB9_r5dgtTYvxcXVj3QnAWbwYUjItgotGk0VogXh-S4CJ-mNZxmqu3xGSNx_2P4zxRQEffeS-Hnpqzeyj22dmMCrT2vtRPLayqmcYrMQORb14unbXzKO3y2fgE2faBHpVUgu_xUUWCwvA3SNaGdR5GP93QBTIhLw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNzAwNDMsImV4cCI6MTczNjI3MTg0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.TYAN1JQq1dj4o4QASXn6ka4bKtIX5xwHZKqEeFiWAljVInKZzSGABwMBXl6N5Is3y7cPoSH4pBQK_KfLRxt8yef4Tc7zfYzCFi5RTx3_is6EqAn6RyGonKDBdX-F-yZH1dsasMYHYFIp-h37B8ITfqb4ah6nA0cIomWjvc4P1nqKHsYnI46pRRhbZoKOTieb9GdJbaRn1cgly4TVzv5rBoBDK4zNMlCELc6DixKKTQ_jfLzL6fvSN8_ONULnp3UPaTQedO6RkmpY3tuR05F5EIkUpw_THYiHO98PW7CSff0gYEsDa_uQjTOuUnCD_dLfr2irKsjcnjHttLQBcsh5Gg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => lwdHO58Tuf7dcI9-k1Hc9xg-fP5jVI4tRm7O4Q2bk4A [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 12:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNzAwNDMsImV4cCI6MTczNjI3MDM0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjcwMDQzLCJhdF9oYXNoIjoiWXlNVGdYU2VSek4ySFhZODYzM2htQSIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.OM6EvdwP3I8PPcp70bAOQJuuz4kH1jtSuwmCbuDYnxNS0pr5cnuPLr_NUezUVAReFD6YaaXGfAMaVJ0G1oF58cXMbQODKR-Lnzyv_hROIy6z3ecCqLpsDUG-UJfbC-0t0hVUEaTcYddVk5cq2PdbPa6nHeHA1IGOOSddaoTd0w9FLvvlUpDQBHYB9_r5dgtTYvxcXVj3QnAWbwYUjItgotGk0VogXh-S4CJ-mNZxmqu3xGSNx_2P4zxRQEffeS-Hnpqzeyj22dmMCrT2vtRPLayqmcYrMQORb14unbXzKO3y2fgE2faBHpVUgu_xUUWCwvA3SNaGdR5GP93QBTIhLw [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyNzAwNDMsImV4cCI6MTczNjI3MTg0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.TYAN1JQq1dj4o4QASXn6ka4bKtIX5xwHZKqEeFiWAljVInKZzSGABwMBXl6N5Is3y7cPoSH4pBQK_KfLRxt8yef4Tc7zfYzCFi5RTx3_is6EqAn6RyGonKDBdX-F-yZH1dsasMYHYFIp-h37B8ITfqb4ah6nA0cIomWjvc4P1nqKHsYnI46pRRhbZoKOTieb9GdJbaRn1cgly4TVzv5rBoBDK4zNMlCELc6DixKKTQ_jfLzL6fvSN8_ONULnp3UPaTQedO6RkmpY3tuR05F5EIkUpw_THYiHO98PW7CSff0gYEsDa_uQjTOuUnCD_dLfr2irKsjcnjHttLQBcsh5Gg [expires_in] => 1800 [token_type] => Bearer [refresh_token] => lwdHO58Tuf7dcI9-k1Hc9xg-fP5jVI4tRm7O4Q2bk4A [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 12:14:04] Production.ERROR: Invoice Payment Date 2025-01-06 00:00:00 [2025-01-07 12:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,06) [2025-01-07 12:14:06] Production.INFO: Batch insert start [2025-01-07 12:14:06] Production.INFO: global counter8 [2025-01-07 12:14:06] Production.INFO: insertion start [2025-01-07 12:14:06] Production.INFO: last batch insert 8 [2025-01-07 12:14:06] Production.INFO: insertion end [2025-01-07 12:14:06] Production.INFO: CALL prc_importPaymentAccounting ('cb9a12e0-cd1a-11ef-8d23-3955ed6efeaa') start [2025-01-07 12:14:06] Production.INFO: CALL prc_importPaymentAccounting ('cb9a12e0-cd1a-11ef-8d23-3955ed6efeaa') end [2025-01-07 12:14:06] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-07 12:14:06] Production.INFO: 2 [2025-01-07 12:14:06] Production.ERROR: CronJobId end14 [2025-01-07 12:14:06] Production.INFO: ==7612== Releasing lock... [2025-01-07 12:14:06] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-07 12:14:06] Production.INFO: 26 MB #Memory Used# [2025-01-07 18:14:03] Production.INFO: -- Xero Api Check -- [2025-01-07 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] => 856 [request_size] => 352 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.754595 [namelookup_time] => 0.27825 [connect_time] => 0.287506 [pretransfer_time] => 0.616663 [size_upload] => 82 [size_download] => 2755 [speed_download] => 3650 [speed_upload] => 108 [download_content_length] => 2755 [upload_content_length] => 82 [starttransfer_time] => 0.754515 [redirect_time] => 0 [redirect_url] => [primary_ip] => 23.222.17.70 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 54.39.180.235 [local_port] => 59152 ) [2025-01-07 18:14:04] Production.INFO: -- connection successfully here --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyOTE2NDQsImV4cCI6MTczNjI5MTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjkxNjQ0LCJhdF9oYXNoIjoiQlU5aGExSVd1Q2JoMWtZSDRFdkVDdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.IJ7-a8pgaO5VzTXFCYLSkIxZC9305624zzzn4btRfxrjPXRA1cEsNE50FQZkBtU7eoyHBRT0r-6uZUmDsY0WvajWes8yVuLHYEjFb0Ufni4aQ7auQ50mID8IaJneO6tYTbAQikGya_KLJnWLnEOSs3gEkf3-cfLJbcC-XGUC83Q-BFS4ezrSviUR4GUij_NXnmW9TAfyfYYpmAgZa8Dm_rBKI4pR4WCtNkRPGffXctxUztIHRYVdoPoKr40DYPZAq2rnojLMmalqOS0NzaRqNdL9nth4APFzcCoMxryJoxemZfOvE9ebGTbCt_A08--ZYLiQUzVo_oAm_GvWOTG4gQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyOTE2NDQsImV4cCI6MTczNjI5MzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.fIbwpnVVewGCg8OMbvpLM-l6SQDat8yA9xeQLoki_z3YOkr10eOR19_Nz0g4o3ZAGny-FwTC6igSIZn2fi6fIpp_O8kkMxWTLr8o06V1s42Bgc78oQxFfYaiaQieJRewwnQlTkZt07brVVPvsVJ5y4uCK9uxjH2MT3TUY0ZqLXPWzDLMeayh9Vz5m8NTtQncWenA9yYSGeLaAp9rGdeCwpU-VBt0zwbTrWAy1tjIjptMKjXsOPzpl3p3AEUu-1skK4557a-F3ckK5llc1c31HoygxZr9BQncYr2g1FgsF9sf13uZw0HCgVFxcy13sJ8MG6J83q-46zR4f0KaZVdKIA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => zAOERTtvTlSAbiQXY4D-wuLBraysDMUHB2IfuAuyGGs [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 18:14:04] Production.INFO: -- connection successfully --stdClass Object ( [id_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyOTE2NDQsImV4cCI6MTczNjI5MTk0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6IjBFNUE4OTZEQ0JCMTQ0Mzk4NENDNjJFNjlCMjBDOTU4IiwiaWF0IjoxNzM2MjkxNjQ0LCJhdF9oYXNoIjoiQlU5aGExSVd1Q2JoMWtZSDRFdkVDdyIsInN1YiI6Ijk4MzYzNDUwNGIxNzVkNzA4ZmYwZWQ0ZGRkNmY2NjNkIiwiYXV0aF90aW1lIjoxNzMyNTI1NTY0LCJ4ZXJvX3VzZXJpZCI6IjQxOWY5MmM4LTkxZTEtNDllNS05ZmZiLWI4YTdjNmI3ODg0NSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJzaWQiOiJiMjAwNzA3MWNkZjI0OTBkYTg2ODkxMjE1YTQ0MDUyYiIsInByZWZlcnJlZF91c2VybmFtZSI6ImNvLmx5bmRhQHlhaG9vLmNvbSIsImVtYWlsIjoiY28ubHluZGFAeWFob28uY29tIiwiZ2l2ZW5fbmFtZSI6Ikx5bmRhIiwiZmFtaWx5X25hbWUiOiJPa29ybyIsIm5hbWUiOiJMeW5kYSBPa29ybyIsImFtciI6WyJwd2QiXX0.IJ7-a8pgaO5VzTXFCYLSkIxZC9305624zzzn4btRfxrjPXRA1cEsNE50FQZkBtU7eoyHBRT0r-6uZUmDsY0WvajWes8yVuLHYEjFb0Ufni4aQ7auQ50mID8IaJneO6tYTbAQikGya_KLJnWLnEOSs3gEkf3-cfLJbcC-XGUC83Q-BFS4ezrSviUR4GUij_NXnmW9TAfyfYYpmAgZa8Dm_rBKI4pR4WCtNkRPGffXctxUztIHRYVdoPoKr40DYPZAq2rnojLMmalqOS0NzaRqNdL9nth4APFzcCoMxryJoxemZfOvE9ebGTbCt_A08--ZYLiQUzVo_oAm_GvWOTG4gQ [access_token] => eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3MzYyOTE2NDQsImV4cCI6MTczNjI5MzQ0NCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiMEU1QTg5NkRDQkIxNDQzOTg0Q0M2MkU2OUIyMEM5NTgiLCJzdWIiOiI5ODM2MzQ1MDRiMTc1ZDcwOGZmMGVkNGRkZDZmNjYzZCIsImF1dGhfdGltZSI6MTczMjUyNTU2NCwieGVyb191c2VyaWQiOiI0MTlmOTJjOC05MWUxLTQ5ZTUtOWZmYi1iOGE3YzZiNzg4NDUiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6ImIyMDA3MDcxY2RmMjQ5MGRhODY4OTEyMTVhNDQwNTJiIiwic2lkIjoiYjIwMDcwNzFjZGYyNDkwZGE4Njg5MTIxNWE0NDA1MmIiLCJqdGkiOiJGNTNDRTI4MjFGRjY3QzE5NEU2QTNFQzgwQjFCNUVCQiIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiNzc3OWNmODUtMTcwNS00MmYyLWI1Y2MtYTdmZWQ3ZTNjNDI4Iiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5zZXR0aW5ncyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.fIbwpnVVewGCg8OMbvpLM-l6SQDat8yA9xeQLoki_z3YOkr10eOR19_Nz0g4o3ZAGny-FwTC6igSIZn2fi6fIpp_O8kkMxWTLr8o06V1s42Bgc78oQxFfYaiaQieJRewwnQlTkZt07brVVPvsVJ5y4uCK9uxjH2MT3TUY0ZqLXPWzDLMeayh9Vz5m8NTtQncWenA9yYSGeLaAp9rGdeCwpU-VBt0zwbTrWAy1tjIjptMKjXsOPzpl3p3AEUu-1skK4557a-F3ckK5llc1c31HoygxZr9BQncYr2g1FgsF9sf13uZw0HCgVFxcy13sJ8MG6J83q-46zR4f0KaZVdKIA [expires_in] => 1800 [token_type] => Bearer [refresh_token] => zAOERTtvTlSAbiQXY4D-wuLBraysDMUHB2IfuAuyGGs [scope] => email profile openid accounting.settings accounting.transactions accounting.contacts offline_access ) [2025-01-07 18:14:04] Production.ERROR: Invoice Payment Date 2025-01-06 00:00:00 [2025-01-07 18:14:04] Production.INFO: calling invoices get methodhttps://api.xero.com/api.xro/2.0/Payments?where=Date>=DateTime(2025,01,06) [2025-01-07 18:14:07] Production.INFO: Batch insert start [2025-01-07 18:14:07] Production.INFO: global counter8 [2025-01-07 18:14:07] Production.INFO: insertion start [2025-01-07 18:14:07] Production.INFO: last batch insert 8 [2025-01-07 18:14:07] Production.INFO: insertion end [2025-01-07 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('166cd7d0-cd4d-11ef-bcf4-7d1f7872e878') start [2025-01-07 18:14:07] Production.INFO: CALL prc_importPaymentAccounting ('166cd7d0-cd4d-11ef-bcf4-7d1f7872e878') end [2025-01-07 18:14:07] Production.INFO: array ( 0 => array ( 'Message' => '0 Records Imported ', ), 1 => array ( 'Message' => ' Invalid InvoiceNumber : Expenses - 18 May 2018', ), ) [2025-01-07 18:14:07] Production.INFO: 2 [2025-01-07 18:14:07] Production.ERROR: CronJobId end14 [2025-01-07 18:14:07] Production.INFO: ==4549== Releasing lock... [2025-01-07 18:14:07] Production.INFO: xeropaymentimport-command-xeropaymentimport-companyid-1-cronjobid-14 #Stops# [2025-01-07 18:14:07] Production.INFO: 26 MB #Memory Used#