Android : SQL Lite insertion or create table issue
<p>Team,</p>

<p>can anyone please help me to understand what could be the problem in the below snippet of code? It fails after insertion 2 and insertion 3 debug statements</p>

<p>I have the contentValues in the Array list, I am iterating the arraylist and inserting the content values in to the database.</p>

<p>Log.d("database","before insertion 1 ");
   liteDatabase = this.openOrCreateDatabase("Sales", MODE_PRIVATE,
     null);
   Log.d("database","before insertion 2 ");
   liteDatabase
     .execSQL("Create table activity ( ActivityId VARCHAR,Created VARCHAR,AMTaps_X VARCHAR,AMTemperature_X VARCHAR,AccountId VARCHAR,AccountLocation VARCHAR,AccountName VARCHAR,Classification VARCHAR,ActivityType VARCHAR,COTaps_X VARCHAR,COTemperature_X VARCHAR,Comment VARCHAR,ContactWorkPhone VARCHAR,CreatedByName VARCHAR,DSCycleNo_X VARCHAR,DSRouteNo_X VARCHAR,DSSequenceNo_X VARCHAR,Description VARCHAR,HETaps_X VARCHAR,HETemperature_X VARCHAR,Pro_Setup VARCHAR,LastUpdated VARCHAR,LastUpdatedBy VARCHAR,Licensee VARCHAR,MUTaps_X VARCHAR,MUTemperature_X VARCHAR,Objective VARCHAR,OwnerFirstName VARCHAR,OwnerLastName VARCHAR,PhoneNumber VARCHAR,Planned VARCHAR,PlannedCleanActualDt_X VARCHAR,PlannedCleanReason_X VARCHAR,PrimaryOwnedBy VARCHAR,Pro_Name VARCHAR,ServiceRepTerritory_X VARCHAR,ServiceRep_X VARCHAR,Status VARCHAR,Type VARCHAR,HEINDSTapAuditDate VARCHAR,HEINEmployeeType VARCHAR)");
   Log.d("database","before insertion 3 ");
   int counter = 0;
   int size = arrayList.size();
   for (counter = 0; counter &lt; size; counter++) {
    ContentValues contentValues = (ContentValues) arrayList
      .get(counter);
    liteDatabase.insert("activity", "activityInfo", contentValues);
    Log.d("database", "Database insertion is done");
   }
  }</p>
