Client Support
cancel

TRIM 6.2.5, build 1343 "unable to clear temporary tables"

SOLVED
Go to solution
Highlighted
user33
Respected Contributor.

TRIM 6.2.5, build 1343 "unable to clear temporary tables"

 

we are currently experiencing an issue with TRIM where we are getting the following error,

 

Function request (Execute Transaction) for TRIM Workgroup Server 'TRIM' failed. The SQL transaction 'dropWorkTable' failed for user ACT00448667D:2456 on command DROP TABLE SESSION.TStmpc23df04675664577b2f586efed2950c9.

 Details : [DB2/NT] SQL0204N  "SESSION.TSTMPC23DF04675664577B2F586EFED2950C9" is an undefined name.  SQLSTATE=42704


 Detailed ADO Errors
 Number  = 0x80040e37
 Source  = IBM OLE DB Provider for DB2
 Description = [DB2/NT] SQL0204N  "SESSION.TSTMPC23DF04675664577B2F586EFED2950C9" is an undefined name.  SQLSTATE=42704

 SQLState  = 42S02
 NativeError = -204

 

 

 

Any assistance will be greatly appreciated.

 

Thanks

4 REPLIES
Grundy
Acclaimed Contributor.

Re: TRIM 6.2.5, build 1343 "unable to clear temporary tables"

When TRIM completes large, complex searches, it creates temp tables in the database to collate results.

These temp tables are cleaned up, but it looks like it is trying to clean up the same temp table again.

 

It's not a major issue.

If you check your database for any tables starting with TSTMP and none exist, then they are cleaning up correctly.

 

There was also a minor issue back in 6.2 where TRIM attempted to clear the temp table twice, which is what I think is causing your error.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
user33
Respected Contributor.

Re: TRIM 6.2.5, build 1343 "unable to clear temporary tables"

Indeed, we are carrying out a  large search through an application, where TRIM internally creates these temporary tables, As we have no control over it's creating temporary tables and further removing these.

 

Is there a way we can avoid this error from happening, is there a patch we need to apply to see if this fixes,

 

currently we are using build 1343, is this likely to have been fixed in build 1406 or is there a solution we could adapt ?

 

Thanks

 

 

 

Grundy
Acclaimed Contributor.
Solution

Re: TRIM 6.2.5, build 1343 "unable to clear temporary tables"

This had Defect number 37685 and was fixed in a later build of 6.2.5.

 

The only way to fix this would be to upgrade TRIM.

 

Alternatively you can ignore the errors as an interim workaround.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
user33
Respected Contributor.

Re: TRIM 6.2.5, build 1343 "unable to clear temporary tables"

Correct this defect is recorded as a standard defect with HP, the only difference is HP have resolved this as a part of 7.1 Upgrade and not 6.2.5

after looking at some documentation, I found that

 

34017 Complex queries create temporary tables and are not being cleaned up
Fixed. Complex queries which invoke temporary table creation now have correspoding call to drop the table after it has been used.

 

is resolved with TRIM 7.1 upgrade, I believe this is both server and client upgrade 7.1