Re: AW: [development-axapta] Who locks the table?
Hi, try Administration/Inquiries/Database/Locking database users (shown per company) From: JoséQuintero Sent: Wednesday, January 23, 2008 3:23 PM To: development-axapta@yahoogroups.com Subject: Re: AW: [development-axapta] Who locks the table? Hello!: We are n version 3 SP6. When we go to online users often this form don't show any SPID (although I know that a specific user is accesing a table). Does exists another way to know who is locking the record in a table?. [EMAIL PROTECTED] wrote: In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von jquinteroz Gesendet: Mittwoch, 23. Januar 2008 02:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed] - Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: AW: [development-axapta] Who locks the table?
Hello, You are saying this form 'often' does not show any SPID. In this case it may be worthwhile to checkout 'timeout' setting on your database. Is there any possibility that the blocking process was initiated by the user but the user disconnected or aborted the process leaving orphaned SPID? Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of José Quintero Sent: Wednesday, January 23, 2008 6:23 AM To: development-axapta@yahoogroups.com Subject: Re: AW: [development-axapta] Who locks the table? Hello!: We are n version 3 SP6. When we go to online users often this form don't show any SPID (although I know that a specific user is accesing a table). Does exists another way to know who is locking the record in a table?. [EMAIL PROTECTED]mailto:jesper.joergensen%40bertelsmann.de wrote: In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED]mailto:jesper.joergensen%40bertelsmann.de blocked::blocked::blocked::mailto:[EMAIL PROTECTED]mailto:jesper.joergensen%40bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com] Im Auftrag von jquinteroz Gesendet: Mittwoch, 23. Januar 2008 02:56 An: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Betreff: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed] - Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Who locks the table?
In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von jquinteroz Gesendet: Mittwoch, 23. Januar 2008 02:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed]
Re: AW: [development-axapta] Who locks the table?
Hello!: We are n version 3 SP6. When we go to online users often this form don't show any SPID (although I know that a specific user is accesing a table). Does exists another way to know who is locking the record in a table?. [EMAIL PROTECTED] wrote: In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von jquinteroz Gesendet: Mittwoch, 23. Januar 2008 02:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed] - Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed]
