In my Adobe CJA connections, I am not seeing any records after establishing the connection. However, in my dataset within Adobe Experience Platform (AEP), I can see data totaling approximately 2.36M records, but it is not being added to Adobe CJA.
I have tried using both lookup and event schemas. I created a timestamp field and mapped it to one of the fields in my source data flow. Similarly, I mapped the identity field, naming it "Quote ID." I cannot use the timestamp which is already provided by XDM Experience Event because I don't have any field in my source which has Map data type.
I followed all the steps in AEP, including creating the schema, setting up data flows in Sources (using Salesforce), and creating the dataset. The data flow appears to be functioning according to the specified time interval, currently set to 15 hours and add records within AEP. I even tried reducing it to 1 hour, but the issue persists with records coming up in Adobe CJA.
Despite completing these steps, Adobe CJA doesn’t show any errors. It simply fails to add any records. I have been troubleshooting this for several weeks, tweaking the schema, data flow, and connections, but nothing seems to work. Even my data backfills are failing for event dataset every time. While the lookup dataset worked.
Can anyone help me with this?