Hi Ming, One thing to test would be where you get the timeout, whether it's in JDBC done in the SPJ or in the communication between the master executor and the UDR server. When you simulate it in your dev environment, do you also issue a single JDBC call that takes more than an hour?
I have to admit I haven't tried it, but hopefully these instructions will work for SPJs as well: https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+object-oriented+UDF+interface#Tutorial:Theobject-orientedUDFinterface-DebuggingUDFcode Hans On Tue, Jun 7, 2016 at 9:04 AM, Liu, Ming (Ming) <[email protected]> wrote: > Hi, > > > > We have a SPJ that perform some insert/select operations against a big > table, and each time then the SPJ runs for 1 hour, the CALL statement will > return -8007 error code, said it is cancelled. What can be possible reasons > for a query to be cancelled? > > > > >>CALL QUERY1SPJ(); > > *** ERROR[8007] The operation has been canceled. > > *** ERROR[8811] Trying to close a statement that is either not in the open > state or has not reached EOF. > > --- SQL operation failed with errors. > > > > I have a dev environment, and simulate a long running SPJ (Not same as the > SPJ in real cluster as above), but I am not able to reproduce it. The test > SPJ runs 1 hour 50 mins and finish correctly. So this seems not a common > SPJ issue, but I am not sure. > > > > Any suggestions to debug this issue will be very appreciated. > > > > Thanks, > > Ming > > >
