[sims] Subquery returned more than 1 value

[Cazab]

Hello, first time poster just recently landed a job in Education IT support with 3 primaries.

Not the most familiar with how SIMS works and creating/running reports, but a member of staff is getting this error when trying to run a report in SIMS

 

http://servicedesk.bourneeducationtrust.co.uk:8080/inlineimages/WorkOrder/17330/0.png

 

This I think appears to be an issue with how they are the configuring the report or am I wrong? Is it user error?

 

I am waiting for them to send details of what exactly the parameters they are using for the report.

The only other instance on here mentions a resolution involving reinstalling SQL-Server, which I'd rather not have to do.

 

Any help would be appreciated, thank you for your time.

[blueday]

According to KB109424 in the Capita MyAccount knowledge base:

 

This is caused by incorrect Regional Settings on the affected machine. Go to Control Panel > Region and Language. In the Formats tab set the format to 'English (United Kingdom)'.

In the Location tab set the current location to 'United Kingdom'. In the Keyboards and Languages tab click 'Change Keyboards. In the General tab set the default input language to 'English (United Kingdom)'.

[Cazab]

Thank you for your reply.

I had checked as it was suggested in a historical thread regarding this issue, and everything was as set to UK. I mean it ought to be as these settings are managed centrally.

The problem is just one report that can't be run.

It is: Reports -> Attendance -> Whole group pupil reports -> Persistent Absence report - student threshold

Running it for other year groups it works however one specific one - Reception - it fails with the above error.

 

Tried it on different computers under different users & SIMS users with the same result.

Capita suggested exactly the same as you.

Me no understand-y!

Edited February 13, 2019 by Cazab

[bfelton]

Here's an odd suggestion... Check that no students in Reception have a strange character in any of their names.

[blueday]

Ah, the solution I suggested was for running reports from SIMS Reporting. For built in reports, it could well be strange characters, or strange dates. You could try another Capita KB suggestion:

 

In SIMS.net run Tools | Validate Memberships and Tools | System Diagnostics | Database Diagnostics.

 

If the issue persists then you will need to run Tools | System Diagnostics | Database Diagnostics first. Then, run Tools | Validate Memberships afterwards.

[Cazab]

Thank you, I shall have a look!

Apologies for my undefined specifics of the issue.

I've narrowed it down to a specific class within this year group that is returning this error.

2/3 classes run it fine, then this third one the error occurs.

Edited February 13, 2019 by Cazab

[Esteban_Child_of_the_Sun]

Run the report for individuals in that class until you find the offending record.

[Cazab]

You beautiful human bean, thank you for your time.

Also found the offending two records.

 

Thank you!

[evarley79919]

Hello,

 

Also having the same issue and have identified the tutor group which has 2 students with hyphenated names one first name one surname could this be the issue?

 

I cannot find how to run the report for individuals in the tutor group to identify exactly which record it is please can you advise?

[DaveA]

Sorry for bring back an old thread but I am now getting the same error on the same SIMS report and I was just wondering if you can remember how you tracked down the issue and fixed it.

 

Thanks

Dave