Print

Print


Hi Carol,

Yes, do you get a System Error about the index 'IX_UCASCourseCodeConstraint'?

If so, it's because the OfferingCopy stored procedure inserts blanks rather null in to the UCASCourseCode field and the index only excludes nulls. We amended our stored procedure and updated the field to null where it was already blank, which seems to have worked. Advanced also advised that you can simply delete the index until it's resolved on their side.

Kind regards,

Russell

Russell Larkin
Head of Systems Development and Reporting

From: ProSolution Users Mailing List <[log in to unmask]> On Behalf Of Carol Hingston
Sent: 04 July 2018 10:55
To: [log in to unmask]
Subject: Copy offerings

Hi

Has anyone had issues with copying offerings since upgrading to v18?

Carol

Carol Hingston
Head of MIS
Oaklands College, St Albans Campus (Smallford), Hatfield Road, St Albans, Hertfordshire, AL4 0JA
[log in to unmask]<mailto:[log in to unmask]> | 01727737741 | 07734 707227

[Image removed by sender. Oaklands College - Take on the world]<https://www.oaklands.ac.uk/?utm_source=email-footer&utm_medium=email&utm_campaign=EmailMigration>

Follow us: [Image removed by sender. Facebook] <https://www.facebook.com/oaklandscollege/> [Image removed by sender. Linkedin] <https://www.linkedin.com/company-beta/56347/> [Image removed by sender. Instagram] <https://www.instagram.com/oaklandscollege/> [Image removed by sender. Twitter] <https://twitter.com/oaklandscollege> [Image removed by sender. YouTube] <https://www.youtube.com/user/RealOaklandsCollege>
This mail list is run by users of the ProSolution Student Management & Information System and is not directly connected with Compass Computer Consultants. Please ensure that you test any ideas provided on this list on your TRAINING SYSTEM before implementing them on your LIVE SYSTEM. The owners of this list and Compass Computer Consultants Limited accept no liability for any loss resulting from this list. Should you be unsure, please contact ProSolution Support on 01928 725522 or email [log in to unmask]

_________________________________________________________________
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately and delete the material from any computer. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the Leeds City College. The recipient should check this email and any attachments for the presence of viruses. Leeds City College accepts no liability for any damage caused by any virus transmitted by this email.

This mail list is run by users of the ProSolution Student Management & Information System and is not directly connected with Compass Computer Consultants. Please ensure that you test any ideas provided on this list on your TRAINING SYSTEM before implementing them on your LIVE SYSTEM. The owners of this list and Compass Computer Consultants Limited accept no liability for any loss resulting from this list.

Should you be unsure, please contact ProSolution Support on 01928 725522 or email [log in to unmask]