Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
EDB 1.06 lock |
Tue, Nov 13 2007 3:35 AM | Permanent Link |
"Harry de Boer" | Tim,
I tried to test the refreshing of views (was solved in 1.06). However, some strange things occur. I connect to a remote DB in EDBmngr and with a testapp. The app shows the view. After editing -in EDBmngr- a field in a table (that is part of the view) I would then refresh the view to see the changed value. However on editing the field in EDBmngr I first got an "Cannot Lock table .." error. Retried and EDBmngr freezes. I shut down EDBmngr via Taskmanager, but on that table I keep getting the lock error. I even closed the testapp, but nothing seems to help. 1 How can I get rid of the lock? 2 What could possibly have gone wrong here? Regards, Harry |
Tue, Nov 13 2007 9:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< I tried to test the refreshing of views (was solved in 1.06). However, some strange things occur. I connect to a remote DB in EDBmngr and with a testapp. The app shows the view. After editing -in EDBmngr- a field in a table (that is part of the view) I would then refresh the view to see the changed value. However on editing the field in EDBmngr I first got an "Cannot Lock table .." error. Retried and EDBmngr freezes. I shut down EDBmngr via Taskmanager, but on that table I keep getting the lock error. I even closed the testapp, but nothing seems to help. >> What was the exact error message that you received ? That will help pinpoint the issue. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Nov 14 2007 4:30 AM | Permanent Link |
"Harry de Boer" | Tim,
Just tried again. The EDBmngr just 'hangs' no error. I will send the testappproject and dbcatalog to the binaries Ng for you to investigate. Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:38922A0B-4DF8-439E-9BAE-FBF293CBF441@news.elevatesoft.com... > Harry, > > << I tried to test the refreshing of views (was solved in 1.06). However, > some strange things occur. I connect to a remote DB in EDBmngr and with a > testapp. The app shows the view. After editing -in EDBmngr- a field in a > table (that is part of the view) I would then refresh the view to see the > changed value. However on editing the field in EDBmngr I first got an > "Cannot Lock table .." error. Retried and EDBmngr freezes. I shut down > EDBmngr via Taskmanager, but on that table I keep getting the lock error. I > even closed the testapp, but nothing seems to help. >> > > What was the exact error message that you received ? That will help > pinpoint the issue. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Wed, Nov 14 2007 3:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< Just tried again. The EDBmngr just 'hangs' no error. I will send the testappproject and dbcatalog to the binaries Ng for you to investigate. >> I cannot reproduce what you're seeing here. Could you perhaps try to post a project without the PSC* and LMD* components included ? Also, I'm working with (initially) empty tables here - is that how you're starting also ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Nov 15 2007 4:42 AM | Permanent Link |
"Harry de Boer" | Tim,
Posted the project again in the binaries NG (same thread). The tables I use are not empty. Maybe I can send the tables that are involved in the view to you. It contains customer's data, so I don't want to send it to the binaries. Where can I send it to? Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:000DDC66-F290-40E9-A8C8-E7D396FD649D@news.elevatesoft.com... > Harry, > > << Just tried again. The EDBmngr just 'hangs' no error. I will send the > testappproject and dbcatalog to the binaries Ng for you to investigate. >> > > I cannot reproduce what you're seeing here. Could you perhaps try to post a > project without the PSC* and LMD* components included ? Also, I'm working > with (initially) empty tables here - is that how you're starting also ? > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Thu, Nov 15 2007 5:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< Posted the project again in the binaries NG (same thread). The tables I use are not empty. Maybe I can send the tables that are involved in the view to you. It contains customer's data, so I don't want to send it to the binaries. Where can I send it to? >> I've got the problem fixed now. It's an issue with the views acquiring read locks on the tables but not releasing them. A fix will be available in about a week in a 1.06 B2 release. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Nov 16 2007 12:31 AM | Permanent Link |
"Harry de Boer" | Tim,
Thanks. Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:98337E4E-556A-4AE8-9F66-A509BCDA3932@news.elevatesoft.com... > Harry, > > << Posted the project again in the binaries NG (same thread). The tables I > use are not empty. Maybe I can send the tables that are involved in the view > to you. It contains customer's data, so I don't want to send it to the > binaries. Where can I send it to? >> > > I've got the problem fixed now. It's an issue with the views acquiring read > locks on the tables but not releasing them. A fix will be available in > about a week in a 1.06 B2 release. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |