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?
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.
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
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!
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.
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
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.
The error is gone! The second script already existed. I really appreciate your help Jonathon!!!
Great to hear Derek. Have a great day.