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 - ‏2011-05-10T15:01:43Z by JP_Parkin
SM11_tabassum_m
SM11_tabassum_m
5 Posts
ACCEPTED ANSWER

Pinned topic ERROR IN DATA FLOW

‏2011-05-10T07:04:10Z |
Hi
I have created a data flow using design studio and added all necessary source tables and target tables and operators but when i execute the flow i am getting following error message. How to solve it
Execution Result:
FATAL: SQW10101E: Execution failed. See further details.



Execution Log:

C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/logs/tpx_SQW007.txt:

Data-Flows May 10, 2011 12:29:29 PM SQW03415I: Flow execution started for SQW007 (/acct/data-flows/tpx)
Data-Flows May 10, 2011 12:29:29 PM SQW38501I: Execution log file: C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/logs/tpx_SQW007.txt
Data-Flows May 10, 2011 12:29:29 PM SQW38509I: Execution temporary work directory: C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/tmp\tpx_SQW007
Data-Flows May 10, 2011 12:29:30 PM JDBCSchema: SQL Exception. SQL state = 42502; error code = -552; error Message = "DB2ADMIN" does not have the privilege to perform operation "CREATE SCHEMA".. SQLCODE=-552, SQLSTATE=42502, DRIVER=3.58.81
Data-Flows May 10, 2011 12:29:30 PM SQW03563E: Failure to execute Java class com.ibm.datatools.etl.dataflow.baselib.runtimeunits.JDBCSchema. Exception: This JDBC operator encountered an exception: {0}
Data-Flows May 10, 2011 12:29:30 PM SQW03406E: Execution failed for activity /acct/data-flows/tpx.etlmetadataxmi
Data-Flows May 10, 2011 12:29:31 PM SQW03276E: Execution of SQL statement "DROP VIEW "OUTPUT_04_0"" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "DB2ADMIN.OUTPUT_04_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.58.81
Data-Flows May 10, 2011 12:29:31 PM SQW03406E: Execution failed for activity /acct/data-flows/tpx.etlmetadataxmi
Data-Flows May 10, 2011 12:29:31 PM SQW03276E: Execution of SQL statement "DROP VIEW "IWSCHEMAB4114D_12".INPUT_04_0" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "IWSCHEMAB4114D_12.INPUT_04_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.58.81
Data-Flows May 10, 2011 12:29:31 PM SQW03406E: Execution failed for activity /acct/data-flows/tpx.etlmetadataxmi
Data-Flows May 10, 2011 12:29:31 PM SQW03276E: Execution of SQL statement "DROP VIEW "OUTPUT_02_0"" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "DB2ADMIN.OUTPUT_02_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.58.81
Data-Flows May 10, 2011 12:29:31 PM SQW03406E: Execution failed for activity /acct/data-flows/tpx.etlmetadataxmi
Data-Flows May 10, 2011 12:29:32 PM SQW03276E: Execution of SQL statement "DROP VIEW "IWSCHEMAB4114D_12".INPUT_02_0" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "IWSCHEMAB4114D_12.INPUT_02_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.58.81
Data-Flows May 10, 2011 12:29:32 PM SQW03406E: Execution failed for activity /acct/data-flows/tpx.etlmetadataxmi
Data-Flows May 10, 2011 12:29:33 PM SQW03368I: Dumping variable values :
${INT-RES/RUN-ID} = B4114D
${RESERVED/APP_NAME} = tpx
${RESERVED/APP_PATH} = C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/rpb3fcf3/
${RESERVED/CURRENT_TIMESTAMP} = 2011-05-10 12:29:30
${RESERVED/DATE} = 2011-05-10
${RESERVED/DAYNAME_SHORT} = Tue
${RESERVED/DAYNAME} = Tuesday
${RESERVED/DAY} = 10
${RESERVED/INSTANCE_NAME} = SQW007
${RESERVED/MISC_DIR} = C:/Users/tabbu/IBM/rationalsdp/workspace\acct\package-misc\
${RESERVED/MONTHNAME_SHORT} = May
${RESERVED/MONTHNAME} = May
${RESERVED/MONTH} = 05
${RESERVED/PROC_NAME} = tpx
${RESERVED/RUN_ID} = B4114D
${RESERVED/SCD_DATE} =
${RESERVED/SCD_TIMESTAMP} =
${RESERVED/START_TIMESTAMP} = 2011-05-10 12:29:30
${RESERVED/TIME} = 12:29:30
${RESERVED/TMP_DIR} = C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/tmp\tpx_SQW007
${RESERVED/USER_DIR} = E:\infosphere\ds
${RESERVED/USER_HOME} = C:\Users\tabbu
${RESERVED/USER_NAME} = tabbu
${RESERVED/YEAR} = 2011
Data-Flows May 10, 2011 12:29:33 PM SQW03408I: Flow execution finished for SQW007 (/acct/data-flows/tpx)
Data-Flows May 10, 2011 12:29:33 PM SQW38508I: Closing log file C:/Users/tabbu/IBM/rationalsdp/workspace/acct/run-profiles/logs/tpx_SQW007.txt.
Updated on 2011-05-10T15:01:43Z at 2011-05-10T15:01:43Z by JP_Parkin
  • JP_Parkin
    JP_Parkin
    128 Posts
    ACCEPTED ANSWER

    Re: ERROR IN DATA FLOW

    ‏2011-05-10T15:01:43Z  in response to SM11_tabassum_m
    Hi - your userid needs to have permission to create a temporary schema.

    There's a couple ways to address this :

    1) Grant DBADM to the userid that is running the flow ( or use a userid with DBADM )

    Using a userid with DBADM or SECADM authority
    db2 connect to <database> user <dbadm user>
    db2 grant DBADM on database to <userid running SQW flows>
    


    2) Change the SQL Execution Schema in the data flow properties Advanced Options tab.
    You need to change the "SQL Execution Schema" to a schema that you have permissions to create temporary tables and views in.

    Best regards,
    JP
    Updated on 2014-03-25T18:28:43Z at 2014-03-25T18:28:43Z by iron-man