{"id":1269,"date":"2011-08-25T19:16:57","date_gmt":"2011-08-25T19:16:57","guid":{"rendered":"https:\/\/alfagestion.com.ar\/faq\/?p=1269"},"modified":"2012-12-19T17:35:39","modified_gmt":"2012-12-19T17:35:39","slug":"error-tieme-out-o-tiempo-de-espera-finalizado","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/","title":{"rendered":"Error Tieme Out o Tiempo de espera finalizado"},"content":{"rendered":"<p>Abrir la tabla AUX_ERR.<\/p>\n<p>Identificar el c\u00f3digo del error. Para ordenar por fecha (Order by fecha = &#8216;xx\/xx\/xxxx&#8217;)<\/p>\n<p><!--more--><\/p>\n<p>En una nueva consulta ejecutar el siguiente Script.<\/p>\n<p style=\"margin-left: 13pt\"><span style=\"color:black; font-family:Segoe UI; font-size:10pt\"><strong>DECLARE @SQL nvarchar(4000)<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 13pt\"><span style=\"color:black; font-family:Segoe UI; font-size:10pt\"><strong>set @sql = &#8216;bcp &#8220;select sql from <span style=\"color:red\">abuela<span style=\"color:black\">.dbo.aux_err where id = <span style=\"color:red\">821<span style=\"color:black\">&#8221; queryout &#8220;c:\\xx.txt&#8221; -c -T -C ANSI&#8217;<br \/>\n<\/span><\/span><\/span><\/span><\/strong><\/span><\/p>\n<p><span style=\"font-family:Segoe UI; font-size:10pt\"><strong><span style=\"color:black\">exec master..xp_cmdshell @sql    (Ver base de datos y poner el nombre correspondiente, en este ejemplo esta la base <span style=\"color:red\">abuela <\/span>y el <\/span>c\u00f3digo de error en este caso es el <span style=\"color:red\">821 <\/span>).<br \/>\n<\/strong><\/span><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Abrir la tabla AUX_ERR. Identificar el c\u00f3digo del error. Para ordenar por fecha (Order by fecha = &#8216;xx\/xx\/xxxx&#8217;)<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[],"class_list":["post-1269","post","type-post","status-publish","format-standard","hentry","category-faq"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9eJDz-kt","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1710,"url":"https:\/\/www.alfagestion.com.ar\/ag\/no-puedo-acceder-a-un-servidor-sql-remoto\/","url_meta":{"origin":1269,"position":0},"title":"No puedo acceder a un servidor SQL remoto.","date":"5 diciembre 2013","format":false,"excerpt":"Si no puede acceder a un servidor SQL remoto debe tener en cuenta las siguientes opciones. Agregar al Firewall de Windows las excepciones a SQL y SQLBrowser. O deshabilitar el Firewall. Los puertos habituales son TCP 1433 SQL y UDP 1434 para el SQL Browser. En configuraci\u00f3n de superficie de\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4975,"url":"https:\/\/www.alfagestion.com.ar\/ag\/4975-2\/","url_meta":{"origin":1269,"position":1},"title":"Registro de Errores en Alfa Gestion","date":"1 agosto 2017","format":false,"excerpt":"El Alfa Gesti\u00f3n registra todos los errores producidos en la base de datos al intentar grabar, para poder\u00a0analizar y recuperar\u00a0la sentencia que produjo el error. Para esto, puede abrir desde el manager la tabla aux_err, normalmente ordenar por id desc para ver los ultimos errores primeros, detectar cual es, y\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4688,"url":"https:\/\/www.alfagestion.com.ar\/ag\/error-reinicio-al-instalar-sql-server-2008\/","url_meta":{"origin":1269,"position":2},"title":"Error Reinicio al instalar Sql Server 2008","date":"8 febrero 2017","format":false,"excerpt":"Pregunta: Estoy tratando de instalar SQL server 2008 Enterprise y al verificar las Reglas Auxiliares del programa de Instalaci\u00f3n da error en una sola: Reiniciar el Equipo. Indica que debo reiniciar el equipo antes de la instalaci\u00f3n. Lo reinicio y vuelve a darme el mismo error.\u00a0Gracias. \u00a0Respuesta para pasar esta\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9207,"url":"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/","url_meta":{"origin":1269,"position":3},"title":"Error de conexi\u00f3n, no abre el Alfa Gestion","date":"26 julio 2022","format":false,"excerpt":"Estado de SQL 01S00 Numero de Error -2147467259 Atributo de cadena de conexion no valido Si el error lo da en el mismo equipo donde esta instalado el motor de base de datos, puede ocurrir porque no arranco el SQL Server, que se ejecuta como un servicio de windows. Para\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2540,"url":"https:\/\/www.alfagestion.com.ar\/ag\/sql-server-2000-base-en-estado-suspect\/","url_meta":{"origin":1269,"position":4},"title":"SQL Server 2000 \u2013 Base en estado Suspect","date":"25 septiembre 2014","format":false,"excerpt":"Base de Datos Sospechosa (Suspect), recuperaci\u00f3n con sp_resetstatus y DBCC DBRECOVER, y el Modo de Emergencia Volver a: [SQL Server FAQ :: Preguntas y Respuestas Frecuentes de SQL Server :: Manual SQL Server] \u00a0Un problema t\u00edpico en Administraci\u00f3n de Bases de Datos SQL Server, es encontrar una Base de Datos\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4776,"url":"https:\/\/www.alfagestion.com.ar\/ag\/configurar-balanza-kretz-report-nx-lcd\/","url_meta":{"origin":1269,"position":5},"title":"CONFIGURAR BALANZA KRETZ REPORT NX LCD","date":"30 abril 2017","format":false,"excerpt":"ARA CONFIGURAR LA RED, DESDE LA BALANZA BALANZA 1 192.168.0.50 PUERTO 1001 SOFTWARE ITEGRA LINK DEL MANUAL\u00a0\u00a0 2- DAR DE ALTA LA EMPRESA DESDE EL MENU MANTENIMIENTO - EMPRESA \u00a0 3- CONFIGURAR EL FORMATO DEL CODIGO DE BARRA \/ ARCHIVOS - CONFIGURACI\u00d3N\u00a0- C\u00d3DIGOS\u00a0DE BARRA 4- CONFIGURAR EL FORMATO DEL CODIGO\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2017\/04\/33.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/1269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/comments?post=1269"}],"version-history":[{"count":2,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/1269\/revisions"}],"predecessor-version":[{"id":1490,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/1269\/revisions\/1490"}],"wp:attachment":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media?parent=1269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/categories?post=1269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/tags?post=1269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}