on 11-27-2013 5:45 AM
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:
The below was the error details that i am able to find when i have clicked on the "Batch From Record 2 to 705 Failed error"
Error Details:
Message :
Batch from Record 2 to 705 Failed
java.lang.IllegalArgumentException
at java.sql.Date.valueOf(Unknown Source)
at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:93)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:198)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.run(FileUploaderJob.java:61)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
PFB sample CASA csv file sample data of 3 Records.
ACCT_ID | EFF_START_DATE | EFF_END_DATE | FLG_CURR_REC | SRC_SYS_ID | ACCT_LVL_PH_NUM | ADHOC_LMT_AMT | BP_LINE_AMT_SANC | BP_LINE_AMT_UTIL | CLEAN_ADHOC_LMT_AMT | CLEAN_SINGLE_TRAN_LMT_AMT | DACC_ABS_LMT_AMT | DACC_LMT_AMT | DACC_LMT_PERC | DR_BAL_LMT_AMT | EXP_OF_ADHOC_LMT_DATE | FAC_AVAILED_CODE | FLG_ACCT_BLOCKED | FLG_CHQ_MANDATE | FLG_DORM_SC | FLG_INT_WAIVER | FLG_RELATIVE_STAFF | FLG_SC_WAIVER | FLG_SWEEP_OUT_IN | FLG_TDS | FLG_WTAX | IND_VOSTRO_ACCT | MODE_OF_OPER_TYPE | RATE_VARIANCE_INT_CR | RATE_VARIANCE_INT_DR | RELATIVE_STAFF_EMP_NUM | SINGLE_TRAN_LMT_AMT | USED_CLEAN_SINGLE_TRAN_LMT_AMT | USED_SINGLE_TRAN_LMT_AMT | USED_UNCLEAR_OVER_DACC_AMT | WTAX_FLOOR_LMT_AMT | WTAX_PERC | CREATED_DATE | LST_UPDATE_DATE | CREATE_RUN_CYCLE_ID | LST_UPD_RUN_CYCLE_ID | LST_UPD_JOB_ID | ACCT_ID_1 | EFF_START_DATE_1 | EFF_END_DATE_1 | FLG_CURR_REC_1 | SRC_SYS_ID_1 | SRC_SYS_CODE | ACCT_NUM | ACCEPTED_RATING | ACCT_BAL_BEFORE_CLOSURE | ACCT_CLS_DATE | ACCT_CR_PREF_PERC | ACCT_DR_PREF_PERC | ACCT_EFF_ROI | ACCT_LOC_CODE | ACCT_MGR_USR_ID | ACCT_NAME | ACCT_NPA_CLASS_REASON_CODE | ACCT_NPA_CLASS_TYPE_CODE | ACCT_NPA_SYS_CLASS_DATE | ACCT_NPA_SYS_MAIN_CLASS_CODE | ACCT_NPA_SYS_SUB_CLASS_CODE | ACCT_NPA_USR_CLASS_DATE | ACCT_NPA_USR_MAIN_CLASS_CODE | ACCT_NPA_USR_SUB_CLASS_CODE | ACCT_OCCUP_CODE | ACCT_OFFR | ACCT_OPN_DATE | ACCT_OWNERSHIP_CODE | ACCT_RATING | ACCT_REPORT_CODE | ACCT_SRC_BACID | ACCT_STATUS_CODE | ACCT_STATUS_DATE | ACCT_TYPE_CODE | ACTIVITY_CODE | ACTIVITY_LBR_CODE | ASCROM_ACCT_CLASS_CODE | ASCROM_CAD_AMT | ASCROM_CADU_AMT | ASCROM_NPA_DATE | ASCROM_TOT_PROV | BORROWER_SUB_GROUP_CODE | BR_CODE | CRNCY_CODE | CUST_NUM | DEBT_ACKN_DATE | FAC_DIST_CODE | FAC_DIST_NAME | FLG_ACCT_CLS | FLG_ACCT_LIEN | FLG_ACCT_PEGGED | FLG_ACT_MOB_REG | FLG_CHQ_CHRG_COLL | FLG_COLTRL_DEPOSIT | FLG_COLTRL_LIFEINSURANCE | FLG_COLTRL_MACH | FLG_COLTRL_PROPERTY | FLG_COLTRL_VEHICLE | FLG_CR_INT | FLG_ECGC_APPL | FLG_NOM_AVAILABLE | FLG_PASS_BOOK | FLG_PASS_SHEET | FLG_RESTRD_ACCT | FLG_SME | FLG_SRC_DEL_REC | FLG_WRITTEN_OFF | GL_SUB_HEAD_CODE | GOVT_SPONSOR_SCHEME_CODE | GOVT_SPONSOR_SCHEME_NAME | GUARDIAN_COVER_CODE | IB_DEF_BIL | IB_FND_ACCT_IND | IB_XFER_IND | INV_IN_PLANT_AND_MACH | LANG_CODE | LAST_INT_APPLIED_DATE | LAST_TRAN_DATE | LINE_OF_BUS_CODE | LINE_OF_BUS_NAME | NPA_CLOSURE_REASON_CODE | NPA_DATE | PROD_CODE | REPHASE_CODE | REPHASEMENT_REASON_CODE | SANC_LMT | SECTOR_CODE | SEGMENT_CODE | SRC_ACCT_NUM | SUB_SECTOR_CODE | SUIT_STATUS_CODE | CREATED_DATE_1 | LST_UPDATE_DATE_1 | CREATE_RUN_CYCLE_ID_1 | LST_UPD_RUN_CYCLE_ID_1 | LST_UPD_JOB_ID_1 | CUST_ID | EFF_START_DATE_2 | EFF_END_DATE_2 | FLG_CURR_REC_2 | SRC_SYS_ID_2 | SRC_SYS_CODE_1 | CUST_NUM_1 | ASSET_CLASS | BOB_EMP_NUM | CLUSTER_CODE | CUST_CASTE_CODE | CUST_COMMUNITY_CODE | CUST_CONSTITUTION_BSR_CODE | CUST_CONSTITUTION_CODE | CUST_EMAIL | CUST_EMP_CODE | CUST_EMPLOYER_ADDR_LINE_1 | CUST_EMPLOYER_ADDR_LINE_2 | CUST_EMPLOYER_CITY_CODE | CUST_EMPLOYER_CNTRY_CODE | CUST_EMPLOYER_EMAIL | CUST_EMPLOYER_FAX | CUST_EMPLOYER_NAME | CUST_EMPLOYER_PH1 | CUST_EMPLOYER_PH2 | CUST_EMPLOYER_STATE_CODE | CUST_EMPLOYER_TELEX | CUST_EMPLOYER_ZIP | CUST_FIRST_NAME | CUST_FULL_NAME | CUST_GENDER | CUST_LAST_NAME | CUST_MIDDLE_NAME | CUST_MOBILE_NUM | CUST_NATIONALITY | CUST_NPA_STATUS_CODE | CUST_PAN_NO | CUST_PRIMARY_BR_CODE | CUST_PRIMARY_BR_NAME | CUST_PRIMARY_CRNCY_CODE | CUST_PRIMARY_CRNCY_DESC | CUST_RATING_CODE | CUST_RATING_DATE | CUST_SHORT_NAME | CUST_TITLE_CODE | CUST_TOT_FUND_BASED_LMT | CUST_TOT_NONFUND_BASED_LMT | DATE_OF_BIRTH | DSA_NUM | FLG_BOB_CURR_STAFF | FLG_BOB_STAFF | FLG_CUST_MINOR | FLG_CUST_NRE | FLG_NET_BANKING | FLG_SRC_DEL_REC_1 | INDIVIDUAL_LEGALENTITY_IND | MAILING_ADDR_CITY_CODE | MAILING_ADDR_CNTRY_CODE | MAILING_ADDR_FAX | MAILING_ADDR_PH1 | MAILING_ADDR_PH2 | MAILING_ADDR_TELEX | MAILING_ADDR_ZIP | MAILLING_ADDR_LINE_1 | MAILLING_ADDR_LINE_2 | MAILLING_ADDR_LINE_3 | MAILLING_ADDR_LINE_4 | MAILLING_ADDR_LINE_5 | MAILLING_ADDR_STATE_CODE | MARITIAL_STATUS_CODE | NATIONAL_ID_CARD_NUM | NPA_DATE_1 | NPA_IDENTIFIED_BY | OCCUP_GRP_CODE | OCCUP_GRP_DESC | PASSPORT_DETAILS | PASSPORT_EXP_DATE | PASSPORT_ISSUE_DATE | PASSPORT_NUM | PERMANENT_ADDR_CITY_CODE | PERMANENT_ADDR_CNTRY_CODE | PERMANENT_ADDR_FAX | PERMANENT_ADDR_LINE_1 | PERMANENT_ADDR_LINE_2 | PERMANENT_ADDR_LINE_3 | PERMANENT_ADDR_LINE_4 | PERMANENT_ADDR_LINE_5 | PERMANENT_ADDR_PH1 | PERMANENT_ADDR_PH2 | PERMANENT_ADDR_STATE_CODE | PERMANENT_ADDR_TELEX | PERMANENT_ADDR_ZIP_CODE | PREFERRED_LANG_CODE | SECTOR_CODE_1 | SRC_CUST_START_DATE | STATUS_CODE | CREATED_DATE_2 | LST_UPDATE_DATE_2 | CREATE_RUN_CYCLE_ID_2 | LST_UPD_RUN_CYCLE_ID_2 | LST_UPD_JOB_ID_2 | ACCT_ID_2 | BUS_DATE_ID | BRANCH_ID | CRNCY_ID | CUST_ID_1 | GL_ID | HM_CRNCY_ID | PROD_ID | SRC_SYS_ID_3 | FLG_DR_CR_BAL_AMT | LAST_ATM_TXN_DATE | LAST_CR_AMT_DATE | LAST_CUST_TXN_DATE | LAST_DR_AMT_DATE | BAL_AMT | CLEAR_BAL_AMT | EQUIV_HM_CRNCY_BAL_AMT | EQUIV_HM_CRNCY_TOT_DISB_AMT | EQUIV_HM_CRNCY_TOT_DMD_AMT | EQUIV_HM_CRNCY_TOT_OVDU_AMT | EQUIV_HM_CRNCY_TOT_RECVRY_AMT | EQV_HM_CRNCY_TOT_SANC_LIM_AMT | EQUIV_HM_CRNCY_CLR_BAL_AMT | EQUIV_HM_CRNCY_UNCLR_BAL_AMT | EQUIV_HM_CRNCY_LIEN_AMT | EQV_HM_CRNCY_TOT_CHRG_REC_AMT | EQV_HM_CRNCY_MAX_BAL_IN_MNTH | EQV_HM_CRNCY_MIN_BAL_IN_MNTH | LIEN_AMT | MAX_BAL_IN_MNTH | MIN_BAL_IN_MNTH | MTD_AVG_BAL_AMT | NUM_CHQ_CAUTIONED | NUM_CHQ_DESTROYED | NUM_CHQ_PAID | NUM_CHQ_RETURNED | NUM_CHQ_STOPPED | NUM_CHQ_UNPAID | QTD_AVG_BAL_AMT | TOT_ATM_TXN_AMT | TOT_ATM_TXN_COUNT | TOT_CHRGS_RECD_AMT | TOT_CR_AMT | TOT_DISB_AMT | TOT_DMD_AMT | TOT_DR_AMT | TOT_RTGS_NEFT_EBANK_TXN_AMT | TOT_RTGS_NEFT_EBANK_TXN_COUNT | TOT_INT_PAID_AMT | TOT_INT_PAYABLE_AMT | TOT_INT_RECD_AMT | TOT_OVDU_AMT | TOT_POS_TXN_AMT | TOT_POS_TXN_COUNT | TOT_RECVRY_AMT | TOT_NON_EBNK_RTGS_NEFT_TXN_AMT | TOT_NON_EBNK_RTGS_NEFT_TXN_CNT | TOT_SANC_LIM_AMT | TOT_TXN_COUNT_CR | TOT_TXN_COUNT_DR | UNCLEAR_BAL_AMT | YIELD_FROM_AC_AMT | YTD_AVG_BAL_AMT | CREATED_DATE_3 | LST_UPDATE_DATE_3 | CREATE_RUN_CYCLE_ID_3 | LST_UPD_RUN_CYCLE_ID_3 | LST_UPD_JOB_ID_3 | DATE_ID | CALENDAR_DATE | BUS_DATE_LAST_MNTH | BUS_DATE_LAST_QTR | BUS_DATE_LAST_YEAR | BUS_DAY_CURR_FIN_YEAR | BUS_DAY_CURR_MNTH | BUS_DAY_CURR_QTR | BUS_DAY_CURR_YEAR | CAL_1_YEAR_AGO | CAL_2_YEAR_AGO | CAL_3_MNTHS_AGO | CAL_6_MNTHS_AGO | CAL_DAYS_IN_MNTH | CAL_DAY_NAME_FULL | CAL_DAY_NAME_SHORT | CAL_DAY_OF_MNTH_NUM | CAL_DAY_OF_QTR_NUM | CAL_DAY_OF_WEEK_NUM | CAL_DAY_OF_YEAR_NUM | CAL_FORTNIGHT_END_DATE | CAL_HALF_END_DATE | CAL_HALF_END_FRI_DATE | CAL_HALF_OF_YEAR_NUM | CAL_HOLIDAY_NAME | CAL_MNTH_AGO | CAL_MNTH_END_DATE | CAL_MNTH_END_FRI_DATE | CAL_MNTH_NAME_FULL | CAL_MNTH_NAME_SHORT | CAL_MNTH_NUM | CAL_MNTH_OF_QTR_NUM | CAL_MNTH_OF_YEAR_NUM | CAL_QTR_END_DATE | CAL_QTR_END_FRI_DATE | CAL_QTR_NUM | CAL_QTR_OF_YEAR_NUM | CAL_WEEK_END_DATE | CAL_WEEK_END_FRI_DATE | CAL_WEEK_OF_MNTH_NUM | CAL_WEEK_OF_QTR_NUM | CAL_WEEK_OF_YEAR_NUM | CAL_YEAR | CAL_YEAR_MNTH_YYYYMM | FIN_1_YEAR_AGO | FIN_2_YEAR_AGO | FIN_CURR_YEAR | FIN_DAY_OF_YEAR_NUM | FIN_HALF_OF_YEAR_NUM | FIN_MNTH_NUM | FIN_MNTH_OF_YEAR_NUM | FIN_QTR_NUM | FIN_QTR_OF_YEAR_NUM | FIN_WEEK_OF_YEAR_NUM | FLG_BOB_HOLIDAY | FLG_CAL_WEEKEND | FLG_CAL_YEAR_END | FLG_FIN_HALF_YR_END | FLG_FIN_HALF_YR_START | FLG_FIN_MNTH_FORTNIGHT | FLG_FIN_MNTH_FORTNIGHT_FRI | FLG_FIN_QTR_END | FLG_FIN_YEAR_END | FLG_FIN_YEAR_START | FLG_MNTH_END_DATE | FLG_MNTH_LAST_FRI | FLG_PUBLIC_HOLIDAY | FORTNIGHT_FRI_END_DATE | PREV_FIN_QTR_END_DATE | CREATED_DATE_4 | LST_UPDATE_DATE_4 | CREATE_RUN_CYCLE_ID_4 | LST_UPD_RUN_CYCLE_ID_4 | LST_UPD_JOB_ID_4 |
34748710 | 1/1/1900 0:00 | 12/31/9999 0:00 | 'Y' | 101 | null | null | null | null | null | null | null | null | null | 0 | null | null | 'D' | 'Y' | 'Y' | 'Y' | null | 'Y' | 'N' | null | null | 'Y' | '001' | null | null | null | null | null | null | null | null | null | ######## | null | 130 | null | null | 34748710 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '36050100002394' | null | null | null | null | null | null | null | null | 'LAMBATE WASEEM A RAZZAK' | null | 'ACCNT' | ######## | '001' | '01' | ######## | '001' | '01' | null | null | ######## | 'C' | null | 'SB101' | null | 'D' | ######## | 'SBA' | null | null | null | null | null | null | null | null | '3605' | 'INR' | '060513953' | null | null | null | 'N' | 'N' | null | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'S' | null | 'Y' | 'Y' | 'Y' | null | null | null | 'N' | '13421' | null | null | null | null | null | null | null | null | ######## | ######## | null | null | null | null | 'SB101' | null | null | null | null | null | 'RW86910644' | null | null | ######## | null | 130 | null | null | 57877140 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '060513953' | null | null | 'SAL' | null | null | null | 'INDL' | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | '. LAMBATE WASEEM A RAZZAK' | 'O' | null | null | null | null | null | null | null | null | 'INR' | 'INDIAN RUPEE' | null | null | 'LAMBATE WA' | '.' | null | null | null | null | null | 'N' | 'N' | 'N' | 'N' | 'N' | null | '.' | 'IN' | null | null | null | null | '000000' | 'SHAMIN APT BLDG NO 1ST 2ND FLOOR FL AT NO 23' | 'ALMAS COLONY KAUSA MUMBRA' | null | null | null | '.' | null | 'NA' | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 'INFENG' | null | ######## | null | ######## | null | 130 | null | 0 | 34748710 | JUN | 3538 | 7644 | 57877140 | 82 | 7644 | 87 | 101 | 'C' | null | null | null | null | 729 | 729 | 729 | 0 | 0 | 0 | 0 | null | 729 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 0 | null | 0 | 0 | null | null | null | null | null | null | 0 | null | null | 0 | null | null | 0 | null | null | null | null | null | null | null | null | null | null | 20120630 | ######## | ######## | ######## | ######## | null | null | null | null | 2011 | 2010 | '32012' | '122011' | 30 | 'Saturday' | 'Sat' | 30 | 91 | 7 | 182 | ######## | null | null | 1 | null | '52012' | ######## | null | 'June' | 'Jun' | null | 3 | 6 | 6/30/2012 0:00 | null | null | 2 | 6/30/2012 0:00 | null | 5 | null | 26 | 2012 | 201206 | null | null | '2012-2013' | 90 | 1 | 3 | 3 | 1 | 1 | null | null | 'N' | 'N' | null | null | 'Y' | null | 'Y' | 'N' | null | 'Y' | null | null | 7/6/2012 0:00 | 3/31/2012 0:00 | null | null | null | null | null |
39341019 | 1/1/1900 0:00 | 12/31/9999 0:00 | 'Y' | 101 | null | null | null | null | null | null | null | null | null | 0 | null | null | null | 'N' | 'Y' | 'Y' | null | 'Y' | 'N' | null | null | 'Y' | '001' | null | null | null | null | null | null | null | null | null | ######## | null | 130 | null | null | 39341019 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '02420100003574' | null | null | null | null | null | null | '.' | null | 'UTTAMBHAI MANJIBHAI VALVI' | null | 'ACCNT' | ######## | '001' | '01' | ######## | '001' | '01' | null | null | ######## | 'C' | null | 'SB101' | null | 'A' | ######## | 'SBA' | null | null | null | null | null | null | null | null | '0242' | 'INR' | '018513248' | null | null | null | 'N' | 'N' | null | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'S' | null | 'N' | 'Y' | 'Y' | null | null | null | 'N' | '13421' | null | null | null | null | null | null | null | null | ######## | ######## | null | null | null | null | 'SB101' | null | null | null | null | null | '1F31202117' | null | null | ######## | null | 130 | null | null | 54150188 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '018513248' | null | null | 'AGRI' | 'ST' | null | null | '.' | null | null | 'SARIGAON BONPADA VIA BHILAD' | 'TA UMBERGAON DI VALSAD' | 'BHILD' | 'IN' | null | null | null | null | null | 'GJ' | null | '396105' | null | 'MR UTTAMBHAI MANJIBHAI VALVI' | 'M' | null | null | '00000000' | null | null | null | null | null | 'INR' | 'INDIAN RUPEE' | null | null | 'UTTAMBHAI' | 'MR' | null | null | ######## | null | null | 'N' | 'N' | 'N' | 'N' | 'N' | null | 'BHILD' | 'IN' | null | '00000000' | '00000000' | null | '396105' | 'SARIGAM BONPADA VIA-BHILAD' | 'BONPADA TA UMBERGAON DI VALSAD' | null | null | null | 'GJ' | null | 'NA' | null | null | null | null | null | null | null | null | 'BHILD' | 'IN' | null | 'SARIGAON BONPADA VIA BHILAD' | 'TA UMBERGAON DI VALSAD' | null | null | null | null | null | 'GJ' | null | '396105' | 'INFENG' | null | ######## | 'GENER' | ######## | null | 130 | null | 0 | 39341019 | APR | 2715 | 7644 | 54150188 | 82 | 7644 | 87 | 101 | 'C' | null | null | null | null | 49960.75 | 49960.75 | 49960.75 | 0 | 0 | 0 | 0 | null | 49960.75 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 0 | null | 0 | 0 | null | null | null | null | null | null | 0 | null | null | 0 | null | null | 0 | null | null | null | null | null | null | null | null | null | null | 20120430 | ######## | ######## | ######## | ######## | null | null | null | null | 2011 | 2010 | '12012' | '102011' | 30 | 'Monday' | 'Mon' | 30 | 30 | 2 | 121 | ######## | null | null | 1 | null | '32012' | ######## | null | 'April' | 'Apr' | null | 1 | 4 | 6/30/2012 0:00 | null | null | 2 | 5/5/2012 0:00 | null | 5 | null | 18 | 2012 | 201204 | null | null | '2012-2013' | 29 | 1 | 1 | 1 | 1 | 1 | null | null | 'N' | 'N' | null | null | 'Y' | null | null | 'N' | null | 'Y' | null | null | 5/11/2012 0:00 | 3/31/2012 0:00 | null | null | null | null | null |
42219879 | 1/1/1900 0:00 | 12/31/9999 0:00 | 'Y' | 101 | null | null | null | null | null | null | null | null | null | 0 | null | null | null | 'Y' | 'Y' | 'Y' | null | 'Y' | 'N' | null | null | 'Y' | '001' | null | null | null | null | null | null | null | null | null | ######## | null | 130 | null | null | 42219879 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '15980100008294' | null | null | null | null | null | null | 'RURAL' | null | 'AMBABEN PREMABHAI PATEL' | null | 'ACCNT' | ######## | '001' | '01' | ######## | '001' | '01' | null | null | ######## | 'C' | null | 'SB114' | null | 'A' | ######## | 'SBA' | null | null | null | null | null | null | null | null | '1598' | 'INR' | '059536577' | null | null | null | 'N' | 'N' | null | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'N' | 'S' | null | 'N' | 'Y' | 'N' | null | null | null | 'N' | '13421' | null | null | null | null | null | null | null | null | ######## | ######## | null | null | null | null | 'SB114' | null | null | null | null | null | 'T882284299' | null | null | ######## | null | 130 | null | null | 68062093 | ######## | ######## | 'Y' | 101 | 'CBS-DOM' | '059536577' | null | null | 'PENS' | 'ST' | null | null | '44207' | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 'MRS AMBABEN PREMABHAI PATEL' | null | null | null | null | null | null | null | null | null | 'INR' | 'INDIAN RUPEE' | null | null | 'AMBABEN' | 'MRS' | null | null | ######## | null | null | 'N' | 'N' | 'N' | 'N' | 'N' | null | 'CHIKH' | 'IN' | null | null | null | null | '396560' | 'AT POST KANGWAI DESAI FALIA' | 'TAL CHIKHLI DIST NAVSARI' | null | null | null | 'GJ' | null | 'NA' | null | null | null | null | null | null | null | null | 'CHIKH' | 'IN' | null | 'AT POST KANGWAI DESAI FALIA' | 'TAL CHIKHLI DIST NAVSARI' | null | null | null | null | null | 'GJ' | null | '396560' | null | null | ######## | 'PENSN' | ######## | null | 130 | null | 0 | 42219879 | JAN | 2015 | 7644 | 68062093 | 82 | 7644 | 93 | 101 | 'C' | null | null | null | null | 35271 | 35271 | 35271 | 0 | 0 | 0 | 0 | 0 | 35271 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 0 | null | 0 | 0 | null | null | null | null | null | null | 0 | null | null | 0 | null | null | 0 | null | null | null | null | null | null | null | null | null | null | 20120131 | ######## | ######## | ######## | ######## | null | null | null | null | 2011 | 2010 | '102011' | '72011' | 31 | 'Tuesday' | 'Tue' | 31 | 31 | 3 | 31 | ######## | null | null | 1 | null | '122011' | ######## | null | 'January' | 'Jan' | null | 1 | 1 | 3/31/2012 0:00 | null | null | 1 | 2/4/2012 0:00 | null | 5 | null | 5 | 2012 | 201201 | null | null | '2011-2012' | 306 | 2 | 10 | 10 | 4 | 4 | null | null | 'N' | 'N' | null | null | 'Y' | null | null | 'N' | null | 'Y' | null | null | 2/3/2012 0:00 | 12/31/2011 0:00 | null | null | null | null | null |
Kindly go through the "Error screen shot"
And guide me accordingly to solve this above error.
Regards,
Praveen,
+91 8056052928.
As seen from the error, it seems the error is due to DATE field.
Are you using Data Type as DATE while loading flat file
Either use this field as NVARCHAR or load DATE field from your file in the below format
YYYY-MM-DD
And make sure that it is shown in the same format when you try to load the file. In Excel if data type is DATE then change the data type to general. then only DATE field can be loaded from flat file
As you have so many null values in many fields so make sure that you don't check Not NULL checkbox
After making thses changes try loading data again
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Vivek
I am getting following error - during some test data load as flat file (Its a Date field and I have tried all the mentioned procedure, still not working)
Batch from Record 2 to 52 Failed
java.lang.IllegalArgumentException
at java.sql.Date.valueOf(Date.java:138)
at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:93)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:198)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.run(FileUploaderJob.java:61)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
For my scenario its mandatory to have Date field in SAP HANA as of DATE type.
I have referred the following discussion:
http://scn.sap.com/thread/3463201
Can you please look into the same.
Regards
Kumar.
Hi Praveen,
The image is broken
WHy did you create another thread for the same error,
You could have posted the sample data in the previous thread:
http://scn.sap.com/thread/3461172
Please refrain from creating duplicate threads
Close the earlier thread
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.