littlemoon Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361997936' post='1303339750'] ee error enduku osthundi vayya Microsoft OLE DB Provider for SQL Server: Timeout expired. oka stored proc lo bulk insert use chesthunte ee error osthundi . this error keeps repeating it self ever couple of hours and sends an error email but then it re runs and does its work why does it error out sme times but work other times ?? telusthe cheppundi vayya evaranna [/quote] time out error ankunta also sql analyzer lo chk cheyandi query e link chusara? [url="http://www.sqlservercentral.com/Forums/Topic404124-146-1.aspx"]http://www.sqlserver...4124-146-1.aspx[/url]
Spartan Posted February 27, 2013 Report Posted February 27, 2013 [quote name='k2s' timestamp='1361999401' post='1303339958'] [img]http://www.desigifs.com/sites/default/files/idea.gif?1290057832[/img] gadey memu bhi seppinam mari code rasi seppinam soodu kinda [/quote]
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='innovative' timestamp='1361999095' post='1303339913'] hmm .. maa company lo mysql Database use chestharu ... database ki pose chese queries ekkuva sepu theskunte to give results ... time out error vachedhi .. then we changed .ini file (configuration file ) to increase the time .. [/quote] okkokadu okko sodhi chepthunnaru ee error search chesthe okadu update stats antadu inkokadu timeout error osthe connection.string lo edo value change cheyyamantadu edo edo chepthunnaru but i m really not understanding what to do anyways ee lolli antha prod lo undi so nenu muttukonu konni possible solutions repu ma manager ki cheppi appudu chustha edanna work out aythado ledo ani. my personal take on this is since this is not failing all the times karna mama cheppinattu connection.string whatever lo time penchatam may be better option emo but 600s undi already isnt that enough ??
Maximus Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999257' post='1303339937'] SQL SERVER [/quote] [img]https://lh4.googleusercontent.com/-q0tG4Nqn8GU/TrILACbtZzI/AAAAAAAAIZM/-8l1E-kUkBc/s150/Brahmi-3.gif[/img] [quote name='k2s' timestamp='1361999309' post='1303339944'] [/quote] alal artham ayyey bashalo chepthey ela...[img]https://lh3.googleusercontent.com/-_iCk7-IufmQ/UCRlVTxRHmI/AAAAAAAAIZY/lmGzvNKUFvw/s150/Brahmi-1.gif[/img]kasta taramayina...chary chudu entha baga cheppado
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='littlemoon' timestamp='1361999410' post='1303339960'] time out error ankunta also sql analyzer lo chk cheyandi query e link chusara? [url="http://www.sqlservercentral.com/Forums/Topic404124-146-1.aspx"]http://www.sqlserver...4124-146-1.aspx[/url] [/quote] kaneesam google la kuda chudakunda ochhesha anukunnava vennela ?? what re u i sawded but it didnt work
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='ChittiNaidu' timestamp='1361999449' post='1303339968'] [/quote] [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-4039.jpg?_r=1355262266[/img]
littlemoon Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999520' post='1303339977'] kaneesam google la kuda chudakunda ochhesha anukunnava vennela ?? what re u i sawded but it didnt work [/quote] ante adi marri
k2s Posted February 27, 2013 Report Posted February 27, 2013 [quote name='ChittiNaidu' timestamp='1361999449' post='1303339968'] [/quote] [quote name='Maximus' timestamp='1361999507' post='1303339974'] alal artham ayyey bashalo chepthey ela...[img]https://lh3.googleusercontent.com/-_iCk7-IufmQ/UCRlVTxRHmI/AAAAAAAAIZY/lmGzvNKUFvw/s150/Brahmi-1.gif[/img]kasta taramayina...chary chudu entha baga cheppado [/quote]english lo matladamattaru....matladithey ardam kadu antaru
k2s Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999559' post='1303339981'] [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-4039.jpg?_r=1355262266[/img] [/quote][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8641.gif?_r=1346179158[/img]
k2s Posted February 27, 2013 Report Posted February 27, 2013 [quote name='k2s' timestamp='1361999607' post='1303339992'] [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8641.gif?_r=1346179158[/img] [/quote][url="http://www.andhrafriends.com/user/12764-charygaru/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-12764.jpg?_r=1341132840[/img][/url]
Spartan Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999463' post='1303339970'] okkokadu okko sodhi chepthunnaru ee error search chesthe okadu update stats antadu inkokadu timeout error osthe connection.string lo edo value change cheyyamantadu edo edo chepthunnaru but i m really not understanding what to do anyways ee lolli antha prod lo undi so nenu muttukonu konni possible solutions repu ma manager ki cheppi appudu chustha edanna work out aythado ledo ani. my personal take on this is since this is not failing all the times karna mama cheppinattu connection.string whatever lo time penchatam may be better option emo but 600s undi already isnt that enough ?? [/quote] 600s endi vay..its too short.....make it somewehere arnd 900-1200...
k2s Posted February 27, 2013 Report Posted February 27, 2013 [quote name='k2s' timestamp='1361999621' post='1303339994'] [url="http://www.andhrafriends.com/user/12764-charygaru/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-12764.jpg?_r=1341132840[/img][/url] [/quote][url="http://www.andhrafriends.com/user/26040-littlemoon/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-26040.jpg?_r=1361376418[/img][/url]
Spartan Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999559' post='1303339981'] [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-4039.jpg?_r=1355262266[/img] [/quote] good post..... oka daarilo ki vachav.....
littlemoon Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999520' post='1303339977'] kaneesam google la kuda chudakunda ochhesha anukunnava vennela ?? what re u i sawded but it didnt work [/quote] linked server tho connct ayi undha sp query? remote login and repomte query timeout increase cheyali...
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='ChittiNaidu' timestamp='1361999267' post='1303339938'] Timeout configure cheyavo... random ga aitunte....ne data kuda random size untadi kada.. i think depending on the bulk data size connection terminate aitundi anukunta...increase the timeout details.. simple logic adi..... [color=#ff0000][b]etla cheyalno...adagaku..naak telvad[/b][/color]... [/quote] [img]http://stream1.gifsoup.com/webroot/animatedgifs/737430_o.gif[/img] [quote name='ChittiNaidu' timestamp='1361999632' post='1303339998'] 600s endi vay..its too short.....make it somewehere arnd 900-1200... [/quote] asalu atlanti oka option undo ledo kuda telvadu vayya nee G this is actually very simple thing. maaku automate ani oka tool undi adi vaadutyham andulo step by step process antha esi untadi when that process reaches this paritcular step it calls the stroed proc and the stored proc runs ippudu itu stored proc lo gaani atu automate lo kaani connection string ane value eda undo naaku telvadu i am guessing since both of them are in diff servers ee server to server time limit edanna unte daani reset cheyyali leda penchaali anukuntunna which is well over my expertise and i am not sure if that is the case as well
Recommended Posts