Windows Server

David O'Brien · Guest

I have a .NET application which extracts data from an IBM iSeries via HIS
2004. While I was on OS400 V4R5M0 everything worked fine. Now that I am on
V5R3M0, the latest version, the application crashes when more than a certain
number of records are returned. For the query I'm testing it on, thats about
130. The error is

The data value could not be converted for reasons other than sign mismatch
or data overflow. For example, the data was corrupted in the data store but
the row was still retrievable.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.InvalidCastException: The data value could not be
converted for reasons other than sign mismatch or data overflow. For example,
the data was corrupted in the data store but the row was still retrievable.

Source Error:

Line 336:
Line 337: Dim ds As New DataSet()
Line 338: myCommand.Fill(ds)
Line 339:
Line 340: dgrSTOCK.DataSource = ds

Source File: D:\TALENTV70\IS2\stockList.aspx Line: 338

Stack Trace:

[InvalidCastException: The data value could not be converted for reasons
other than sign mismatch or data overflow. For example, the data was
corrupted in the data store but the row was still retrievable.]
System.Data.OleDb.DBBindings.get_Value() +1488
System.Data.OleDb.OleDbDataReader.GetValues(Object[] values) +103
System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues,
Boolean acceptChanges) +61
System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
+155
System.Data.Common.DbDataAdapter.FillFromReader(Object data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterColumn, Object parentChapterValue) +260
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +129
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.stockList_aspx.BindGrid() in D:\TALENTV70\IS2\stockList.aspx:338
ASP.stockList_aspx.Page_Load(Object Sender, EventArgs E) in
D:\TALENTV70\IS2\stockList.aspx:38
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

I get no error on the iSeries and when I run the SQL interactively on the
iSeries it works perfectly. My web server is an IBM xSeries running Windows
2003 SP1

Aaron Grady [MSFT] · Guest

David-

I believe we have had a few other customers report similar problems after
upgrading to V5R3 and our support escalation engineers are working with
those customers now to get a resolution to the issue. I would strongly
encourage you to start a support case for this so that you can also help us
get this issue resolved and get a resolution to your problem.

Thanks,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"David O'Brien" <DavidOBrien@discussions.microsoft.com> wrote in message
news:FA1C3D91-FFD3-499B-9C33-F9DAD8D6FA2A@microsoft.com...

Charles Ezzell (MSFT) · Guest

As Aaron mentions, please open a support case for this. We will need some
general information from your AS/400 system that will help in getting this
issue resolved.

Thanks,
Charles

"Aaron Grady [MSFT]" <aagrady@online.microsoft.com> wrote in message
news:eu0NWiQQFHA.2348@tk2msftngp13.phx.gbl...

	Windows Server Forum Index -> Host Integration Server	All times are GMT
Page 1 of 1