[Microsoft][ODBC SQL Server Driver]:Timeout Expired
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?
Thanks in advance.