'ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [1] [1] [] [] [] [] [] while submitting data
I have a code, which submits the data into the database. What I do is, First upload excel and submit its relevant data into the database. Below is the code for the same.
protected void btnSubmitIPFeeUpload_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ViewState["GridDataIPFee"] = SelectedRecordIDIPFee;
dt = ViewState["GridDataIPFee"] as DataTable;
try
{
string consString = ConfigurationManager.ConnectionStrings["ConnectionString_IPCOLO"].ConnectionString;
using (OracleConnection oracleConnection = new OracleConnection(consString))
{
string query = @"INSERT INTO TBL_IPCOLO_BILLING_MST_IPFEE (R4GSTATE, SITE_ADDRESS, POLITICAL_STATE_NAME, POLITICAL_STATE_CODE, CMP, SITE_NAME, RFCDATE, RFS_DATE, RFE1_DATE, SITE_DROP_DATE,
INFRA_PROVIDER, IP_COLO_SITEID, VENDOR_CODE, MW_INSTALLED, DG_NONDG, EB_NONEB, TOWER_TYPE, ID_OD_COUNTCHANGE, ID_OD_CHANGEDDATE, RRH_COUNTCHANGE,
RRH_CHANGEDDATE, TENANCY_COUNTCHANGE, TENANCY_CHANGEDDATE,
TOWER_WIND_SPEED, NO_OF_RF_ANTENNA, MW_ANTENNA_06_DIA, MW_ANTENNA_12_DIA, MW_ANTENNA_GREATER_12_DIA, ANTENNA_HIGHEST_HEIGHT, POWER_RATING, LAND_LORD_RENT, WT_ON_TOWER, YEARS_ESCALATION,
NON_EB_CHARGES, EXTRA_BTS_SPACE, U_SPACE, VOLUME_DISCOUNT, SO_DATE, SO_TENURE, LOCK_IN_PERIOD, MANUAL_RFI_SIGNOFF_DATE, LOCATION_PREMIUM, TERM_CHARGES,
PREMIUM_CITY, APPLICABLE_MSA, CITY_NAME_MSA, NO_RF_ANTENNA_SAIL_AREA,NO_RF_ANTENNA_EXD_SAIL_AREA, SAP_ID,CREATED_BY, HEX_ODC_OLT, HUB_SITE_DECLARED, COLUMN_1, COLUMN_2, COLUMN_3, COLUMN_4, COLUMN_5, COLUMN_6, COLUMN_7)
VALUES
(:R4GSTATE, :SITE_ADDRESS, :POLITICAL_STATE_NAME, :POLITICAL_STATE_CODE, :CMP, :SITE_NAME, :RFCDATE, :RFS_DATE, :RFE1_DATE, :SITE_DROP_DATE,
:INFRA_PROVIDER, :IP_COLO_SITEID, :VENDOR_CODE, :MW_INSTALLED, :DG_NONDG, :EB_NONEB, :TOWER_TYPE, :ID_OD_COUNTCHANGE, :ID_OD_CHANGEDDATE, :RRH_COUNTCHANGE,
:RRH_CHANGEDDATE, :TENANCY_COUNTCHANGE, :TENANCY_CHANGEDDATE,
:TOWER_WIND_SPEED, :NO_OF_RF_ANTENNA, :MW_ANTENNA_06_DIA, :MW_ANTENNA_12_DIA, :MW_ANTENNA_GREATER_12_DIA, :ANTENNA_HIGHEST_HEIGHT, :POWER_RATING, :LAND_LORD_RENT, :WT_ON_TOWER, :YEARS_ESCALATION,
:NON_EB_CHARGES, :EXTRA_BTS_SPACE, :U_SPACE, :VOLUME_DISCOUNT, :SO_DATE, :SO_TENURE, :LOCK_IN_PERIOD, :MANUAL_RFI_SIGNOFF_DATE, :LOCATION_PREMIUM, :TERM_CHARGES,
:PREMIUM_CITY, :APPLICABLE_MSA, :CITY_NAME_MSA, :NO_RF_ANTENNA_SAIL_AREA, :NO_RF_ANTENNA_EXD_SAIL_AREA, :SAP_ID, :CREATED_BY, :HEX_ODC_OLT, :HUB_SITE_DECLARED, :COLUMN_1, :COLUMN_2, :COLUMN_3, :COLUMN_4, :COLUMN_5, :COLUMN_6, :COLUMN_7)";
oracleConnection.Open();
using (var command = oracleConnection.CreateCommand())
{
command.CommandText = query;
command.CommandType = CommandType.Text;
command.BindByName = true;
command.ArrayBindCount = dt.Rows.Count;
/*********** P&F **********************/
command.Parameters.Add(":R4GSTATE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("R4GSTATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SITE_ADDRESS", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("SITE_ADDRESS")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":POLITICAL_STATE_NAME", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("POLITICAL_STATE_NAME")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":POLITICAL_STATE_CODE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("POLITICAL_STATE_CODE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":CMP", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("CMP")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SITE_NAME", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("SITE_NAME")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":RFCDATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("RFCDATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":RFS_DATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("RFS_DATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":RFE1_DATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("RFE1_DATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SITE_DROP_DATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("SITE_DROP_DATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":INFRA_PROVIDER", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("INFRA_PROVIDER")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":IP_COLO_SITEID", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("IP_COLO_SITEID")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":VENDOR_CODE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<double?>("VENDOR_CODE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":MW_INSTALLED", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<double?>("MW_INSTALLED")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":DG_NONDG", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("DG_NONDG")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":EB_NONEB", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("EB_NONEB")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":TOWER_TYPE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("TOWER_TYPE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":ID_OD_COUNTCHANGE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("ID_OD_COUNTCHANGE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":ID_OD_CHANGEDDATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("ID_OD_CHANGEDDATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":RRH_COUNTCHANGE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("RRH_COUNTCHANGE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":RRH_CHANGEDDATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("RRH_CHANGEDDATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":TENANCY_COUNTCHANGE", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<double?>("TENANCY_COUNTCHANGE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":TENANCY_CHANGEDDATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("TENANCY_CHANGEDDATE")).ToArray(), ParameterDirection.Input);
/*********** IP FEE **********************/
command.Parameters.Add(":TOWER_WIND_SPEED", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("TOWER_WIND_SPEED")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":NO_OF_RF_ANTENNA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("NO_OF_RF_ANTENNA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":MW_ANTENNA_06_DIA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("MW_ANTENNA_06_DIA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":MW_ANTENNA_12_DIA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("MW_ANTENNA_12_DIA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":MW_ANTENNA_GREATER_12_DIA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("MW_ANTENNA_GREATER_12_DIA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":ANTENNA_HIGHEST_HEIGHT", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("ANTENNA_HIGHEST_HEIGHT")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":POWER_RATING", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("POWER_RATING")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":LAND_LORD_RENT", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("LAND_LORD_RENT")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":WT_ON_TOWER", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("WT_ON_TOWER")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":NON_EB_CHARGES", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("NON_EB_CHARGES")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":YEARS_ESCALATION", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("YEARS_ESCALATION")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":EXTRA_BTS_SPACE", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("EXTRA_BTS_SPACE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":U_SPACE", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("U_SPACE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":VOLUME_DISCOUNT", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("VOLUME_DISCOUNT")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SO_DATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("SO_DATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SO_TENURE", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("SO_TENURE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":LOCK_IN_PERIOD", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("LOCK_IN_PERIOD")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":MANUAL_RFI_SIGNOFF_DATE", OracleDbType.Date, dt.AsEnumerable().Select(r => r.Field<DateTime?>("MANUAL_RFI_SIGNOFF_DATE")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":LOCATION_PREMIUM", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("LOCATION_PREMIUM")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":TERM_CHARGES", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("TERM_CHARGES")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":PREMIUM_CITY", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("PREMIUM_CITY")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":APPLICABLE_MSA", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("APPLICABLE_MSA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":CITY_NAME_MSA", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("CITY_NAME_MSA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":NO_RF_ANTENNA_SAIL_AREA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("NO_RF_ANTENNA_SAIL_AREA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":NO_RF_ANTENNA_EXD_SAIL_AREA", OracleDbType.Double, dt.AsEnumerable().Select(r => r.Field<double?>("NO_RF_ANTENNA_EXD_SAIL_AREA")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":SAP_ID", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("SAP_ID")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":CREATED_BY", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("CREATED_BY")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":HEX_ODC_OLT", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("HEX_ODC_OLT")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":HUB_SITE_DECLARED", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("HUB_SITE_DECLARED")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_1", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_1")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_2", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_2")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_3", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_3")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_4", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_4")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_5", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_5")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_6", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_6")).ToArray(), ParameterDirection.Input);
command.Parameters.Add(":COLUMN_7", OracleDbType.NVarchar2, dt.AsEnumerable().Select(r => r.Field<string>("COLUMN_7")).ToArray(), ParameterDirection.Input);
int result = command.ExecuteNonQuery(); // getting errpr at this line
int intSuccessCount = result;
if (result > 0)
{
string strValidInfo = intSuccessCount + " Record(s) uploaded successfully";
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", "alert('" + strValidInfo + "');", true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('" + strValidInfo + "');window.location ='IPDataInsert.aspx';", true);
}
}
}
}
catch (Exception ex)
{
string strErrorMsg = ex.Message.ToString() + " " + "StackTrace :" + ex.StackTrace.ToString();
CommonDB.WriteLog("ERROR:" + strErrorMsg, ConfigurationManager.AppSettings["IPCOLO_LOG"].ToString());
}
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|