Back to forum list… Back to Issues and Problems...

Error when applying Pagination (5 replies)

Browndog
4 years ago
Browndog 4 years ago

Hi,

I am trying to get Pagination working for an api I am reading from, I can read successfully but when I configure pagination I am met with the below error

"An error occurred whilst reading the source data. Error - Cannot access a closed Stream.."

I have attached the settings for the webservice behaviour which after checking several times look right to me, is this a bug?

https://www.realisable.co.uk/wp-content/uploads/2020/06/Capture1.jpg
Browndog
4 years ago
Browndog 4 years ago

Attached is response from the api and below is error log

 

2020-06-25 10:00:49:081 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Cannot access a closed Stream.. ---> System.ObjectDisposedException: Cannot access a closed Stream.
at System.IO.__Error.StreamIsClosed()
at System.IO.MemoryStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Realisable.Utils.Net.HttpWebRequestExtensions.GetResponseByte(WebResponse response)
at Realisable.Utils.Net.HttpWebRequestExtensions.GetResponseString(WebResponse response, Encoding encoding)
at Realisable.Utils.Net.StringResponse..ctor(HttpWebResponse response, Encoding encoding)
at Realisable.Data.Transform.Webservice.ErrorCodePaging.PageRequest[T](String& requestUri, String& body, Boolean& endOfRequest, Dictionary`2 headers, PageRequestHandler`1 pageHandler)
at Realisable.Data.Transform.HttpIOControllerAdapter.FetchTextDataPrivate()
at Realisable.Data.Transform.HttpIOControllerAdapter.FetchNextTextData()
at Realisable.Data.Transform.JSONReader.MoveNextSource()
at Realisable.Data.Transform.ReadStrategySteppedController.IterateSingleControllerData(BlockingQueue`1 transactionQueue, TransformRecordDefinition topRecDef)
at Realisable.Data.Transform.ReadStrategySteppedController.IterateDataWithNonDeferrableIOController(BlockingQueue`1 transactionQueue)
at Realisable.Data.Transform.ReadStrategySteppedController.IterateHeirarchicalData(BlockingQueue`1 transactionQueue)
at Realisable.Data.Transform.ReadStrategySteppedController.ReadData(BlockingQueue`1 transactionQueue)
at Realisable.Data.Transform.ReadStrategy.ReadData()
--- End of inner exception stack trace ---
at Realisable.Data.Transform.ReadStrategy.Read()
at Realisable.Data.Transform.TransformRead.Process()
at Realisable.Data.Transform.TransformControllerInterop.Process()

https://www.realisable.co.uk/wp-content/uploads/2020/06/Capture-1.jpg
Support
4 years ago
Support 4 years ago

Can you try turning off tracing?

Browndog
4 years ago
Browndog 4 years ago

Now I am met with this error

 

An error occurred whilst reading the source data. Error - The entry path for the iterator is invalid. Check the documents being parsed match to the expected layout..

Support
4 years ago
Support 4 years ago

Patch provided; will be rolled into v4.2 PU3.

Support
4 years ago
Support 4 years ago

Both the trace and the pagination is now in PU3.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close