You can translate the question and the replies:

Error while retrieving data from element_metadata() procedure

Need to extract data from **element_metadata()** procedure. I'm getting below error while executing this procedure. ``` __P__S_NULL_79531090828947838643116096234859310357981553095826998064586988454878675543788_2743334557 [PROJECTION] [ERROR] ELEMENT_METADATA [STORED_PROCEDURE] [ERROR] ELEMENT_METADATA [STORED PROCEDURE] [ERROR] Received exception with message 'com.denodo.vdb.engine.storedprocedure.StoredProcedureException' ``` Query Used: ``` select distinct a.database_name as database_name, 'Where Clause' as Expression_Type, b.`where` as expression from (select distinct met.database_name,met.view_name, 'view' as element_type From CATALOG_METADATA_VIEWS() met where b.view_type = 1) a inner join (SELECT * FROM element_metadata()) b on ( a.database_name = b.`database` AND a.view_name = b.element AND a.element_type = b.element_type) where a.database_name = <Database Name> and b.`where` is not null ``` Kindly help me with this. Let me know incase you need any details. Denodo version : 7.0
user
26-02-2021 00:00:52 -0500
code

2 Answers

Hi, I tested your query it works fine for me with no error, please make sure that the virtual database exists in the environment you are querying against. If the issue persists, please export and attach the VQL of your virtual database to analyze further. Hope this helps!
Denodo Team
26-02-2021 09:40:45 -0500
code
This was working fine for me intially. I started getting this error few days later. Unable to export the database with dependencies due to access restrictions. Kindly create an base view with query(using above query mentioned) after creating data source pointing to any of the denodo instance. Kindly let me know incase you need any details.
user
28-02-2021 23:58:09 -0500
You must sign in to add an answer. If you do not have an account, you can register here