473,395 Members | 1,386 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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

365 100+
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,facilityId) REFERENCES compFacilityMap(component,facilityId)
)
;

insert into saveTables (tableName) values("eventLog");


config_ascci file
===========
eventLog = {}
eventLog[1] = {}
eventLog[1]["component"] = "UMI_COMP_NTP"
eventLog[1]["textMessage"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:167:ntpTblHandler\
eventLog[1]["logLevel"] = "128"
eventLog[1]["binMessage"] = ""
eventLog[1]["_ROWID_"] = "1"
eventLog[1]["facilityId"] = "3"
eventLog[2] = {}
eventLog[2]["component"] = "UMI_COMP_NTP"
eventLog[2]["textMessage"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:181:tz: 0 \
eventLog[2]["logLevel"] = "128"
eventLog[2]["binMessage"] = ""
eventLog[2]["_ROWID_"] = "2"
eventLog[2]["facilityId"] = "3"
eventLog[3] = {}
eventLog[3]["component"] = "UMI_COMP_NTP"
eventLog[3]["textMessage"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:191:DayLightsaving: 0 \
eventLog[3]["logLevel"] = "128"
eventLog[3]["binMessage"] = ""
eventLog[3]["_ROWID_"] = "3"
eventLog[3]["facilityId"] = "3"
eventLog[4] = {}
eventLog[4]["component"] = "UMI_COMP_NTP"
eventLog[4]["textMessage"] = "Sun Dec 30 11:08:00 2007 [Netgard_MFD][System][NTP] ntpTblHandler:204:status: 1 \
eventLog[4]["logLevel"] = "128"
eventLog[4]["binMessage"] = ""
eventLog[4]["_ROWID_"] = "4"
eventLog[4]["facilityId"] = "3"
eventLog[5] = {}
eventLog[5]["component"] = "UMI_COMP_NTP"
eventLog[5]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:236:pNtpControl->ServerNames[PRIMARY_SERVER]: 0.us.pool.ntp.org \
eventLog[5]["logLevel"] = "128"
eventLog[5]["binMessage"] = ""
eventLog[5]["_ROWID_"] = "5"
eventLog[5]["facilityId"] = "3"
eventLog[6] = {}
eventLog[6]["component"] = "UMI_COMP_NTP"
eventLog[6]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:242:pNtpControl->ServerNames[SECONDARY_SERVER]: 1.us.pool.ntp.org \
eventLog[6]["logLevel"] = "128"
eventLog[6]["binMessage"] = ""
eventLog[6]["_ROWID_"] = "6"
eventLog[6]["facilityId"] = "3"
eventLog[7] = {}
eventLog[7]["component"] = "UMI_COMP_NTP"
eventLog[7]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpTblHandler:281:DS: 1 \
eventLog[7]["logLevel"] = "128"
eventLog[7]["binMessage"] = ""
eventLog[7]["_ROWID_"] = "7"
eventLog[7]["facilityId"] = "3"
eventLog[8] = {}
eventLog[8]["component"] = "UMI_COMP_NTP"
eventLog[8]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpdGetDefaultServers:509:pPriServ 0.us.pool.ntp.org\
eventLog[8]["logLevel"] = "128"
eventLog[8]["binMessage"] = ""
eventLog[8]["_ROWID_"] = "8"
eventLog[8]["facilityId"] = "3"
eventLog[9] = {}
eventLog[9]["component"] = "UMI_COMP_NTP"
eventLog[9]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][NTP] ntpdGetDefaultServers:510:pSecServ 1.us.pool.ntp.org\
eventLog[9]["logLevel"] = "128"
eventLog[9]["binMessage"] = ""
eventLog[9]["_ROWID_"] = "9"
eventLog[9]["facilityId"] = "3"
eventLog[10] = {}
eventLog[10]["component"] = "UMI_COMP_PLATFORM"
eventLog[10]["textMessage"] = "Sun Dec 30 11:08:03 2007 [Netgard_MFD][System][PLATFORM] platformHandleDBUpdate:248:DATABASE UPDATE, Table Name:vlan operation:INSERT row=2\
eventLog[10]["logLevel"] = "128"
eventLog[10]["binMessage"] = ""
eventLog[10]["_ROWID_"] = "10"
eventLog[10]["facilityId"] = "3"

Expand|Select|Wrap|Line Numbers
  1.  
  2. database.lua script
  3. =============
  4. -- Import settings from given file.
  5. function db.import (filename)
  6.     local valid = true
  7.     util.appendDebugOut("Imported DB!<br>")
  8.     dofile(filename)
  9.     local saveTables = db.getTable("saveTables", false)
  10.     db.beginTransaction()
  11.  
  12.     -- for each dbTable
  13.     for k,v in pairs(saveTables) do
  14.         if (not valid) then break end
  15.         local tableName = v["tableName"]
  16.         local table = util.getLuaVariable(tableName)
  17.  
  18.         if (table == nil) then
  19.             print ("no LUA variable:" .. tableName)
  20.             break
  21.         end
  22.  
  23.         if (#table >= 1) then
  24.             -- for each row
  25.             for kk,vv in pairs(table) do
  26.                 valid = db.insert(tableName, table[kk], true, true)
  27.                 if (not valid) then 
  28.                     print ("******** table insert failed for " .. tableName)
  29.                     break 
  30.                 end
  31.             end
  32.         end
  33.     end
  34.  
  35.     -- return
  36.     if (valid) then
  37.         db.commitTransaction()
  38.         return "imported successfully!!!!!!!!!!!!!!!!!!"
  39.     else
  40.         db.rollback()
  41.         return "import failed!"
  42.     end
  43. end
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51. -- Save table to file in ascii format.
  52. function db.saveTable (f, name, value, saved)
  53.     local one, two = "", ""
  54.     saved = saved or {}       -- initial value
  55.     if type(value) == "number" or type(value) == "string" then
  56.         one = name .. " = "
  57.         two = basicSerialize(value) .. "\n"
  58.         f:write(one, two)
  59.     elseif type(value) == "table" then
  60.         one = name .. " = "
  61.         if saved[value] then    -- value already saved?
  62.             f:write(one)
  63.             f:write(saved[value], "\n")  -- use its previous name
  64.         else
  65.             f:write(one)
  66.             f:write("{}\n")
  67.             saved[value] = name   -- save name for next time
  68.             for k,v in pairs(value) do      -- save its fields
  69.                 local fieldname = string.format("%s[%s]", name,
  70.                 basicSerialize(k))
  71.                 db.saveTable(f, fieldname, v, saved)
  72.             end
  73.         end
  74.     else
  75.     -- function
  76.     end
  77.     f:flush()
  78. end
  79.  
  80.  
Feb 1 '10 #1
0 1464

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Thomas Reat | last post by:
The postgresql documentation claims that "on insert" rules are executed after the insert. This is not happening for me. I have a rule that is being executed even though the insert should have...
2
by: Robin Tucker | last post by:
I have some code that dynamically creates a database (name is @FullName) and then creates a table within that database. Is it possible to wrap these things into a transaction such that if any one...
1
by: technocraze | last post by:
Hi guys, I am having trouble resolving this error. Below mentioned is my code and implmentation. MS Acess is my front end and sql server is my backend. What i want to achieve is to be...
3
by: 01423481d | last post by:
Hi All I am facing a very strange "problem" on the captioned issue, I hope I can explain it clearly. Actually I am developing an interface (using VB.net) which read records from a file and...
3
by: Twanne | last post by:
Hi, I've got a table called Aerosol and a table called LinkTabel. Now I do an update to a table from an excell sheet, this table is called ExportAerosol. So far so good, the import works...
5
by: =?Utf-8?B?Y2RiaWdncw==?= | last post by:
Hi, I've been tasked to write a windows app that allows people to enter transactions. For each transaction, there can be an unknown number of items, and as a person enters an item, the program...
5
by: doc1355 | last post by:
Hi, I have a script that I need to use a variable to select the database table that I want to update or to get the results from. But for some reason when I use the variable I get error. If I...
1
srj115
by: srj115 | last post by:
This is just something that had me tearing out my nose hairs in frustration... hypothetically. I must have spent 7 or 8 hours trying to get this to work before I smelled the coffee (so to speak). ...
3
by: Larry Leonard | last post by:
Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe 300 lines, heavily commented). It's an...
7
by: tarunkhatri | last post by:
Hi, I want to insert multiple rows in a database table, from an submit form. But not able to trouble shoot the problem in my code. Following is the code. <form action=test_insert.php...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.