Subquery returned more than 1 value. NJ Staffing issue in SIMS.net

[Jehanzeb]

Hi all, Not sure if anyone else had this issue but I seem to have had a bizare issue since 18th Sept. I am unable to setup the new NJ Staff paygrade and associated salaries in SIMS.net ---> Tools ---> Staff ---> Pay Related ----> NJ Pay Awards (new Sept 2019 fileset .xml) does not import into SIMS.net. This is obviously affecting FMS as I am unable to import new salaries from recon files.

 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used a an expression. The statement has been terminated

It seems to me there is a duplication issue in the database but not really sure if I am correct? Has anyone else had this issue? I have raised the issue with Capita and even after over 3 weeks (nearly a month) I have had no updates apart from a phone call today saying we're looking into it and we'll give you a call tomorrow. Not something I was expecting... Anyhow, I do not want to rant here but simply wanted to know if someone else had a problem and if yes, did you manage to fix it and if you did, how? Your kind help will be highly appreciated. Kindest regards Jay.

[Jawloms]

Have you done a "Validate Memberships" and then tried again?

[Jehanzeb]

Have you done a "Validate Memberships" and then tried again?

Hi Jawloms, yep, that's a basic thing anyone would do as a first point of step. Done that, no luck (which I thought would be the case). The issue seems like we have to remove the entries from dbs for the MIS to start again. Kind regards Jay

[Jawloms]

Hi Jawloms, yep, that's a basic thing anyone should do as a first point of step.

 

FTFY

[Jehanzeb]

FTFY

Hahahaaha true!