Summary
The log file shows an error related to unexpected data in records during replication, resulting in a failure.
Question
This is the error in the log file if someone can help resolve this issue “readFromSource” : {
“elapsedTimeInNanos” : 4985058371,
“executionCount” : 2,
“avgExecTimeInNanos” : 2.4925291855E9
},
“processFromDest” : {
“elapsedTimeInNanos” : 0,
“executionCount” : 0,
“avgExecTimeInNanos” : “NaN”
},
“writeToDest” : {
“elapsedTimeInNanos” : 0,
“executionCount” : 0,
“avgExecTimeInNanos” : “NaN”
},
“readFromDest” : {
“elapsedTimeInNanos” : 5208415592,
“executionCount” : 181,
“avgExecTimeInNanos” : 2.8775776751381215E7
}
}
}
2024-03-26 11:42:04 platform > failures: [ {
“failureOrigin” : “replication”,
“internalMessage” : “Unexpected data in record: [{"customer_id":"AAAAAAAADDHMCAAA","salutation":"Ms.","first_name":"Wanda","last_name":"Peterson","birth_day":30,"birth_month":10,"birth_year":1931,"birth_country":"ECUADOR","login":null,"email_address":"Wanda.Peterson#http://bABLAp.org|bABLAp.org","preferred_cust_flag":"N","first_shipto_date":"2018-12-11","first_sales_date":"2018-11-11","last_review_date":" 2.4589390","address":{"address_sk":290602,"address_id":"AAAAAAAAKCPGEAAA","street_number":"909","street_name":"South Hickory","street_type":"Ln","suite_number":"Suite 0","city":"Woodlawn","county":"De Witt County","state":"IL","zip":"64098","country":"United States","gmt_offset":"-6.00","location_type":"condo"},"customer_demographic":{"customer_demographic_sk":90059,"gender":"M","marital_status":"U","education_status":"2 yr Degree","purchase_estimate":3500,"credit_rating":"Good","dependent_count":2},"household_demographic":{"household_demographic_sk":3454,"buy_potential":">10000","vehicle_count":2,"incomeband_lowerbound":140001,"incomeband_Upperbound":150000}},{"customer_id":"AAAAAAAALPNDEAAA","salutation":"Dr.","first_name":"Leslie","last_name":"Colby","birth_day":7,"birth_month":12,"birth_year":1985,"birth_country":"UNITED STATES","login":null,"email_address":"Leslie.Colby#http://qYkxG.org|qYkxG.org","preferred_cust_flag":"N","first_shipto_date":"2016-08-15","first_sales_date":"2016-07-16","last_review_date":" 2.4590860","address":{"address_sk":187305,"address_id":"AAAAAAAAJKLNCAAA","street_number":"205","street_name":"River","street_type":"Blvd","suite_number":"Suite 140","city":"Arlington","county":"Esmeralda County","state":"NV","zip":"86557","country":"United States","gmt_offset":"-8.00","location_type":"condo"},"customer_demographic":{"customer_demographic_sk":42966,"gender":"F","marital_status":"D","education_status":"Advanced Degree","purchase_estimate":7000,"credit_rating":"High Risk","dependent_count":0},"household_demographic":{"household_demographic_sk":2859,"buy_potential":">10000","vehicle_count":2,"incomeband_lowerbound":190001,"incomeband_Upperbound":200000}},{"customer_id":"AAAAAAAADDHMCAAA","salutation":"Ms.","first_name":"Wanda","last_name":"Peterson","birth_day":30,"birth_month":10,"birth_year":1931,"birth_country":"ECUADOR","login":null,"email_address":"Wanda.Peterson#http://bABLAp.org|bABLAp.org","preferred_cust_flag":"N","first_shipto_date":"2018-12-11","first_sales_date":"2018-11-11","last_review_date":" 2.4589390","address":{"address_sk":290602,"address_id":"AAAAAAAAKCPGEAAA","street_number":"909","street_name":"South Hickory","street_type":"Ln","suite_number":"Suite 0","city":"Woodlawn","county":"De Witt County","state":"IL","zip":"64098","country":"United States","gmt_offset":"-6.00","location_type":"condo"},"customer_demographic":{"customer_demographic_sk":90059,"gender":"M","marital_status":"U","education_status":"2 yr Degree","purchase_estimate":3500,"credit_rating":"Good","dependent_count":2},"household_demographic":{"household_demographic_sk":3454,"buy_potential":">10000","vehicle_count":2,"incomeband_lowerbound":140001,"incomeband_Upperbound":150000}},{"customer_id":"AAAAAAAAELGICAAA","salutation":"Mr.","first_name":"Richard","last_name":"Doyle","birth_day":18,"birth_month":8,"birth_year":1937,"birth_country":"MONGOLIA","login":null,"email_address":"Richard.Doyle#http://KmGj7GdfXuA.edu|KmGj7GdfXuA.edu","preferred_cust_flag":"Y","first_shipto_date":"2018-11-06","first_sales_date":"2018-10-07","last_review_date":" 2.4591050","address":{"address_sk":163101,"address_id":"AAAAAAAANBNHCAAA","street_number":"592","street_name":"11th Ridge","street_type":"Boulevard","suite_number":"Suite A","city":"Pleasant Valley","county":"Woodruff County","state":"AR","zip":"72477","country":"United States","gmt_offset":"-6.00","location_type":"apartment"},"customer_demographic":{"customer_demographic_sk":816302,"gender":"F","marital_status":"M","education_status":"2 yr Degree","purchase_estimate":1000,"credit_rating":"Unknown","dependent_count":5},"household_demographic":{"household_demographic_sk":2278,"buy_potential":"Unknown","vehicle_count":1,"incomeband_lowerbound":180001,"incomeband_Upperbound":190000}}]”,
“externalMessage” : “Something went wrong during replication”,
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.