Hi all!
I have a minor but serious problem here.
I have a 5 user lisence webspeed. So when I started wsbroker I have five agents. The query result shown 5 agents available.
But some times weird things happened. It's hard to explain (my bad english), but I'll give an example.
I have a record with a value '20'. Then I update the value to '50' (wether using PROGRESS EDITOR or using .R web program). But when I display it's value in my web program, it's still -proudly- showing 20. not 50 as it shold!. When I check directly trough the database using PROGRESS EDITOR, it shown the correct value: 50.
So the conclusion is my web program did not refresh it's value. It's not always happening. Just some case, but really often. about one in two days.
What makes it weirder, when I query my wsbroker, it only displayed 1 agents available (sometime 2).
So when this 'late data refresh' problem occur, I must restart my wsbroker so it gains 5 agents again. and voilla! my program displays data correctly.
My question is:
1. What makes my broker missing? Was it my code, lack of memory or else.
2. Is there any way to fix it? This 'late refresh' thing is so anoying, and I think restarting my broker isn't a good solution .
As a note, my broker was connected with 2 database in a DELL sever with RAM 1GB, processor clock 2.x GHz (I forgot).
Thanks in advanced
I have a minor but serious problem here.
I have a 5 user lisence webspeed. So when I started wsbroker I have five agents. The query result shown 5 agents available.
But some times weird things happened. It's hard to explain (my bad english), but I'll give an example.
I have a record with a value '20'. Then I update the value to '50' (wether using PROGRESS EDITOR or using .R web program). But when I display it's value in my web program, it's still -proudly- showing 20. not 50 as it shold!. When I check directly trough the database using PROGRESS EDITOR, it shown the correct value: 50.
So the conclusion is my web program did not refresh it's value. It's not always happening. Just some case, but really often. about one in two days.
What makes it weirder, when I query my wsbroker, it only displayed 1 agents available (sometime 2).
So when this 'late data refresh' problem occur, I must restart my wsbroker so it gains 5 agents again. and voilla! my program displays data correctly.
My question is:
1. What makes my broker missing? Was it my code, lack of memory or else.
2. Is there any way to fix it? This 'late refresh' thing is so anoying, and I think restarting my broker isn't a good solution .
As a note, my broker was connected with 2 database in a DELL sever with RAM 1GB, processor clock 2.x GHz (I forgot).
Thanks in advanced