unsupported version of oracle database in ewa

[Former Member]

hi sap experts,

When going through my ewa report, i'm getting the following issue, which is showing

"Unsupported Oracle Release"

I also notice that on the database part, the current version of Oracle is missing? We have Oracle version 10.

please help me!

[Former Member · Accepted solution]

Hello Jessica,

I've seen this issue many times and the way it will definately get resolved is by doing a full service definition refresh. Please follow SAP Note 727998 to do this completely. Please complete this first on your Solution Manager system and once completed, do the same on the Satellite system.

Please note that there are 3 steps in the service definition refresh & they are:

- Delete the Service Definition

- Refresh the Service Definition

- Regenerate the Service Definition

Note 727998 will outline all the steps required to have this happen.

Once you have completed this, please re-generate the EWA report in question to ensure that the problem is resolved.

Hope this helps you out!

Thanks,

Mark

[Former Member · Accepted solution]

wow thanks for the fast reply. i will try this and hope it resolves my problem and will let you know. thanks Mark

[Former Member · Accepted solution]

mark - i have a couple of questions in regards to the note that you have given me. i hope you can help me out. how do i check if d010inc stats are up to date or not? as well, how do i delete all the entries in the service definition tables? would you know how long this process may take? thanks a bunch

[Former Member · Accepted solution]

Hello Jessica,

I'll try to answer the questions that you brought up.

1. You can use Transaction Code DB20 to enter the table D010INC and then check the statistic by clicking on the 'refresh' option.

2. Run report BDL_DELETE_ALL_TABLES via SE38 to delete all entries in the service definition tables.

3. All varies. When you do this, just go through the Solution Manager, and in the SDCCN logs, you can see once it has been completed. Once you see that the Delete & Refresh have been completed in the SDCCN (SOLMAN) done logs, then you can go ahead and start it on the Satellite system.

Thanks,

Mark