SQL2005 is keeping temp table after succesfull dimension processing

[Former Member]

When processing dimensions, I notice that on SQL there are tmp tables that do not get deleted. These tables have a different owner (not dbo but the installation user of BPC, with the domain prefix)

Any idea why these temp tables are there?

Example of such a temp table: tmpMBRAccount_20100315094306 (for the dimension Account)

Version : SAP BPC 7.0 SP7 on SQL 2005, multi server (SQL clustered - virtual app server - physical OLAP server)

[Former Member]

I have reproduced it on Apshell-same issue. Support assumes a SQL issue, but I have no clue for the moment.

Any help is much appreciated

[Former Member]

Have you tried running SQL profiler to see what SQL commands are being executed? I've seen those tables get left around before, but only when the task failed while trying to create the dimension.

[Former Member]

even when task completes succesfully, the temp table remains

I am in contact with support on this

I think it has to do with the dbo, but am not sure

[Former Member]

No, just using standard functionality. My test is Apshell

[sorin_radulescu]

Hi Bjorn,

Did you check the creation date of that temporary table?

Can you reproduce the issue in Apshell?

I was looking into my environment I don't see any table like one mentioned by you.

To import dimension are you using a custom DTS package? This can be an explanation for that table.

Regards

Sorin Radulescu