SYMPTOM:
An ORA-00955 error in Oracle or a similar error in another database is obtained when running datamart in Strategy Developer 9.4.x-10.x, as shown below:
Error: QueryEngine encountered error: Execute Query failed. Object already exists. Error type: Odbc error. Odbc operation attempted. SQLExecDirect.
ORA-00955: name is already used by an existing objectError in Process
method of Component: QueryEngineServer, xxx, Job 77605, Error Code=-2147212544.
CAUSE
This issue may occur because an object, e.g. index, is created in the pre SQL but is not dropped afterwards.
Therefore, when the datamart is run again, the index creation fails, as shown below:
ACTION
If the datamart appends and is creating objects in pre SQL, the object needs to be dropped in a post SQL.
