[Microsoft][ODBC SQL Server Driver]Timeout expired

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

[Microsoft][ODBC SQL Server Driver]Timeout expired

Author

Topic

thomasom
Starting Member

7 Posts

Posted - 2002-05-29 : 01:03:32

Database \\VMFGSRVR\VMFG is SQL 2000 Std.
Database \\NT002\P_GL is SQL 7.0.
All SQL versions are at the current SP levels.

I receive the timeout message when I am in EM, database,VMFG(database), Views, Open View, Return All Rows. I can successfully run the code in QA. What items should I be looking at?I am attempting to create a view with the following code:
--------------
CREATE view uv_olap_adj_co_profit as
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
'7' as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)*ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.material) as material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)*ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)*ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
customer
where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id = customer.id and
(customer_order.salesrep_id = 'LABELAIREP' or
customer_order.salesrep_id = 'OMOHUNDR' or
customer_order.salesrep_id = 'EGGERSR')
union all
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
customer.user_2 as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)*ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.material) as material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)*ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)*ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
customer
where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id = customer.id and
(customer_order.salesrep_id <> 'LABELAIREP' and
customer_order.salesrep_id <> 'OMOHUNDR' and
customer_order.salesrep_id <> 'EGGERSR')

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-05-29 : 09:22:11

EM imposes a timeout, which you're likely hitting by asking all rows be returned from what looks to be a rather complex view.

My answer runs parallel to that bad doctor joke - if QA works, then use QA ...

BTW, you really shouldn't use EM to look at data. That's what QA is for.

setBasedIsTheTruepath
<O>

thomasom
Starting Member

7 Posts

Posted - 2002-05-29 : 10:54:06

setBasedIsTheTruepath,
Thank you for your input. The View is input to dimensions in a cube. I'm not sure that running it in QA is the answer. I am a DBA newbie. Can I execute the View create in QA when the dimension is processed?
Mike

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources