Hi
@KAI DINGThanks for pointing me to the -964 sql error. I have increased the log space in the repo db.
Note: I did not find any where the logs and db parameters required in DMC documentation for the repository db. That's why it was unset.
I now used the recommendations from DSM docs, and have increased the log space. hope this will be enough.
Do you still hit the "-404" error in home page after console restart? And is the "internal error" message gone?After increasing the logs in the repo, I have restarted DMC, but still receiving -401 error
:11090/dbapi/v4/internal/users/roles:1 Failed to load resource: the server responded with a status of 401 (Unauthorized)
TEXTLOG 12:53:28 [INFO] [EventService] - token expired or logged out
:11090/dbapi/v4/internal/settings_ext:1 Failed to load resource: the server responded with a status of 401 (Unauthorized)
and the issue should be specific in your env.Well, this was working exactly fine with DMC 3.1.0 . Same server, same repo, same everything, just DMC got updated to 3.1.1 release.
I can accept that it could be something in my env, but not being able to identify it.
What else I can do, or what else I can provide you in order to troubleshoot this ?
Regards
------------------------------
Samuel Pizarro
------------------------------
Original Message:
Sent: Wed February 12, 2020 10:44 PM
From: KAI DING
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi Samuel,
We've re-validated the upgrade scenario just as you described, and it works well. So the process should be fine, and the issue should be specific in your env.
Do you still hit the "-404" error in home page after console restart? And is the "internal error" message gone?
Also in your logs I find a lot of "Db2 -964 transaction log full" error. It would make monitor functionality down. Please consider to fix it and restart Db2 if necessary. thanks.
------------------------------
KAI DING
Original Message:
Sent: Tue February 11, 2020 05:54 AM
From: KAI DING
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi Samuel,
Thanks for your update. We are investigating the issue, and will let you know the update. thanks.
------------------------------
KAI DING
Original Message:
Sent: Mon February 10, 2020 12:09 PM
From: Samuel Pizarro
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi @KAI DING
Yes, that was the log I have provided... from Console output , in developer tools.
but here is a new picture of it..
2) I have described my upgrade scenario, in other thread in this forum .
Basically, my original 3.1.0 setup was done by windows GUI installer, and we have no option to upgrade that. The only option is by script-installer interface. So, when the zip was extracted in the original setup. none of the files got replaced, as they dir layout does not match.
so, when setup of 3.1.1 was executed, it performed a clean-setup instead of upgrading.
Later on, when I first activated DMC and logged in, it prompted me to setup the repository (so it really did not detect the previous one during the upgarde). when I pointed my original repository, it asked me something like this :
"The repository was used by a previous version of DMC, do you want to keep existing setup, or start a fresh new ? "
I asked to preserve the settings
since them, monitor is not working properly.
I have stopped and restarted DMC one more time today. and now it looks it wrote somehing to the logs...
I have uploaded them logs.zip
Regards
------------------------------
Samuel Pizarro
Original Message:
Sent: Sun February 09, 2020 08:30 PM
From: KAI DING
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi Samuel,
1) About "Developer Tools", I mean the browser tool which can show all HTTP requests in browser. Take Chrome as an example: View -> Developer -> Developer Tools. The purpose is to find out which HTTP request caused the "Internal Errors" shown in page.
2) About the empty files, seems DMC is not working as expected, and it may be related to the DMC upgrade. Could you provide more details about how you did the upgrade, and was there anything wrong during the upgrade?
------------------------------
KAI DING
Original Message:
Sent: Fri February 07, 2020 07:11 AM
From: Samuel Pizarro
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi @KAI DING
1. I am not sure what part of "Developer Tools" section details you want.. I hope it`s the console log. I have saved the console output. Please, let me know if this is not what you are looking for, and provide more details on how to get it. I have uploaded the file in this post.
2. The "monitor.*" files are all empty. here is the current log files inside logs subdir
PS C:\IBM_DB2_DMC\ibm-datamgmtconsole\logs> dir Directory: C:\IBM_DB2_DMC\ibm-datamgmtconsole\logsMode LastWriteTime Length Name---- ------------- ------ ----d----- 06/02/2020 09:53 ffdc-a---- 06/02/2020 09:32 0 admin.0-a---- 06/02/2020 09:32 0 admin.0.lck-a---- 06/02/2020 17:03 0 alert.0-a---- 06/02/2020 09:32 0 alert.0.lck-a---- 06/02/2020 17:03 10518184 alert.1-a---- 06/02/2020 09:31 0 console.log-a---- 06/02/2020 09:33 225 console.token-a---- 06/02/2020 09:33 695 DS_System.0-a---- 06/02/2020 09:32 84535 DS_System.0.1-a---- 06/02/2020 09:32 0 DS_System.0.1.lck-a---- 06/02/2020 09:33 695 DS_System.0.2-a---- 06/02/2020 09:32 0 explain.0-a---- 06/02/2020 09:32 0 explain.0.lck-a---- 06/02/2020 09:33 233 integration.token-a---- 06/02/2020 09:33 0 LOAD.0-a---- 06/02/2020 09:33 0 LOAD.0.lck-a---- 06/02/2020 09:31 0 messages.log-a---- 06/02/2020 09:32 0 monitor.0-a---- 06/02/2020 09:32 0 monitor.0.lck-a---- 06/02/2020 09:48 0 repoUtil.0-a---- 06/02/2020 09:48 0 repoUtil.0.lck-a---- 06/02/2020 09:32 0 runsql.0-a---- 06/02/2020 09:32 0 runsql.0.lck-a---- 06/02/2020 09:33 0 sample.0-a---- 06/02/2020 09:33 0 sample.0.lck-a---- 06/02/2020 09:33 1045 setup.0-a---- 06/02/2020 09:33 170 setup.0.1-a---- 06/02/2020 09:32 0 tuning.0-a---- 06/02/2020 09:32 0 tuning.0.lck
Do you want them all ?
------------------------------
Samuel Pizarro
Original Message:
Sent: Thu February 06, 2020 09:39 PM
From: KAI DING
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi Samuel,
Could you please help to provide following info? thanks.
1) Please open browser "developer tools", and refresh the summary page again, so that to locate which request caused the error;
2) The detailed error log may be found in "monitor.*" log files, please help provide the info (in the same folder as DS_System.*).
------------------------------
KAI DING
Original Message:
Sent: Thu February 06, 2020 02:56 PM
From: Samuel Pizarro
Subject: An Internal error occours - summary page not working after upgrading to 3.1.1
Hi DMC team
Have just upgraded DMC to 3.1.1, after re-connecting to my existing previous repository db, getting this error in the summary page.
------------------------------
Samuel Pizarro
------------------------------
#Db2