oi9 all-in-one-8.0.8 to 9.2 (OpenInsight 32-bit)
At 27 MAY 2022 09:21:19PM Barry Stevens wrote:
I have converted a 8.0.8 system to OI9.4
One of the upgrades in that progressive path was the "all in one 8.0.8 to 9.2."
This upgrade showed error in the upgrade log.
I carried on with the rest of the version updates to 9.4 and the system appears to run ok. BUT!
Anyway here is the log with some weird errors.
Any advice as to what I should do would be welcome.
Upgrade Log
Started: 10:48:05 27 MAY 2022
Create Table failed in line 8
Create Table failed in line 9
Create Table failed in line 10
Create Table failed in line 11
Create Table failed in line 12
Create Table failed in line 13
Create Table failed in line 14
Create Table failed in line 15
Create Table failed in line 16
Create Table failed in line 17
Create Table failed in line 18
Create Table failed in line 19
Create Table failed in line 20
Create Table failed in line 21
Create Table failed in line 22
Create Table failed in line 23
Create Table failed in line 24
Create Table failed in line 25
Create Table failed in line 26
Create Table failed in line 27
Create Table failed in line 28
Create Table failed in line 29
Create Table failed in line 30
Create Table failed in line 31
Create Table failed in line 32
Create Table failed in line 33
Create Table failed in line 34
Create Table failed in line 35
Error (401) opening the "DICT.CUSTOMERS" file in line 93
Error (401) opening the "DICT.CUSTOMERS" file in line 94
Error (401) opening the "DICT.CUSTOMERS" file in line 95
Error (401) opening the "DICT.PRODUCTS" file in line 405
Error (401) opening the "DICT.PRODUCTS" file in line 406
Error (401) opening the "DICT.SYSCODETEMPLATES" file in line 418
Error (401) opening the "DICT.SYSCODETEMPLATES" file in line 419
Error (145) opening the "DICT.SYSPTRS" file in line 437
Error (145) opening the "DICT.SYSPTRS" file in line 438
Error (145) opening the "DICT.SYSPTRS" file in line 439
Error (145) opening the "DICT.SYSPTRS" file in line 440
Error (145) opening the "DICT.SYSPTRS" file in line 441
Error (145) opening the "DICT.SYSPTRS" file in line 442
Error (401) opening the "DICT.SYSU2PROCS" file in line 508
Error (100) reading upgrade row "AUTHORIZE_PROC" in line 669
Error (100) reading upgrade row "BROWSERS" in line 670
Error (100) reading upgrade row "CODES_COUNTRIES" in line 673
Error (100) reading upgrade row "CODES_MF" in line 674
Error (100) reading upgrade row "CODES_ONOFF" in line 675
Error (100) reading upgrade row "CODES_STATES" in line 676
Error (100) reading upgrade row "CODES_TF" in line 677
Error (100) reading upgrade row "CODES_YN" in line 678
Error (100) reading upgrade row "CORE" in line 679
Error (100) reading upgrade row "CORE.LOCAL" in line 680
Error (100) reading upgrade row "CORE.ONLINE" in line 681
Error (100) reading upgrade row "DEFAULT" in line 682
Error (100) reading upgrade row "DEFAULT.REV" in line 683
Error (100) reading upgrade row "DEFAULT.WEBOI" in line 684
Error (100) reading upgrade row "DETECT_SCRIPT" in line 685
Error (100) reading upgrade row "FILES" in line 686
Error (100) reading upgrade row "FILTER_PROC" in line 687
Error (100) reading upgrade row "FOCUSDELAY" in line 688
Error (100) reading upgrade row "MENUDIR" in line 689
Error (100) reading upgrade row "O4WREPORT_DYNAMIC" in line 690
Error (100) reading upgrade row "O4WVERSION" in line 691
Error (100) reading upgrade row "PERMDEFS" in line 692
Error (100) reading upgrade row "STANDARD_CODES" in line 693
Error (100) reading upgrade row "STANDARD_SCRIPTS" in line 695
Error (100) reading upgrade row "TEMPLATEDIRECTORY" in line 696
Error (401) opening the "SYSCODETEMPLATES" file in line 799
Error (401) opening the "SYSCODETEMPLATES" file in line 800
Error (401) opening the "SYSCODETEMPLATES" file in line 801
Error (401) opening the "SYSCODETEMPLATES" file in line 802
Error (401) opening the "SYSCODETEMPLATES" file in line 803
Error (401) opening the "SYSCODETEMPLATES" file in line 804
Error (401) opening the "SYSCODETEMPLATES" file in line 805
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*AUTHORIZE_PROC" in line 3854
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*BROWSERS" in line 3855
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_COUNTRIES" in line 3857
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_MF" in line 3858
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_ONOFF" in line 3859
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_STATES" in line 3860
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_TF" in line 3861
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CODES_YN" in line 3862
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CORE" in line 3863
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CORE.LOCAL" in line 3864
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*CORE.ONLINE" in line 3865
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*DEFAULT" in line 3866
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*DEFAULT.REV" in line 3867
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*DEFAULT.WEBOI" in line 3868
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*DETECT_SCRIPT" in line 3869
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*FILES" in line 3870
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*FILTER_PROC" in line 3871
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*FOCUSDELAY" in line 3872
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*MENUDIR" in line 3873
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*O4WREPORT_DYNAMIC" in line 3874
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*O4WVERSION" in line 3875
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*PERMDEFS" in line 3876
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*STANDARD_CODES" in line 3877
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*STANDARD_SCRIPTS" in line 3879
Error (100) reading upgrade row "SYSPROG*CONFIG*O4W*TEMPLATEDIRECTORY" in line 3880
Error (401) opening the "SYSU2PROCS" file in line 7754
Error (401) opening the "SYSU2PROCS" file in line 7755
Error (401) opening the "SYSU2PROCS" file in line 7756
Error (401) opening the "SYSU2PROCS" file in line 7757
Error (401) opening the "SYSU2PROCS" file in line 7758
Error (401) opening the "SYSU2PROCS" file in line 7759
Error (401) opening the "SYSU2PROCS" file in line 7760
Error (401) opening the "SYSU2PROCS" file in line 7761
Error (401) opening the "SYSU2PROCS" file in line 7762
Error (401) opening the "SYSU2PROCS" file in line 7763
Error (401) opening the "SYSU2PROCS" file in line 7764
Error (401) opening the "SYSU2PROCS" file in line 7765
Error (401) opening the "SYSU2PROCS" file in line 7766
Error (401) opening the "SYSU2PROCS" file in line 35
Error (401) opening the "DICT.CUSTOMERS" file in line 38
Error (401) opening the "SYSU2PROCS" file in line 203
Error (401) opening the "SYSU2PROCS" file in line 385
Error (401) opening the "DICT.CUSTOMERS" file in line 1129
Error (401) opening the "SYSCODETEMPLATES" file in line 1398
Error (401) opening the "SYSU2PROCS" file in line 1848
Error (401) opening the "SYSCODETEMPLATES" file in line 1893
Error (401) opening the "SYSU2PROCS" file in line 1950
Error (401) opening the "DICT.PRODUCTS" file in line 1971
Error (401) opening the "SYSU2PROCS" file in line 2084
Error (401) opening the "DICT.SYSCODETEMPLATES" file in line 2098
Error (401) opening the "SYSU2PROCS" file in line 2414
Error (401) opening the "SYSU2PROCS" file in line 2955
Error (145) opening the "DICT.SYSPTRS" file in line 2959
Error (145) opening the "DICT.SYSPTRS" file in line 3035
Error (401) opening the "SYSCODETEMPLATES" file in line 3529
Error (401) opening the "SYSU2PROCS" file in line 3566
Error (401) opening the "SYSU2PROCS" file in line 3737
Error (401) opening the "SYSU2PROCS" file in line 3863
Error (145) opening the "DICT.SYSPTRS" file in line 4161
Error (145) opening the "DICT.SYSPTRS" file in line 4224
Error (145) opening the "DICT.SYSPTRS" file in line 4847
Error (401) opening the "SYSCODETEMPLATES" file in line 5065
Error (401) opening the "SYSU2PROCS" file in line 5145
Error (145) opening the "DICT.SYSPTRS" file in line 5623
Error (401) opening the "SYSU2PROCS" file in line 5703
Error (401) opening the "DICT.SYSU2PROCS" file in line 5738
Error (401) opening the "SYSCODETEMPLATES" file in line 6678
Error (401) opening the "SYSCODETEMPLATES" file in line 7018
Error (401) opening the "SYSCODETEMPLATES" file in line 7243
Error (401) opening the "DICT.SYSCODETEMPLATES" file in line 7337
Error (401) opening the "DICT.CUSTOMERS" file in line 7342
Error (401) opening the "DICT.PRODUCTS" file in line 7520
Finished: 10:48:55 27 MAY 2022
At 29 MAY 2022 02:43AM Donald Bakke wrote:
Anyway here is the log with some weird errors.
Any advice as to what I should do would be welcome.
Was the EXAMPLES application removed from the original 8.0.8 application? Or was SYSPROG.DBT and/or EXAMPLES.DBT modified?
At 29 MAY 2022 06:01PM Barry Stevens wrote:
Anyway here is the log with some weird errors.
Any advice as to what I should do would be welcome.
Was the EXAMPLES application removed from the original 8.0.8 application? Or was SYSPROG.DBT and/or EXAMPLES.DBT modified?
EXAMPLES was removed
Not aware of any SYSPROG change.
At 29 MAY 2022 07:27PM Donald Bakke wrote:
Anyway here is the log with some weird errors.
Any advice as to what I should do would be welcome.
Was the EXAMPLES application removed from the original 8.0.8 application? Or was SYSPROG.DBT and/or EXAMPLES.DBT modified?
EXAMPLES was removed
Not aware of any SYSPROG change.
I think it is easy to explain half of those errors on the missing EXAMPLES application and I suspect the other errors are similarly related, but not relevant. There might be some missing entities as a result but I don't think your application needs them. That said, I have never had an all-in-one upgrade work perfectly. There has always been something that is amiss so I've become accustomed to upgrading one version at a time
At 29 MAY 2022 07:32PM Barry Stevens wrote:
Anyway here is the log with some weird errors.
Any advice as to what I should do would be welcome.
Was the EXAMPLES application removed from the original 8.0.8 application? Or was SYSPROG.DBT and/or EXAMPLES.DBT modified?
EXAMPLES was removed
Not aware of any SYSPROG change.
I think it is easy to explain half of those errors on the missing EXAMPLES application and I suspect the other errors are similarly related, but not relevant. There might be some missing entities as a result but I don't think your application needs them. That said, I have never had an all-in-one upgrade work perfectly. There has always been something that is amiss so I've become accustomed to upgrading one version at a time
Thank you.
I have never had an all-in-one upgrade work perfectly.Total agree