SYMPTOM:
After Metadata and Warehouse for Tutorial Project are moved to Oracle 12c database using Project mover in Strategy 10.2, when report "Performance by Store" in Strategy Tutorial Project is executed, the error message pops out, as showed below.
Error: SQL Generation CompleteQueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQL ExecDirect. [42000:923: on SQLHANDLE][Strategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-00923: FROM keyword not found where expected
STEPS TO REPRODUCE:
CAUSE:
This is a defect in Strategy 10.2.
ACTION:
This is addressed in the 10.3 copy of the tutorial metadata so the error no longer happens, but the underlying resolution as to why the issue was happening is resolved in 10.6