Thank you @TomBascom .
After checking some kb and info from progress knowledge base, I know that for my version the limit size of DBI file is 1Tb.
I also know that the growth could be caused by non using "NO-UNDO" on temp-table definition.
So thanks to you we watched the IO caused we had the case again and it's the DBI file of a user that was growing at huge pace.
So I will have to work on that.
Hello,
While doing a new project I was testing something on performance, there is two way I tried:
I used CUSTOMER table as exemple, but for my case I have a table with 30 fields and only need 6 of them. Also I'm reading around 6K records.
It appears that the traditionnal FOR EACH block was...
You are not working with dynamic query but static one. They're changing at run time.
You should read this part of the documentation to do what you want to do:
https://docs.progress.com/fr-FR/bundle/openedge-abl-reference-117/page/CREATE-QUERY-statement.html
You also have a part where your are repositioning your focus, just there:
IF br-itens:QUERY:NUM-RESULTS > 0 THEN DO:
IF br-itens:QUERY:NUM-RESULTS + 1 = linha THEN
linha = linha - 1.
br-itens:QUERY:REPOSITION-TO-ROW(linha).
END.
Hello wich browse are you talking about in your code? Is it "br-itens" ?
Because if it's him in your DBLCLICK triggers your are doing an open-query on him that could explain the lose of your focus:
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br-itens wWindow
ON MOUSE-SELECT-DBLCLICK OF br-itens IN...
You need to had more object to your frame like a button to do stuff after the user choosed a value in your combo box.
But a question, why are you using a procedure file and not a window file (.w) It would be more easier for you
Hello @Rob Fitzpatrick ,
Thank you for your support on this matter. I'm glad in a way that progress seems not to be the root of it. Also what you tell me will help us to put down a procedure to follow if this issue where to happen again .
Thank you again . I will marked it answered
They are only GUI client and no database or apps server.
We have a server for each task:
A database server
A RDS serveur for production application
And local install for othe user.
Same on this side.
Also it's the first time we had that.
This was unable too and the file wasn't there.
As I said earlier I'm not sure that progress was the root of it. I'm just exploring the path and saerching if it happend to one of you ?
By invisible:
- I mean that the folder c:\temp\progress\ weigthed around 60Go and more
- When you cliked on the folder to enter it, there was no such file or sufficient number of small file to attaint this weight
- They have tried we different tools to analyzed disk space and no such file was...
Hello Guys,
We had a strange issue recently. We don't know if is a progress side issue or on windows side.
There was an invisible file on a end user working directory that continue to grow endlessly around 60Gb and more. The issue was resolved by restarting the server.
On this working directory...
It's strange, because the attribute you'r talking about is not part of the widget:
https://docs.progress.com/fr-FR/bundle/abl-reference/page/BROWSE-widget.html
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.