Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Super Contributor
Posts: 36
Registered: ‎04-16-2009

SLX 8.1 Reports are no longer running

Webcore 3 and SNC 3b Reports have been installed.

I hope there will be a FAQ one day why these things are happening and how we can solve them.

 

Thanks,

 

 

Hartog

 

Employee
Posts: 629
Registered: ‎04-24-2009

Re: SLX 8.1 Reports are no longer running

Hi Hartog,

 

Can you please provide more information? Do you see an error; if so, what does it say? Please post any error information from the application event log, which is where the error may be logged. If your Job Server is on another machine please examine that application event log there as well. Note that if you have reports with dynamic parameters, you will have to map those first using the SLXReportingAssistant.exe application (important: cascading dynamic parameters are not supported yet).

 

Thanks

 

Mike

Copper Super Contributor
Posts: 36
Registered: ‎04-16-2009

Re: SLX 8.1 Reports are no longer running

 
Hey Mike,
 
This is the error that the web client displays: 
Sorry, an unexpected error occurred during the execution of job 'Saleslogix.Reporting.Jobs.CrystalReportsJob'.
 

2014-10-15 18:44:51,344 [130] ERROR SlxReporting.SlxReport - The assembly CrystalDecisions.CrystalReports.Engine.resources, Version=13.0.2000.0, Culture=en-GB, PublicKeyToken=692fbea5521e1304 could not be resovled.

{

"slxErrorId": "SLXCACC36788DD03E44",

"date": "2014-10-15T18:44:51",

"utc": "2014-10-15T16:44:51",

"stackTrace": " at SlxReporting.SlxReport.OnAppDomainAssemblyResolve(Object sender, ResolveEventArgs args)\r\n at System.AppDomain.OnAssemblyResolveEvent(RuntimeAssembly assembly, String assemblyFullName)\r\n at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)\r\n at System.Reflection.RuntimeAssembly.InternalGetSatelliteAssembly(String name, CultureInfo culture, Version version, Boolean throwOnFileNotFound, StackCrawlMark& stackMark)\r\n at System.Resources.ManifestBasedResourceGroveler.GetSatelliteAssembly(CultureInfo lookForCulture, StackCrawlMark& stackMark)\r\n at System.Resources.ManifestBasedResourceGroveler.GrovelForResourceSet(CultureInfo culture, Dictionary`2 localResourceSets, Boolean tryParents, Boolean createIfNotExists, StackCrawlMark& stackMark)\r\n at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo requestedCulture, Boolean createIfNotExists, Boolean tryParents, StackCrawlMark& stackMark)\r\n at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)\r\n at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream)\r\n at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture)\r\n at CrystalDecisions.CrystalReports.Engine.CREngineRes.getResourceValue(String name, CultureInfo culture)\r\n at CrystalDecisions.CrystalReports.Engine.CREngineRes.GetString(CultureInfo culture, String name)\r\n at CrystalDecisions.CrystalReports.Engine.CREngineRes.GetString(String name)\r\n at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.get_CurrentValues()\r\n at CrystalDecisions.CrystalReports.Engine.InternalParameterValues..ctor(ParameterFieldDefinition fieldDef, Boolean isCurrentValues)\r\n at CrystalDecisions.CrystalReports.Engine.InternalParameterField..ctor(ParameterFieldDefinition field)\r\n at CrystalDecisions.CrystalReports.Engine.InternalParameterFields..ctor(ParameterFieldDefinitions parameterFields)\r\n at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_ParameterFields()\r\n at SlxReporting.SlxReport.RefreshParameterFields()\r\n at SlxReporting.SlxReport._reportDocument_InitReport(Object sender, EventArgs e)\r\n at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)\r\n at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod)\r\n at SlxReporting.SlxReport.LoadReport(String fileName)\r\n at SlxReporting.SlxReport.Load(String fileName)\r\n at Sage.SalesLogix.SystemAdapter.Reports.ReportRequestHandler.RetrieveNativeReportInfo(Plugin entity)\r\n at Sage.SalesLogix.SystemAdapter.Reports.ReportRequestHandler.GetReportTables(Plugin entity)\r\n at Sage.SalesLogix.SystemAdapter.Reports.ReportRequestHandler.CopyEntityToFeedEntry(Plugin entity, ReportEntry entry, InclusionNode include)\r\n at Sage.Platform.SData.RequestHandlerBase`3.UpdateFeedEntryFromEntity(TFeedEntry entry, TEntity entity, InclusionNode include, Boolean includeSchema, Boolean isSingleEntry)\r\n at Sage.Platform.SData.RequestHandlerBase`3.CreateFeedEntryFromEntity(TEntity entity, InclusionNode include, Boolean includeSchema, Boolean isSingleEntry)\r\n at Sage.Platform.SData.RequestHandlerBase`3.InternalGet()\r\n at Invokec22b41f3089c4add806e5624045eb83a.Invoke(Object , IRequest )\r\n at Sage.Integration.Messaging.RequestTargetRegistration.RequestTargetInvoker.Invoke(IRequest request)\r\n at Sage.Integration.Messaging.Request.Process(RequestTargetInvoker invoker)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.Process(IRequest request)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.ProcessWorker(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Adapter.AdapterController.Process(IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Web.SageIntegrationHandler.ProcessRequest(HttpContext context)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n",

"hashCode": "AB8F3801-59AAA19D-E1F2FF54",

"pid": 1972,

"identity": {

"name": "Admin",

"isAuthenticated": true,

"authenticationType": "Forms"

},

"version": "8.1.0.1152",

"logger": {

"level": "ERROR",

"location": "SlxReporting.SlxReport.OnAppDomainAssemblyResolve(:0)",

"name": "SlxReporting.SlxReport",

"message": "The assembly CrystalDecisions.CrystalReports.Engine.resources, Version=13.0.2000.0, Culture=en-GB, PublicKeyToken=692fbea5521e1304 could not be resovled."

},

"request": {

"looksLikeAjax": true,

"isLocal": false,

"method": "GET",

"url": "https://slx.intelsol.de/slxclient/slxdata.ashx/slx/system/-/reports('p6UJ9A0005TA')?_includeContent=...

"referrer": "https://slx.intelsol.de/slxclient/ReportManager.aspx",

"ipAddress": "10.18.1.1",

"userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko",

"userLanguages": "en-GB; de-DE;q=0.7; nl-NL;q=0.3"

},

"browser": {

"type": "InternetExplorer11",

"name": "InternetExplorer",

"version": "11.0",

"majorVersion": 11,

"minorVersion": 0.0,

"platform": "WinNT"

},

"server": {

"machineName": "FRA-INT-SLXW01",

"timeZone": "W. Europe Standard Time",

"commandLine": "C:\\Windows\\SysWOW64\\inetsrv\\w3wp.exe -ap \"Saleslogix\" -v \"v4.0\" -l \"webengine4.dll\" -a \\\\.\\pipe\\iisipm3ff5cc92-6050-4fd8-9752-afdf0b26c29e -h \"C:\\inetpub\\temp\\apppools\\Saleslogix\\Saleslogix.config\" -w \"\" -m 0",

"versionString": "Microsoft Windows NT 6.3.9600.0",

"is64BitOperatingSystem": true,

"host": {

"siteName": "Saleslogix",

"applicationId": "/LM/W3SVC/2/ROOT/SlxClient",

"applicationPhysicalPath": "c:\\inetpub\\wwwroot\\SlxClient\\",

"applicationVirtualPath": "/SlxClient",

"isDebuggingEnabled": false,

"isHosted": true,

"maxConcurrentRequestsPerCPU": 5000,

"maxConcurrentThreadsPerCPU": 0

},

"logonUser": {

"name": "SITGLOBAL\\WebDLL",

"authenticationType": "Forms",

"impersonationLevel": "Impersonation",

"isAnonymous": false,

"isGuest": false,

"isSystem": false

}

}

}

 

and another one...

 

2014-10-15 18:45:37,313 [QuartzScheduler_Worker-3] ERROR Quartz.Core.JobRunShell - Job SlxJobService.Saleslogix.Reporting.Jobs.CrystalReportsJob threw an unhandled Exception:

 

Sage.Common.Syndication.Json.JsonSerializationException: Error converting value {null} to type 'System.Boolean'. Path '[0]', line 126, position 2. ---> System.InvalidCastException: Null object cannot be converted to a value type.

 

at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)

 

at Sage.Common.Syndication.ConvertEx.ChangeType(Object value, Type conversionType, IFormatProvider provider)

 

at Sage.Common.Syndication.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType)

 

--- End of inner exception stack trace ---

 

Server stack trace:

 

at Sage.Scheduling.Core.RemotingHelpers.SubstituteCustomExceptions(Action action)

 

at Sage.Scheduling.Core.RemoteJob.Execute(IJobExecutionContext context)

 

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)

 

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

 

Exception rethrown at [0]:

 

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

 

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

 

at Quartz.IJob.Execute(IJobExecutionContext context)

 

at Sage.Scheduling.Server.LocalJob.<>c__DisplayClass3.<Execute>b__1()

 

at Sage.Scheduling.Core.RemotingHelpers.RestoreExceptionStackTraces(Action action)

 

at Sage.Scheduling.Server.LocalJob.Execute(IJobExecutionContext context)

 

at Quartz.Core.JobRunShell.Run()

 

Thanks again...

 

Regards,

 

Hartog

 

 

 

 

 

 

 

 
Employee
Posts: 629
Registered: ‎04-24-2009

Re: SLX 8.1 Reports are no longer running

Hi,

 

The first event log entry (from SlxClient) can be ignored and is bogus; however, this is no longer logged in Core 03, which means you have an environmental issue (since you stated you had Core 03 installed). I believe the second issue was addressed in Core 01 in:

 

Sage.Common.Syndication.dll
File version: 1.0.5.250

 

However, the first log indicates that you have Core 01 installed, since the version information in the log is taken from Sage.SalesLogix.Web.dll: 8.1.0.1152 (Core 01).

 

Note that there was a 8.1.0.Web Core.03b build (you indicated 8.1.0.Web Core.03). The first thing I would check is that the bundles are applied correctly and both SlxClient and the Job Server portals have been redeployed. The file version for most 8.1.0.Web Core.03b files should be:  8.1.0.1228 and 8.1.0.1224 for  8.1.0.Web Core.03. Since you have installed SNC 03b I'm assuming you will need  8.1.0.Web Core.03b as well (if it's not already applied.

 

It's very possible your issue is environmental.

 

Thanks

 

Mike