Skip to Main Content

Java APIs

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

937070May 14 2012 — edited May 14 2012
Hi

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
"getenv SERVER_JAVA_TRACE"
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2012
Added on May 14 2012
1 comment
1,125 views