Random datagrid issues

[David]

Hi all,

This is a weird one.

I have been asked to look at an intermittent fault.

Basically, I have a webservice that is delivering info into a datagrid.

Dim Statement As New my_service.Stat ement
Dim my_data As New my_service.my_d ata
Statement = my_data.FullSta tement(AccNo, StartDate)
dgridStatement. DataSource = Statement.Statm entEntries
dgridStatement. DataBind()

From what I see here, Statement is on the webservice, so
my_data.FullSta tement is calling the webservice, to push it back to the
webservice, then bring brought down again from the webservice for the
datasource of the datagrid.

I have simplified it, but not sure if it has the same effect... basically,
statement is now a local dataset, which is now
my_data.FullSta tement(...).Sta tmentEntries then bind just statement to the
datagrid.


The problem I am having (prior to the change, don't know if it happens after
the change yet) is that randomly, the data in the datagrid is doubling for
each row. It doesn't happen often, but it does happen.


There could potentially be 3 points (that I see) where it is happening.
1. On the database. Highly unlikely in my opinion. (The DB is using a stored
proc calling a view, which comes from 3 tables, so a possibility that it
could be from here)
2. The backwards and forwards of the data in the code snippet above.
3. a problem with the datagrid.


I had probs with the datagrid on another unrelated project where the
databind was running twice, so this is why I won't discount this.

Has anyone come up against a similar issue. This is REALLY puzzling me.

--
Best regards,
Dave Colliver.

http://www.AshfieldFOCUS.com

~~
http://www.FOCUSPortals.com - Local franchises available

[Patrice]

Re: Random datagrid issues

My first thought would be to check the webservice implementation. What
happens when running multiple requests at the same time. Do you use static
(or VB.NET shared data) in your webservice ?

--
Patrice

"David" <david.colliver .NEWS@revilloc. REMOVETHIS.coma écrit dans le
message de groupe de discussion : #IFN5YzSJHA.358 4@TK2MSFTNGP06. phx.gbl...

Hi all,
>
This is a weird one.
>
I have been asked to look at an intermittent fault.
>
Basically, I have a webservice that is delivering info into a datagrid.
>
Dim Statement As New my_service.Stat ement
Dim my_data As New my_service.my_d ata
Statement = my_data.FullSta tement(AccNo, StartDate)
dgridStatement. DataSource = Statement.Statm entEntries
dgridStatement. DataBind()
>
From what I see here, Statement is on the webservice, so
my_data.FullSta tement is calling the webservice, to push it back to the
webservice, then bring brought down again from the webservice for the
datasource of the datagrid.
>
I have simplified it, but not sure if it has the same effect... basically,
statement is now a local dataset, which is now
my_data.FullSta tement(...).Sta tmentEntries then bind just statement to the
datagrid.
>
>
The problem I am having (prior to the change, don't know if it happens
after the change yet) is that randomly, the data in the datagrid is
doubling for each row. It doesn't happen often, but it does happen.
>
>
There could potentially be 3 points (that I see) where it is happening.
1. On the database. Highly unlikely in my opinion. (The DB is using a
stored proc calling a view, which comes from 3 tables, so a possibility
that it could be from here)
2. The backwards and forwards of the data in the code snippet above.
3. a problem with the datagrid.
>
>
I had probs with the datagrid on another unrelated project where the
databind was running twice, so this is why I won't discount this.
>
Has anyone come up against a similar issue. This is REALLY puzzling me.
>
--
Best regards,
Dave Colliver.

http://www.AshfieldFOCUS.com

~~
http://www.FOCUSPortals.com - Local franchises available
>

[David]

Re: Random datagrid issues

Hi Patrice,

Thanks for the response. I am not sure at the moment (I have been moved onto
another project, but I will be sure to have a look).

What would you suggest should be there? (should it be static / shared?)

The main problem I have is that I am effectively working blind. I didn't
write the system initially, and I can't really test it as it is on a client
site and I don't have an account to log into their system. On top of that,
my test rig won't run because the directory has ASP.NET authentication on
it, so even though I put my test code in place, I am still being asked to
sign-in.

This is one of those frustrating projects. :-(

--
Best regards,
Dave Colliver.

http://www.AshfieldFOCUS.com

~~
http://www.FOCUSPortals.com - Local franchises available


"Patrice" <http://www.chez.com/scribe/wrote in message
news:OJGMcczSJH A.5408@TK2MSFTN GP04.phx.gbl...

My first thought would be to check the webservice implementation. What
happens when running multiple requests at the same time. Do you use static
(or VB.NET shared data) in your webservice ?
>
--
Patrice
>
"David" <david.colliver .NEWS@revilloc. REMOVETHIS.coma écrit dans le
message de groupe de discussion : #IFN5YzSJHA.358 4@TK2MSFTNGP06. phx.gbl...

>Hi all,
>>
>This is a weird one.
>>
>I have been asked to look at an intermittent fault.
>>
>Basically, I have a webservice that is delivering info into a datagrid.
>>
> Dim Statement As New my_service.Stat ement
> Dim my_data As New my_service.my_d ata
> Statement = my_data.FullSta tement(AccNo, StartDate)
> dgridStatement. DataSource = Statement.Statm entEntries
> dgridStatement. DataBind()
>>
>From what I see here, Statement is on the webservice, so
>my_data.FullSt atement is calling the webservice, to push it back to the
>webservice, then bring brought down again from the webservice for the
>datasource of the datagrid.
>>
>I have simplified it, but not sure if it has the same effect...
>basically, statement is now a local dataset, which is now
>my_data.FullSt atement(...).St atmentEntries then bind just statement to
>the datagrid.
>>
>>
>The problem I am having (prior to the change, don't know if it happens
>after the change yet) is that randomly, the data in the datagrid is
>doubling for each row. It doesn't happen often, but it does happen.
>>
>>
>There could potentially be 3 points (that I see) where it is happening.
>1. On the database. Highly unlikely in my opinion. (The DB is using a
>stored proc calling a view, which comes from 3 tables, so a possibility
>that it could be from here)
>2. The backwards and forwards of the data in the code snippet above.
>3. a problem with the datagrid.
>>
>>
>I had probs with the datagrid on another unrelated project where the
>databind was running twice, so this is why I won't discount this.
>>
>Has anyone come up against a similar issue. This is REALLY puzzling me.
>>
>--
>Best regards,
>Dave Colliver.
>http://www.AshfieldFOCUS.com
>~~
>http://www.FOCUSPortals.com - Local franchises available
>>

>

[Patrice]

Re: Random datagrid issues

My thought would be that the dataset returned by the web service (I assuming
it is a dataset) is stored in a static (shared for VB.NET) variable. such a
variable is unique to the application, and in the case of ASP.NET it means
this is share accross requests... So if having multiple requests at the same
time the "Fill" call would add data to the same data resulting in twice (or
more) the same data...

This is whay I would check the web service to see hiow is stored the dataset
used on this side.

A more general approach would be to have some kind of trace to track the
record count allowing possibly to check from the beginning to the end of the
whole process where the count starts to differ...


--
Patrice


"David" <david.colliver .NEWS@revilloc. REMOVETHIS.coma écrit dans le
message de groupe de discussion : eY$vuc8SJHA.437 2@TK2MSFTNGP04. phx.gbl...

Hi Patrice,
>
Thanks for the response. I am not sure at the moment (I have been moved
onto another project, but I will be sure to have a look).
>
What would you suggest should be there? (should it be static / shared?)
>
The main problem I have is that I am effectively working blind. I didn't
write the system initially, and I can't really test it as it is on a
client site and I don't have an account to log into their system. On top
of that, my test rig won't run because the directory has ASP.NET
authentication on it, so even though I put my test code in place, I am
still being asked to sign-in.
>
This is one of those frustrating projects. :-(
>
--
Best regards,
Dave Colliver.

http://www.AshfieldFOCUS.com

~~
http://www.FOCUSPortals.com - Local franchises available
>
>
"Patrice" <http://www.chez.com/scribe/wrote in message
news:OJGMcczSJH A.5408@TK2MSFTN GP04.phx.gbl...

>My first thought would be to check the webservice implementation. What
>happens when running multiple requests at the same time. Do you use
>static (or VB.NET shared data) in your webservice ?
>>
>--
>Patrice
>>
>"David" <david.colliver .NEWS@revilloc. REMOVETHIS.coma écrit dans le
>message de groupe de discussion :
>#IFN5YzSJHA.35 84@TK2MSFTNGP06 .phx.gbl...

>>Hi all,
>>>
>>This is a weird one.
>>>
>>I have been asked to look at an intermittent fault.
>>>
>>Basically, I have a webservice that is delivering info into a datagrid.
>>>
>> Dim Statement As New my_service.Stat ement
>> Dim my_data As New my_service.my_d ata
>> Statement = my_data.FullSta tement(AccNo, StartDate)
>> dgridStatement. DataSource = Statement.Statm entEntries
>> dgridStatement. DataBind()
>>>
>>From what I see here, Statement is on the webservice, so
>>my_data.FullS tatement is calling the webservice, to push it back to the
>>webservice, then bring brought down again from the webservice for the
>>datasource of the datagrid.
>>>
>>I have simplified it, but not sure if it has the same effect...
>>basically, statement is now a local dataset, which is now
>>my_data.FullS tatement(...).S tatmentEntries then bind just statement to
>>the datagrid.
>>>
>>>
>>The problem I am having (prior to the change, don't know if it happens
>>after the change yet) is that randomly, the data in the datagrid is
>>doubling for each row. It doesn't happen often, but it does happen.
>>>
>>>
>>There could potentially be 3 points (that I see) where it is happening.
>>1. On the database. Highly unlikely in my opinion. (The DB is using a
>>stored proc calling a view, which comes from 3 tables, so a possibility
>>that it could be from here)
>>2. The backwards and forwards of the data in the code snippet above.
>>3. a problem with the datagrid.
>>>
>>>
>>I had probs with the datagrid on another unrelated project where the
>>databind was running twice, so this is why I won't discount this.
>>>
>>Has anyone come up against a similar issue. This is REALLY puzzling me.
>>>
>>--
>>Best regards,
>>Dave Colliver.
>>http://www.AshfieldFOCUS.com
>>~~
>>http://www.FOCUSPortals.com - Local franchises available
>>>

>>

>
>