[Microsoft][ODBC SQL Server Driver]:Timeout Expired

[Former Member]

Hi Experts,

We are using stored procedure in SAP MII 12.2 using PCo query with two parameters

1) End Date

2) Elapsed Time.

If we pass end date as 2nd Aug13 and elapsed time as 24 then we are getting past 24 hours data i.e 1st Aug13.

So for getting month data we need to loop stored procedure. We build logic in MII12.2(Screenshot attached).

Using next for loop,we are incrementing the dates and passing to stored procedure. But sometimes it gives [Microsoft][ODBC SQL Server Driver]:Timeout Expired error for random dates.

If we run stored procedure in Sql sever using while loop,it is giving data for total month but time required is more.

Is transaction logic needs to be changed?

Please suggest.

Thanks in advance.

[Former Member]

I guess you can increase the value timeout, under data servers and check.

Regards,

Rao

[Former Member]

Hi Padma,

I m using PCo query in MII 12.2. so i increased query timeout of Pco query which is in sec.

But no luck.

Please suggest.

Regards,

Neha

[Former Member]

Neha,

Is error coming for same set of dates? Or when you execute it gives for different dates everytime?

Wht is the first assignment and second assignment doing here?

Can you put a tracer to get LastErrorMessage of query?

Also check below link dont know whether it helps you just giving a hint.

http://support.microsoft.com/kb/313661

Regards,

Rao

[Former Member]

Hi Neha,

Is it a constraint for you to give the elapsed time to a maximum of 24 hours?

If not, can you try giving it 72 hours or something like that so that you will not require to loop through your stored procedure so many times which will optimize your performance and might eliminate the TimeOut error.

Best Regards,

Anuj

[Former Member]

Hi Anuj,

Thank you for quick reply.

I have already tried by giving 48 or 72 hours to stored procedure from MII using PCo query.

But it is giving me same error.

I have also tried by giving 48 or 72 hours to stored procedure from SQL sever side and it is working fine.

Can you please suggest any other alternative?

Regards,

Neha