File Index is not in range 1 to 1

Last day i got one task.Need to insert employees form CSV file to CI.We know its was a common thing.First thing need to create CI for that.Drag drop CI in application engine.Then we will read our CSV file and insert to the CI.This is the code which i have written to load CSV file data (commented non required variables).

/* ===>

This is a dynamically generated PeopleCode template to be used only as a helper
to the application developer.
You need to replace all references to '[*]' OR default values with  references to
PeopleCode variables and/or a Rec.Fields. */

Local File &fileLog;
Local ApiObject &oSession, &oRPersonalData;
Local ApiObject &oNameTypeVwCollection, &oNameTypeVw;
Local ApiObject &oNamesCollection, &oNames;
Local ApiObject &oPersDataEffdtCollection, &oPersDataEffdt;
Local ApiObject &oPersNidCollection, &oPersNid;
Local ApiObject &oAddressTypeVwCollection, &oAddressTypeVw;
Local ApiObject &oAddressesCollection, &oAddresses;
Local ApiObject &oPersonalPhoneCollection, &oPersonalPhone;
Local ApiObject &oEmailAddressesCollection, &oEmailAddresses;
Local ApiObject &oDiversEthnicCollection, &oDiversEthnic;
Local ApiObject &oDiversReligionCollection, &oDiversReligion;
Local ApiObject &oPersonBraCollection, &oPersonBra;
Local ApiObject &oPersDataBraCollection, &oPersDataBra;
Local ApiObject &oPersDataCanCollection, &oPersDataCan;
Local ApiObject &oPersSmokerCollection, &oPersSmoker;
Local ApiObject &oPersDataCheCollection, &oPersDataChe;
Local ApiObject &oPlaceOrigCheCollection, &oPlaceOrigChe;
Local ApiObject &oPersHukouChnCollection, &oPersHukouChn;
Local ApiObject &oPersWrklifChnCollection, &oPersWrklifChn;
Local ApiObject &oPersWrklvChnCollection, &oPersWrklvChn;
Local ApiObject &oPersDataDeuCollection, &oPersDataDeu;
Local ApiObject &oNationalityGerCollection, &oNationalityGer;
Local ApiObject &oPersDataEspCollection, &oPersDataEsp;
Local ApiObject &oPersonFraCollection, &oPersonFra;
Local ApiObject &oPersDataFraCollection, &oPersDataFra;
Local ApiObject &oPersDataIndCollection, &oPersDataInd;
Local ApiObject &oPersDataItaCollection, &oPersDataIta;
Local ApiObject &oPersDataJpnCollection, &oPersDataJpn;
Local ApiObject &oPersDataMexCollection, &oPersDataMex;

Local ApiObject &oPersDataUsaCollection, &oPersDataUsa;

Local ApiObject &oPersDataFpsCollection, &oPersDataFps;

Local ApiObject &oFpmactdocTblCollection, &oFpmactdocTbl;
Local ApiObject &oPerChecklistCollection, &oPerChecklist;
Local ApiObject &oPerChklstItmCollection, &oPerChklstItm;
Local ApiObject &oCurJobPygrpCollection, &oCurJobPygrp;
Function errorHandler()

   Local ApiObject &oPSMessageCollection, &oPSMessage;
   Local number &i;
   Local string &sErrMsgSetNum, &sErrMsgNum, &sErrMsgText, &sErrType;
   &oPSMessageCollection = &oSession.PSMessages;

   For &i = 1 To &oPSMessageCollection.Count
      &oPSMessage = &oPSMessageCollection.Item(&i);
      &sErrMsgSetNum = &oPSMessage.MessageSetNumber;
      &sErrMsgNum = &oPSMessage.MessageNumber;
      &sErrMsgText = &oPSMessage.Text;
      &fileLog.WriteLine(&sErrType | " (" | &sErrMsgSetNum | "," | &sErrMsgNum | ") - " | &sErrMsgText);
   End-For;

   rem ***** Delete the Messages from the collection *****;
   &oPSMessageCollection.DeleteAll();
End-Function;
   try
      rem ***** Set the Log File *****;
      &fileLog = GetFile("D:\DOCUME~1\dzrkq7\LOCALS~1\Temp\R_PERSONAL_DATA.log", "w", "a", %FilePath_Absolute);
      &fileLog.WriteLine("Begin");

            rem ***** Get current PeopleSoft Session *****;
      &oSession = %Session;
      rem ***** Set the PeopleSoft Session Error Message Mode *****;
      rem ***** 0 - None *****;
      rem ***** 1 - PSMessage Collection only (default) *****;
      rem ***** 2 - Message Box only *****;
      rem ***** 3 - Both collection and message box *****;
      &oSession.PSMessagesMode = 1;

      rem ***** Get the Component Interface *****;

      &oRPersonalData = &oSession.GetCompIntfc(CompIntfc.R_PERSONAL_DATA);
      If &oRPersonalData = Null Then
         errorHandler();
         throw CreateException(0, 0, "GetCompIntfc failed");
      End-If;

      rem ***** Set the Component Interface Mode *****;
      &oRPersonalData.InteractiveMode = False;
      &oRPersonalData.GetHistoryItems = True;
      &oRPersonalData.EditHistoryItems = False;  

      Local array of string &Array_IP_string;
&MYFILE = GetFile("D:\Documents and Settings\dzrkq7\Desktop\ci.txt", "R", %FilePath_Absolute);

While &MYFILE.readline(&text)
   &Array_IP_string = Split(&text, ",");
   rem Warning (&Array_IP_string.Len);
   &array1 = &Array_IP_string [1];
   &array2 = &Array_IP_string [2];
   &array3 = &Array_IP_string [3];
   &array4 = &Array_IP_string [4];
   &array5 = &Array_IP_string [5];
   &array6 = &Array_IP_string [6];        

      rem ***** Set Component Interface Get/Create Keys *****;
      Rem &oRPersonalData.EMPLID = "New"       
      &oRPersonalData.EMPLID = &array1; 

      rem ***** Execute Get *****;
      rem If Not &oRPersonalData.Get() Then
      rem ***** No rows exist for the specified keys.*****;

      rem errorHandler();
      rem throw CreateException(0, 0, "Get failed");
      rem End-If;

      rem ***** Execute Create ******;
      If Not &oRPersonalData.Create() Then;
         rem ***** Unable to Create Component Interface for the Add keys provided. *****;
         errorHandler();

         throw CreateException(0, 0, "Create failed");
      End-If;   

      rem ***** Begin: Get/Set Component Interface Properties *****;
      rem ***** Get/Set Level 0 Field Properties *****;
      rem &fileLog.WriteLine("&oRPersonalData.BIRTHDATE = " | &oRPersonalData.BIRTHDATE);
      rem &oRPersonalData.BIRTHDATE = [*];

      rem &fileLog.WriteLine("&oRPersonalData.BIRTHPLACE = " | &oRPersonalData.BIRTHPLACE);
      rem &oRPersonalData.BIRTHPLACE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.BIRTHCOUNTRY = " | &oRPersonalData.BIRTHCOUNTRY);
      rem &oRPersonalData.BIRTHCOUNTRY = [*];
      rem &fileLog.WriteLine("&oRPersonalData.BIRTHSTATE = " | &oRPersonalData.BIRTHSTATE);
      rem &oRPersonalData.BIRTHSTATE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.DT_OF_DEATH = " | &oRPersonalData.DT_OF_DEATH);
      rem &oRPersonalData.DT_OF_DEATH = [*];
      rem &fileLog.WriteLine("&oRPersonalData.CHECKLIST_CD = " | &oRPersonalData.CHECKLIST_CD);
      rem &oRPersonalData.CHECKLIST_CD = [*];
      &fileLog.WriteLine("&oRPersonalData.DERIVED_EMP = " | &oRPersonalData.DERIVED_EMP);
      &oRPersonalData.DERIVED_EMP = &array2 ;
      rem &fileLog.WriteLine("&oRPersonalData.DERIVED_CWR = " | &oRPersonalData.DERIVED_CWR);
      rem &oRPersonalData.DERIVED_CWR = [*];
      rem &fileLog.WriteLine("&oRPersonalData.DERIVED_POI = " | &oRPersonalData.DERIVED_POI);
      rem &oRPersonalData.DERIVED_POI = [*];
      rem &fileLog.WriteLine("&oRPersonalData.EMPL_RCD = " | &oRPersonalData.EMPL_RCD);
      rem &oRPersonalData.EMPL_RCD = [*];
      rem &fileLog.WriteLine("&oRPersonalData.POI_TYPE = " | &oRPersonalData.POI_TYPE);
      rem &oRPersonalData.POI_TYPE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.ORG_EMP_TYPE = " | &oRPersonalData.ORG_EMP_TYPE);
      rem &oRPersonalData.ORG_EMP_TYPE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.WAIVE_DATA_PROTECT = " | &oRPersonalData.WAIVE_DATA_PROTECT);
      rem &oRPersonalData.WAIVE_DATA_PROTECT = [*];
      rem &fileLog.WriteLine("&oRPersonalData.ETHNIC_GRP_CD_UK = " | &oRPersonalData.ETHNIC_GRP_CD_UK);
      rem &oRPersonalData.ETHNIC_GRP_CD_UK = [*];
      rem &fileLog.WriteLine("&oRPersonalData.NI_COMMUNITY_BG = " | &oRPersonalData.NI_COMMUNITY_BG);
      rem &oRPersonalData.NI_COMMUNITY_BG = [*];
      rem &fileLog.WriteLine("&oRPersonalData.NI_CB_DET_DATE = " | &oRPersonalData.NI_CB_DET_DATE);
      rem &oRPersonalData.NI_CB_DET_DATE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.EXP_RETIRE_DT = " | &oRPersonalData.EXP_RETIRE_DT);
      rem &oRPersonalData.EXP_RETIRE_DT = [*];
      rem &fileLog.WriteLine("&oRPersonalData.NIFE_DIRECT_QUEST = " | &oRPersonalData.NIFE_DIRECT_QUEST);
      rem &oRPersonalData.NIFE_DIRECT_QUEST = [*];
      rem &fileLog.WriteLine("&oRPersonalData.DEPTID = " | &oRPersonalData.DEPTID);

      rem &oRPersonalData.DEPTID = [*];

      rem &fileLog.WriteLine("&oRPersonalData.JOBCODE = " | &oRPersonalData.JOBCODE);
      rem &oRPersonalData.JOBCODE = [*];
      rem &fileLog.WriteLine("&oRPersonalData.BUSINESS_UNIT = " | &oRPersonalData.BUSINESS_UNIT);

      rem &oRPersonalData.BUSINESS_UNIT = [*];

      rem ***** Set/Get NAME_TYPE_VW Collection Field Properties -- Parent: PS_ROOT Collection *****;
      &oNameTypeVwCollection = &oRPersonalData.NAME_TYPE_VW;
      Local integer &i148;
      For &i148 = 1 To &oNameTypeVwCollection.Count;
         &oNameTypeVw = &oNameTypeVwCollection.Item(&i148);
         rem ***** Set/Get NAMES Collection Field Properties -- Parent: NAME_TYPE_VW Collection *****;
         rem &oNamesCollection = &oRPersonalData.NAMES;
         &oNamesCollection = &oNameTypeVw.NAMES;
         Local integer &i249;

         For &i249 = 1 To &oNamesCollection.Count;
            &oNames = &oNamesCollection.Item(&i249);
            &fileLog.WriteLine("&oNames.EFFDT = " | &oNames.EFFDT);
            &oNames.EFFDT = &array3;
            rem &fileLog.WriteLine("&oNames.COUNTRY_NM_FORMAT = " | &oNames.COUNTRY_NM_FORMAT);
            &oNames.COUNTRY_NM_FORMAT = &array4;
            rem &fileLog.WriteLine("&oNames.NAME_INITIALS = " | &oNames.NAME_INITIALS);
            rem &oNames.NAME_INITIALS = [*];
            rem &fileLog.WriteLine("&oNames.NAME_PREFIX = " | &oNames.NAME_PREFIX);
            rem &oNames.NAME_PREFIX = [*];
            rem &fileLog.WriteLine("&oNames.NAME_SUFFIX = " | &oNames.NAME_SUFFIX);
            rem &oNames.NAME_SUFFIX = [*];
            rem &fileLog.WriteLine("&oNames.NAME_ROYAL_PREFIX = " | &oNames.NAME_ROYAL_PREFIX);
            rem &oNames.NAME_ROYAL_PREFIX = [*];
            rem &fileLog.WriteLine("&oNames.NAME_ROYAL_SUFFIX = " | &oNames.NAME_ROYAL_SUFFIX);
            rem &oNames.NAME_ROYAL_SUFFIX = [*];
            rem &fileLog.WriteLine("&oNames.NAME_TITLE = " | &oNames.NAME_TITLE);
            rem &oNames.NAME_TITLE = [*];
            &fileLog.WriteLine("&oNames.LAST_NAME = " | &oNames.LAST_NAME);
            &oNames.LAST_NAME = &array5;
            &fileLog.WriteLine("&oNames.FIRST_NAME = " | &oNames.FIRST_NAME);
            &oNames.FIRST_NAME = &array6;
            rem &fileLog.WriteLine("&oNames.MIDDLE_NAME = " | &oNames.MIDDLE_NAME);
            rem &oNames.MIDDLE_NAME = [*];
            rem &fileLog.WriteLine("&oNames.SECOND_LAST_NAME = " | &oNames.SECOND_LAST_NAME);
            rem &oNames.SECOND_LAST_NAME = [*];
            rem &fileLog.WriteLine("&oNames.NAME_AC = " | &oNames.NAME_AC);
            rem &oNames.NAME_AC = [*];
            rem &fileLog.WriteLine("&oNames.PREF_FIRST_NAME = " | &oNames.PREF_FIRST_NAME);
            rem &oNames.PREF_FIRST_NAME = [*];
            rem &fileLog.WriteLine("&oNames.PARTNER_LAST_NAME = " | &oNames.PARTNER_LAST_NAME);
            rem &oNames.PARTNER_LAST_NAME = [*];
            rem &fileLog.WriteLine("&oNames.PARTNER_ROY_PREFIX = " | &oNames.PARTNER_ROY_PREFIX);
            rem &oNames.PARTNER_ROY_PREFIX = [*];
            rem &fileLog.WriteLine("&oNames.LAST_NAME_PREF_NLD = " | &oNames.LAST_NAME_PREF_NLD);
            rem &oNames.LAST_NAME_PREF_NLD = [*];
         End-For;
      End-For;
      rem ***** End: Get/Set Component Interface Properties *****;  

      rem***** Execute Save *****;
      If Not &oRPersonalData.Save() Then;
         errorHandler();
         throw CreateException(0, 0, "Save failed");
      End-If;  

      rem ***** Execute Cancel *****;
      rem If Not &oRPersonalData.Cancel() Then;
      rem errorHandler();

      rem throw CreateException(0, 0, "Cancel failed");
      rem End-If;

   catch Exception &ex
      rem Handle the exception;
      &fileLog.WriteLine(&ex.ToString());
End-While;
&MYFILE.Close();
   end-try;

&fileLog.WriteLine("End");
&fileLog.Close();

While running this App engine,fews issues came
1)Instance already exists
2)Fetching array element 2: index is not in range 1 to 1. (180,252)

Instance already exists: We know google is the solution.Yes i found.For first this Instance already exists issue i came to know i'm calling while loop after the session object.so its trying to insert same value again.so i made while loop before session object.

Fetching array element 2: index is not in range 1 to 1. (180,252) : Every one can say that array not initiated properly.May be.But issue is related to CSV file.After entering our data in CSV file we should not hit the space button or enter button.If so delete those and keep the cursor next to last data.On removing these blank lines in the csv file(opened in a notepad) the app engine ran successfully without any errors.
Source for this issue : Shyam's Peoplesoft Blog and Google