I get this error sometimes.. only in my production  not in my test
server

An error occured while processing the request. Request Url:
https://www.jwod.com/payment.aspx? ...r />
F15107FA9
 C648BEBCF8D93B7B92ADDD01D325269EE7111EED
07E001930A89F13151BA
Stack Trace: System.Web.HttpUnhandledException: Exception of type
System.Web.HttpUnhandledException was thrown. --->
System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionRead
(WrapperRead()).]General network error. Check your network
documentation.
at Microsoft.CommerceServer.Site.Payment.btnPurchase_Click(Object
sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String
eventArgument)
at System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain()
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously)

[ Post a follow-up to this message ]

The error below "General network error" seems different than the error you
originally reported "Failed to retrieve item #0 from the line item
collection". It no longer sounds like your syntax for looping through the
items is the issue. Is your database server separate from your web server?
Is the configuration the same for test and production? If this really is an
intermittent error in production, it sounds like maybe more of a network
issue than a code issue.

--
Zoe Hart
Commerce Server MVP

"nirsivak" <nir3in@yahoo-dot-com.no-spam.invalid> wrote in message
news:ytidndm-Aaw_cbPeRVn_vA@giganews.com...
>I get this error sometimes.. only in my production  not in my test
> server
>
> An error occured while processing the request. Request Url:
> https://www.jwod.com/payment.aspx? ...6D067C5FF15107F
 A9C648BEBCF8D93B7B92ADDD01D325269EE7111E
ED07E001930A89F13151BA
> Stack Trace: System.Web.HttpUnhandledException: Exception of type
> System.Web.HttpUnhandledException was thrown. --->
> System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionRead
> (WrapperRead()).]General network error. Check your network
> documentation.
>   at Microsoft.CommerceServer.Site.Payment.btnPurchase_Click(Object
> sender, EventArgs e)
>   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
>   at
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Raise
PostBackEvent(String
> eventArgument)
>   at System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

> sourceControl, String eventArgument)
>   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
>   at System.Web.UI.Page.ProcessRequestMain()
>   --- End of inner exception stack trace ---
>   at System.Web.UI.Page.HandleError(Exception e)
>   at System.Web.UI.Page.ProcessRequestMain()
>   at System.Web.UI.Page.ProcessRequest()
>   at System.Web.UI.Page.ProcessRequest(HttpContext context)
>   at System.Web.CallHandlerExecutionStep.Execute()
>   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
> Boolean& completedSynchronously)
>

[ Post a follow-up to this message ]

My SQL Server and Web server are in the same box... out 100 orders one
orders fails with this error or
Microsoft.CommerceServer.Runtime.Orders.CommerceOrderSystemException:
Failed to retrieve item #0 from the line item collection. --->
Microsoft.CommerceServer.Runtime.CommerceException: GetItemInfo
Failed. ---> System.Runtime.InteropServices.COMException
(0x8002000B): Invalid index.
at Microsoft.CommerceServer.Runtime.ISimpleList.get_Item(Int32 Index)

at

thanks

[ Post a follow-up to this message ]