Database import fails and prints "insert table failed for eventLog" - what issue?

[tvnaidu]

database file gets created using below sql file, then lua script calls "db.import config_ascc", then I get errors says "insert table failed for eventLog", below are my sql file entry, config file, also import and saveTable function, any idea what is wrong, why I get error?. thanks in advance.




system.sql file
==========
CREATE TABLE eventLog
(
component text NOT NULL,
facilityId integer NOT NULL,
logLevel integer NOT NULL,
textMessage text NOT NULL,
binMessage blob,
FOREIGN KEY (component,faci lityId) REFERENCES compFacilityMap (component,faci lityId)
)
;

insert into saveTables (tableName) values("eventLo g");


config_ascci file
===========
eventLog = {}
eventLog[1] = {}
eventLog[1]["component"] = "UMI_COMP_N TP"
eventLog[1]["textMessag e"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:1 67:ntpTblHandle r\
eventLog[1]["logLevel"] = "128"
eventLog[1]["binMessage "] = ""
eventLog[1]["_ROWID_"] = "1"
eventLog[1]["facilityId "] = "3"
eventLog[2] = {}
eventLog[2]["component"] = "UMI_COMP_N TP"
eventLog[2]["textMessag e"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:1 81:tz: 0 \
eventLog[2]["logLevel"] = "128"
eventLog[2]["binMessage "] = ""
eventLog[2]["_ROWID_"] = "2"
eventLog[2]["facilityId "] = "3"
eventLog[3] = {}
eventLog[3]["component"] = "UMI_COMP_N TP"
eventLog[3]["textMessag e"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:1 91:DayLightsavi ng: 0 \
eventLog[3]["logLevel"] = "128"
eventLog[3]["binMessage "] = ""
eventLog[3]["_ROWID_"] = "3"
eventLog[3]["facilityId "] = "3"
eventLog[4] = {}
eventLog[4]["component"] = "UMI_COMP_N TP"
eventLog[4]["textMessag e"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:2 04:status: 1 \
eventLog[4]["logLevel"] = "128"
eventLog[4]["binMessage "] = ""
eventLog[4]["_ROWID_"] = "4"
eventLog[4]["facilityId "] = "3"
eventLog[5] = {}
eventLog[5]["component"] = "UMI_COMP_N TP"
eventLog[5]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:2 36:pNtpControl->ServerNames[PRIMARY_SERVER]: 0.us.pool.ntp.o rg \
eventLog[5]["logLevel"] = "128"
eventLog[5]["binMessage "] = ""
eventLog[5]["_ROWID_"] = "5"
eventLog[5]["facilityId "] = "3"
eventLog[6] = {}
eventLog[6]["component"] = "UMI_COMP_N TP"
eventLog[6]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:2 42:pNtpControl->ServerNames[SECONDARY_SERVE R]: 1.us.pool.ntp.o rg \
eventLog[6]["logLevel"] = "128"
eventLog[6]["binMessage "] = ""
eventLog[6]["_ROWID_"] = "6"
eventLog[6]["facilityId "] = "3"
eventLog[7] = {}
eventLog[7]["component"] = "UMI_COMP_N TP"
eventLog[7]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:2 81:DS: 1 \
eventLog[7]["logLevel"] = "128"
eventLog[7]["binMessage "] = ""
eventLog[7]["_ROWID_"] = "7"
eventLog[7]["facilityId "] = "3"
eventLog[8] = {}
eventLog[8]["component"] = "UMI_COMP_N TP"
eventLog[8]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpdGetDefaultS ervers:509:pPri Serv 0.us.pool.ntp.o rg\
eventLog[8]["logLevel"] = "128"
eventLog[8]["binMessage "] = ""
eventLog[8]["_ROWID_"] = "8"
eventLog[8]["facilityId "] = "3"
eventLog[9] = {}
eventLog[9]["component"] = "UMI_COMP_N TP"
eventLog[9]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpdGetDefaultS ervers:510:pSec Serv 1.us.pool.ntp.o rg\
eventLog[9]["logLevel"] = "128"
eventLog[9]["binMessage "] = ""
eventLog[9]["_ROWID_"] = "9"
eventLog[9]["facilityId "] = "3"
eventLog[10] = {}
eventLog[10]["component"] = "UMI_COMP_PLATF ORM"
eventLog[10]["textMessag e"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][PLATFORM] platformHandleD BUpdate:248:DAT ABASE UPDATE, Table Name:vlan operation:INSER T row=2\
eventLog[10]["logLevel"] = "128"
eventLog[10]["binMessage "] = ""
eventLog[10]["_ROWID_"] = "10"
eventLog[10]["facilityId "] = "3"

 
database.lua script
=============
-- Import settings from given file.
function db.import (filename)
    local valid = true
    util.appendDebugOut("Imported DB!<br>")
    dofile(filename)
    local saveTables = db.getTable("saveTables", false)
    db.beginTransaction()
 
    -- for each dbTable
    for k,v in pairs(saveTables) do
        if (not valid) then break end
        local tableName = v["tableName"]
        local table = util.getLuaVariable(tableName)
 
        if (table == nil) then
            print ("no LUA variable:" .. tableName)
            break
        end
 
        if (#table >= 1) then
            -- for each row
            for kk,vv in pairs(table) do
                valid = db.insert(tableName, table[kk], true, true)
                if (not valid) then 
                    print ("******** table insert failed for " .. tableName)
                    break 
                end
            end
        end
    end
 
    -- return
    if (valid) then
        db.commitTransaction()
        return "imported successfully!!!!!!!!!!!!!!!!!!"
    else
        db.rollback()
        return "import failed!"
    end
end
 
 
 
 
 
 
 
-- Save table to file in ascii format.
function db.saveTable (f, name, value, saved)
    local one, two = "", ""
    saved = saved or {}       -- initial value
    if type(value) == "number" or type(value) == "string" then
        one = name .. " = "
        two = basicSerialize(value) .. "\n"
        f:write(one, two)
    elseif type(value) == "table" then
        one = name .. " = "
        if saved[value] then    -- value already saved?
            f:write(one)
            f:write(saved[value], "\n")  -- use its previous name
        else
            f:write(one)
            f:write("{}\n")
            saved[value] = name   -- save name for next time
            for k,v in pairs(value) do      -- save its fields
                local fieldname = string.format("%s[%s]", name,
                basicSerialize(k))
                db.saveTable(f, fieldname, v, saved)
            end
        end
    else
    -- function
    end
    f:flush()
end