Large no of temporary tables are getting created in database

[Former Member]

Hi  All,

We are using SAP BPC 7.5 MS version sp 07 with MS SQL server 2008 sp 02

It's been observed that large no of temporary tables are created in database for a particular Appset and their number seems to be growing

ex: dbo.importTemp012569833

Can you please tell me from where these temp tables have been created/generated?

Can we delete them?

Many Thanks,

Vanashree

[former_member186498 · Accepted solution]

Hi Vanashree,

this issue is solved in sp9, see please 1748157 - FIX:DM temporary tables are not deleted

In the meanwhile you can delete the old temp tables, be sure that no imports are running, from SSMS.

Regards

     Roberto

p.s. please don't forget to close the solved threads.