SYMPTOM:
When using ApplySimple to transform Unix time stamp into a readable date format with FROM_UNIXTIME() function against an Oracle data warehouse, the execution of the report will return the following error message in Strategy Desktop, which runs successfully against a MySQL data warehouse.
Sample Code/Error:
Error: SQL Generation Complete QueryEngine encountered error:
Execute Query failed. Error type: Odbc error. Odbc operation attempted:
SQLExecDirect. ORA-00904: "FROM_UNIXTIME": invalid identifier Connection String:
DSN=TDM_Data_source;UID=IXP;HOST=10.248.19.39;PORT=1521;SID=ixp;.
SQL Statement: ...QueryEngine encountered error:
Report : Drop table error: DBInstance = TDM_DB_InstanceSQL Statement: drop table
TY7RX9KGTAM000 purge.
Error in Process method of Component: QueryEngineServer, Project TDM_VOICE,
Job 14117, Error Code= -2147212544.
CAUSE:
The Oracle database does not support the function FROM_UNIXTIME() which is supported by MySQL database.
ACTION:
Use the following statement in the attribute form expression editor instead of the "FROM_UNIXTIME()" function to convert the Unix time stamp data against the Oracle database.
Sample Code/Error
