cancel
Showing results for 
Search instead for 
Did you mean: 

SQL2005 is keeping temp table after succesfull dimension processing

Former Member
0 Kudos

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)

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

No, just using standard functionality. My test is Apshell

sorin_radulescu
Active Contributor
0 Kudos

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