dbTalk Databases Forums  

Process SSAS DAtabase: The connection either timed out or was lost

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Process SSAS DAtabase: The connection either timed out or was lost in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM






Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #12  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM






Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #13  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM



Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #14  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM



Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #15  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM



Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #16  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM



Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #17  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 09:40 AM



Hello Charles

Thanks for supporting me on this issue.

I checked the timeout value in the Editor of my SSAS OLE DB Connection and
it is set to 0. My connectionstring looks like this:

Data Source=localhost;Initial Catalog=SSAS_DB;Provider=MSOLAP.3;Integrated
Security=SSPI;Impersonation Level=Impersonate;

When I process the cube it lasts about 30 minutes for a full process.

In BIDS I did not try but I will do now and post the result.

Kind regards,

Marc

Reply With Quote
  #18  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 10:18 AM



Hello Charles

out from BIDS the processing with a SSIS package takes about 30 minutes and
was successful. I just moved this data warehouse to virtualized 64bit box -
before I did not have this problem. I realized that the last step of
processing takes a long time and nearly no processing power (seen in
taskmanager) is used.

Could this be a reason for the timeout?

Kind regards,

Marc

Reply With Quote
  #19  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 10:18 AM



Hello Charles

out from BIDS the processing with a SSIS package takes about 30 minutes and
was successful. I just moved this data warehouse to virtualized 64bit box -
before I did not have this problem. I realized that the last step of
processing takes a long time and nearly no processing power (seen in
taskmanager) is used.

Could this be a reason for the timeout?

Kind regards,

Marc

Reply With Quote
  #20  
Old   
Marc
 
Posts: n/a

Default RE: Process SSAS DAtabase: The connection either timed out or was - 11-13-2008 , 10:18 AM



Hello Charles

out from BIDS the processing with a SSIS package takes about 30 minutes and
was successful. I just moved this data warehouse to virtualized 64bit box -
before I did not have this problem. I realized that the last step of
processing takes a long time and nearly no processing power (seen in
taskmanager) is used.

Could this be a reason for the timeout?

Kind regards,

Marc

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.