charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='ChittiNaidu' timestamp='1361999684' post='1303340008'] good post..... oka daarilo ki vachav..... [/quote] nuvvu ostha ante cheppu nenu daily ade daarilo ostha [img]http://lh4.ggpht.com/_KVkPY2XIbRQ/TaUAMRKJgWI/AAAAAAAACDk/0lph6IducwM/NTR.gif[/img]
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='littlemoon' timestamp='1361999840' post='1303340027'] linked server tho connct ayi undha sp query? remote login and repomte query timeout increase cheyali... [/quote] sp lo query lo aithe em linked servers unattu naaku kanipiyyaledu the third party tool that we use connects to our prod db thru a connection string whose time out limit is not being used as we speak so ekkada marchaali anedi kind of confusing
Guest Posted February 27, 2013 Report Posted February 27, 2013 Option 1) Increase the execution time-out : In SSMS Go to Tools--> Options-->Query Execution--> SQL Server-->Execution-timeout ( Make this value 0, meaning unlimited wait ) Option 2) Break down the text file in two parts ( take half of the rows and save in another text file ) and load those two files, if this doesn't work out break down into three 1
Spartan Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999846' post='1303340028'] [img]http://stream1.gifsoup.com/webroot/animatedgifs/737430_o.gif[/img] 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 [/quote] ok..automate lo.. nuvvu a particular step lo run chese process ki timeout mention chesi unda chudu..script lo... unte try to increase that....idi case 1 case 2: nuvvu ye servers ni copy cheyadaniki chustunnavo..a renditlo rt click manage advanced untadi..if u have access to it.. akkada time out preferences untayi...avi increase chesi chudu..renditlo..
Maximus Posted February 27, 2013 Report Posted February 27, 2013 [quote name='k2s' timestamp='1361999585' post='1303339988'] english lo matladamattaru....matladithey ardam kadu antaru [/quote] [img]http://img518.imageshack.us/img518/6286/rtengrtr1.gif[/img]
Maximus Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999881' post='1303340034'] nuvvu ostha ante cheppu nenu daily ade daarilo ostha [/quote] [img]http://i1170.photobucket.com/albums/r537/ram406/gif2/Sleepover-no-homo.gif[/img]
karna11 Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999063' post='1303339907'] mama naaku ee webconfig endo connection string endo em ardam kaale gmail lo naa badha antha rasi email chesthe jara chusi pedthava ?? [/quote] adhi kadhi neee mS oledb provider ekkada vaduthunnavoo aa app loo chudu baa
innovative 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. [b]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 ??[/b] [/quote] ya naaku kooda time maristhe saripothadhi anipistundhi .. karna cheppunattu changes chesi test cheyyi .. inka 600 saripothundho ledho ante .. first nee query konni sarlu worked fine annav kada .. appudu entha sepu pattindo results ravataniki choosi dhani kanna konni seconds ekkuva mention cheyyi ...
innovative Posted February 27, 2013 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] repost of my post ..
karna11 Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1361999975' post='1303340046'] sp lo query lo aithe em linked servers unattu naaku kanipiyyaledu the third party tool that we use connects to our prod db thru a connection string whose time out limit is not being used as we speak so ekkada marchaali anedi kind of confusing [/quote] nee connection string ekkada vadavooo akkada Cntrl f kotti time out tho search cheyyii
charygaru Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='Guest' timestamp='1362000028' post='1303340056'] Option 1) Increase the execution time-out : In [b]SSMS Go to Tools--> Options-->Query Execution--> SQL Server-->Execution-timeout ( Make this value 0, meaning unlimited wait )[/b] Option 2) Break down the text file in two parts ( take half of the rows and save in another text file ) and load those two files, if this doesn't work out break down into three [/quote] nuvvu sallagundaali vayya ippati daaka andaru marchu marchu anetolle tappa ekkada ela marchali ani okkadu kuda cheppale thanks for the drive. but it is already 0. and making the text file into two parts vishayam antava i guess if the timeout is 0 how does that mater ?? anyways ee solution cheppi chustha repoka sari. thanks a million for the clear instructions bruh
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] [quote name='k2s' timestamp='1361999607' post='1303339992'] [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8641.gif?_r=1346179158[/img] [/quote] [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] [quote name='k2s' timestamp='1361999639' post='1303340000'] [url="http://www.andhrafriends.com/user/26040-littlemoon/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-26040.jpg?_r=1361376418[/img][/url] [/quote] [quote name='ChittiNaidu' timestamp='1361999684' post='1303340008'] good post..... oka daarilo ki vachav..... [/quote][url="http://www.andhrafriends.com/user/29258-innovative/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-29258.jpg?_r=1357230411[/img][/url][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8641.gif?_r=1346179158[/img]
innovative Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Guest' timestamp='1362000028' post='1303340056'] Option 1) Increase the execution time-out : In SSMS Go to Tools--> Options-->Query Execution--> SQL Server-->Execution-timeout ( Make this value 0, meaning unlimited wait ) Option 2) Break down the text file in two parts ( take half of the rows and save in another text file ) and load those two files, if this doesn't work out break down into three [/quote] vgp ...
k2s Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1362000371' post='1303340099'] nuvvu sallagundaali vayya ippati daaka andaru marchu marchu anetolle tappa ekkada ela marchali ani okkadu kuda cheppale thanks for the drive. but it is already 0. and making the text file into two parts vishayam antava i guess if the timeout is 0 how does that mater ?? anyways ee solution cheppi chustha repoka sari. thanks a million for the clear instructions bruh [/quote]memu bhi gadey seppinam kada 4ry
karna11 Posted February 27, 2013 Report Posted February 27, 2013 [quote name='charygaru' timestamp='1362000371' post='1303340099'] nuvvu sallagundaali vayya ippati daaka andaru marchu marchu anetolle tappa ekkada ela marchali ani okkadu kuda cheppale thanks for the drive. but it is already 0. and making the text file into two parts vishayam antava i guess if the timeout is 0 how does that mater ?? anyways ee solution cheppi chustha repoka sari. thanks a million for the clear instructions bruh [/quote] nee yenkees ippati ki kadhaaa, memu inkaa nuvvu enni kastallo vunnvemoo aniii ikkada tension paduthunteeee, nee job maa savokochiddhiga vayyaaa
Recommended Posts