Q&A BY TAG 'Invalid query in create base view from query'

You must sign in to ask a question. If you do not have an account, you can register here

On base views created from query with parameters-how can we pass the parameters from a subquery in where statement
answered 14-06-2022 05:57:06 -0400

I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...

Answers: 3

Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery

I can able to execute the table but unable execute the specific column of the table
answered 04-01-2021 05:51:58 -0500

I can able to execute the table but unable execute the specific column of the table. error message Finished with error: Field not found 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001.start_date' in view 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CH...

Answers: 1

Invalid query in create base view from query DENODO

Base view deployed even though table not present in database
answered 27-03-2020 12:22:06 -0400

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

Answers: 1

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

Invalid Query because of Oracle REGEXP_LIKE pattern
answered 03-03-2020 04:40:24 -0500

Hi, I am trying to create a base view from query with below sql syntax. However it is failiing with invalid query so i came to know that it is because of '<(1\d{3}(.\d+)?)+>'). Now i tried escaping { and } with '\' but still no success. i am ...

Answers: 1

Invalid query in create base view from query