rdr.EndOfStream shows function evaluation timeout

Question

when i read 6 mb txt file from ftp using streamreader then rdr.EndOfStream shows function evaluation timeout . Need help

Jaganathan Bantheswaran · Answer

Hi, I could try this post. But still it may help you. Have a look at this post

Ish Bandhu · Answer

I think problem in connection open and close, please check your code you properly opened and closed connection. You debugged your code and check in which line it showing problem. may be problem is here: OracleDataAdapter odp = new OracleDataAdapter("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn); DataSet ds = new DataSet(); odp.Fill(ds); here u did not open the connection

Ravi Shekhar · Answer

public void CopyFlatFilePurchaseOrder() { //OracleCommand cmdDel = new OracleCommand("Delete from Bcil_PurchaseOrder", cnn); //cnn.Open(); //cmdDel.ExecuteNonQuery(); ////cnn.Close(); string FTP_filename; string FTP_User; string FTP_Password; try { OracleCommand cmdFTP = new OracleCommand("Select FTP_Name,FTP_USer,FTP_Password,FTP_PO_FILENAME from Bcil_Configuration_Master", cnn); if (cnn.State == ConnectionState.Open) cnn.Close(); cnn.Open(); OracleDataReader odr = cmdFTP.ExecuteReader(); if (odr.Read()) { FTP_filename = odr["FTP_Name"].ToString() + "//" + odr["FTP_PO_FILENAME"].ToString(); FTP_User = odr["FTP_User"].ToString(); FTP_Password = odr["FTP_Password"].ToString(); } else { OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','File not found')", cnn); if (cnn.State == ConnectionState.Open) cnn.Close(); cnn.Open(); cmdError.ExecuteNonQuery(); cnn.Close(); return; } cnn.Close(); } catch (Exception ex) { OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','" + ex.Message + "')", cnn); if (cnn.State == ConnectionState.Open) cnn.Close(); cnn.Open(); cmdError.ExecuteNonQuery(); cnn.Close(); return; } FtpWebRequest request = (FtpWebRequest)WebRequest.Create(FTP_filename); request.Credentials = new NetworkCredential(FTP_User, FTP_Password); request.UsePassive = true; request.UseBinary = true; request.KeepAlive = true; //request.Method = WebRequestMethods.Ftp.DownloadFile; // This example assumes the FTP site uses anonymous logon. FtpWebResponse response = (FtpWebResponse)request.GetResponse(); Stream responseStream = response.GetResponseStream(); StreamReader rdr = new StreamReader(responseStream); //StreamReader rdr = new StreamReader("D:\ORDMAST.TXT"); int intCount = 1; string strConcept = null;// (1 char), string strType = null; // (1 char), string strOrderNo = null; // (7 char), string strDelDateT = null; // (8 char), string strOrdYrWk = null; // (6 char), string strDelDate = null; // (8 char), string strArtNo = null; // (7 char), string strRdcNo = null; // (5 char), string strAssoNo = null; // (5 char), string strAsstCode = null; // (2 char), int intTotPR; //( 9 digit), int intPR1; //( 7 digit), int intPR2; //( 7 digit), int intPR3; //( 7 digit), int intPR4; //( 7 digit), int intPR5; //( 7 digit), int intPR6; //( 7 digit), int intPR7; //( 7 digit), int intPR8; //( 7 digit), int intPR9; //( 7 digit), int intPR10; //( 7 digit), int intPR11; //( 7 digit), int intPR12; //( 7 digit), int intPR13; //( 7 digit), int intPR14 = 0; //( 7 digit), string strPrntAg = null; //(1 dight), string strOrderType = null; //(1 dight), string strCategory = null; //(4 dight), string strPackMth = null; //(1 dight), string strNoClmDisk = null; //(6 dight), string strFob = null; //(6 dight), string strProforma = null; //(6 dight), string strDelYrWk = null; // (6 char), string strOpnYrWk = null; // (6 char), int intUnitBal; //(7 digit), int intRDCBal; //(7 digit), int intMaxQty; //(7 digit), int intOdrQty; //(3 digit), string strPacktype; //(1 char), string str = null; while (!rdr.EndOfStream) { string strRow = rdr.ReadLine(); try { strConcept = strRow.Substring(0, 1); strType = strRow.Substring(1, 1); strOrderNo = strRow.Substring(2, 7); strDelDateT = strRow.Substring(9, 8); strOrdYrWk = strRow.Substring(17, 6); strDelDate = strRow.Substring(23, 8); // (8 char), strArtNo = strRow.Substring(31, 7); // (7 char), strRdcNo = "1" + strRow.Substring(38, 5); // (5 char), strAssoNo = strRow.Substring(43, 5); // (5 char), strAsstCode = strRow.Substring(48, 2); // (2 char), intTotPR = int.Parse(strRow.Substring(50, 9)); //( 9 digit), intPR1 = int.Parse(strRow.Substring(59, 7)); //( 7 digit), intPR2 = int.Parse(strRow.Substring(66, 7)); //( 7 digit), intPR3 = int.Parse(strRow.Substring(73, 7)); //( 7 digit), intPR4 = int.Parse(strRow.Substring(80, 7)); //( 7 digit), intPR5 = int.Parse(strRow.Substring(87, 7)); //( 7 digit), intPR6 = int.Parse(strRow.Substring(94, 7)); //( 7 digit), intPR7 = int.Parse(strRow.Substring(101, 7)); //( 7 digit), intPR8 = int.Parse(strRow.Substring(108, 7)); //( 7 digit), intPR9 = int.Parse(strRow.Substring(115, 7)); //( 7 digit), intPR10 = int.Parse(strRow.Substring(122, 7)); //( 7 digit), intPR11 = int.Parse(strRow.Substring(129, 7)); //( 7 digit), intPR12 = int.Parse(strRow.Substring(136, 7)); //( 7 digit), intPR13 = int.Parse(strRow.Substring(143, 7)); //( 7 digit), //intPR14 = int.Parse(strRow.Substring(150, 7)); //( 7 digit), strPrntAg = strRow.Substring(150, 1); //(1 dight), strOrderType = strRow.Substring(151, 1); //(1 dight), strCategory = strRow.Substring(152, 4); //(4 dight), strPackMth = strRow.Substring(156, 1); //(1 dight), strNoClmDisk = strRow.Substring(157, 6); //(6 dight), strFob = null; //(6 dight), strProforma = null; //(6 dight), strDelYrWk = strRow.Substring(184, 6); // (6 char), strOpnYrWk = strRow.Substring(190, 6); // (6 char), intUnitBal = int.Parse(strRow.Substring(196, 7)); //(7 digit), intRDCBal = int.Parse(strRow.Substring(203, 7)); //(7 digit), intMaxQty = int.Parse(strRow.Substring(210, 7)); //(7 digit), int.TryParse(strRow.Substring(217, 3), out intOdrQty); //(3 digit),; strPacktype = strRow.Substring(220, 1); string strPlan = GetPlan(strDelDateT); int counter = 0; OracleDataAdapter odp = new OracleDataAdapter("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn); DataSet ds = new DataSet(); odp.Fill(ds); counter = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); //OracleCommand cmdIns = new OracleCommand("select count(*) from Bcil_PurchaseOrder where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn); //cnn.Open(); //counter = cmdIns.ExecuteNonQuery(); if (counter { OracleCommand cmd = new OracleCommand("Insert into Bcil_PurchaseOrder(REQUEST_TYPE,ART_CODE,PROD_ORDER,PROD_UNIT,DESTINATION,BOX_QTY,ORD_QTY,CONCEPT,SUP_CATEGORY,PACK_TYPE,ART_SIZE1,ART_SIZE2,ART_SIZE3,ART_SIZE4,ART_SIZE5,ART_SIZE6,ART_SIZE7,ART_SIZE8,ART_SIZE9,ART_SIZE10,ART_SIZE11,ART_SIZE12,ART_SIZE13,ART_SIZE14,TOT_QTY,DPLAN_NO,CREATE_BY,CREATE_DT) values ('" + strType + "','" + strArtNo + "','" + strOrderNo + "','" + strAssoNo + "','" + strRdcNo + "'," + intOdrQty + "," + intTotPR + ",'" + strConcept + "','" + strCategory + "','" + strPacktype + "'," + intPR1 + "," + intPR2 + "," + intPR3 + "," + intPR4 + "," + intPR5 + "," + intPR6 + "," + intPR7 + "," + intPR8 + "," + intPR9 + "," + intPR10 + "," + intPR11 + "," + intPR12 + "," + intPR13 + "," + intPR14 + "," + intTotPR + ",'" + strPlan + "','BCIL','" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "')", cnn); cnn.Open(); cmd.ExecuteNonQuery(); } else //if (counter { OracleCommand cmd = new OracleCommand("update Bcil_PurchaseOrder set REQUEST_TYPE='" + strType + "',PROD_UNIT='" + strAssoNo + "',BOX_QTY=" + intOdrQty + ",ORD_QTY=" + intTotPR + ",CONCEPT='" + strConcept + "',SUP_CATEGORY='" + strCategory + "',PACK_TYPE='" + strPacktype + "',ART_SIZE1=" + intPR1 + ",ART_SIZE2=" + intPR2 + ",ART_SIZE3=" + intPR3 + ",ART_SIZE4=" + intPR4 + ",ART_SIZE5=" + intPR5 + ",ART_SIZE6=" + intPR6 + ",ART_SIZE7=" + intPR7 + ",ART_SIZE8=" + intPR8 + ",ART_SIZE9=" + intPR9 + ",ART_SIZE10=" + intPR10 + ",ART_SIZE11=" + intPR11 + ",ART_SIZE12=" + intPR12 + ",ART_SIZE13=" + intPR13 + ",ART_SIZE14=" + intPR14 + ",TOT_QTY=" + intTotPR + ",DPLAN_NO='" + strPlan + "',CREATE_BY='BCIL',CREATE_DT='" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "' where ART_CODE='" + strArtNo + "' and PROD_ORDER='" + strOrderNo + "' and DESTINATION='" + strRdcNo + "'", cnn); cnn.Open(); cmd.ExecuteNonQuery(); } cnn.Close(); } catch (Exception ex) { OracleCommand cmdError = new OracleCommand("Insert into ErrorLog(ErrorDate,ErrorTable,Module,Remarks) values ('" + DateTime.Now.Date.ToString("dd-MMM-yyyy") + "','Bcil_PurchaseOrder','Default.aspx','" + ex.Message + "')", cnn); if (cnn.State == ConnectionState.Open) cnn.Close(); cnn.Open(); cmdError.ExecuteNonQuery(); cnn.Close(); } } rdr.Close(); rdr.Dispose(); }

Ish Bandhu · Answer

can u post the code of reading file

Ravi Shekhar · Answer

I have set but still getting timeout.

Ravi Shekhar · Answer

Thank you ish!!! :)

Jaganathan Bantheswaran · Answer

Can you post the code ?

Ish Bandhu · Answer

Set that in web.config:

rdr.EndOfStream shows function evaluation timeout

Answers (8)