LOAD DATA INFILE - Error Code: 122. CAL0006: a BRM get hwm error. [BRM error status: FAILED]

3 posts / 0 new
Last post
jgheaton
jgheaton's picture
Offline
Last seen: 6 months 3 weeks ago
Joined: Feb 14 2014
Junior Boarder

Posts: 2

John Heaton , Snr DW Analyst
LOAD DATA INFILE - Error Code: 122. CAL0006: a BRM get hwm error. [BRM error status: FAILED]

I am using a LOAD DATA INFILE in a Proof of Concept to try and load data into InfiniDB file is around 8GB and on a Windows x64 platform.  

 

See Code below

 

use POC;
 
LOAD DATA INFILE 'E:/SAS/Stage/Files/UF_DTR_Bal.csv' INTO TABLE uf_dtr_bal_tx
FIELDS TERMINATED BY '|' 
LINES TERMINATED BY '\n'
( DTR_Level1 , DTR_Level2  ,
    DTR_Level3      ,
    DTR_Level4      ,
    DTR_Level5      ,
    DTR_Level6      ,
    DTR_Level7      ,
    DTR_Level8      ,
    DTR_Order        ,
    DTR_Code          ,
    GL_Control_Account ,
    Acct_No             ,
    Account_Status       ,
    Loan_Status           ,
    Mortgage_Insurance     ,
    Eligibility             ,
    Classification           ,
    Sec_Classification_Group  ,
    Sec_Classification_SubGroup,
    Sec_Scheme_Number          ,
    Sec_Scheme_Name            ,
    Sec_Scheme_Active_CD        ,
    Sec_Scheme_Int_Rate        ,
    Scenario                    ,
    Balance_Date                ,
    Bal_Curr                    ,
    LVR                         ,
    Int_Curr                    ,
    Sec_Int_Curr                ,
    Int_Rate_Curr               ,
    Sec_Int_Rate_Curr           ,
    Bal_Yest                    ,
    Bal_BOM                     ,
    Bal_BOY                     ,
    Repay_Curr                  ,
    Repay_Annual                ,
    Repay_Rate                  ,
    Days_Num                    ,
    Repay_Yest                  ,
    Repay_MTD                   ,
    Repay_YTD                   ,
    LANA_Amt                    ,
    DTR_Level1_Order            ,
    DTR_Level2_Order            ,
    DTR_Level3_Order            ,
    DTR_Level4_Order            ,
    DTR_Level5_Order            ,
    DTR_Level6_Order            ,
    DTR_Level7_Order            ,
    DTR_Level8_Order            ,
    Rec_Src_Sys                 );
 
The error I am receiving is 
 
Error Code: 122. CAL0006:  a BRM get hwm error. [BRM error status: FAILED]
 
Any ideas would be appreciatted. 
 
Thanks
John

 

jgheaton
jgheaton's picture
Offline
Last seen: 6 months 3 weeks ago
Joined: Feb 14 2014
Junior Boarder

Posts: 2

John Heaton , Snr DW Analyst
LOAD DATA INFILE - Error Code: 122. CAL0006:
Traced the issue to null or blank fields in the text file.  Modified the load script to cater for the nulls and seems to be working.  Any ideas how to achieve the same with cpimport ?
 
Thanks John
 
LOAD DATA INFILE 'E:/SAS/Stage/Files/UF_DTR_Bal.csv' INTO TABLE uf_dtr_bal_tx
FIELDS TERMINATED BY '|' 
LINES TERMINATED BY '\n'
( DTR_Level1 , DTR_Level2  ,
    DTR_Level3      ,
    DTR_Level4      ,
    DTR_Level5      ,
    DTR_Level6     ,
DTR_Level7,
DTR_Level8,
DTR_Order,
DTR_Code,
    GL_Control_Account          ,
    Acct_No                  ,
    Account_Status            ,
    Loan_Status             ,
    Mortgage_Insurance       ,
    Eligibility               ,
    Classification             ,
    Sec_Classification_Group    ,
    Sec_Classification_SubGroup ,
    Sec_Scheme_Number           ,
    Sec_Scheme_Name             ,
    Sec_Scheme_Active_CD        ,
    @Sec_Scheme_Int_Rate         ,
    Scenario,
@Balance_Date                ,
    @Bal_Curr                ,
    @LVR                         ,
    @Int_Curr                    ,
    @Sec_Int_Curr                ,
    @Int_Rate_Curr               ,
    @Sec_Int_Rate_Curr           ,
    @Bal_Yest                    ,
    @Bal_BOM                     ,
    @Bal_BOY                     ,
@Repay_Curr                  ,
    @Repay_Annual                ,
    @Repay_Rate                  ,
    @Days_Num                    ,
    @Repay_Yest                  ,
    @Repay_MTD                   ,
    @Repay_YTD                   ,
    @LANA_Amt       ,
@DTR_Level1_Order            ,
    @DTR_Level2_Order            ,
    @DTR_Level3_Order            ,
    @DTR_Level4_Order            ,
    @DTR_Level5_Order            ,
    @DTR_Level6_Order            ,
    @DTR_Level7_Order            ,
    @DTR_Level8_Order            ,
    Rec_Src_Sys 
)
SET Sec_Scheme_Int_Rate   = NULLIF(@Sec_Scheme_Int_Rate,''),
Balance_Date  =  str_to_date(@Balance_Date, '%d%b%Y'),            
Bal_Curr  = NULLIF(@Bal_Curr,'') , 
LVR =  NULLIF(@LVR,''),
Int_Curr  =  NULLIF(@Int_Curr,''),
    Sec_Int_Curr    =  NULLIF(@Sec_Int_Curr,''),
    Int_Rate_Curr   =  NULLIF(@Int_Rate_Curr,''),
    Sec_Int_Rate_Curr  =  NULLIF(@Sec_Int_Rate_Curr,''),
    Bal_Yest         =  NULLIF(@Bal_Yest,''),
    Bal_BOM        =  NULLIF(@Bal_BOM,''),
    Bal_BOY        =  NULLIF(@Bal_BOY,''),
 Repay_Curr     =  NULLIF(@Repay_Curr,''),
    Repay_Annual   =  NULLIF(@Repay_Annual,''),
    Repay_Rate     =  NULLIF(@Repay_Rate,''),
    Days_Num       =  NULLIF(@Days_Num,''),
    Repay_Yest     =  NULLIF(@Repay_Yest,''),
    Repay_MTD      =  NULLIF(@Repay_MTD,''),
    Repay_YTD      =  NULLIF(@Repay_YTD,''),
    LANA_Amt       =  NULLIF(@LANA_Amt,''), 
DTR_Level1_Order =  NULLIF(@DTR_Level1_Order,''),
    DTR_Level2_Order  =  NULLIF(@DTR_Level2_Order,''),
    DTR_Level3_Order  =  NULLIF(@DTR_Level3_Order,''),
    DTR_Level4_Order  =  NULLIF(@DTR_Level4_Order,''),
    DTR_Level5_Order  =  NULLIF(@DTR_Level5_Order,''),
    DTR_Level6_Order  =  NULLIF(@DTR_Level6_Order,''),
    DTR_Level7_Order  =  NULLIF(@DTR_Level7_Order,''),
    DTR_Level8_Order  =  NULLIF(@DTR_Level8_Order,'')
radams
radams's picture
Offline
Last seen: 2 days 19 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
LOAD DATA INFILE - Error Code: 122. CAL0006:

 

Hi John,

 

Check the Admin Guide has information on using cpimport for loading data.

 

Thanks,

 

Robert