IWTEMP tables in DB

Hi All,

We have upgraded our TS to 6.7.1 & OD to 6.2.0 with Datadeploy.

And now I am noticing a bunch of IWTEMP_******* tables in the database. So far around 2000+ tables in our database. The tables names are like IWTEMP_ with some random numbers and characters like IWTEMP_294A2322C, IWTEMP_88A23295....

What are these tables and how to stop growing these? I guess these are temporary tables used on data deployment, but how come its not been removed after the process.

Thanks
John

Find more posts tagged with

Comments

dazzlad

Maybe the database user that you are connecting with doesn't have permission to drop tables??

Just a guess.

jstephan

I found the issue. I have set the DDInternalDebugging as YES on the odbase.xml file and that kept all the tables that is been created after the change.

I disabled that and it solved the issue.

Thank you for response.