Hi,
I have a custom entity which does not assign all the column values from staging to the target table. Strangely, it only assigns all values only to the last records.
Any help is appreciated!
Regards,
Abhinay
*This post is locked for comments
Hi,
I have a custom entity which does not assign all the column values from staging to the target table. Strangely, it only assigns all values only to the last records.
Any help is appreciated!
Regards,
Abhinay
*This post is locked for comments
[quote user="Nikolaos Mäenpää"]Does your entity key correspond to the unique index of the target table?[/quote]
The relation between the staging and target table was incorrect.
Thank you for your suggestion.
- Do you have some custom code in your entity?
- Does your entity key correspond to the unique index of the target table?
One thing that I have noticed is that method setTargetBuffer receives the same record over and over again.
[quote user="André Arnaud de Calavon"]Does this table already have records and you are trying to update them?[/quote]
No.
[quote user="André Arnaud de Calavon"]Or are all of them new records?[/quote]
All the records are new.
[quote user="André Arnaud de Calavon"]It would really help if you share details of your custom entity[/quote]
Could you please specify which details are your expecting? I will try to share as much as possible.
Regards,
Abhinay
Hi Abhinary,
Does this table already have records and you are trying to update them? Or are all of them new records? I do understand correctly that the staging table is filled correctly? It would really help if you share details of your custom entity, so we can try to see if there is an error in how you created the entity or not.
It takes in data from an XML file and stores in a staging table. When I try to execute "Copy data to target" it creates records with blank fields except for the last record which retains all the values in all the fields.
Hi Abhinay,
Can you provide some more details about the custom entity and an example?
André Arnaud de Cal...
292,869
Super User 2025 Season 1
Martin Dráb
231,733
Most Valuable Professional
nmaenpaa
101,156
Moderator