Re: iDB2ConversionException on ExecuteNonQuery() onlyon Server

Do you have the same version of IBM i Access and the same Service Level on both the PC and the server?

Craig Pelkie


----- Original Message ----- From: "Mike" <koldark@xxxxxxxxx>
To: <systemidotnet@xxxxxxxxxxxx>
Sent: Friday, August 13, 2010 8:06 AM
Subject: [SystemiDotNet] iDB2ConversionException on ExecuteNonQuery() onlyon Server

I have a strange error I am trying to figure out. I am getting
a DB2ConversionException on an ExecuteNonQuery(). I am running a stored
procedure that calls an RPG program. This works perfect on my own PC.
However, when I publish it to the web server, I get the error.

public void SignTimeSheet(Timesheet timesheet, string approved)
{
// Get the data from the iSeries
using (iDB2Connection conn = new iDB2Connection(_CONNSTRING))
{
conn.Open();

iDB2Command cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;

if ((String.IsNullOrEmpty(timesheet.SupervisorComments)) &&
(approved == " "))
{
cmd.CommandText = "MPRLIB.APPROVETIMESHEET";

cmd.Parameters.Add("@SSN",
timesheet.EmployeeUniqueKey.ToString("0000000000"));
cmd.Parameters.Add("@PAPER",
timesheet.EmployeeSignedPaper);
cmd.Parameters.Add("@SUPERVISORID",
timesheet.SupervisorUserId);
cmd.Parameters.Add("@SIGNEDUSER",
timesheet.SupervisorSignedBy);
cmd.Parameters.Add("@WORKSTATION",
timesheet.SupervisorSignedComputer);
}
else
{
cmd.CommandText = "MPRLIB.APPROVETIMESHEETWCOMMENT";

cmd.Parameters.Add("@SSN",
timesheet.EmployeeUniqueKey.ToString("0000000000"));
cmd.Parameters.Add("@PAPER",
timesheet.EmployeeSignedPaper);
cmd.Parameters.Add("@APPROVE", approved);
cmd.Parameters.Add("@SIGNEDUSER",
timesheet.SupervisorSignedBy);
cmd.Parameters.Add("@WORKSTATION",
timesheet.SupervisorSignedComputer);
cmd.Parameters.Add("@COMMENT",
timesheet.SupervisorComments);
}

cmd.ExecuteNonQuery();
conn.Close();
}
}

Any ideas on what it might be or how to debug this on the server?

--
Mike Wills
http://mikewills.info
--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.