Can't Generate the CENSUS return file

[Sonic3]

Sorry to post in an old thread but I'm having no luck finding a solution to this one. It just started happening yesterday for seemingly no reason at all; exactly like the OP says. I've checked folder/file permissions but can't see anything wrong. Does anyone know how we might fix the issue?

[bfelton]

Might be a weird suggestion but make sure that your screen scaling is set to 100%, sometimes that can stop the census working.

[Sonic3]

Might be a weird suggestion but make sure that your screen scaling is set to 100%, sometimes that can stop the census working.

 

Thanks for the suggestion. The member of staff trying to generate the return is using a dual monitor/extended desktop setup, but no display scaling. I tried disabling the 2nd monitor just in case it's that but no luck

[CommodoreS]

Possibly also unrelated but we had a problem with the Segoe UI font in windows becoming corrupt after a recent update. Replacing it from a working PC resolved the issue.

[lollettuk]

For anyone search for an answer to this old problem - We just had this with one of our schools getting "Could not find file ....\census_output.xml" quickly flashing at the bottom of sims.

 

Every time we run a create and validate census it wrote the following error to c:\users\[username]\SREngine.log (might sometimes save to c:\program files (x86)\SIMS\SIMS .net\ folder).

 

----- SREngine.exe exception raised 06/10/2021 at 13:32:33

Message : Could not find stored procedure 'sims.sre_pix_datapackage_census_GetFamDetails'.

Source : .Net SqlClient Data Provider

StackTrace :

at SIMS.Processes.Database.RetrieveDataSet(IDbCommand command, Boolean AsCP320)

...

------------------- Additional Data (as key/value pairs) -------------------

...

-------------------------- Parameters passed to SREngine.exe --------------------

...

------------------------------- End of Exception --------------------------------

 

When compared to other SIMS databases this stored procedure was indeed missing from the SQL database.

 

 

Problem was due to SIMS Summer 2021 - Consolidated Workstation Patch 1

This comes in two parts - "SIMS .Net client update files" and the "database patch".

 

The clients had been updated to 7.200.35.1

But the database patch hadn't been applied for some reason.

 

Note: SIMS doesn't seem to whinge "database mismatch" for these consolidated workstation patches.

 

So applying the database patch and re-running the create and validate census then worked