CreateOLAPCube error when processing Apps. Preventing the running of logic

[Former Member]

Our Dev team has just found a problem both with running EVDRE scripts into our test databases and with processing the Apps.

They get the following error when processing:

-

---

An error has occurred during processing

Detail Message:

Error Message:

CreateOLAPCubeForApplication:CreateCube:Timeout expired.

The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

-

---

We have tried restarting the BPC processes on the WEB server and rebooting both WEB and SQL boxes, but we just get the same.

I have also found the following in the Outlooksoft event log on the WEB server:

-

---

Event Type: Error

Event Source: OutlookSoft log

Event Category: None

Event ID: 0

Date: 27/09/2009

Time: 05:05:28

User: N/A

Computer: READ-MRSWEB-03

Description:

==============[System Exception Tracing]==============

[System Name] : OSoft Send log

[Message Type] : ErrorMessage

[Job Name] : CSendGovernor::ExtractSendUit:TM08_TRAINING_SEPT

[DateTime] : 27/09/2009 05:05:28

[UserId] : SENDG

[Exception]

DetailMsg : {Microsoft.VisualBasic Object variable or With block variable not set.}

==============[System Exception Tracing End ]==============

-

---

The system seems to have been fine up to last Thursday (27th), at which point it created one of these Eventvwr entries about every second, and it now seems that we can't do anything with the system at all.

Please help if you can, as I have tried our "usual" fixes for this system, but we are still unable to test right now.

Thanks

Craig Aucott

[Former Member · Accepted solution]

If Sorin's suggestion did not work, maybe you can try setting pooling to false...

POOLING = FALSE

In outlooksoft.config file of C:\BPC\websrvr\bin folder change the following line:

<add key="Database_AppServerDBConn" value="Server=<servername>;Database=AppServer;Trusted_Connection=True;"

to

<add key="Database_AppServerDBConn" value="Server=<servername>;Database=AppServer;Trusted_Connection=True;pooling=false;"

***Please note that where I have <servername> it should remain the value of the customer's servername****

Also, add the pooling=false; to every connection string in tblappsetinfo.

[Former Member · Accepted solution]

To add to both points,

When you process the cube using AS the cube should throw an eror with the element ID that is wrong or not valid. This will help you find out and isolate the bad members, just incase you do not see anything in SQL sqery that was provided by sorin.

Also I am sure you have checked this already, but make sure there are no changes on you BPCSUPER account access across network..

Sam

[sorin_radulescu]

Hi Craig,

Did you tried to processes the pplication using modify applicatipon and selecting both check boxes for reindex and process application?

If you are processing the cube from Analysis Manager are you receiving any error?

In my opinion you have some bad records into one of fact table.

You can see this using the follow select:

select count(*) from tblfact"yourapplication" where "yourdimension" not in (select [id] from mbr"yourdimension" where calc = 'N')

if you receive for one dimension count <> 0 then you have to run the same query but this time

using

delete from tblfact"yourapplication" where "yourdimension" not in (select [id] from mbr"yourdimension" where calc = 'N')

Kind Regards

Sorin radulescu

[Former Member]

Sorry, I forgot to mention.

We run BPC 5.1 SP3