Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-10-09T08:04:48Z by SystemAdmin
ariyani_sanjung
ariyani_sanjung
1 Post
ACCEPTED ANSWER

Pinned topic Error when import a flat file

‏2012-10-02T07:00:18Z |
Dear All,
I need your help, I design a data flow by a simple flat file(.csv), 3 coloum and 3 record, but I get the error for the execution file like this, please help me everyone, thx :
( I attached the error_log too) and
Data-Flows Oct 2, 2012 1:39:59 PM SQW03415I: Flow execution started for SQW002 (/LAT_FILE/data-flows/INTEG1)
Data-Flows Oct 2, 2012 1:39:59 PM SQW38501I: Execution log file: D:/IBM/perhutani/latihan/LAT_FILE/run-profiles/logs/INTEG1_SQW002.txt
Data-Flows Oct 2, 2012 1:39:59 PM SQW38509I: Execution temporary work directory: D:/IBM/perhutani/latihan/LAT_FILE/run-profiles/tmp\INTEG1_SQW002
Data-Flows Oct 2, 2012 1:39:59 PM SQW38502I: Runtime execution library path is: C:\Program Files (x86)\IBM\SDPShared\plugins\com.ibm.datatools.sqwruntime.tasks_2.2.3.v20110322_1534\
Data-Flows Oct 2, 2012 1:39:59 PM SQW38503I: Start executing flow.
Data-Flows Oct 2, 2012 1:39:59 PM SQW38001I: Start code generation.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38002I: Finished code generation.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38003I: Start processing resources.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38005I: Finished processing resources.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38006I: Start processing variables.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38007I: Finished processing variables.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38009I: Start executing deployment EPGs.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38011I: Finished executing deployment EPGs.
Data-Flows Oct 2, 2012 1:40:00 PM SQW38012I: Start executing runtime EPGs.
Data-Flows Oct 2, 2012 1:40:01 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM

Data-Flows Oct 2, 2012 1:40:01 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:01 PM SQW03801I: Entering method handleJAVA in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM SQW030808I: Database name: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:01 PM JDBCSchema: Database Name: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:01 PM JDBCSchema: Database Connection URL = "jdbc:db2://10.0.0.6:50001/PHTDW"
Data-Flows Oct 2, 2012 1:40:01 PM JDBCSchema: Schema Name: IWSCHEMA33DC30_a
Data-Flows Oct 2, 2012 1:40:01 PM JDBCSchema: Action: CREATE
Data-Flows Oct 2, 2012 1:40:01 PM SQW37776I: Execution of Java class com.ibm.datatools.etl.dataflow.baselib.runtimeunits.JDBCSchema finished successfully.
Data-Flows Oct 2, 2012 1:40:01 PM SQW03201I: com.ibm.datatools.etl.dataflow.baselib.runtimeunits.JDBCSchema task completed successfully
Data-Flows Oct 2, 2012 1:40:01 PM SQW03802I: Exiting method handleJAVA in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM SQW030815I: All code units in the TXN block 12 executed successfully. Committing database: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:01 PM

Data-Flows Oct 2, 2012 1:40:01 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM

Data-Flows Oct 2, 2012 1:40:01 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:01 PM SQW03801I: Entering method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:01 PM SQW030808I: Database name: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:02 PM SQW030871I: Number of rows modified: 0.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03275I: Execution of SQL statement "SET CURRENT SCHEMA "IWSCHEMA33DC30_a"" through JDBC connection finished successfully
Data-Flows Oct 2, 2012 1:40:02 PM SQW03802I: Exiting method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW030815I: All code units in the TXN block 15 executed successfully. Committing database: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:02 PM

Data-Flows Oct 2, 2012 1:40:02 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM

Data-Flows Oct 2, 2012 1:40:02 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:02 PM SQW03801I: Entering method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW030808I: Database name: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:02 PM SQW030871I: Number of rows modified: 0.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03275I: Execution of SQL statement "CREATE TABLE "IWSCHEMA33DC30_a"."IWTEMP33DC30_a1"(
KODE_NAMA INTEGER,
KODE_ALAMAT INTEGER,
NOMOR INTEGER)" through JDBC connection finished successfully
Data-Flows Oct 2, 2012 1:40:02 PM SQW03802I: Exiting method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW030815I: All code units in the TXN block 18 executed successfully. Committing database: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:02 PM

Data-Flows Oct 2, 2012 1:40:02 PM
Execute node: com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null)
Data-Flows Oct 2, 2012 1:40:02 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM

Data-Flows Oct 2, 2012 1:40:02 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:02 PM SQW03801I: Entering method handleExecTask in EPG traverser.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03208I: Entering method: com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null)
Data-Flows Oct 2, 2012 1:40:02 PM SQW03267I: SQW runtime lib path: /C:/Program Files (x86)/IBM/SDPShared/plugins/com.ibm.datatools.sqwruntime.tasks_2.2.3.v20110322_1534/sqwtasks.jar
Data-Flows Oct 2, 2012 1:40:02 PM SQW03266I: Temporary script file location: D:\IBM\perhutani\latihan\LAT_FILE\run-profiles\tmp\INTEG1_SQW002\TASK_10.sql
Data-Flows Oct 2, 2012 1:40:02 PM SQW03261I: Database: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03264I: Statement terminator: ;
Data-Flows Oct 2, 2012 1:40:02 PM SQW03263I: User name: db2inst2.
Data-Flows Oct 2, 2012 1:40:02 PM SQW03265I: Temporary result file location: D:\IBM\perhutani\latihan\LAT_FILE\run-profiles\tmp\INTEG1_SQW002\TASK_10.output
Data-Flows Oct 2, 2012 1:40:04 PM SQW03258I: Execution result for com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) is
**SQL0104N An unexpected token "as" was found following "<identifier>".**

**Expected tokens may include: "USER". SQLSTATE=42601**

QUIT

DB20000I The QUIT command completed successfully.

.
Data-Flows Oct 2, 2012 1:40:04 PM code: 0 : exception: null

SQW03260I: Exit status for com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) is -1.
Data-Flows Oct 2, 2012 1:40:04 PM SQW03203E: com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) task failed
Data-Flows Oct 2, 2012 1:40:04 PM SQW03209I: Exiting from method: com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null)
Data-Flows Oct 2, 2012 1:40:04 PM SQW03802I: Exiting method handleExecTask in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM SQW03406E: Execution failed for activity /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:04 PM -- Create check points .....
Data-Flows Oct 2, 2012 1:40:04 PM 2 CP Name =com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) loop number = 0 actInst=com.ibm.datatoo0349160002615
Data-Flows Oct 2, 2012 1:40:04 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM processFailed item=com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) type=CODE_UNIT actLF=com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@8f108f1 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null)
Data-Flows Oct 2, 2012 1:40:04 PM processFailed item=EPGTry type=TRY
Data-Flows Oct 2, 2012 1:40:04 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM

Data-Flows Oct 2, 2012 1:40:04 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:04 PM SQW03801I: Entering method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM SQW030808I: Database name: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:04 PM SQW030871I: Number of rows modified: 0.
Data-Flows Oct 2, 2012 1:40:04 PM SQW03275I: Execution of SQL statement "DROP TABLE "IWSCHEMA33DC30_a"."IWTEMP33DC30_a1"" through JDBC connection finished successfully
Data-Flows Oct 2, 2012 1:40:04 PM SQW03802I: Exiting method handleJDBC in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM SQW030815I: All code units in the TXN block 7 executed successfully. Committing database: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:04 PM

Data-Flows Oct 2, 2012 1:40:04 PM SQW03801I: Entering method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM

Data-Flows Oct 2, 2012 1:40:04 PM Executing Activity: /LAT_FILE/data-flows/INTEG1.etlmetadataxmi
Data-Flows Oct 2, 2012 1:40:04 PM SQW03801I: Entering method handleJAVA in EPG traverser.
Data-Flows Oct 2, 2012 1:40:04 PM SQW030808I: Database name: PHTDW as db2inst2.
Data-Flows Oct 2, 2012 1:40:04 PM JDBCSchema: Database Name: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:04 PM JDBCSchema: Database Connection URL = "jdbc:db2://10.0.0.6:50001/PHTDW"
Data-Flows Oct 2, 2012 1:40:04 PM JDBCSchema: Schema Name: IWSCHEMA33DC30_a
Data-Flows Oct 2, 2012 1:40:04 PM JDBCSchema: Action: DROP
Data-Flows Oct 2, 2012 1:40:05 PM SQW37776I: Execution of Java class com.ibm.datatools.etl.dataflow.baselib.runtimeunits.JDBCSchema finished successfully.
Data-Flows Oct 2, 2012 1:40:05 PM SQW03201I: com.ibm.datatools.etl.dataflow.baselib.runtimeunits.JDBCSchema task completed successfully
Data-Flows Oct 2, 2012 1:40:05 PM SQW03802I: Exiting method handleJAVA in EPG traverser.
Data-Flows Oct 2, 2012 1:40:05 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:05 PM SQW030815I: All code units in the TXN block 10 executed successfully. Committing database: PHTDW as db2inst2
Data-Flows Oct 2, 2012 1:40:05 PM

Data-Flows Oct 2, 2012 1:40:05 PM SQW03802I: Exiting method processActionNode in EPG traverser.
Data-Flows Oct 2, 2012 1:40:05 PM processFailed item=/LAT_FILE/data-flows/INTEG1.etlmetadataxmi type=EPG_REF_NODE
Data-Flows Oct 2, 2012 1:40:05 PM SQW38014I: Finished executing runtime EPGs.
Data-Flows Oct 2, 2012 1:40:05 PM SQW03368I: Dumping variable values :
${INPUT1/masukan} = D:\FILE_EX\lat_integer.csv
${INT-RES/RUN-ID} = 33DC30
${RESERVED/ACTIVITY_NAME} = INTEG1
${RESERVED/ACTIVITY_TYPE} = INTEG1
${RESERVED/APP_NAME} = INTEG1
${RESERVED/APP_PATH} = D:/IBM/perhutani/latihan/LAT_FILE/run-profiles/LAT_FILE_INTEG1/
${RESERVED/CF_ACTIVITY_NAME} = INTEG1/INTEG1
${RESERVED/CURRENT_TIMESTAMP} = 2012-10-02 13:40:01
${RESERVED/DATE} = 2012-10-02
${RESERVED/DAYNAME_SHORT} = Tue
${RESERVED/DAYNAME} = Tuesday
${RESERVED/DAY} = 02
${RESERVED/INSTANCE_NAME} = SQW002
${RESERVED/MISC_DIR} = D:/IBM/perhutani/latihan\LAT_FILE\package-misc\
${RESERVED/MONTHNAME_SHORT} = Oct
${RESERVED/MONTHNAME} = October
${RESERVED/MONTH} = 10
${RESERVED/PROC_NAME} = INTEG1
${RESERVED/RUN_ID} = 33DC30
${RESERVED/SCD_DATE} =
${RESERVED/SCD_TIMESTAMP} =
${RESERVED/START_TIMESTAMP} = 2012-10-02 13:40:00
${RESERVED/TIME} = 13:40:00
${RESERVED/TMP_DIR} = D:/IBM/perhutani/latihan/LAT_FILE/run-profiles/tmp\INTEG1_SQW002
${RESERVED/USER_DIR} = C:\Program Files\IBM\ISWarehouse\ds
${RESERVED/USER_HOME} = C:\Users\User
${RESERVED/USER_NAME} = User
${RESERVED/YEAR} = 2012
Updated on 2012-10-09T08:04:48Z at 2012-10-09T08:04:48Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: Error when import a flat file

    ‏2012-10-09T08:04:48Z  in response to ariyani_sanjung
    Hi, do you mind uploading the dataflow (under <workspace>/<project>/data-flows) and the csv file?