11/25/2024 5:38:40 AM
|
| |
| 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!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Web reporting 7.5.1 frozen 
Posted: 02 Jun 09 7:05 AM
|
Hi,
When I open a report, the report popup freezes.
I have one server with the Web CRM, another server with the Web reporting.
I have 1 warning and 2 errors in the event logs located in the Web CRM server.
Any idea?
Log 1 warning :
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 29/05/2009 17:40:25
Event time (UTC): 29/05/2009 15:40:25
Event ID: f3fe8c5700364bd1a09495870dd30669
Event sequence: 150272
Event occurrence: 36
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/Root/SlxClient-1-128865908827853508
Trust level: Full
Application Virtual Path: /SlxClient
Application Path: c:\inetpub\wwwroot\SlxClient\
Machine name: TRCRMWEB
Process information:
Process ID: 3048
Process name: w3wp.exe
Account name: TRCRMWEB\WebDLL
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://trcrmweb:3333/slxclient/SLXGroupBuilder.aspx?method=GetColumnsForTable&tbl=COMMANDE&tblpath=COMMANDE&time=1243611625462
Request path: /slxclient/SLXGroupBuilder.aspx
User host address: 195.16.9.37
User: megabyte
Is authenticated: True
Authentication Type: Forms
Thread account name: TRCRMWEB\WebDLL
Thread information:
Thread ID: 1
Thread account name: TRCRMWEB\WebDLL
Is impersonating: False
Stack trace: at Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetColumnsForTable(String TableName)
at Sage.SalesLogix.Client.GroupBuilder.GroupBuilderHttpHandler.GetColumnsForTable(String TableName)
at Sage.SalesLogix.Client.GroupBuilder.GroupBuilderHttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
Log 2 errors:
2009-05-29 17:40:25,685 ERROR Global - Unhandled exception.
System.NullReferenceException: Object reference not set to an instance of an object.
at Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetColumnsForTable(String TableName)
at Sage.SalesLogix.Client.GroupBuilder.GroupBuilderHttpHandler.GetColumnsForTable(String TableName)
at Sage.SalesLogix.Client.GroupBuilder.GroupBuilderHttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
Log 3 errors:
2009-05-29 17:37:16,375 ERROR SlxClient.OpportunityPage - Unhandled exception occurred during async postback.
System.ArgumentException: Could not find the dynamic method 17154409-c39d-4437-8a43-6d69af246cb9.cmdOK_OnClick. Check your method configuration to ensure that this method exists.
at Sage.Platform.DynamicMethod.DynamicMethodLibrary.GetInvoker(String methodName)
at Sage.Platform.DynamicMethod.DynamicMethodLibrary.Execute(String methodName, Object[] args)
at ASP.OpportunityClosedWon.cmdOK_ClickAction(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(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(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
|
|
|
|
Re: Web reporting 7.5.1 frozen
Posted: 02 Jun 09 11:20 PM
|
Do you see any entries in the event log on the reporting server? The entries you've listed don't seem to me to have any bearing on web reporting.
Have you deployed the web reporting portal as documented in the 7.5 SP1 documentation? Things changed significantly with this service pack.
For what it's worth, I am struggling with web reporting on 7.5.1 also. My issue is that after a period of time the report portal will suddenly stop responding. No errors in the event log, no other visible symptoms or side-effects. Just an apparently hung web reporting website. In our case, the web client will freeze up when navigating the report menu or simply not respond to clicks on the "View Report" button. A simple IISRESET fixes it, but, needless to say, this sucks. SalesLogix tech support tells me no one else has reported any issues like mine with web reporting for 7.5.1 - it either works (and stays working) or doesn't work at all.
Anyone out there have a successful web reporting deployment for 7.5.1? If so - care to share the secret?
-Doug |
|
|
|
Re: Web reporting 7.5.1 frozen
Posted: 10 Aug 09 1:18 PM
|
Charles - has reporting EVER worked in your environment? It looks like you might be dealing with a configuration issue. Doug is correct, it did change quite a bit in 7.5.1 and includes a step in App. Architect that it didn't before. Let us know if you are dealing with an issue after successful implementation or if this has never worked.
Doug - many of our clients are working fine on 7.5.1 web reporting. We do just fine internally. From a support standpoint - I can't speak for them. But in our professional services organization it works just fine. If an IISRESET works for you every time, can you monitor whether or not a series of report runs seems to be causing it? In other words, if you run invoice reports every month end and it dies near the end of the month every time, perhaps it is high demand or a report that is not set up correctly? Maybe a user running the reports against groups that are not created in a correct manner? Just some thoughts to hopefully narrow it down.
-Jason |
|
|
|
Re: Web reporting 7.5.1 frozen
Posted: 25 Sep 09 2:22 PM
|
| For what it's worth we have pretty much the exact same issue and there is no patter to which report or process is causing it. We have since moved our reporting server off of the other 2003 R2 box and onto a VMWare image running nothing but 2003 R2 server onto the same server as our main SLX web system (64 bit 2008 box), but since the clean install on a fresh server and image we have only had the issue happen once in 3 weeks (we are assuming something on the other server was causing this, since it was not a fresh install of the OS). Before we would get it several times a day since the upgrade and had the same errors in the event log. It will probably crash now that I've said this... |
|
|
|
Re: Web reporting 7.5.1 frozen
Posted: 03 Nov 09 3:43 AM
|
Hello Doug,
I also have exactly the problem that you describe on 7.5.1
Did you ever find a fix for it?
thanks
Martin.. |
|
|
|
Re: Web reporting 7.5.1 frozen
Posted: 03 Nov 09 7:28 AM
|
SalesLogix provided a couple of updated DLLs that fixed the problem. I'm not sure if there is a hot fix for it, but I expect 7.5.2 will include the fixes. Contact your Business Partner or SalesLogix tech support for an update.
|
|
|
|
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!
|
|
|
|
|
|
|
|