Finsql.exe APPCRASH on company open by specific user

Pinkycz

Hi all,

I'm facing quite weird behaviour of a database that has recently been moved from one SQL server to another. The test has been fine and all working so we move dthe production database. The old server is 2003 and new 2012, yet enoding of databases, server locale etc. is set identically.
The problem started with only on eaccount, notably mine "admin" account. My regular user account and other users can open th edatabase correctly.

At the company open the finsql crashes with the following details.

Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	finsql.exe
  Application Version:	6.0.32012.0
  Application Timestamp:	4d030bb8
  Fault Module Name:	finsql.exe
  Fault Module Version:	6.0.32012.0
  Fault Module Timestamp:	4d030bb8
  Exception Code:	c0000005
  Exception Offset:	00162276
  OS Version:	6.1.7601.2.1.0.16.7
  Locale ID:	1029

Additional information about the problem:
  LCID:	1033

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  X:\Windows\system32\en-US\erofflps.txt

The locale ID seem to be grabbed from the user profile setting, tried various locale setup and it is crashing even when the two LCID are identical 1033.

Tried to catch the error and it seem to be the in Company open trigger of CU1.

There see, to be a custom modification in there

IF GUIALLOWED THEN
  LogInStart;

// - PRF005
IF USERID <> '' THEN
  IF UserSetup.GET(USERID) THEN
    IF UserSetup."Main Menu ID" <> 0 THEN
      FORM.RUN(UserSetup."Main Menu ID");

And it is the line
IF UserSetup."Main Menu ID" <> 0 THEN

crashing the app. The admin account is not even existing in the user setup table! So it appears as an wrong code as it should never get to that line.... strange engough exactly the same code exist in 3 other databases, the admin account doe snot exist in th euser setup table of those databases either and I can oen company fine, no crash??


What could be the problme here, any ideas please?? #-o

Albertvh

Hi Pinkycz,

I think that the field name Main Menu ID existed in pre 4 Nav
It no longer exists.

See if you can login with another user and check if this field is in your User Setup table, perhaps you only dd a technical upgrade.

This functionality was used to put users onto a form selected in that field, they never got to the Main Menu.

Hope this helps.

Pinkycz

Hi Albertvh,

yes the field exist... seem to be a custom field and refering to the same modification that is referred in th etrigger.. And other users (those who have their ID listed in User Setup table and even those who do not) can login fine... it is just my admin account that is crashing

Enabled Field No. Field Name Data Type Length Description
Yes 50000 Main Menu ID Integer PRF005

Albertvh

Hi Pinkycz,
Ok check if there is a value in that field and if so see if a form with that id exists, if not make this value zero.

Pinkycz

No, there is no record matching that userID in the USer Setup table so it should not find enything there... All other user accounts have this filed not updated, everyone has 0 there and all these people log in normally...

I commented out the whole code now and still getting the crash when leaving the trigger...

:shock: :shock: :shock:

Pinkycz

Problem resolved... not really sure WHAT was causing this, but this is what I did and it worked.
Remove the user id under which the app is crashing
Sync the security
Add the ID again, add roles
Sync security

Voila... now all works fine again...

[-o<