RM SuccessMaker Enterprise (ASA Error - 198)

[tomlin]

I’m upgrading the three workstations that Success Maker Enterprise run on (stand along installs) I've installed all the software, changed the database name from SME to SME1/SME2/SME3 to match the original machines. They all log in fine with no errors about duplicate database name on network

 

BUT when I use the import utility to import the students with there previous results I get the error message

 

Error: ASA Error - 198: Primary key for row 'Attendance' is referenced by foreign key 'Attendance' in table 'Online'.

It has imported all the students names and groups, but no history/grades for the students.

 

This error message has only occurred on the second and third machine. (First import all three workstations turned on, subsequent tries other two workstations turned off)

 

Has anybody had this error before, to save me renewing our contract with RM