Topic
1 reply Latest Post - ‏2012-10-09T08:48:15Z by SystemAdmin
sqwnb
sqwnb
11 Posts
ACCEPTED ANSWER

Pinned topic ERROR SQW03276E

‏2012-09-26T07:54:04Z |
Hi,

I tried developing a Data Flow with lookup (PFA the DataFlow). When matched rows are brought out, the flow runs successfully. But when the discard rows are brought out, i m getting an error. Given below is the error log.

DSLog (Data-Flows) Sep 26, 2012 1:14:40 PM INFO SQW03415I: Flow execution started for SQW043 (/RFR/data-flows/RFRTEST/J_IC_RCTP)
DSLog (Data-Flows) Sep 26, 2012 1:14:40 PM INFO SQW38501I: Execution log file: D:/Benita/Project/ISW/run-profiles/logs/J_IC_RCTP_SQW043.txt
DSLog (Data-Flows) Sep 26, 2012 1:14:40 PM INFO SQW38509I: Execution temporary work directory: D:/Benita/Project/ISW/run-profiles/tmp\J_IC_RCTP_SQW043
DSLog (Data-Flows) Sep 26, 2012 1:14:43 PM INFO SQW03275I: Execution of SQL statement "SET CURRENT SCHEMA "IWSCHEMA88F08F_165"" through JDBC connection finished successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:43 PM INFO SQW03275I: Execution of SQL statement "CREATE TABLE "IWSCHEMA88F08F_165"."IWTEMP88F08F_1651"(
"Month" DATE,
"BU Code" CHAR(5),
"Entity Name" VARCHAR(30),
"Vertical" CHAR(9),
"CRM ID" INTEGER,
"Customer Name" VARCHAR(36),
"Project ID" VARCHAR(11),
"Project Name" VARCHAR(30),
"Internal Remarks" VARCHAR(31),
"Classifier" VARCHAR(20),
"AssociateID" INTEGER,
"Associate Name" CHAR(10),
"Designation" CHAR(10),
"Associate Status" CHAR(10),
"ON\OF" CHAR(3),
"Location Code" CHAR(10),
"Location Description" VARCHAR(14),
UOM VARCHAR(14),
"Currency" CHAR(6),
"Efforts" VARCHAR(11),
"Rate" INTEGER,
"Revenue" DECIMAL(8,2),
"T & E" DECIMAL(11,1),
"Total Rev Nat" VARCHAR(32),
"Exchange Rate" DECIMAL(9,8),
"T & E USD" INTEGER,
"Revenue USD" DECIMAL(8,2),
"Total Rev USD" VARCHAR(32),
"Project Bill Type" CHAR(8),
"Solution" CHAR(3),
"Sub Solution" VARCHAR(16),
"Source" CHAR(7),
"Detail Remarks" VARCHAR(20),
"To be Considered for Utilization" VARCHAR(20),
"Comments - Finance" VARCHAR(254))" through JDBC connection finished successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM INFO SQW03201I: com.ibm.datatools.etl.codeunit.impl.SQLScriptImpl@20a720a7 (ID: null, codeUnitType: SQLSCRIPT, action: EXECUTION, phase: RUNTIME, codeLocation: null, argumentTableLocation: null) (executor: null) task completed successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM INFO SQW03275I: Execution of SQL statement "CREATE VIEW "IWTEMP88F08F_165_keyLookUp/op:017/op:04"(
C0,
C1,
C2,
C3,
C4,
C5,
C6,
D0,
D1,
D2,
D3,
D4,
D5,
D6,
ID0
) AS
SELECT Q1862.C0 AS C0, Q1862.C1 AS C1, Q1862.C2 AS C2, Q1862.C3 AS C3,
Q1862.C4 AS C4, Q1862.C5 AS C5, Q1862.C6 AS C6, Q1862.D0 AS D0,
Q1862.D1 AS D1, Q1862.D2 AS D2, Q1862.D3 AS D3, Q1862.D4 AS D4,
Q1862.D5 AS D5, Q1862.D6 AS D6, Q1862.ID0 AS ID0
FROM
(SELECT LTRIM(RTRIM(Q2478."Project ID")) AS C0, LTRIM(RTRIM(Q2478."Classifier")) AS C1,
LTRIM(RTRIM(Q2478."AssociateID")) AS C2, LTRIM(RTRIM(Q2478."ON\OF")) AS C3,
CASE WHEN (LTRIM(RTRIM(Q2478."Total Rev Nat")) = '-') THEN '0.00' ELSE LTRIM(RTRIM(Q2478."Total Rev Nat")) END AS C4,
CASE WHEN (LTRIM(RTRIM(Q2478."Total Rev USD")) = '-') THEN '0.00' ELSE LTRIM(RTRIM(Q2478."Total Rev USD")) END AS C5,
LTRIM(RTRIM(Q2478."Currency")) AS C6, LTRIM(RTRIM(Q2478."Project ID")) AS D0,
LTRIM(RTRIM(Q2478."Classifier")) AS D1, LTRIM(RTRIM(Q2478."AssociateID")) AS D2,
LTRIM(RTRIM(Q2478."ON\OF")) AS D3, LTRIM(RTRIM(Q2478."Currency")) AS D4,
CASE WHEN (LTRIM(RTRIM(Q2478."Total Rev Nat")) = '-') THEN '0.00' ELSE LTRIM(RTRIM(Q2478."Total Rev Nat")) END AS D5,
CASE WHEN (LTRIM(RTRIM(Q2478."Total Rev USD")) = '-') THEN '0.00' ELSE LTRIM(RTRIM(Q2478."Total Rev USD")) END AS D6,
Q2514.CONST0 AS ID0
FROM
"IWSCHEMA88F08F_165"."IWTEMP88F08F_1651" Q2478 LEFT OUTER JOIN (
SELECT Q1271.ON_OFF_ID AS ON_OFF_ID, 1 AS CONST0
FROM WAREHOUSE.IC_D_ON_OFF Q1271) Q2514 ON (Q2478."ON\OF" = Q2514.ON_OFF_ID)) Q1862" through JDBC connection finished successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03276E: Execution of SQL statement "CREATE VIEW "IWTEMP88F08F_165_DISCARD_04_0"(
) AS
SELECT D0 AS Project ID, D1 AS Classifier, D2 AS AssociateID, D3 AS ON\OF, D4 AS Currency, D5 AS Total Rev Nat, D6 AS Total Rev USD FROM "IWTEMP88F08F_165_keyLookUp/op:017/op:04" WHERE ID0 IS NULL" through JDBC connection failed. Exception: SQL Exception. SQL state = 42601; error code = -7; error Message = The character "\" following "ssociateID, D3 AS ON" is not valid.. SQLCODE=-7, SQLSTATE=42601, DRIVER=3.63.108SQL Exception. SQL state = 56098; error code = -727; error Message = An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-7", SQLSTATE "42601" and message tokens "\|ssociateID, D3 AS ON".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.63.108SQL Exception. SQL state = 56098; error code = -727; error Message = An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-7", SQLSTATE "42601" and message tokens "\|ssociateID, D3 AS ON".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.63.108
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03406E: Execution failed for activity /RFR/data-flows/RFRTEST/J_IC_RCTP.etlmetadataxmi
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03276E: Execution of SQL statement "DROP VIEW "IWTEMP88F08F_165_MATCH_04_0"" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "IWSCHEMA88F08F_165.IWTEMP88F08F_165_MATCH_04_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.63.108
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03406E: Execution failed for activity /RFR/data-flows/RFRTEST/J_IC_RCTP.etlmetadataxmi
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03276E: Execution of SQL statement "DROP VIEW "IWTEMP88F08F_165_DISCARD_04_0"" through JDBC connection failed. Exception: SQL Exception. SQL state = 42704; error code = -204; error Message = "IWSCHEMA88F08F_165.IWTEMP88F08F_165_DISCARD_04_0" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.63.108
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM ERROR SQW03406E: Execution failed for activity /RFR/data-flows/RFRTEST/J_IC_RCTP.etlmetadataxmi
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM INFO SQW03275I: Execution of SQL statement "DROP VIEW "IWTEMP88F08F_165_keyLookUp/op:017/op:04"" through JDBC connection finished successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM INFO SQW03275I: Execution of SQL statement "DROP TABLE "IWSCHEMA88F08F_165"."IWTEMP88F08F_1651"" through JDBC connection finished successfully
DSLog (Data-Flows) Sep 26, 2012 1:14:45 PM INFO SQW03368I: Dumping variable values :
${INT-RES/RUN-ID} = 88F08F
${RESERVED/ACTIVITY_NAME} = J_IC_RCTP
${RESERVED/ACTIVITY_TYPE} = J_IC_RCTP
${RESERVED/APP_NAME} = J_IC_RCTP
${RESERVED/APP_PATH} = D:/Benita/Project/ISW/run-profiles/rp88d815/
${RESERVED/CF_ACTIVITY_NAME} = J_IC_RCTP/J_IC_RCTP
${RESERVED/CURRENT_TIMESTAMP} = 2012-09-26 13:14:42
${RESERVED/DATE} = 2012-09-26
${RESERVED/DAYNAME_SHORT} = Wed
${RESERVED/DAYNAME} = Wednesday
${RESERVED/DAY} = 26
${RESERVED/INSTANCE_NAME} = SQW043
${RESERVED/MISC_DIR} = C:/Documents and Settings/220884/IBM/rationalsdp/workspace\RFR\package-misc\
${RESERVED/MONTHNAME_SHORT} = Sep
${RESERVED/MONTHNAME} = September
${RESERVED/MONTH} = 09
${RESERVED/PROC_NAME} = J_IC_RCTP
${RESERVED/RUN_ID} = 88F08F
${RESERVED/SCD_DATE} =
${RESERVED/SCD_TIMESTAMP} =
${RESERVED/START_TIMESTAMP} = 2012-09-26 13:14:42
${RESERVED/TIME} = 13:14:42
${RESERVED/TMP_DIR} = D:/Benita/Project/ISW/run-profiles/tmp\J_IC_RCTP_SQW043
${RESERVED/USER_DIR} = C:\Program Files\IBM\ISWarehouse10\ds
${RESERVED/USER_HOME} = C:\Documents and Settings\220884
${RESERVED/USER_NAME} = 220884
${RESERVED/YEAR} = 2012
Please help.
Updated on 2012-10-09T08:48:15Z at 2012-10-09T08:48:15Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: ERROR SQW03276E

    ‏2012-10-09T08:48:15Z  in response to sqwnb
    Hi,

    When creating the temporary view, the name ON\OF should not directly be specified as the alias.

    Change the column name (without the \) will resolve this problem.

    If you have to use this name, please contact the Level 2 team for more help.

    Thanks,
    Wei.