3 Replies Latest reply on Sep 9, 2018 7:40 AM by Glen Conway

Unable to change DBID for AWR/ASH reports

SirajGulam Sep 8, 2018 3:35 PM

Hi -

I am using SQL Developer 18.2 (64-bit) on Windows-7 Ultimate. I am unable to change DBID for running an ASH/AWR report (when DB ID is more than 9 numbers long).

Assuming this is because it is not supported as per certification matrix. Does anyone have a way to make this work? Well, I tried 32-bit version (which should be supported), but it is still the same.

Regards

Siraj

1. Re: Unable to change DBID for AWR/ASH reports

Glen Conway Sep 8, 2018 4:25 PM (in response to SirajGulam)

You may have found a new bug if it only involves dbids of more than 9 digits.

Here are some prior (but unanswered or not fully answered) discussions regarding AWR/ASH dbids:
Replace Older version report in new version
ASH Report Viewer and multiple dbids
LOV Missing while generating AWR from SQL Developer
Can generate AWR with SQL Developer

You should describe exactly what you are doing and add a screen shot so all can see what you are seeing.
Like Show 0 Likes(0)

Actions
2. Re: Unable to change DBID for AWR/ASH reports

SirajGulam Sep 8, 2018 6:00 PM (in response to Glen Conway)

Hi

I am having the exact problem as stated in the thread:

ASH Report Viewer and multiple dbids

As in the screenshot, I am unable to change DBID to correct one for running an ASH report, but I can change to the first 3 perhaps because they are 9 numbers long..
Like Show 2 Likes(2)

Actions
3. Re: Unable to change DBID for AWR/ASH reports

Glen Conway Sep 9, 2018 7:40 AM (in response to SirajGulam)

Hopefully someone on the development team will see this and comment / log a bug. Otherwise, if you are able, log an SR with MOS.
Like Show 0 Likes(0)

Actions

Go to original post