Oracle profiler ingestion returns invalid identifier error

[vithushanms]

Affected module When I do the profiler ingestion with Oracle DB, I am getting the following error

Describe the bug The issue is with the query being generated. The following column name has to be wrapped within quotes, but here the quotes are missing in the OM query.

You can see the same query working after I added the double qoutes.

Version:

• OS: ubuntu
• Python version: 3.8
• OpenMetadata version: tested in both 1.2.5 and 1.3.1
• OpenMetadata Ingestion package version: 1.2.5

[vithushanms]

Are there any updates on this team?

[harshach]

@TeddyCr can you review this

[sushi30]

@vithushanms can you provide a DDL for the failing table?

[ayush-shah]

We are not able to reproduce this error, if @vithushanms can provide the DDL, that would be great, we will validate the same and open the issue if reproduced, till then, closing this issue.

EDIT: Also, @vithushanms can you try the same if it can be reproduced in the latest version of OM.