Get 00934 error when optimizing sql statement (4317529)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Get 00934 error when optimizing sql statement
Description

When optimizing SQL statement we are getting an error in Vfactoring error 00934 and the process stop
Resolution

Here what we found. The query has a subquery. If you uncheck the option 'Remove subqueries' then it'll work. For some reason, when that option is set, the query is getting reformatted incorrectly, which is causing the error.
We created a bug ID for this: Bug ID TOR-2632
PS. If you turn off the refactoring option, then it will work. Maybe an option for you.
Defect ID

TOR-2632

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title