Database view 'sn_itom_pattern_amazon_cloud_database' throws error on Oracle instances


Description

Database view 'sn_itom_pattern_amazon_cloud_database' throws error on Oracle instances:
Syntax Error or Access Rule Violation detected by database (ORA-00904: "CDB"."SYS_ID": invalid identifier)

Steps to Reproduce

- In an OOB instance running on Oracle
- Activate the plugin sn_itom_pattern [Discovery and Service Mapping Patterns version 1.0.70 N,O,P)
- Search and open the database view 'sn_itom_pattern_amazon_cloud_database'
- Click the 'Try' related link

You will get the following error:
Syntax Error or Access Rule Violation detected by database (ORA-00904: "CDB"."SYS_ID": invalid identifier)

Workaround

• in oracle database rel.parent=sv.sys_id is not working but works fine in mysql instances.
• Where clause should be like this rel_parent=sv_sys_id in order for query to work.

  1. Open the database view details.
  2. Go to ViewTables.
  3. Check the where clause column should not contain .(dot)

Fix:

replace .(dot) with _(underscore)

Example:

rel.parent=sv.sys_id  ===> rel_parent=sv_sys_id 


Related Problem: PRB1472280