Analytics Software

Hi All,

I'm trying to generate flatfile via ODI;

1. Created variable DateTime

SELECT 'Oracle_GL_DATA_' || TO_CHAR(CURRENT_DATE, 'DD-MON-YYYY HH:MI:SS') FROM dual

2. Created flatfile model and entered resource name #ProjectCode.DateTime

3. Created a Package and inserted DateTime variable and set type to Declare Variable.

3. Inserted Interface which is used to load data into flat file...

When I execute the package I get this error:

7000 : null : java.sql.SQLException: File not found: D:\dmfg17\Hyperion\ODI_Files\Data\HPCM/'Oracle_GL_DATA_20090922 10:03:24'
java.sql.SQLException: File not found: D:\dmfg17\Hyperion\ODI_Files\Data\HPCM/'Oracle_GL_DATA_20090922 10:03:24'

at com.sunopsis.jdbc.driver.file.h.a(h.java)

at com.sunopsis.jdbc.driver.file.a.d.e.a(e.java)

at com.sunopsis.jdbc.driver.file.g.a(g.java)

at com.sunopsis.jdbc.driver.file.w.executeUpdate(w.java)

at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)

at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)

at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)

at com.sunopsis.dwg.cmd.e.i(e.java)

at com.sunopsis.dwg.cmd.g.y(g.java)

at com.sunopsis.dwg.cmd.e.run(e.java)

at java.lang.Thread.run(Unknown Source)


you see it is trying to find D:\dmfg17\Hyperion\ODI_Files\Data\HPCM/'Oracle_GL_DATA_20090922 10:03:24'...but this file should be created by the process...

Using IKM SQL to FIle append...with Insert,Truncate and File Header options set to YES...

what have I missed here?