SYMPTOM:
In Strategy Developer 9.x, executing a report against Oracle database runs into following error:
Status: Execution failed Error: SQL Generation CompletedQueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Invalid Position. Connection String:
And it is noticed that in the fact table physical view, the SQL window contains very complicated SQL which involves lots of comments as shown below:
There are two ways to add comments into SQL, one is "/*....comments...*/", the other is "--comment". A snippet of the SQL whose comment has been highlighted is shown below:
CAUSE:
One possible cause is that too many comments in the fact table can’t be accepted by Oracle in the same time.
ACTION:
Remove the comments from fact table resolves the issue.
