ptotham Posted January 23, 2013 Posted January 23, 2013 I having a problem with Sims hanging/not responding when running reports for 1 of my admin users that has mandatory profiles with appdata redirect to a generic folder on our file server and redirected start menu. I have another admin user that doesn't have a profile and they can run the reports with no problems, both user have local admin rights on the PC. Can any one shed any light on what may be causing this or anyone else running mandatory profiles using sims?
Kyle Posted January 24, 2013 Posted January 24, 2013 We had a similar issue and edited the connect.ini on the users local PC. We added the line CommandTimeout=100000 and this helped, you can increase the number as you see fit.
Rawns Posted January 24, 2013 Posted January 24, 2013 We had a similar issue and edited the connect.ini on the users local PC. We added the line CommandTimeout=100000 and this helped, you can increase the number as you see fit. What version of Office are the users on? What type of reports are they running? Data intensive reports like assessment marksheets, or simple reports like class lists? Could be an issue with SIMS caching the data for the report in the tmpSimsRpt folder..
Kyle Posted January 25, 2013 Posted January 25, 2013 What version of Office are the users on? What type of reports are they running? Data intensive reports like assessment marksheets, or simple reports like class lists? Could be an issue with SIMS caching the data for the report in the tmpSimsRpt folder.. We are using Office 2010.
Rawns Posted January 25, 2013 Posted January 25, 2013 We are using Office 2010. Doh! I was meant to quote the OP!!!
Rawns Posted January 25, 2013 Posted January 25, 2013 I having a problem with Sims hanging/not responding when running reports for 1 of my admin users that has mandatory profiles with appdata redirect to a generic folder on our file server and redirected start menu. I have another admin user that doesn't have a profile and they can run the reports with no problems, both user have local admin rights on the PC. Can any one shed any light on what may be causing this or anyone else running mandatory profiles using sims? Lets try again!!! What version of Office are the users on? What type of reports are they running? Data intensive reports like assessment marksheets, or simple reports like class lists? Could be an issue with SIMS caching the data for the report in the tmpSimsRpt folder..
vikpaw Posted January 25, 2013 Posted January 25, 2013 Report creation likes the local app data folder. I think local low and is a pain with roaming profiles. Not sure what it will do with roaming. i know it helped to wipe out old xp profiles and recreate new win 7 ones. Plus make sure the office 2010 Word patches / hotfixes are installed. Someone will recall them or they are in another thread.
Cache Posted January 26, 2013 Posted January 26, 2013 If it's a standard report from Capita, it may well be worth reimporting the report definitions from the latest upgrade. We've had some weird issues before where reports run really slowly and reimporting them has fixed it (issues ranging from everybody affected, individual users affected and all buyt one user affected)
ptotham Posted January 31, 2013 Author Posted January 31, 2013 We had a similar issue and edited the connect.ini on the users local PC. We added the line CommandTimeout=100000 and this helped, you can increase the number as you see fit. il give that ago
bossman Posted January 31, 2013 Posted January 31, 2013 Just this week had an issue with printing all the staff timetables out at once, Fault code: 1151-9994-5300 error Sims Entities DatabaseException Timeout. Capita KB400750 - gives a good solution Hope this helps
ptotham Posted January 31, 2013 Author Posted January 31, 2013 What version of Office are the users on? What type of reports are they running? Data intensive reports like assessment marksheets, or simple reports like class lists? Could be an issue with SIMS caching the data for the report in the tmpSimsRpt folder.. we are using office 2010 also the reports that have been hanging so far assessment report for whole year groups where it has generate the report and then print out if the we did one student at a time it was fine. it is not a standard report from capita either.
ptotham Posted January 31, 2013 Author Posted January 31, 2013 machines are fully patched. we using WSUS at our site.
Rawns Posted January 31, 2013 Posted January 31, 2013 machines are fully patched. we using WSUS at our site. Are you using Offline File Sync for users Home drives? When this is enabled, it causes issues with caching when SIMS try's to access the tempSimsRpts folder. Also worth adding the users home drive to trusted sites. I guess it's covered by WSUS, but may be worth double checking that the Primary Interop Assemblies are installed. This hotfix works wonders at fixing odd reporting issues!
Steve21 Posted January 31, 2013 Posted January 31, 2013 Just as a generic note, there's an hotfix patch from MS for Word that fixes a lot of issues with Reports that we have. We often find it'll hang reports, or only print off 1 page then refuse to print anymore etc, and this fixed them all for us. Might be worth a shot, but might be completely different issue for you word2010-kb2553912-fullfile-x86-glb.exe Steve
Rawns Posted January 31, 2013 Posted January 31, 2013 Just as a generic note, there's an hotfix patch from MS for Word that fixes a lot of issues with Reports that we have. We often find it'll hang reports, or only print off 1 page then refuse to print anymore etc, and this fixed them all for us. Might be worth a shot, but might be completely different issue for you word2010-kb2553912-fullfile-x86-glb.exe Steve I was going to add this to my post too as likewise we apply it and it fixes a lot of odd issues with reports not printing correctly, but assumed it would be covered by WSUS.
Steve21 Posted January 31, 2013 Posted January 31, 2013 I was going to add this to my post too as likewise we apply it and it fixes a lot of odd issues with reports not printing correctly, but assumed it would be covered by WSUS. Generally not all hotfixes are always deployed properly through Windows update though, but not sure if that one is or not. At least it's not here, but it may have just be sitting waiting for authentication who knows! Steve
ptotham Posted January 31, 2013 Author Posted January 31, 2013 Are you using Offline File Sync for users Home drives? When this is enabled, it causes issues with caching when SIMS try's to access the tempSimsRpts folder. Also worth adding the users home drive to trusted sites. I guess it's covered by WSUS, but may be worth double checking that the Primary Interop Assemblies are installed. This hotfix works wonders at fixing odd reporting issues! we are not using offline file sycn, when you say adding user home drives as trusted sites where do you mean for setting that?(sorry if being thick) I have the KB number for a word patch going to check my wsus server and local machines and if it not applied give it a try.
Rawns Posted January 31, 2013 Posted January 31, 2013 we are not using offline file sycn, when you say adding user home drives as trusted sites where do you mean for setting that?(sorry if being thick) I have the KB number for a word patch going to check my wsus server and local machines and if it not applied give it a try. In Word: File | Options | Trust Center | Trust Center Settings | Trusted Locations Tick "Allow trusted locations on my network (not recommended)" then "Add New Location". Pick the users home drive, tick "Subfolders of this location are also trusted" and OK.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now