4 Replies Latest reply: Feb 17, 2014 4:31 AM by Raj2188 RSS

    Unknown reason for error code 36331

    987994

      Hello Guru's

       

      I am using,

       

      BIAPPS 7.9.6.4

      EBS Instance OracleR1213

      I am getting below error when performing FULL LOAD for  Order Management

       

      28813  SEVERE  Wed Feb 12 11:57:24 IST 2014  pmcmd startworkflow -sv Intg_Srvc_OBIA_7964 -d Dev_MAC1 -u Administrator -p ****  -f SDE_ORAR1213_Adaptor  -paramfile D:\DAC_11g\dac\Informatica\parameters\SDE_ORAR1213_Adaptor.SDE_ORA_ProductDimension_Full.ORA_R1213.txt  SDE_ORA_ProductDimension_Full

      Status Desc : Failed

      WorkFlowMessage :

      Error Message : Unknown reason for error code 36331

      ErrorCode : 36331

       

       

      Any solution for this issue.

       

       

      Regards,

      NN

        • 1. Re: Unknown reason for error code 36331
          SunilSharma

          check the informatica logs and see what is causing the issue. From DAC you will just get generic error info. Paste the informatica log for the corresponding workflow SDE_ORA_ProductDimension_Full

          • 2. Re: Unknown reason for error code 36331
            Raj2188

            Hi NN,

             

            There are various reason for this error code like, duplicate values, invalid parameter etc... so as Sunil said you will only be able to get the full information from the Informatica logs.

            • 3. Re: Unknown reason for error code 36331
              987994

              Hello Sunil,

               

              Below is the log info

               

              ERROR 2/12/2014 12:39:54 PM  node01_Dev_MAC1 TRANSF_1_1_1 TT_11019          There is an error in the port [CREATED_BY_ID]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

              ... nl:ERROR(s:'transformation error')).

               

               

              DEBUG            2/12/2014 12:39:54 PM  node01_Dev_MAC1 TRANSF_1_1_1 DBG_21082            Upd_Strategy_W_ORA_PRODUCT_DS_TMP_Ins_Upd (Input Group 0): : ERROR: NULL input column CREATED_BY_ID: Current Input data:

               

              Input row from EXPTRANS: Rowdata: ( RowType=0(insert) Src Rowid=1 Targ Rowid=1

                DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1000.000000000000"

                INVENTORY_ITEM_ID (INVENTORY_ITEM_ID:Double:): "4558.000000000000"

                ORGANIZATION_ID (ORGANIZATION_ID:Double:): "204.0000000000000"

                PROD_NAME (PROD_NAME:Char.100:): "Standard Pallet for Shipping"

                PRODUCT_TYPE_CODE (PRODUCT_TYPE_CODE:Char.50:): "Unspecified"

                PRODUCT_TYPE_DESC (PRODUCT_TYPE_DESC:Char.255:): "(NULL)"

                PR_PROD_LN (PR_PROD_LN:Char.100:): "Unspecified"

                PR_PROD_LN_DESC (PR_PROD_LN_DESC:Char.255:): "(NULL)"

                CONFIG_CAT_CODE (CONFIG_CAT_CODE:Char.50:): "(NULL)"

                CONFIG_CAT_DESC (CONFIG_CAT_DESC:Char.80:): "(NULL)"

                PRICE_TYPE_CD (PRICE_TYPE_CD:Char.30:): "(NULL)"

                BASIC_PRODUCT (BASIC_PRODUCT:Char.30:): "(NULL)"

                PR_EQUIV_PROD_NAME (PR_EQUIV_PROD_NAME:Char.100:): "(NULL)"

                CONFIG_PROD_IND (CONFIG_PROD_IND:Char.1:): "(NULL)"

                CONTAINER_CODE (CONTAINER_CODE:Char.50:): "(NULL)"

                CONTAINER_DESC (CONTAINER_DESC:Char.80:): "(NULL)"

                INDUSTRY_CODE (INDUSTRY_CODE:Char.50:): "(NULL)"

                INDUSTRY_NAME (INDUSTRY_NAME:Char.80:): "(NULL)"

                INDUSTRY_STD_DESC (INDUSTRY_STD_DESC:Char.255:): "(NULL)"

                INTRODUCTION_DT (INTRODUCTION_DT:Date:): "(NULL)"

                LOW_LEVEL_CODE (LOW_LEVEL_CODE:Char.50:): "(NULL)"

                MAKE_BUY_IND (MAKE_BUY_IND:Char.1:): "B"

                PROD_LIFE_CYCL_CD (PROD_LIFE_CYCL_CD:Char.30:): "(NULL)"

                PROD_REPRCH_PERIOD (PROD_REPRCH_PERIOD:Double:): "(NULL)"

                PROD_STRUCTURE_TYPE (PROD_STRUCTURE_TYPE:Char.30:): "(NULL)"

                PROD_GRP_CODE (PROD_GRP_CODE:Char.50:): "(NULL)"

                PROD_GRP_DESC (PROD_GRP_DESC:Char.80:): "(NULL)"

                STORAGE_TYPE_CODE (STORAGE_TYPE_CODE:Char.50:): "(NULL)"

                STORAGE_TYPE_DESC (STORAGE_TYPE_DESC:Char.80:): "(NULL)"

                BATCH_IND (BATCH_IND:Char.1:): "(NULL)"

                BRAND (BRAND:Char.30:): "(NULL)"

                COLOR (COLOR:Char.30:): "(NULL)"

                CUSTOM_PROD_FLG (CUSTOM_PROD_FLG:Char.1:): "(NULL)"

                PACKAGED_PROD_FLG (PACKAGED_PROD_FLG:Char.1:): "(NULL)"

                RTRN_DEFECTIVE_FLG (RTRN_DEFECTIVE_FLG:Char.1:): "N"

                SALES_PROD_FLG (SALES_PROD_FLG:Char.1:): "(NULL)"

                SALES_SRVC_FLG (SALES_SRVC_FLG:Char.1:): "N"

                SERIALIZED_FLG (SERIALIZED_FLG:Char.1:): "N"

                NRC_FLG (NRC_FLG:Char.1:): "Y"

                FRU_FLG (FRU_FLG:Char.1:): "(NULL)"

                ITEM_SIZE (ITEM_SIZE:Double:): "(NULL)"

                LEAD_TIME (LEAD_TIME:Char.30:): "(NULL)"

                MTBF (MTBF:Double:): "(NULL)"

                MTTR (MTTR:Double:): "(NULL)"

                PART_NUM (PART_NUM:Char.50:): "Pallet"

                VENDOR_LOC (VENDOR_LOC:Char.50:): "(NULL)"

                VENDOR_NAME (VENDOR_NAME:Char.100:): "Unspecified"

                VENDR_PART_NUM (VENDR_PART_NUM:Char.50:): "(NULL)"

                DISCONTINUATION_DT (DISCONTINUATION_DT:Date:): "(NULL)"

                HAZARD_MTL_DESC (HAZARD_MTL_DESC:Char.80:): "(NULL)"

                HAZARD_MTL_CODE (HAZARD_MTL_CODE:Char.50:): "(NULL)"

                SALES_UOM_CODE (SALES_UOM_CODE:Char.50:): "Ea"

                SALES_UOM_DESC (SALES_UOM_DESC:Char.80:): "Each"

                SERIALIZED_COUNT (SERIALIZED_COUNT:Double:): "(NULL)"

                SHELF_LIFE (SHELF_LIFE:Double:): "1.000000000000000"

                SHIP_MTHD_GRP_CODE (SHIP_MTHD_GRP_CODE:Char.50:): "(NULL)"

                SHIP_MTHD_GRP_DESC (SHIP_MTHD_GRP_DESC:Char.80:): "(NULL)"

                SHIP_MTL_GRP_CODE (SHIP_MTL_GRP_CODE:Char.50:): "(NULL)"

                SHIP_MTL_GRP_DESC (SHIP_MTL_GRP_DESC:Char.80:): "(NULL)"

                SHIP_TYPE_CODE (SHIP_TYPE_CODE:Char.50:): "(NULL)"

                SHIP_TYPE_DESC (SHIP_TYPE_DESC:Char.80:): "(NULL)"

                SOURCE_OF_SUPPLY (SOURCE_OF_SUPPLY:Char.30:): "(NULL)"

                SPRT_WITHDRAWL_DT (SPRT_WITHDRAWL_DT:Date:): "(NULL)"

                UOM (UOM:Char.30:): "(NULL)"

                UOM_I (UOM_I:Char.50:): "(NULL)"

                BASE_UOM_CODE (BASE_UOM_CODE:Char.50:): "Ea"

                BASE_UOM_DESC (BASE_UOM_DESC:Char.80:): "Each"

                UNIT_GROSS_WEIGHT (UNIT_GROSS_WEIGHT:Double:): "(NULL)"

                UNIT_NET_WEIGHT (UNIT_NET_WEIGHT:Double:): "(NULL)"

                UNIT_VOLUME (UNIT_VOLUME:Double:): "(NULL)"

                UNIV_PROD_CODE (UNIV_PROD_CODE:Char.50:): "(NULL)"

                UNIV_PROD_DESC (UNIV_PROD_DESC:Char.80:): "(NULL)"

                UOV_CODE (UOV_CODE:Char.50:): "(NULL)"

                UOV_DESC (UOV_DESC:Char.80:): "(NULL)"

                UOW_CODE (UOW_CODE:Char.50:): "(NULL)"

                UOW_DESC (UOW_DESC:Char.80:): "(NULL)"

                APPLICATION_FLG (APPLICATION_FLG:Char.1:): "(NULL)"

                BODY_STYLE_CD (BODY_STYLE_CD:Char.30:): "(NULL)"

                BODY_STYLE_CD_I (BODY_STYLE_CD_I:Char.50:): "(NULL)"

                CASE_PACK (CASE_PACK:Double:): "(NULL)"

                CTLG_CAT_ID (CTLG_CAT_ID:Char.30:): "(NULL)"

                DEALER_INV_PRICE (DEALER_INV_PRICE:Double:): "(NULL)"

                DETAIL_TYPE (DETAIL_TYPE:Char.30:): "(NULL)"

                DOORS_TYPE_CD (DOORS_TYPE_CD:Char.30:): "(NULL)"

                DRIVE_TRAIN_CD (DRIVE_TRAIN_CD:Char.30:): "(NULL)"

                ENGINE_TYPE_CD (ENGINE_TYPE_CD:Char.30:): "(NULL)"

                FUEL_TYPE_CD (FUEL_TYPE_CD:Char.30:): "(NULL)"

                GROSS_MRGN (GROSS_MRGN:Double:): "(NULL)"

                INVENTORY_FLG (INVENTORY_FLG:Char.1:): "Y"

                MAKE_CD (MAKE_CD:Char.30:): "(NULL)"

                MODEL_CD (MODEL_CD:Char.30:): "(NULL)"

                MODEL_YR (MODEL_YR:Double:): "(NULL)"

                MSRP (MSRP:Double:): "(NULL)"

                ORDERABLE_FLG (ORDERABLE_FLG:Char.1:): "(NULL)"

                PROD_NDC_ID (PROD_NDC_ID:Char.30:): "(NULL)"

                PROD_TYPE (PROD_TYPE:Char.30:): "(NULL)"

                PROFIT_RANK (PROFIT_RANK:Char.30:): "(NULL)"

                REFERRAL_FLG (REFERRAL_FLG:Char.1:): "(NULL)"

                RX_AVG_PRICE (RX_AVG_PRICE:Double:): "(NULL)"

                SERVICE_TYPE (SERVICE_TYPE:Char.30:): "(NULL)"

                STATUS (STATUS:Char.30:): "(NULL)"

                R_TYPE (R_TYPE:Char.30:): "(NULL)"

                SUB_TYPE (SUB_TYPE:Char.30:): "(NULL)"

                SUB_TYPE_CD (SUB_TYPE_CD:Char.30:): "(NULL)"

                TGT_CUST_TYPE (TGT_CUST_TYPE:Char.30:): "(NULL)"

                TRANSMISSION_CD (TRANSMISSION_CD:Char.30:): "(NULL)"

                TRIM_CD (TRIM_CD:Char.30:): "(NULL)"

                UNIT_CONV_FACTOR (UNIT_CONV_FACTOR:Double:): "(NULL)"

                VER_DT (VER_DT:Date:): "(NULL)"

                PAR_INTEGRATION_ID (PAR_INTEGRATION_ID:Char.30:): "(NULL)"

                CREATED_ON_DT (CREATED_ON_DT:Date:): "04/05/2001 12:13:41.000000000"

                CHANGED_ON_DT_OUT (CHANGED_ON_DT:Date:): "02/12/2014 12:39:53.000000000"

                AUX1_CHANGED_ON_DT (AUX1_CHANGED_ON_DT:Date:): "(NULL)"

                AUX2_CHANGED_ON_DT (AUX2_CHANGED_ON_DT:Date:): "(NULL)"

                AUX3_CHANGED_ON_DT (AUX3_CHANGED_ON_DT:Date:): "(NULL)"

                AUX4_CHANGED_ON_DT (AUX4_CHANGED_ON_DT:Date:): "(NULL)"

                SRC_EFF_FROM_DT (SRC_EFF_FROM_DT:Date:): "01/01/1899 00:00:00.000000000"

                SRC_EFF_TO_DT (SRC_EFF_TO_DT:Date:): "(NULL)"

                DELETE_FLG (DELETE_FLG:Char.1:): "N"

                INTEGRATION_ID (INTEGRATION_ID:Char.80:): "4558"

                TENANT_ID (TENANT_ID:Char.80:): "DEFAULT"

                X_CUSTOM (X_CUSTOM:Char.10:): "(NULL)"

                CREATED_BY_ID (CREATED_BY_ID:Char.80:): "(NULL)"

                CHANGED_BY_ID (CHANGED_BY_ID:Char.80:): "(NULL)"

                UPDATE_FLG (UPDATE_FLG:Char.10:): "U"

              )

              • 4. Re: Unknown reason for error code 36331
                Raj2188

                It's not an error, it's only an information that you have a port with a default value set toERROR('transformation error'), so Integration Service will skip the NULL values with an ERRORfunction.

                The Designer inserts this expression automatically, when you add a new output port; you can change it. Edit the expression, find the port on the Ports tab and check the Default value field at the bottom.