DB Load post-UTF8 migration throws error U00038127 Loading in upgrade mode...
Article ID: 409115
Updated On:
Products
Issue/Introduction
After running through the UTF8 migration workflow in 12.3 or 21.0 and running the FINAL SQL Statements, loading the intialdata, UC_UPD.txt with the 24.x db load throws an error:
U00038127 Loading in upgrade mode is not possible while the system is running
Environment
DB Load 24.X
Cause
The FINAL migration workflow SQL statements were run while the source system was active or a stuck record is in the MQSRV table.
Resolution
This message comes up because the database has entries in the MQSRV table with a last update time of more than 10 minutes ago using the statement:
20250826/212906.015 - U00009909 TRACE: (BINDPAR: MQSRV_Type ) 00007FFC14B24DE4 000004
00000000 08000000 >....<
20250826/212906.015 - >8<
20250826/212906.015 - U00009909 TRACE: (BINDPAR: MQSRV_LastUpdate ) 00007FFC14B24DF8 000016
00000000 E9070800 1A001500 13000600 00000000 >................<
20250826/212906.015 - >2025.08.26 21:19:06.0<
20250826/212906.015 - select * from MQSRV where MQSRV_Type != ? and MQSRV_LastUpdate > ?
or:
select * from MQSRV where MQSRV_Type != 8 and MQSRV_LastUpdate > [10 minutes previous to this db load]
Assuming the connection string in the ucybdbld.ini file is pointing to the correct (target, utf8) database and getting this error, the following can be run:
delete from mqsrv;
Then they can run the following after 2-4 minutes:
select * from mqsrv
If the select statement returns no rows, then go forward with the db load.
If the select statement DOES return rows after a few minutes, it means that you are trying to load the initialdata into a live system. If you feel like you are not loading into a live database, please open a new case Support and attach the db load and trace logs with a database=4 trace set in ucybdbld.ini
Feedback
