Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Unknown Error when logging into 1 company after upgrade

(0) ShareShare
ReportReport
Posted on by

Upgraded from v10 to V2010R2

One company gets a window that pops up at login with nothing more than 'Unknown Error' and an OK button.  All other companies function normal at login.  Error occurs for all users, including sa.

Pressing OK allows the user to continue logging into this company and things seem to function ok.
This is a section of the Dex log.  I let the window stay on the screen for 1 minute so it was clear where the point of the error was in the log.

/*  Date: 03/15/2012  Time: 10:55:04
stmt(45853688):*/
{ CALL DYNAMICS.dbo.zDP_SY10500SS_1 ( 'sa', 4, 'POWERUSER' ) }

/*  Date: 03/15/2012  Time: 10:55:04
stmt(45853688):*/
{CALL MCPS.dbo.zDP_ReportPublishersF_1('sa',-32768,-32768,'','','sa',32767,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

at this point I press the OK button, the homepage loads as normal

/*  Date: 03/15/2012  Time: 10:56:08
stmt(45872272):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 7, 0 ) }

How do I fix this so we don't get the error?

*This post is locked for comments

  • Jonathan Fear Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    Great to hear Derek. Have a great day.

  • Community Member Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    The error is gone!  The second script already existed.  I really appreciate your help Jonathon!!!

  • Jonathan Fear Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    Here is a scripts that should fix this:

    insert into SY20020 values(-1,9,0)

    insert into SY20020 values(-1,0,0)

    The second script may fail if that record is there already but I wanted to make sure you had it just in case.

  • Community Member Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    This is a working company:

    TemplateID CMPANYID IsDefault DEX_ROW_ID

    -1 8 0 379

    9975 8 1 380

    9976 8 1 381

    9977 8 1 382

    9978 8 1 383

    9979 8 1 384

    9980 8 1 385

    9981 8 1 386

    9982 8 1 387

    9983 8 1 388

    9984 8 1 389

    9985 8 1 390

    9986 8 1 391

    9987 8 1 392

    9988 8 1 393

    9989 8 1 394

    9990 8 1 395

    9991 8 1 396

    9992 8 1 397

    9993 8 1 398

    9994 8 1 399

    9995 8 1 400

    9996 8 1 401

    9997 8 1 402

    9998 8 1 403

    9999 8 1 404

    10000 8 1 405

    This is the non-working company:

    9979 9 1 406

    9987 9 1 407

    9988 9 1 408

    9989 9 1 409

    9990 9 1 410

    9991 9 1 411

    9992 9 1 412

    9975 9 1 413

    9993 9 1 414

    9994 9 1 415

    9976 9 1 416

    9995 9 1 417

    9996 9 1 418

    9997 9 1 419

    9998 9 1 420

    9977 9 1 421

    9999 9 1 422

    9980 9 1 423

    10000 9 1 424

    9978 9 1 425

    9981 9 1 426

    9982 9 1 427

    9983 9 1 428

    9984 9 1 429

    9985 9 1 430

    9986 9 1 431  Last row in table

  • Jonathan Fear Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    Hi Derek,

    I would need to see the results that are then I could write an insert script. You may want to create a support incident to get faster results.

  • Community Member Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    I am having this problem also.  There are only 26 rows for the company getting this error and the missing row is TemplateID -1, IsDefault = 0...so how do I rebuild this table?  I have tried Checklinks on the System and Company tables, but it didn't fix the problem.

    Thank you for your help!

  • Jonathan Fear Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    This erorr is due to missing records in the SY20020 table. Run the following scripts and make sure you have 27 records per company:

    Select * from SY01500

    Select * from SY20020

  • Community Member Profile Picture
    on at
    Re: Unknown Error when logging into 1 company after upgrade

    More info:

    10:55:04 B:'CheckIfReportsNeedToBePublished'

    10:55:04 B:    'AreThereReportsToPublish()', 0

    10:55:04  'SQLPath', 3278, 8, 0, ""

    10:56:08  'SY_Error_Message OK_Button_CHG on form SY_Error_Message'

    10:56:08  'MBS_ScreenShot_Remove_Form'

    Reports were deployed same method for all companies.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans