[sims] Duplicate cluster, class in Sims so Nova T6 will now not transfer data

[Sambo69]

I cannot transfer NovaT6 data to Sims because

 

I cannot rename or change an offending duplicate Cluster/Class in SQL. It is appearing as a duplicate curriculum name and the dates for the class have been split across the year causing the conflict. THe end date for ONE class has been recorded as 04/03/2019 but yet there is another class with an alternative end date of the end of the academic year.

 

I have tried every conceivable export and I cannot remove the duplicate.

 

I have tried deleting the classes from within the course manger. I didn’t try deleting the course itself though.

 

I have updated class memberships repeatedly.

 

Does anyone know how to solve this please

Edited March 19, 2019 by Sambo69

[Esteban_Child_of_the_Sun]

Have you tried validate memberships and database diagnostics from within the Tools menu in SIMS?

[Sambo69]

I have validated the memberships several times. I will look at the database diagnostics tomorrow, Have you any other ideas.

[Sambo69]

I have done all of the above and this has not fixed the problem. I have noticed duplicate scheme names in Sims and I could delete one of these as no members are attached. How do I do this?

[Esteban_Child_of_the_Sun]

Have you run the report in NOVA to list any "Duplicate Curriculum Names"?

[Sambo69]

Thanks for the response the problem was nothing to do with a duplicate cluster, there was a class that was not linked and a dollar sign in one of the teachers name in error. It took a week and five qualified specialists to establish the error. Something to keep in mind.