cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

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_IDEFF_START_DATEEFF_END_DATEFLG_CURR_RECSRC_SYS_IDACCT_LVL_PH_NUMADHOC_LMT_AMTBP_LINE_AMT_SANCBP_LINE_AMT_UTILCLEAN_ADHOC_LMT_AMTCLEAN_SINGLE_TRAN_LMT_AMTDACC_ABS_LMT_AMTDACC_LMT_AMTDACC_LMT_PERCDR_BAL_LMT_AMTEXP_OF_ADHOC_LMT_DATEFAC_AVAILED_CODEFLG_ACCT_BLOCKEDFLG_CHQ_MANDATEFLG_DORM_SCFLG_INT_WAIVERFLG_RELATIVE_STAFFFLG_SC_WAIVERFLG_SWEEP_OUT_INFLG_TDSFLG_WTAXIND_VOSTRO_ACCTMODE_OF_OPER_TYPERATE_VARIANCE_INT_CRRATE_VARIANCE_INT_DRRELATIVE_STAFF_EMP_NUMSINGLE_TRAN_LMT_AMTUSED_CLEAN_SINGLE_TRAN_LMT_AMTUSED_SINGLE_TRAN_LMT_AMTUSED_UNCLEAR_OVER_DACC_AMTWTAX_FLOOR_LMT_AMTWTAX_PERCCREATED_DATELST_UPDATE_DATECREATE_RUN_CYCLE_IDLST_UPD_RUN_CYCLE_IDLST_UPD_JOB_IDACCT_ID_1EFF_START_DATE_1EFF_END_DATE_1FLG_CURR_REC_1SRC_SYS_ID_1SRC_SYS_CODEACCT_NUMACCEPTED_RATINGACCT_BAL_BEFORE_CLOSUREACCT_CLS_DATEACCT_CR_PREF_PERCACCT_DR_PREF_PERCACCT_EFF_ROIACCT_LOC_CODEACCT_MGR_USR_IDACCT_NAMEACCT_NPA_CLASS_REASON_CODEACCT_NPA_CLASS_TYPE_CODEACCT_NPA_SYS_CLASS_DATEACCT_NPA_SYS_MAIN_CLASS_CODEACCT_NPA_SYS_SUB_CLASS_CODEACCT_NPA_USR_CLASS_DATEACCT_NPA_USR_MAIN_CLASS_CODEACCT_NPA_USR_SUB_CLASS_CODEACCT_OCCUP_CODEACCT_OFFRACCT_OPN_DATEACCT_OWNERSHIP_CODEACCT_RATINGACCT_REPORT_CODEACCT_SRC_BACIDACCT_STATUS_CODEACCT_STATUS_DATEACCT_TYPE_CODEACTIVITY_CODEACTIVITY_LBR_CODEASCROM_ACCT_CLASS_CODEASCROM_CAD_AMTASCROM_CADU_AMTASCROM_NPA_DATEASCROM_TOT_PROVBORROWER_SUB_GROUP_CODEBR_CODECRNCY_CODECUST_NUMDEBT_ACKN_DATEFAC_DIST_CODEFAC_DIST_NAMEFLG_ACCT_CLSFLG_ACCT_LIENFLG_ACCT_PEGGEDFLG_ACT_MOB_REGFLG_CHQ_CHRG_COLLFLG_COLTRL_DEPOSITFLG_COLTRL_LIFEINSURANCEFLG_COLTRL_MACHFLG_COLTRL_PROPERTYFLG_COLTRL_VEHICLEFLG_CR_INTFLG_ECGC_APPLFLG_NOM_AVAILABLEFLG_PASS_BOOKFLG_PASS_SHEETFLG_RESTRD_ACCTFLG_SMEFLG_SRC_DEL_RECFLG_WRITTEN_OFFGL_SUB_HEAD_CODEGOVT_SPONSOR_SCHEME_CODEGOVT_SPONSOR_SCHEME_NAMEGUARDIAN_COVER_CODEIB_DEF_BILIB_FND_ACCT_INDIB_XFER_INDINV_IN_PLANT_AND_MACHLANG_CODELAST_INT_APPLIED_DATELAST_TRAN_DATELINE_OF_BUS_CODELINE_OF_BUS_NAMENPA_CLOSURE_REASON_CODENPA_DATEPROD_CODEREPHASE_CODEREPHASEMENT_REASON_CODESANC_LMTSECTOR_CODESEGMENT_CODESRC_ACCT_NUMSUB_SECTOR_CODESUIT_STATUS_CODECREATED_DATE_1LST_UPDATE_DATE_1CREATE_RUN_CYCLE_ID_1LST_UPD_RUN_CYCLE_ID_1LST_UPD_JOB_ID_1CUST_IDEFF_START_DATE_2EFF_END_DATE_2FLG_CURR_REC_2SRC_SYS_ID_2SRC_SYS_CODE_1CUST_NUM_1ASSET_CLASSBOB_EMP_NUMCLUSTER_CODECUST_CASTE_CODECUST_COMMUNITY_CODECUST_CONSTITUTION_BSR_CODECUST_CONSTITUTION_CODECUST_EMAILCUST_EMP_CODECUST_EMPLOYER_ADDR_LINE_1CUST_EMPLOYER_ADDR_LINE_2CUST_EMPLOYER_CITY_CODECUST_EMPLOYER_CNTRY_CODECUST_EMPLOYER_EMAILCUST_EMPLOYER_FAXCUST_EMPLOYER_NAMECUST_EMPLOYER_PH1CUST_EMPLOYER_PH2CUST_EMPLOYER_STATE_CODECUST_EMPLOYER_TELEXCUST_EMPLOYER_ZIPCUST_FIRST_NAMECUST_FULL_NAMECUST_GENDERCUST_LAST_NAMECUST_MIDDLE_NAMECUST_MOBILE_NUMCUST_NATIONALITYCUST_NPA_STATUS_CODECUST_PAN_NOCUST_PRIMARY_BR_CODECUST_PRIMARY_BR_NAMECUST_PRIMARY_CRNCY_CODECUST_PRIMARY_CRNCY_DESCCUST_RATING_CODECUST_RATING_DATECUST_SHORT_NAMECUST_TITLE_CODECUST_TOT_FUND_BASED_LMTCUST_TOT_NONFUND_BASED_LMTDATE_OF_BIRTHDSA_NUMFLG_BOB_CURR_STAFFFLG_BOB_STAFFFLG_CUST_MINORFLG_CUST_NREFLG_NET_BANKINGFLG_SRC_DEL_REC_1INDIVIDUAL_LEGALENTITY_INDMAILING_ADDR_CITY_CODEMAILING_ADDR_CNTRY_CODEMAILING_ADDR_FAXMAILING_ADDR_PH1MAILING_ADDR_PH2MAILING_ADDR_TELEXMAILING_ADDR_ZIPMAILLING_ADDR_LINE_1MAILLING_ADDR_LINE_2MAILLING_ADDR_LINE_3MAILLING_ADDR_LINE_4MAILLING_ADDR_LINE_5MAILLING_ADDR_STATE_CODEMARITIAL_STATUS_CODENATIONAL_ID_CARD_NUMNPA_DATE_1NPA_IDENTIFIED_BYOCCUP_GRP_CODEOCCUP_GRP_DESCPASSPORT_DETAILSPASSPORT_EXP_DATEPASSPORT_ISSUE_DATEPASSPORT_NUMPERMANENT_ADDR_CITY_CODEPERMANENT_ADDR_CNTRY_CODEPERMANENT_ADDR_FAXPERMANENT_ADDR_LINE_1PERMANENT_ADDR_LINE_2PERMANENT_ADDR_LINE_3PERMANENT_ADDR_LINE_4PERMANENT_ADDR_LINE_5PERMANENT_ADDR_PH1PERMANENT_ADDR_PH2PERMANENT_ADDR_STATE_CODEPERMANENT_ADDR_TELEXPERMANENT_ADDR_ZIP_CODEPREFERRED_LANG_CODESECTOR_CODE_1SRC_CUST_START_DATESTATUS_CODECREATED_DATE_2LST_UPDATE_DATE_2CREATE_RUN_CYCLE_ID_2LST_UPD_RUN_CYCLE_ID_2LST_UPD_JOB_ID_2ACCT_ID_2BUS_DATE_IDBRANCH_IDCRNCY_IDCUST_ID_1GL_IDHM_CRNCY_IDPROD_IDSRC_SYS_ID_3FLG_DR_CR_BAL_AMTLAST_ATM_TXN_DATELAST_CR_AMT_DATELAST_CUST_TXN_DATELAST_DR_AMT_DATEBAL_AMTCLEAR_BAL_AMTEQUIV_HM_CRNCY_BAL_AMTEQUIV_HM_CRNCY_TOT_DISB_AMTEQUIV_HM_CRNCY_TOT_DMD_AMTEQUIV_HM_CRNCY_TOT_OVDU_AMTEQUIV_HM_CRNCY_TOT_RECVRY_AMTEQV_HM_CRNCY_TOT_SANC_LIM_AMTEQUIV_HM_CRNCY_CLR_BAL_AMTEQUIV_HM_CRNCY_UNCLR_BAL_AMTEQUIV_HM_CRNCY_LIEN_AMTEQV_HM_CRNCY_TOT_CHRG_REC_AMTEQV_HM_CRNCY_MAX_BAL_IN_MNTHEQV_HM_CRNCY_MIN_BAL_IN_MNTHLIEN_AMTMAX_BAL_IN_MNTHMIN_BAL_IN_MNTHMTD_AVG_BAL_AMTNUM_CHQ_CAUTIONEDNUM_CHQ_DESTROYEDNUM_CHQ_PAIDNUM_CHQ_RETURNEDNUM_CHQ_STOPPEDNUM_CHQ_UNPAIDQTD_AVG_BAL_AMTTOT_ATM_TXN_AMTTOT_ATM_TXN_COUNTTOT_CHRGS_RECD_AMTTOT_CR_AMTTOT_DISB_AMTTOT_DMD_AMTTOT_DR_AMTTOT_RTGS_NEFT_EBANK_TXN_AMTTOT_RTGS_NEFT_EBANK_TXN_COUNTTOT_INT_PAID_AMTTOT_INT_PAYABLE_AMTTOT_INT_RECD_AMTTOT_OVDU_AMTTOT_POS_TXN_AMTTOT_POS_TXN_COUNTTOT_RECVRY_AMTTOT_NON_EBNK_RTGS_NEFT_TXN_AMTTOT_NON_EBNK_RTGS_NEFT_TXN_CNTTOT_SANC_LIM_AMTTOT_TXN_COUNT_CRTOT_TXN_COUNT_DRUNCLEAR_BAL_AMTYIELD_FROM_AC_AMTYTD_AVG_BAL_AMTCREATED_DATE_3LST_UPDATE_DATE_3CREATE_RUN_CYCLE_ID_3LST_UPD_RUN_CYCLE_ID_3LST_UPD_JOB_ID_3DATE_IDCALENDAR_DATEBUS_DATE_LAST_MNTHBUS_DATE_LAST_QTRBUS_DATE_LAST_YEARBUS_DAY_CURR_FIN_YEARBUS_DAY_CURR_MNTHBUS_DAY_CURR_QTRBUS_DAY_CURR_YEARCAL_1_YEAR_AGOCAL_2_YEAR_AGOCAL_3_MNTHS_AGOCAL_6_MNTHS_AGOCAL_DAYS_IN_MNTHCAL_DAY_NAME_FULLCAL_DAY_NAME_SHORTCAL_DAY_OF_MNTH_NUMCAL_DAY_OF_QTR_NUMCAL_DAY_OF_WEEK_NUMCAL_DAY_OF_YEAR_NUMCAL_FORTNIGHT_END_DATECAL_HALF_END_DATECAL_HALF_END_FRI_DATECAL_HALF_OF_YEAR_NUMCAL_HOLIDAY_NAMECAL_MNTH_AGOCAL_MNTH_END_DATECAL_MNTH_END_FRI_DATECAL_MNTH_NAME_FULLCAL_MNTH_NAME_SHORTCAL_MNTH_NUMCAL_MNTH_OF_QTR_NUMCAL_MNTH_OF_YEAR_NUMCAL_QTR_END_DATECAL_QTR_END_FRI_DATECAL_QTR_NUMCAL_QTR_OF_YEAR_NUMCAL_WEEK_END_DATECAL_WEEK_END_FRI_DATECAL_WEEK_OF_MNTH_NUMCAL_WEEK_OF_QTR_NUMCAL_WEEK_OF_YEAR_NUMCAL_YEARCAL_YEAR_MNTH_YYYYMMFIN_1_YEAR_AGOFIN_2_YEAR_AGOFIN_CURR_YEARFIN_DAY_OF_YEAR_NUMFIN_HALF_OF_YEAR_NUMFIN_MNTH_NUMFIN_MNTH_OF_YEAR_NUMFIN_QTR_NUMFIN_QTR_OF_YEAR_NUMFIN_WEEK_OF_YEAR_NUMFLG_BOB_HOLIDAYFLG_CAL_WEEKENDFLG_CAL_YEAR_ENDFLG_FIN_HALF_YR_ENDFLG_FIN_HALF_YR_STARTFLG_FIN_MNTH_FORTNIGHTFLG_FIN_MNTH_FORTNIGHT_FRIFLG_FIN_QTR_ENDFLG_FIN_YEAR_ENDFLG_FIN_YEAR_STARTFLG_MNTH_END_DATEFLG_MNTH_LAST_FRIFLG_PUBLIC_HOLIDAYFORTNIGHT_FRI_END_DATEPREV_FIN_QTR_END_DATECREATED_DATE_4LST_UPDATE_DATE_4CREATE_RUN_CYCLE_ID_4LST_UPD_RUN_CYCLE_ID_4LST_UPD_JOB_ID_4
347487101/1/1900 0:0012/31/9999 0:00'Y'101nullnullnullnullnullnullnullnullnull0nullnull'D''Y''Y''Y'null'Y''N'nullnull'Y''001'nullnullnullnullnullnullnullnullnull########null130nullnull34748710################'Y'101'CBS-DOM''36050100002394'nullnullnullnullnullnullnullnull'LAMBATE WASEEM A RAZZAK'null'ACCNT'########'001''01'########'001''01'nullnull########'C'null'SB101'null'D'########'SBA'nullnullnullnullnullnullnullnull'3605''INR''060513953'nullnullnull'N''N'null'N''N''N''N''N''N''N''S'null'Y''Y''Y'nullnullnull'N''13421'nullnullnullnullnullnullnullnull################nullnullnullnull'SB101'nullnullnullnullnull'RW86910644'nullnull########null130nullnull57877140################'Y'101'CBS-DOM''060513953'nullnull'SAL'nullnullnull'INDL'nullnullnullnullnullnullnullnullnullnullnullnullnullnullnull'. LAMBATE WASEEM A RAZZAK''O'nullnullnullnullnullnullnullnull'INR''INDIAN RUPEE'nullnull'LAMBATE WA''.'nullnullnullnullnull'N''N''N''N''N'null'.''IN'nullnullnullnull'000000''SHAMIN APT BLDG NO 1ST 2ND FLOOR FL AT NO 23''ALMAS COLONY KAUSA MUMBRA'nullnullnull'.'null'NA'nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull'INFENG'null########null########null130null034748710JUN353876445787714082764487101'C'nullnullnullnull7297297290000null729nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull0null00nullnullnullnullnullnull0nullnull0nullnull0nullnullnullnullnullnullnullnullnullnull20120630################################nullnullnullnull20112010'32012''122011'30'Saturday''Sat'30917182########nullnull1null'52012'########null'June''Jun'null366/30/2012 0:00nullnull26/30/2012 0:00null5null262012201206nullnull'2012-2013'9013311nullnull'N''N'nullnull'Y'null'Y''N'null'Y'nullnull7/6/2012 0:003/31/2012 0:00nullnullnullnullnull
393410191/1/1900 0:0012/31/9999 0:00'Y'101nullnullnullnullnullnullnullnullnull0nullnullnull'N''Y''Y'null'Y''N'nullnull'Y''001'nullnullnullnullnullnullnullnullnull########null130nullnull39341019################'Y'101'CBS-DOM''02420100003574'nullnullnullnullnullnull'.'null'UTTAMBHAI MANJIBHAI VALVI'null'ACCNT'########'001''01'########'001''01'nullnull########'C'null'SB101'null'A'########'SBA'nullnullnullnullnullnullnullnull'0242''INR''018513248'nullnullnull'N''N'null'N''N''N''N''N''N''N''S'null'N''Y''Y'nullnullnull'N''13421'nullnullnullnullnullnullnullnull################nullnullnullnull'SB101'nullnullnullnullnull'1F31202117'nullnull########null130nullnull54150188################'Y'101'CBS-DOM''018513248'nullnull'AGRI''ST'nullnull'.'nullnull'SARIGAON BONPADA VIA BHILAD''TA UMBERGAON DI VALSAD''BHILD''IN'nullnullnullnullnull'GJ'null'396105'null'MR UTTAMBHAI MANJIBHAI VALVI''M'nullnull'00000000'nullnullnullnullnull'INR''INDIAN RUPEE'nullnull'UTTAMBHAI''MR'nullnull########nullnull'N''N''N''N''N'null'BHILD''IN'null'00000000''00000000'null'396105''SARIGAM BONPADA VIA-BHILAD''BONPADA TA UMBERGAON DI VALSAD'nullnullnull'GJ'null'NA'nullnullnullnullnullnullnullnull'BHILD''IN'null'SARIGAON BONPADA VIA BHILAD''TA UMBERGAON DI VALSAD'nullnullnullnullnull'GJ'null'396105''INFENG'null########'GENER'########null130null039341019APR271576445415018882764487101'C'nullnullnullnull49960.7549960.7549960.750000null49960.75nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull0null00nullnullnullnullnullnull0nullnull0nullnull0nullnullnullnullnullnullnullnullnullnull20120430################################nullnullnullnull20112010'12012''102011'30'Monday''Mon'30302121########nullnull1null'32012'########null'April''Apr'null146/30/2012 0:00nullnull25/5/2012 0:00null5null182012201204nullnull'2012-2013'2911111nullnull'N''N'nullnull'Y'nullnull'N'null'Y'nullnull5/11/2012 0:003/31/2012 0:00nullnullnullnullnull
422198791/1/1900 0:0012/31/9999 0:00'Y'101nullnullnullnullnullnullnullnullnull0nullnullnull'Y''Y''Y'null'Y''N'nullnull'Y''001'nullnullnullnullnullnullnullnullnull########null130nullnull42219879################'Y'101'CBS-DOM''15980100008294'nullnullnullnullnullnull'RURAL'null'AMBABEN PREMABHAI PATEL'null'ACCNT'########'001''01'########'001''01'nullnull########'C'null'SB114'null'A'########'SBA'nullnullnullnullnullnullnullnull'1598''INR''059536577'nullnullnull'N''N'null'N''N''N''N''N''N''N''S'null'N''Y''N'nullnullnull'N''13421'nullnullnullnullnullnullnullnull################nullnullnullnull'SB114'nullnullnullnullnull'T882284299'nullnull########null130nullnull68062093################'Y'101'CBS-DOM''059536577'nullnull'PENS''ST'nullnull'44207'nullnullnullnullnullnullnullnullnullnullnullnullnullnullnull'MRS AMBABEN PREMABHAI PATEL'nullnullnullnullnullnullnullnullnull'INR''INDIAN RUPEE'nullnull'AMBABEN''MRS'nullnull########nullnull'N''N''N''N''N'null'CHIKH''IN'nullnullnullnull'396560''AT POST KANGWAI DESAI FALIA''TAL CHIKHLI DIST NAVSARI'nullnullnull'GJ'null'NA'nullnullnullnullnullnullnullnull'CHIKH''IN'null'AT POST KANGWAI DESAI FALIA''TAL CHIKHLI DIST NAVSARI'nullnullnullnullnull'GJ'null'396560'nullnull########'PENSN'########null130null042219879JAN201576446806209382764493101'C'nullnullnullnull3527135271352710000035271nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull0null00nullnullnullnullnullnull0nullnull0nullnull0nullnullnullnullnullnullnullnullnullnull20120131################################nullnullnullnull20112010'102011''72011'31'Tuesday''Tue'3131331########nullnull1null'122011'########null'January''Jan'null113/31/2012 0:00nullnull12/4/2012 0:00null5null52012201201nullnull'2011-2012'3062101044nullnull'N''N'nullnull'Y'nullnull'N'null'Y'nullnull2/3/2012 0:0012/31/2011 0:00nullnullnullnullnull

Kindly go through the "Error screen shot"

And guide me accordingly to solve this above error.

Regards,

Praveen,

+91 8056052928.

Accepted Solutions (0)

Answers (2)

Answers (2)

vivekbhoj
Active Contributor
0 Kudos

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

former_member184871
Contributor
0 Kudos

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.


Former Member
0 Kudos

Hi,

For Data from Local file the format of the date should be "yyyy-mm-dd" or "yyyymmdd". Please try with the above format and the data will get uploaded.

If you are using Timestamp then the format should be yyyy-mm-dd hh:mm:ss[.f...]. The fractional seconds may be omitted.

Regards,

Thomas

vivekbhoj
Active Contributor
0 Kudos

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