Delete Survey records

johnrob18
Giga Guru

I have cloned an environment and now want to clear down all the records not required.

I have 26,000 surveys on the system in various states that I would like to delete.

I have tried to clear down the records on the tables (in Tables & Columns) but none of these has deleted the records.

When I try to delete the records manually I get the following error message.

Any thoughts how I can clear down these records?

find_real_file.png

2 REPLIES 2

arielgritti
Mega Sage

Hello

It's look there is a Referential integrity Constraint with the "Assessment Instance Question" table (asmt_assessment_instance_question).

Try deleting records from asmt_assessment_instance_question before.

Be careful about the "deletes".

 

Please, mark my answer correct, useful or bookmark if I helped you

Thanks

Ariel

 

 

snowolper
Tera Expert

Yea I used the above to help me. 

 

Searched: asmt_assessment_instance_question.list

Cross-referenced the instances that I needed to clean up one by one, deleting them, and then deleting the referenced assessment_instance.

 

Its pretty painful... This needs to be fixed...