Forum Stats

  • 3,875,457 Users
  • 2,266,916 Discussions


Server java trace error while updating bulk records from AIX to Oracle 10g


I am getting an error in TCL (Tool Command language) script that updates the records in a database table i.e around 2500 records are to be updated. I am using update statement with bind variables to insert the data.

SQL "insert into netuser.visit_temp (FP_FROM,FP_TO,HOPS,FP_FROM_ID) values (:SN,:EN,:HP,:FPID)" [list SN $startnode EN $endnode HP $hops FPID $fpId]

However, after processing 900 or so records (takes around 8 hours) I get the following error:

environment variable "SERVER_JAVA_TRACE" undefined
while executing
invoked from within
"dotransaction {
logm "Processing $fp"
set value [SQL $query3 [list FP $fp]]
logm "Found value $value"
set fpid [Koplingspunkt quer..."
("foreach" body line 3)
invoked from within
"foreach fp $cmd2 {
UtilityObject cleanCache
dotransaction {
logm "Processing $fp"
set value [SQL $query3 [list FP $fp]]
logm "Found v..."

Could anyone please suggest the possible cause of error?


This discussion has been closed.