I'm using T4EA to import data into Teamcenter from a legacy database.
The approach I'm using is the following:
In a scheduled job I'm reading the legacy database, and based on the changes happened there I'm creating some T4EA Batch Jobs, that are intended to update some items in Teamcenter.
It's not uncommon that I have in one scheduled job more than 1 million SQL statements executed in the legacy database.
If there are a lot of changes in the legacy database, (that implies even more SQL statement executions) than at a certain time I get the following error:
LAST ERROR MESSAGE :: (TCL ERROR ON PIPE SERVER) java exeption function=staticRun in class=de/tesis/plmware/objects/commands/WithCommand while executing "tpco_sendECMD $handle $timeout $command $quotedArgs" (procedure "::T4X::JAVASERVER::sExecute" line 14) invoked from within "::T4X::JAVASERVER::sExecute 514 with 514.*23651 executeQuery" ("eval" body line 1) invoked from within "eval ::T4X::JAVASERVER::sExecute $serverHandle with $handle $methodName $args" (procedure "T4X::OBJECTS::tplet" line 17)
Could someone help me how could I find out what's the root cause of this?
Did you check the gateway logs by setting the trace level to the lowest value (I think to 'info'?!)
what do those logs say?
Can you share the log statements preceding the error statement?