Mayur Takle 15.Oct.12 10:16 AM a Web browser LEI LEI - 6.5 Windows
When we run the procedure through LEI it is facing issue in reflecting the SQL table when we update the table with more than 7 records. The LEI shows completed successfully but the records are not reflected in the SQL table when the count of updating record is more than 7. If we update the SQL table with less than 7 records it is working properly.
I had perform some tracing from the SQL end and found that the below query is formed on SQL side when we run the LEI job.
declare @p1 int
declare @p3 int
declare @p4 int
declare @p5 int
exec sp_cursoropen @p1 output,N'EXECUTE spEMPLOYEE_Process',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5
The above query displays result properly when the updated records are less than 7. The same query is generated for the records more than 7 but the results are not displayed in SQL table. So we tried to run this query from the SQL end it worked successfully and displayed the result.
I then tried to run the LEI having the whole query in the command field of the LEI job. But the results were not displayed for more than 7 records.
Request anyone from you to suggest some thing in order to solve such issue.