0 Replies Latest reply: Oct 22, 2012 4:26 AM by Tataji vijjapu RSS

    Error while creating a task for creating an generic task  /app/dac/CustomSQ

    Tataji vijjapu
      Hi ,

      I have created a sql file in DAC server /app/dac/CustomSQLs/ ,just to fire an update sql in database
      In DAC task tab i have created a task with the following:
      Command for incremental load :/app/dac/CustomSQLs/DBNameBeforeLoad.sql
      Primary source :flatfileconnection
      target source:DBCONNECTION_OLAP
      Execution type:SQL FILE
      Task phase:GENERAL

      I created subject area and assembled ,then created a Execution plan.
      When i try to execute this EP ,it shows the following error in DAC log:

      ANOMALY INFO::: Error while creating a task for creating an generic task /app/dac/CustomSQLs/DBNameBeforeLoad.sql
      MESSAGE:::/app/dac/CustomSQLs/DBNameBeforeLoad.sql - invalide template name!
      EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.TaskInitializationException

      com.siebel.analytics.etl.etltask.SQLFileTask.doInit(SQLFileTask.java:69)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.init(GenericTaskImpl.java:194)

      Does my above configuration is correct ..?