SO Windows and SOAdmin Windows - Slow start up

Hi, at a customer site SuperOffice(7.5) can take anything up to 5 minutes just to log in

We have got a copy of the db and upgraded it to 8.1 on our site and it still takes a long time to login.

I have noticed though that SOAdmin also has a long delay logging in (so it's nothing to do with the number of incomplete tasks, or the number of future appts building an invites list - which was a suggested reason for SOWin having the same delay)

The delay (in this case on SOAdmin of over 1 1/2 minutes) appears to be between these two lines in an extended logfile:

171201 10:34:13 SS               [SOAdmin.exe] Verify Lang Code 'US'. Src: SSuperOfficeIni::VerifyLangCode at SuperOfficeIni.cpp v line 1092
171201 10:35:57 SS               [SOAdmin.exe] SuperOffice Version: 8.0.6352.33, loaded from e:\SuperOffice\SuperOffice Windows on computer WEBSVR. Src: SBasicLoginController::OkButtonHdl at SBasicLoginController.cpp v line 104

Does anyone know why it seems to be taking so long on SOWin & SOAdmin to verify the language code?

Cheers James

RE: SO Windows and SOAdmin Windows - Slow start up

PS Here's the same two lines of log info but for SOWindows:

171129 10:49:42 SS               [SOCRM.exe] Verify Lang Code 'US'. Src: SSuperOfficeIni::VerifyLangCode at SuperOfficeIni.cpp v line 1140

171129 10:54:11 SS               [SOCRM.exe] Calculate SODirPath=f:\Program Files (x86)\SuperOffice7\SuperOffice Windows\SuperOffice.INI. Src: SSuperOfficeIni::InitVariables at SuperOfficeIni.cpp v line 332

Cheers James

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi James,

Long time no speak :-). This hardly seems like a developer API issue, so I'll go ahead and move this topic over to Technical forums.

BTW, I trust you have turned off "phone home" preferences as seen in this blog post.

 

Best regards!

Af: Tony Yates 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Tony,

your link points to the wrong blog post, so i'll do a search for phone home preferences - nothing to do with ET is it?

:) James

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

I doubt this has much to do with VerifyLangCode. What you are seeing is the time difference between two consecutive log points.

We may need to get this db and setup a debugger session. That will normally quickly show us what is going on.

Conrad

Af: Conrad Weyns 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi!

 

If you look in the database in productversion table, does all look correct there?

Af: Emilija Vilija Treciokaite 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

That' the correct blog post James. Statistics are "Phone Home" settings. I'm not mentioning it because I think it will solve this particular problem... only to make you aware of issues for you and SuperOffice that stem from copying and working with production databases.

Cheers!

Af: Tony Yates 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Tony,

your link points to the wrong blog post, so i'll do a search for phone home preferences - nothing to do with ET is it?

:) James

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Tony,

sorry - when you said "phone home" I thought that you meant some preference setting that related to the home country phone format and prefix!!

Doh!

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Emilija,

what exactly should I be looking for?

It all looks ok to me detailing various netserver versions and superoffice releases up to 8.1

Cheers James

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad,

that's why i asked what it does between those log points.

If it is something specific then i could look for fault in that area.

NB like I said this affects both SuperOffice Windows and SOAdmin (Windows) ate the same point during the load process so I doubt if it is anything related to the actual content of the database (companies\persons\tasks etc)

Also I'd like to point out that this problem does not affect logging in to SuperOffice Web in the slightest which logs straight in no problem

 

Cheers James

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Is the last updatePath correct? 

Which version is it connected to?

Af: Emilija Vilija Treciokaite 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Emilija,

out of all 98 entries in that table only one record has a value in the updatePath field

the value points to a server that was on the customers domain that no longer exists

and the version of SO it relates to is 7.0.4421.000 (and they are on the last released version of 7.5) and we are on 8.1

Cheers James

[edit]I tried removing that entry from the updatePath field os that it was blank - it didn't make a difference :( [/edit]

Af: James Carter 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

ProductVersion.updatePath is not a good candidate any more. We now read the productversion table before the login sequence to determine the correct action for the "Auto-Client-Update" system.

If this were SoCrm only, I'd be inclined to suspect Browser panels to urls that are not anylonger accessible.
But since it also affects SoAdmin...

My advice is to register a case with support so that we can get to debug with your database. Much faster and no guess work.

Conrad

Af: Conrad Weyns 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

ACTUALLY... since you are on 8.1 and my memory must be fainting - try this:

[Startup]
Timers=1

Add Timers=1 to your souser.ini file, in the Startup section. Make sure to use the correct file, the one that lives in \Roaming e.g.

C:\Users\cprwe\AppData\Roaming\SuperOffice\SOUSER.INI

Restart SoCrm and wait untill the app is up and running.
(If he active archive is loading, cancel it)

This should give you some extra menu items in the Personal dropdown menubutton of the Top panel.

 

Select Dump timers.

 

Should give us something interesting to look at e.g this snippet.

18:05:49:509 -- 31.671966       WinMain to Execute
18:05:49:611 -- -- 0.000003        _CallPrologs
18:05:49:611 -- -- 0.000088        SOApplication::SOApplication
18:05:49:612 -- -- 31.568909       SOApplication::Main to Execute
18:05:49:612 -- -- -- 0.007991        SOApplication::ParseCommandLine
18:05:49:620 -- -- -- -- 0.000042        SOApplication::RegisterSuperCOM
18:05:49:625 -- -- -- 4.322380        SSuperOfficeIni::SSuperOfficeIni
18:05:54:177 -- -- -- 0.011887        class SLookAndFeelManager
18:05:54:189 -- -- -- 26.989580       SOApplication::InitInstance
18:05:54:281 -- -- -- -- 11.258197       Login
18:05:54:281 -- -- -- -- -- 0.023994        SBasicLoginController::SBasicLoginController
18:05:54:287 -- -- -- -- -- -- 0.018626        SLoginDialog::SLoginDialog
18:05:54:305 -- -- -- -- -- 11.234164       SBasicLoginController::Login
18:05:57:412 -- -- -- -- -- -- 1.236347        NSSoSession::_OpenSession
18:05:58:648 -- -- -- -- -- -- 6.887919        ModalDialog::Execute
18:06:04:892 -- -- -- -- -- -- -- 0.000012        class SOPreference
18:06:04:892 -- -- -- -- -- -- -- 0.130046        SOPreference::Impl::LoadCache
18:06:05:61  -- -- -- -- -- -- -- 0.000817        class SSysEventAlerter
18:06:05:61  -- -- -- -- -- -- -- 0.289897        class SCurrentAssociate
18:06:05:61  -- -- -- -- -- -- -- -- 0.152535        class SMDOListCacheManager
18:06:05:61  -- -- -- -- -- -- -- -- -- 0.152294        class SRightsManager
18:06:05:215 -- -- -- -- -- -- -- -- -- 0.000048        class SHistoryManager
18:06:05:216 -- -- -- -- -- -- -- -- 0.000006        class SUserRoleManager
18:06:05:252 -- -- -- -- -- -- -- -- 0.063598        class SRoleFunctionRightManager
18:06:05:504 -- -- -- -- -- -- -- 0.024380        class SSysEventManager
18:06:05:540 -- -- -- -- 0.490731        class SApplicationArchives
18:06:05:540 -- -- -- -- -- 0.490675        class SArchivesConfigurations
18:06:05:540 -- -- -- -- -- -- 0.000064        SOApplication::GetSharedArchiveKeys
18:06:06:39  -- -- -- -- 15.119736       SMainOwner::Initialize
18:06:06:40  -- -- -- -- -- 0.001035        class NSArchiveProviderFactory

Show it here or send it to me.
Conrad

Af: Conrad Weyns 1. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad,

it isn't to do with the web panels (or applications) as for a test i marked all as deleted and prior to that made sure that all web panles pointed to a valid url and that the couple of deleted applications pointed to valid applications too.

I'll try the "Dump timers" and reply shortly

Cheers James

Af: James Carter 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

At support we haved solved several slow login to win client (SuperOffice v.8.xxxx) cases by putting in the correct update path in the database.

If this does not work, like Conrad suggested, you could register it as a ticket. 

Af: Emilija Vilija Treciokaite 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad, the relevant dump lines are here:

08:10:32:850 -- -- -- 94.139430       SOApplication::InitInstance

08:10:32:881 -- -- -- -- 83.478438       Login
08:10:32:881 -- -- -- -- -- 0.012147        SBasicLoginController::SBasicLoginController
08:10:32:881 -- -- -- -- -- -- 0.009675        SLoginDialog::SLoginDialog
08:10:32:897 -- -- -- -- -- 83.466271       SBasicLoginController::Login
08:10:33:928 -- -- -- -- -- -- 0.055713        NSSoSession::_OpenSession
08:10:33:990 -- -- -- -- -- -- 82.371432       ModalDialog::Execute
08:10:40:114 -- -- -- -- -- -- -- 0.000004        class SOPreference
08:10:40:114 -- -- -- -- -- -- -- 76.062799       SOPreference::Impl::LoadCache
08:11:56:191 -- -- -- -- -- -- -- 0.012804        class SSysEventAlerter
08:11:56:207 -- -- -- -- -- -- -- 0.091472        class SCurrentAssociate

If you would prefer the full dump log then you can download it from here:

https://1drv.ms/t/s!Aq1EIOMddmM_xkHKg3iM-U16cZP2

Cheers James

Af: James Carter 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi James,
Jez..Chr..!
On the one hand I am happy my Timers came to good use, but on the other hand..
How many UserPreference rows are there for your login associate?

/conrad

Af: Conrad Weyns 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad,

there are 378 rows where the Owner_id = the curently logged on user

55 of these rows are used by our own applications (prefsection=www.redcastle.co.uk)

Incidentally this same problem (slow login) is also a problem for brand new users - in fact I have been told that it is worse and can take up to 5 minutes for a new user to login on a new laptop\pc

This is a test database so if you would like me to delete all rows for a user to test login times then that will not be a problem, or even to register a brand new user

Cheers James

Af: James Carter 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad,

hang fire - i have just checked the system level preferences and there are 91,000+ records for www.redcastle.co.uk - I am going to have a word with the developer of the app that has written these.....

Af: James Carter 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Yes, the query is somewhat more complex. It looks at various default levels and owner_id.

Let me know if this is it.
If not, we may need to debug with your db if at all possible.

Conrad

Af: Conrad Weyns 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Hi Conrad,

yes - this was the problem - I verified this by deleteing all of these records out of the userpreference table on the test database and it now logins in in under 2 seconds.

I have suggested to the developer that he moves these values out into a custom table that had previously been added for another purpose and is now unused.

 

The "dump timers" option certainly did come in use :)

Cheers James

Af: James Carter 4. dec 2017

RE: SO Windows and SOAdmin Windows - Slow start up

Sound good to me :-)
Conrad

Af: Conrad Weyns 4. dec 2017