"Batch From Records Failed Error " in HANA while trying to load csv file data.

[Former Member]

Hi,

This is Praveen I have been facing  with the following error.

PFA “Error Screen Shots”

That I have been facing while trying to load the
CASA file data into SAP HANA.
Errors:

1. Batch From Record 2 to 705 Failed: SAP DBTech  JDBC: [260]: invalid column name : RELATIVE_STAFF_EMP_NUM.
2. Batch From Record 2 to 705 Failed.

Kindly go through the "Error screen shot"

And guide me accordingly to solve this above error.

Regards,

Praveen,

+91 8056052928.

[rindia]

Hi Praveen,

Could you attach the excel file and DDL for the table. In case if it is a new table, still the table will create with empty data. To get the DDL, right click on table and select Open definition.

Once you send the file, I will upload and see what the problem is?

Regards

Raj

[Former Member]

Hi Raj,

Thanks for your quick reply.

I have been trying to create the table in three different ways that are possible.

1. With the New table creation and automatically the HANA to decide the data types, where i have been facing with these errors.

Errors:
1. Zero Length Delimiter Identifier :""

1. Inserted Value Too Large For The Column Ex: "MAILING_ADDR_LINE_4"

  3."Numeric Overflow".
4. "Batch From Records Failed"
2. Through Second method using the Existing table as first creation of the table and trying to laod the data from csv CASA data to it.

Errors:

1. Batch From Record 2 to 705 Failed: SAP DBTech  JDBC: [260]: invalid column name : RELATIVE_STAFF_EMP_NUM.
2. Batch From Record 2 to 705 Failed.

Finally

The error as "Batch From Record 2 to 705 Failed error exists.

PFB DDL & csv CASA data file.

CREATE COLUMN TABLE "Z_STS"."CASA_DATATYPE" ("ACCT_ID" NVARCHAR(50) NOT NULL ,

           "EFF_START_DATE" DAYDATE CS_DAYDATE,

           "EFF_END_DATE" DAYDATE CS_DAYDATE,

           "FLG_CURR_REC" VARCHAR(50),

           "SRC_SYS_ID" NVARCHAR(20),

           "ACCT_LVL_PH_NUM" VARCHAR(50),

           "ADHOC_LMT_AMT" NVARCHAR(20),

           "BP_LINE_AMT_SANC" VARCHAR(100),

           "BP_LINE_AMT_UTIL" VARCHAR(50),

           "CLEAN_ADHOC_LMT_AMT" NVARCHAR(50),

           "CLEAN_SINGLE_TRAN_LMT_AMT" NVARCHAR(20),

           "DACC_ABS_LMT_AMT" NVARCHAR(50),

           "DACC_LMT_AMT" NVARCHAR(50),

           "DACC_LMT_PERC" VARCHAR(50),

           "DR_BAL_LMT_AMT" NVARCHAR(20),

           "EXP_OF_ADHOC_LMT_DATE" DAYDATE CS_DAYDATE,

           "FAC_AVAILED_CODE" VARCHAR(50),

           "FLG_ACCT_BLOCKED" VARCHAR(50),

           "FLG_CHQ_MANDATE" VARCHAR(50),

           "FLG_DORM_SC" VARCHAR(50),

           "FLG_INT_WAIVER" VARCHAR(50),

           "FLG_RELATIVE_STAFF" VARCHAR(50),

           "FLG_SC_WAIVER" VARCHAR(50),

           "FLG_SWEEP_OUT_IN" VARCHAR(50),

           "FLG_TDS" VARCHAR(50),

           "FLG_WTAX" VARCHAR(50),

           "IND_VOSTRO_ACCT" VARCHAR(50),

           "MODE_OF_OPER_TYPE" VARCHAR(50),

           "RATE_VARIANCE_INT_CR" VARCHAR(50),

           "RATE_VARIANCE_INT_DR" VARCHAR(50),

           "RELATIVE_STAFF_EMP_NUM" NVARCHAR(50),

           "SINGLE_TRAN_LMT_AMT" NVARCHAR(50),

           "USED_CLEAN_SINGLE_TRAN_LMT_AMT" NVARCHAR(50),

           "USED_SINGLE_TRAN_LMT_AMT" NVARCHAR(50),

           "USED_UNCLEAR_OVER_DACC_AMT" NVARCHAR(50),

           "WTAX_FLOOR_LMT_AMT" NVARCHAR(50),

           "WTAX_PERC" VARCHAR(50),

           "CREATED_DATE" DAYDATE CS_DAYDATE,

           "LST_UPDATE_DATE" DAYDATE CS_DAYDATE,

           "CREATE_RUN_CYCLE_ID" NVARCHAR(50),

           "LST_UPD_RUN_CYCLE_ID" VARCHAR(50),

           "LST_UPD_JOB_ID" NVARCHAR(50),

           "ACCT_ID_1" NVARCHAR(50),

           "EFF_START_DATE_1" DAYDATE CS_DAYDATE,

           "EFF_END_DATE_1" DAYDATE CS_DAYDATE,

           "FLG_CURR_REC_1" VARCHAR(50),

           "SRC_SYS_ID_1" NVARCHAR(50),

           "SRC_SYS_CODE" VARCHAR(50),

           "ACCT_NUM" NVARCHAR(50),

           "ACCEPTED_RATING" VARCHAR(50),

           "ACCT_BAL_BEFORE_CLOSURE" VARCHAR(50),

           "ACCT_CLS_DATE" DAYDATE CS_DAYDATE,

           "ACCT_CR_PREF_PERC" VARCHAR(50),

           "ACCT_DR_PREF_PERC" VARCHAR(50),

           "ACCT_EFF_ROI" VARCHAR(50),

           "ACCT_LOC_CODE" VARCHAR(50),

           "ACCT_MGR_USR_ID" NVARCHAR(50),

           "ACCT_NAME" VARCHAR(180),

           "ACCT_NPA_CLASS_REASON_CODE" VARCHAR(50),

           "ACCT_NPA_CLASS_TYPE_CODE" VARCHAR(50),

           "ACCT_NPA_SYS_CLASS_DATE" DAYDATE CS_DAYDATE,

           "ACCT_NPA_SYS_MAIN_CLASS_CODE" VARCHAR(50),

           "ACCT_NPA_SYS_SUB_CLASS_CODE" VARCHAR(50),

           "ACCT_NPA_USR_CLASS_DATE" DAYDATE CS_DAYDATE,

           "ACCT_NPA_USR_MAIN_CLASS_CODE" VARCHAR(50),

           "ACCT_NPA_USR_SUB_CLASS_CODE" VARCHAR(50),

           "ACCT_OCCUP_CODE" VARCHAR(50),

           "ACCT_OFFR" VARCHAR(15),

           "ACCT_OPN_DATE" DAYDATE CS_DAYDATE,

           "ACCT_OWNERSHIP_CODE" VARCHAR(50),

           "ACCT_RATING" VARCHAR(50),

           "ACCT_REPORT_CODE" VARCHAR(50),

           "ACCT_SRC_BACID" VARCHAR(50),

           "ACCT_STATUS_CODE" VARCHAR(50),

           "ACCT_STATUS_DATE" DAYDATE CS_DAYDATE,

           "ACCT_TYPE_CODE" VARCHAR(15),

           "ACTIVITY_CODE" VARCHAR(15),

           "ACTIVITY_LBR_CODE" VARCHAR(50),

           "ASCROM_ACCT_CLASS_CODE" VARCHAR(50),

           "ASCROM_CAD_AMT" NVARCHAR(50),

           "ASCROM_CADU_AMT" NVARCHAR(50),

           "ASCROM_NPA_DATE" DAYDATE CS_DAYDATE,

           "ASCROM_TOT_PROV" NVARCHAR(20),

           "BORROWER_SUB_GROUP_CODE" VARCHAR(15),

           "BR_CODE" VARCHAR(6),

           "CRNCY_CODE" VARCHAR(50),

           "CUST_NUM" NVARCHAR(50),

           "DEBT_ACKN_DATE" DAYDATE CS_DAYDATE,

           "FAC_DIST_CODE" VARCHAR(50),

           "FAC_DIST_NAME" VARCHAR(50),

           "FLG_ACCT_CLS" VARCHAR(50),

           "FLG_ACCT_LIEN" VARCHAR(50),

           "FLG_ACCT_PEGGED" VARCHAR(50),

           "FLG_ACT_MOB_REG" VARCHAR(50),

           "FLG_CHQ_CHRG_COLL" VARCHAR(50),

           "FLG_COLTRL_DEPOSIT" VARCHAR(50),

           "FLG_COLTRL_LIFEINSURANCE" VARCHAR(50),

           "FLG_COLTRL_MACH" VARCHAR(50),

           "FLG_COLTRL_PROPERTY" VARCHAR(50),

           "FLG_COLTRL_VEHICLE" VARCHAR(50),

           "FLG_CR_INT" VARCHAR(50),

           "FLG_ECGC_APPL" VARCHAR(50),

           "FLG_NOM_AVAILABLE" VARCHAR(50),

           "FLG_PASS_BOOK" VARCHAR(50),

           "FLG_PASS_SHEET" VARCHAR(50),

           "FLG_RESTRD_ACCT" VARCHAR(50),

           "FLG_SME" VARCHAR(50),

           "FLG_SRC_DEL_REC" VARCHAR(50),

           "FLG_WRITTEN_OFF" VARCHAR(50),

           "GL_SUB_HEAD_CODE" VARCHAR(50),

           "GOVT_SPONSOR_SCHEME_CODE" VARCHAR(50),

           "GOVT_SPONSOR_SCHEME_NAME" VARCHAR(50),

           "GUARDIAN_COVER_CODE" VARCHAR(50),

           "IB_DEF_BIL" VARCHAR(50),

           "IB_FND_ACCT_IND" VARCHAR(50),

           "IB_XFER_IND" VARCHAR(50),

           "INV_IN_PLANT_AND_MACH" VARCHAR(50),

           "LANG_CODE" VARCHAR(50),

           "LAST_INT_APPLIED_DATE" DAYDATE CS_DAYDATE,

           "LAST_TRAN_DATE" DAYDATE CS_DAYDATE,

           "LINE_OF_BUS_CODE" VARCHAR(50),

           "LINE_OF_BUS_NAME" VARCHAR(50),

           "NPA_CLOSURE_REASON_CODE" NVARCHAR(20),

           "NPA_DATE" DAYDATE CS_DAYDATE,

           "PROD_CODE" VARCHAR(50),

           "REPHASE_CODE" VARCHAR(50),

           "REPHASEMENT_REASON_CODE" VARCHAR(50),

           "SANC_LMT" NVARCHAR(50),

           "SECTOR_CODE" VARCHAR(50),

           "SEGMENT_CODE" VARCHAR(50),

           "SRC_ACCT_NUM" NVARCHAR(50),

           "SUB_SECTOR_CODE" VARCHAR(50),

           "SUIT_STATUS_CODE" VARCHAR(50),

           "CREATED_DATE_1" DAYDATE CS_DAYDATE,

           "LST_UPDATE_DATE_1" DAYDATE CS_DAYDATE,

           "CREATE_RUN_CYCLE_ID_1" NVARCHAR(50),

           "LST_UPD_RUN_CYCLE_ID_1" NVARCHAR(50),

           "LST_UPD_JOB_ID_1" NVARCHAR(50),

           "CUST_ID" NVARCHAR(20),

           "EFF_START_DATE_2" DAYDATE CS_DAYDATE,

           "EFF_END_DATE_2" DAYDATE CS_DAYDATE,

           "FLG_CURR_REC_2" VARCHAR(50),

           "SRC_SYS_ID_2" NVARCHAR(50),

           "SRC_SYS_CODE_1" VARCHAR(50),

           "CUST_NUM_1" NVARCHAR(50),

           "ASSET_CLASS" VARCHAR(50),

           "BOB_EMP_NUM" NVARCHAR(50),

           "CLUSTER_CODE" VARCHAR(50),

           "CUST_CASTE_CODE" VARCHAR(50),

           "CUST_COMMUNITY_CODE" VARCHAR(50),

           "CUST_CONSTITUTION_BSR_CODE" VARCHAR(50),

           "CUST_CONSTITUTION_CODE" VARCHAR(50),

           "CUST_EMAIL" VARCHAR(70),

           "CUST_EMP_CODE" VARCHAR(50),

           "CUST_EMPLOYER_ADDR_LINE_1" VARCHAR(70),

           "CUST_EMPLOYER_ADDR_LINE_2" VARCHAR(70),

           "CUST_EMPLOYER_CITY_CODE" VARCHAR(50),

           "CUST_EMPLOYER_CNTRY_CODE" VARCHAR(50),

           "CUST_EMPLOYER_EMAIL" VARCHAR(70),

           "CUST_EMPLOYER_FAX" NVARCHAR(50),

           "CUST_EMPLOYER_NAME" VARCHAR(70),

           "CUST_EMPLOYER_PH1" NVARCHAR(50),

           "CUST_EMPLOYER_PH2" NVARCHAR(50),

           "CUST_EMPLOYER_STATE_CODE" VARCHAR(50),

           "CUST_EMPLOYER_TELEX" NVARCHAR(50),

           "CUST_EMPLOYER_ZIP" VARCHAR(50),

           "CUST_FIRST_NAME" VARCHAR(50),

           "CUST_FULL_NAME" VARCHAR(150),

           "CUST_GENDER" VARCHAR(50),

           "CUST_LAST_NAME" VARCHAR(70),

           "CUST_MIDDLE_NAME" VARCHAR(50),

           "CUST_MOBILE_NUM" VARCHAR(50),

           "CUST_NATIONALITY" VARCHAR(50),

           "CUST_NPA_STATUS_CODE" VARCHAR(50),

           "CUST_PAN_NO" VARCHAR(50),

           "CUST_PRIMARY_BR_CODE" VARCHAR(50),

           "CUST_PRIMARY_BR_NAME" VARCHAR(50),

           "CUST_PRIMARY_CRNCY_CODE" VARCHAR(50),

           "CUST_PRIMARY_CRNCY_DESC" VARCHAR(50),

           "CUST_RATING_CODE" VARCHAR(50),

           "CUST_RATING_DATE" DAYDATE CS_DAYDATE,

           "CUST_SHORT_NAME" VARCHAR(50),

           "CUST_TITLE_CODE" VARCHAR(50),

           "CUST_TOT_FUND_BASED_LMT" NVARCHAR(50),

           "CUST_TOT_NONFUND_BASED_LMT" NVARCHAR(50),

           "DATE_OF_BIRTH" DAYDATE CS_DAYDATE,

           "DSA_NUM" NVARCHAR(50),

           "FLG_BOB_CURR_STAFF" VARCHAR(50),

           "FLG_BOB_STAFF" VARCHAR(50),

           "FLG_CUST_MINOR" VARCHAR(50),

           "FLG_CUST_NRE" VARCHAR(50),

           "FLG_NET_BANKING" VARCHAR(50),

           "FLG_SRC_DEL_REC_1" VARCHAR(50),

           "INDIVIDUAL_LEGALENTITY_IND" VARCHAR(50),

           "MAILING_ADDR_CITY_CODE" VARCHAR(50),

           "MAILING_ADDR_CNTRY_CODE" VARCHAR(50),

           "MAILING_ADDR_FAX" NVARCHAR(50),

           "MAILING_ADDR_PH1" NVARCHAR(50),

           "MAILING_ADDR_PH2" NVARCHAR(50),

           "MAILING_ADDR_TELEX" NVARCHAR(50),

           "MAILING_ADDR_ZIP" VARCHAR(50),

           "MAILLING_ADDR_LINE_1" VARCHAR(70),

           "MAILLING_ADDR_LINE_2" VARCHAR(70),

           "MAILLING_ADDR_LINE_3" VARCHAR(70),

           "MAILLING_ADDR_LINE_4" VARCHAR(70),

           "MAILLING_ADDR_LINE_5" VARCHAR(70),

           "MAILLING_ADDR_STATE_CODE" VARCHAR(50),

           "MARITIAL_STATUS_CODE" VARCHAR(50),

           "NATIONAL_ID_CARD_NUM" NVARCHAR(50),

           "NPA_DATE_1" DAYDATE CS_DAYDATE,

           "NPA_IDENTIFIED_BY" VARCHAR(50),

           "OCCUP_GRP_CODE" VARCHAR(50),

           "OCCUP_GRP_DESC" VARCHAR(50),

           "PASSPORT_DETAILS" VARCHAR(50),

           "PASSPORT_EXP_DATE" DAYDATE CS_DAYDATE,

           "PASSPORT_ISSUE_DATE" DAYDATE CS_DAYDATE,

           "PASSPORT_NUM" VARCHAR(50),

           "PERMANENT_ADDR_CITY_CODE" VARCHAR(50),

           "PERMANENT_ADDR_CNTRY_CODE" VARCHAR(70),

           "PERMANENT_ADDR_FAX" NVARCHAR(50),

           "PERMANENT_ADDR_LINE_1" VARCHAR(70),

           "PERMANENT_ADDR_LINE_2" VARCHAR(70),

           "PERMANENT_ADDR_LINE_3" VARCHAR(70),

           "PERMANENT_ADDR_LINE_4" VARCHAR(70),

           "PERMANENT_ADDR_LINE_5" VARCHAR(70),

           "PERMANENT_ADDR_PH1" NVARCHAR(50),

           "PERMANENT_ADDR_PH2" NVARCHAR(50),

           "PERMANENT_ADDR_STATE_CODE" VARCHAR(50),

           "PERMANENT_ADDR_TELEX" NVARCHAR(50),

           "PERMANENT_ADDR_ZIP_CODE" VARCHAR(50),

           "PREFERRED_LANG_CODE" VARCHAR(50),

           "SECTOR_CODE_1" VARCHAR(50),

           "SRC_CUST_START_DATE" DAYDATE CS_DAYDATE,

           "STATUS_CODE" VARCHAR(50),

           "CREATED_DATE_2" DAYDATE CS_DAYDATE,

           "LST_UPDATE_DATE_2" DAYDATE CS_DAYDATE,

           "CREATE_RUN_CYCLE_ID_2" NVARCHAR(50),

           "LST_UPD_RUN_CYCLE_ID_2" NVARCHAR(50),

           "LST_UPD_JOB_ID_2" NVARCHAR(50),

           "ACCT_ID_2" NVARCHAR(50),

           "BUS_DATE_ID" NVARCHAR(50),

           "BRANCH_ID" NVARCHAR(50),

           "CRNCY_ID" NVARCHAR(50),

           "CUST_ID_1" NVARCHAR(50),

           "GL_ID" NVARCHAR(50),

           "HM_CRNCY_ID" NVARCHAR(50),

           "PROD_ID" NVARCHAR(50),

           "SRC_SYS_ID_3" NVARCHAR(50),

           "FLG_DR_CR_BAL_AMT" NVARCHAR(50),

           "LAST_ATM_TXN_DATE" DAYDATE CS_DAYDATE,

           "LAST_CR_AMT_DATE" DAYDATE CS_DAYDATE,

           "LAST_CUST_TXN_DATE" DAYDATE CS_DAYDATE,

           "LAST_DR_AMT_DATE" DAYDATE CS_DAYDATE,

           "BAL_AMT" NVARCHAR(50),

           "CLEAR_BAL_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_BAL_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_TOT_DISB_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_TOT_DMD_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_TOT_OVDU_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_TOT_RECVRY_AMT" NVARCHAR(50),

           "EQV_HM_CRNCY_TOT_SANC_LIM_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_CLR_BAL_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_UNCLR_BAL_AMT" NVARCHAR(50),

           "EQUIV_HM_CRNCY_LIEN_AMT" NVARCHAR(50),

           "EQV_HM_CRNCY_TOT_CHRG_REC_AMT" NVARCHAR(50),

           "EQV_HM_CRNCY_MAX_BAL_IN_MNTH" NVARCHAR(50),

           "EQV_HM_CRNCY_MIN_BAL_IN_MNTH" NVARCHAR(50),

           "LIEN_AMT" NVARCHAR(50),

           "MAX_BAL_IN_MNTH" NVARCHAR(50),

           "MIN_BAL_IN_MNTH" NVARCHAR(50),

           "MTD_AVG_BAL_AMT" NVARCHAR(50),

           "NUM_CHQ_CAUTIONED" NVARCHAR(50),

           "NUM_CHQ_DESTROYED" NVARCHAR(50),

           "NUM_CHQ_PAID" NVARCHAR(50),

           "NUM_CHQ_RETURNED" NVARCHAR(50),

           "NUM_CHQ_STOPPED" NVARCHAR(50),

           "NUM_CHQ_UNPAID" NVARCHAR(50),

           "QTD_AVG_BAL_AMT" NVARCHAR(50),

           "TOT_ATM_TXN_AMT" NVARCHAR(50),

           "TOT_ATM_TXN_COUNT" NVARCHAR(50),

           "TOT_CHRGS_RECD_AMT" NVARCHAR(50),

           "TOT_CR_AMT" NVARCHAR(50),

           "TOT_DISB_AMT" NVARCHAR(50),

           "TOT_DMD_AMT" NVARCHAR(50),

           "TOT_DR_AMT" NVARCHAR(50),

           "TOT_RTGS_NEFT_EBANK_TXN_AMT" NVARCHAR(50),

           "TOT_RTGS_NEFT_EBANK_TXN_COUNT" NVARCHAR(50),

           "TOT_INT_PAID_AMT" NVARCHAR(50),

           "TOT_INT_PAYABLE_AMT" NVARCHAR(50),

           "TOT_INT_RECD_AMT" NVARCHAR(50),

           "TOT_OVDU_AMT" NVARCHAR(50),

           "TOT_POS_TXN_AMT" NVARCHAR(50),

           "TOT_POS_TXN_COUNT" NVARCHAR(50),

           "TOT_RECVRY_AMT" NVARCHAR(50),

           "TOT_NON_EBNK_RTGS_NEFT_TXN_AMT" NVARCHAR(50),

           "TOT_NON_EBNK_RTGS_NEFT_TXN_CNT" NVARCHAR(50),

           "TOT_SANC_LIM_AMT" NVARCHAR(50),

           "TOT_TXN_COUNT_CR" NVARCHAR(50),

           "TOT_TXN_COUNT_DR" NVARCHAR(50),

           "UNCLEAR_BAL_AMT" NVARCHAR(50),

           "YIELD_FROM_AC_AMT" NVARCHAR(50),

           "YTD_AVG_BAL_AMT" NVARCHAR(50),

           "CREATED_DATE_3" DAYDATE CS_DAYDATE,

           "LST_UPDATE_DATE_3" DAYDATE CS_DAYDATE,

           "CREATE_RUN_CYCLE_ID_3" DAYDATE CS_DAYDATE,

           "LST_UPD_RUN_CYCLE_ID_3" NVARCHAR(50),

           "LST_UPD_JOB_ID_3" NVARCHAR(50),

           "DATE_ID" NVARCHAR(50),

           "CALENDAR_DATE" DAYDATE CS_DAYDATE,

           "BUS_DATE_LAST_MNTH" DAYDATE CS_DAYDATE,

           "BUS_DATE_LAST_QTR" DAYDATE CS_DAYDATE,

           "BUS_DATE_LAST_YEAR" DAYDATE CS_DAYDATE,

           "BUS_DAY_CURR_FIN_YEAR" NVARCHAR(50),

           "BUS_DAY_CURR_MNTH" NVARCHAR(50),

           "BUS_DAY_CURR_QTR" NVARCHAR(50),

           "BUS_DAY_CURR_YEAR" NVARCHAR(50),

           "CAL_1_YEAR_AGO" NVARCHAR(50),

           "CAL_2_YEAR_AGO" NVARCHAR(50),

           "CAL_3_MNTHS_AGO" VARCHAR(50),

           "CAL_6_MNTHS_AGO" VARCHAR(50),

           "CAL_DAYS_IN_MNTH" NVARCHAR(50),

           "CAL_DAY_NAME_FULL" VARCHAR(50),

           "CAL_DAY_NAME_SHORT" VARCHAR(50),

           "CAL_DAY_OF_MNTH_NUM" NVARCHAR(50),

           "CAL_DAY_OF_QTR_NUM" NVARCHAR(50),

           "CAL_DAY_OF_WEEK_NUM" NVARCHAR(50),

           "CAL_DAY_OF_YEAR_NUM" NVARCHAR(50),

           "CAL_FORTNIGHT_END_DATE" DAYDATE CS_DAYDATE,

           "CAL_HALF_END_DATE" DAYDATE CS_DAYDATE,

           "CAL_HALF_END_FRI_DATE" DAYDATE CS_DAYDATE,

           "CAL_HALF_OF_YEAR_NUM" NVARCHAR(50),

           "CAL_HOLIDAY_NAME" VARCHAR(50),

           "CAL_MNTH_AGO" VARCHAR(50),

           "CAL_MNTH_END_DATE" DAYDATE CS_DAYDATE,

           "CAL_MNTH_END_FRI_DATE" DAYDATE CS_DAYDATE,

           "CAL_MNTH_NAME_FULL" VARCHAR(50),

           "CAL_MNTH_NAME_SHORT" VARCHAR(50),

           "CAL_MNTH_NUM" NVARCHAR(50),

           "CAL_MNTH_OF_QTR_NUM" NVARCHAR(50),

           "CAL_MNTH_OF_YEAR_NUM" NVARCHAR(50),

           "CAL_QTR_END_DATE" DAYDATE CS_DAYDATE,

           "CAL_QTR_END_FRI_DATE" DAYDATE CS_DAYDATE,

           "CAL_QTR_NUM" NVARCHAR(50),

           "CAL_QTR_OF_YEAR_NUM" NVARCHAR(50),

           "CAL_WEEK_END_DATE" DAYDATE CS_DAYDATE,

           "CAL_WEEK_END_FRI_DATE" DAYDATE CS_DAYDATE,

           "CAL_WEEK_OF_MNTH_NUM" NVARCHAR(50),

           "CAL_WEEK_OF_QTR_NUM" NVARCHAR(50),

           "CAL_WEEK_OF_YEAR_NUM" NVARCHAR(50),

           "CAL_YEAR" NVARCHAR(50),

           "CAL_YEAR_MNTH_YYYYMM" NVARCHAR(50),

           "FIN_1_YEAR_AGO" VARCHAR(50),

           "FIN_2_YEAR_AGO" VARCHAR(50),

           "FIN_CURR_YEAR" VARCHAR(50),

           "FIN_DAY_OF_YEAR_NUM" NVARCHAR(50),

           "FIN_HALF_OF_YEAR_NUM" NVARCHAR(50),

           "FIN_MNTH_NUM" NVARCHAR(50),

           "FIN_MNTH_OF_YEAR_NUM" NVARCHAR(50),

           "FIN_QTR_NUM" NVARCHAR(50),

           "FIN_QTR_OF_YEAR_NUM" NVARCHAR(50),

           "FIN_WEEK_OF_YEAR_NUM" NVARCHAR(50),

           "FLG_BOB_HOLIDAY" VARCHAR(50),

           "FLG_CAL_WEEKEND" VARCHAR(50),

           "FLG_CAL_YEAR_END" VARCHAR(50),

           "FLG_FIN_HALF_YR_END" VARCHAR(50),

           "FLG_FIN_HALF_YR_START" VARCHAR(50),

           "FLG_FIN_MNTH_FORTNIGHT" VARCHAR(50),

           "FLG_FIN_MNTH_FORTNIGHT_FRI" VARCHAR(50),

           "FLG_FIN_QTR_END" VARCHAR(50),

           "FLG_FIN_YEAR_END" VARCHAR(50),

           "FLG_FIN_YEAR_START" VARCHAR(50),

           "FLG_MNTH_END_DATE" VARCHAR(50),

           "FLG_MNTH_LAST_FRI" VARCHAR(50),

           "FLG_PUBLIC_HOLIDAY" VARCHAR(50),

           "FORTNIGHT_FRI_END_DATE" DAYDATE CS_DAYDATE,

           "PREV_FIN_QTR_END_DATE" DAYDATE CS_DAYDATE,

           "CREATED_DATE_4" DAYDATE CS_DAYDATE,

           "LST_UPDATE_DATE_4" DAYDATE CS_DAYDATE,

           "CREATE_RUN_CYCLE_ID_4" NVARCHAR(50),

           "LST_UPD_RUN_CYCLE_ID_4" NVARCHAR(50),

           "LST_UPD_JOB_ID_4" NVARCHAR(25)) UNLOAD PRIORITY 5 AUTO MERGE

Regards,

Praveen,

+91 8056052928.

[rindia]

Hi Praveen,

Your table structure is big. Looks like you forgot to attach the CSV file. Good that you have not sent

 I have been trying to create the table in three different ways that are possible.
1. With the New table creation and automatically the HANA to decide the data types, where i have been facing with these errors.
2. Through Second method using the Existing table as first creation of the table and trying to laod the data from csv CASA data to it.

To make this simple, just take save as copy of your csv file and keep only 1 or 2 records in it.

In case of errors, compare your file column data size and type with error.

As per my opinion, if you want to try all the methods to load data, then take the file which has few columns only, covering as many data types, with few records in it.

This is how you can play and then go for file with bulk columns and data.

Let me know if you need simple sample data.

Regards

Raj

[former_member184768]

Hi Praveen,

Couple of suggestions.

1. Can you please change your create table script and ensure that it uses NVARCHAR instead of VARCHAR. In case you have extended characters in your data, VARCHAR may not be able to fit in the characters in the given length.
2. The script looks like the generated script, but I hope your date data types are defined as DATE, which has column store type as DAYDATE.
3. Can you please provide more details on the Numeric overflow error. For which column does it happen.

Regards,

Ravi

[vivekbhoj]

Hi Praveen,

In your second case,

1. Batch From Record 2 to 705 Failed.

Can you please click and select any one of the error and you will get more details regarding it in the below empty box.

Please post that message.

Most probably I think it is due to some data type mismatch

And if possible please post some sample data

Regards,

Vivek