Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: zonOriginally posted by: Tim Meagher
Can you post the code that you are using which encounters this error?
It looks like you are referencing the index of a character within a string, or the index of an element within a list beyond the end of the string/list.
Here is the code:
#Cria��o dos campos originais do ficheiro de Media��o
DataList = DATA.substr(8).split(",")
PRODUCT_INSTANCE_ID = DataList.getItem(0).replace("\"", "")
EVENT_START_DATETIME = DataList.getItem(2).replace("\"", "")
BA = DataList.getItem(13).replace("\"","")
ORIGIN = DataList.getItem(14).replace("\"","")
ORIGIN_COST_CODE = DataList.getItem(15).replace("\"","")
DESTINATION = DataList.getItem(16).replace("\"","")
COST_CODE= DataList.getItem(17).replace("\"","")
DURATION = DataList.getItem(18).replace("\"","").int()
OPERATOR = DataList.getItem(20).replace("\"","")
#Cria��o dos campos auxiliares para c�lculo
EVENT_START_DATE = EVENT_START_DATETIME.left(10).date("CCYY/MM/DD")
EVENT_START_YEAR = year(EVENT_START_DATE)
EVENT_START_MONTH = month(EVENT_START_DATE)
EVENT_START_DAY = day(EVENT_START_DATE)
EVENT_START_TIME = EVENT_START_DATETIME.substr(11,8).time("HH-MM-SS")
EVENT_START_HOUR = hours(EVENT_START_TIME)
EVENT_START_MINUTE = minutes(EVENT_START_TIME)
EVENT_START_SECOND = seconds(EVENT_START_TIME)
EVENT_STARTDATETIME = timestamp(date(EVENT_START_YEAR, EVENT_START_MONTH, EVENT_START_DAY), time(EVENT_START_HOUR, EVENT_START_MINUTE, EVENT_START_SECOND))
BAINST_ID = BA+PRODUCT_INSTANCE_ID
RECORD_ID = BAINST_ID+EVENT_STARTDATETIME+ORIGIN+DESTINATION
EVENT_END_DATE = dateTimeAdjust(EVENT_STARTDATETIME,DURATION,"secon ds")
EVENT_END_DAY = day(EVENT_END_DATE)
EVENT_END_HOUR = hours(EVENT_END_DATE)
EVENT_END_MINUTE = minutes(EVENT_END_DATE)
EVENT_END_SECOND = seconds(EVENT_END_DATE)
#Escreve os dados
emit PRODUCT_INSTANCE_ID,
BAINST_ID,
RECORD_ID,
EVENT_STARTDATETIME,
EVENT_START_DATE,
EVENT_START_YEAR,
EVENT_START_MONTH,
EVENT_START_DAY,
EVENT_START_TIME,
EVENT_START_HOUR,
EVENT_START_MINUTE,
EVENT_START_SECOND,
EVENT_END_DAY,
EVENT_END_HOUR,
EVENT_END_MINUTE,
EVENT_END_SECOND,
EVENT_END_DATE,
BA,
ORIGIN,
ORIGIN_COST_CODE,
DESTINATION,
COST_CODE,
DURATION,
OPERATOR
where EVENT_START_MONTH == 6