Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Wednesday, February 19, 2025 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New ThreadView:  Search:  
 Author  Thread: Unable to read beyond the end of the stream.
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Dec 07 12:55 PM
On a recently upgraded version of SLX I am getting this error in the web client whenever I try to view Account or Opp detail. Contact detail displays fine.. has anyone seen this? Possible cause? Thansk
[Reply][Quote]
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Dec 07 3:12 PM
No resolution yet, but found this about the error:

http://chivinou.blogspot.com/2007/10/unable-to-read-beyond-end-of-stream.html


There seems to be a problem parsing the Systeminfo Data blob. I did a bit of investigation and it seems the "DelphiStreamReader" is choking trying to parse some old Crystal information (this is a pretty old database, originally Saleslogix 4 I believe). Specifically the "SkipList" method is not properly skipping the list if it is in certain formats.


Not yet familiar with the history of this db.. Any thoughts on likely culprits?
[Reply][Quote]
Carla Tillman
Posts: 290
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Dec 07 9:23 AM
Steve,

What does the error say?

c
[Reply][Quote]
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Dec 07 7:56 AM
As a note, this error also occurs when inserting an account..

The error as it appears in the Event Viewer:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 12/20/2007
Time: 8:51:30 AM
User: N/A
Computer: PSRVWEB2
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/20/2007 8:51:30 AM
Event time (UTC): 12/20/2007 1:51:30 PM
Event ID: adb4a1f2186d48d1bcea0d0c52f64109
Event sequence: 29
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/Root/SlxClient-1-128426322524107118
Trust level: Full
Application Virtual Path: /SlxClient
Application Path: c:\inetpub\wwwroot\SlxClient\
Machine name: PSRVXXXX

Process information:
Process ID: 3204
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: EndOfStreamException
Exception message: Unable to read beyond the end of the stream.

Request information:
Request URL: http://psrvxxxx/SlxClient/ACCOUNT.aspx?entityId=QOZKKA300G40&gid=pWTBZA0001YP&pos=6
Request path: /SlxClient/ACCOUNT.aspx
User host address: 192.168.XXX User: admin
Is authenticated: True
Authentication Type: Forms
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value)
at Sage.Platform.ComponentModel.ComponentViewPropertyDescriptor.SetValue(Object component, Object value)
at Sage.Platform.EntityBinding.PropertyBinding.HydrateComponent()
at Sage.Platform.EntityBinding.PropertyBinding.OnBind()
at Sage.Platform.EntityBinding.EntityBinding.Bind(Object entity, Boolean metadataChanged)
at Sage.Platform.EntityBinding.EntityBinding.Sage.Platform.EntityBinding.IEntityBinding.Bind(Object entity, Boolean metadataChanged)
at Sage.Platform.EntityBinding.EntityBindingSource.Bind(Boolean metadataChanged)
at Sage.Platform.EntityBinding.EntityBindingSource.Bind()
at Sage.Platform.WebPortal.SmartParts.EntityBoundSmartPart.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
[Reply][Quote]
Nicolas Galler
Posts: 93
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Dec 07 7:03 PM
If you replace the Systeminfo.Data blob with one from an eval database (something like:
Update Systeminfo set data = (select data from saleslogix_eval.sysdba.systeminfo where systeinfoid='PRIMARY') where systeminfoid='PRIMARY'
), and it works, then you will have 2 alternatives:
1. Keep the "good" systeminfo, and edit the profile in the Admin to try and match what is on the original db
2. Dump the systeminfo.data to a text file and pull out the hex editor, if you see some references to the old crystal report configuration (the one where you had to configure the remote's DSN on slx 5.2) try cutting it out, there is a bit of trial and error since the format is not documented

On the Newsgroup someone with a similar problem said they went with (1) and it worked, so it is probably the easiest. The main reason I used the hex editor is because I wanted to make sure I had identified the problem correctly.

Oh another thing you can try is disabling the multi currency, if it is enabled. Maybe disable it then reenable it if it is needed.

Hope this helps...
[Reply][Quote]
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Dec 07 6:35 AM
Thanks Nicolas. Some good info on your blog by the way - you are guy that likes to know what makes things tick.

I pulled up the blob in the SQL Query tool in the SLX Administrator. I found a few crystal entries - do these look like likely suspects? They seem to match what you describe- especially the last line:

ReportEngines = [reCRW]
CRWReportPasswords.Strings = (
'Workgroup=|SALESLOGIX_ODBC|SYSDBA|'#8218#227#144#228#129#243#732#253#8222'|SQL Server|'
'Remote=|SALESLOGIX_REMOTE_DSN|SYSDBA|'#8218#227#144#228#129#243#732#253#8222'|SQL Server|')


A little leary about replacing the blob but that may be the only way.. I'll let you know how it turns out..
[Reply][Quote]
Nicolas Galler
Posts: 93
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Dec 07 3:59 PM
Yep those look just like the ones that caused the crash on our db.
[Reply][Quote]
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Re: Unable to read beyond the end of the stream. Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Jan 08 7:21 AM
Finally was able to replace the SYSTEMINFO record from eval. A few tweaks and all is well. Thanks all.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 2/19/2025 7:39:32 PM