This discussion is archived
7 Replies Latest reply: Nov 21, 2012 12:20 AM by SinfoMichele RSS

Problem with ad-hoc Report

SinfoMichele Newbie
Currently Being Moderated
Hi,
we are trying to test the RPT -> ad hoc report functionalities.
When we click on the "search" button, we get all records as expected.
Then we try to generate the very same report and display it in the reports queue area.
The system shows the batch but its status remains yellow.
It never turns green and completed.
What are we missing?

Thank you
  • 1. Re: Problem with ad-hoc Report
    Matt J Journeyer
    Currently Being Moderated
    if it stays yellow, the first thing to check is if remotingcontainer is running. and, if it is running, is the reporting service enabled? you can check this in environmentsettings.config -> search for ReportProcessingService (bottom of file) in the RemotingContainer node -> verify isActive="true"
  • 2. Re: Problem with ad-hoc Report
    SinfoMichele Newbie
    Currently Being Moderated
    Hi Matt,
    the Remote Container is running and the Reporting Service is active.
    Did I miss anything else?

    Thanks and regards
  • 3. Re: Problem with ad-hoc Report
    SinfoMichele Newbie
    Currently Being Moderated
    this log was been generated from ReportGenerator-Prodika:

    ReportGeneratorThread_63288975-70db-4682-984e-b9f522054077: Exception [SinceStart=2 Type=System.Configuration.ConfigurationErrorsException, Message='System.NullReferenceException: Object reference not set to an instance of an object.
       at Xeno.Prodika.MRUService.MostRecentlyUsedItemObjectEnabledResolverFactory.IsUserSupportMRU()
       at Xeno.Prodika.MRUService.MostRecentlyUsedItemObjectEnabledResolverFactory.Create()
       at Xeno.Prodika.EQTService.Config.Handlers.SearchableProperiesInfoConfigHandler.Create(INodeResolver resolver, XmlNode section, Object args)
       at Xeno.Prodika.EQTService.Config.Handlers.SearchableModelInfoConfigBasedLoader.LoadModelInfoFromXML(XmlNode node)
       at Xeno.Prodika.EQTService.Config.Handlers.SearchableModelInfoConfigHandler.Create(INodeResolver resolver, XmlNode section, Object args)
       at Xeno.Prodika.EQTService.Config.Handlers.SearchableViewConfigHandler.Create(INodeResolver resolver, XmlNode section, Object args)
       at Xeno.Prodika.EQTService.Config.Handlers.ViewsConfigHandler.Create(Object parent, Object configContext, XmlNode section)'
       at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
    at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
    at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)
    at System.Configuration.ConfigurationManager.GetSection(String sectionName)
    at System.Configuration.ConfigurationSettings.GetConfig(String sectionName)
    at Xeno.Prodika.Common.ConfigProtocolHandler.CreateObject(String name)
    at Xeno.Prodika.Common.ObjectLoader.createObject(String name)
    at Xeno.Prodika.Protocol.Handlers.SearchableViewHandler.CreateObject(String name)
    at Xeno.Prodika.Common.ObjectLoader.createObject(String name)
    at Xeno.Web.UI.EqtUiLib.ModelViewHelper.CreateView(String modelViewURL)
    at Xeno.Reporting.Service.ReportProcessing.ReportGenerator.GetText(IReportRequestBO request)
    at Xeno.Reporting.Service.ReportProcessing.ReportGenerator.Generate(IReportRequestBO request)
    at Xeno.Reporting.Service.ReportProcessing.ReportGeneratorThread.ThreadMain()


    what I miss?

    Thank you
  • 4. Re: Problem with ad-hoc Report
    Matt J Journeyer
    Currently Being Moderated
    For this error, what value do you have defined for environmentvariables.config\Prodika.RemotingContainer.SysUser? is this a valid user in the PLM4P application? by default, it is 'system'.
  • 5. Re: Problem with ad-hoc Report
    SinfoMichele Newbie
    Currently Being Moderated
    Hi Matt, I have this value:
    Prodika.RemotingContainer.SysUser = prodika
    prodika is a valid user.
    Any idea?

    Thank you
  • 6. Re: Problem with ad-hoc Report
    Matt J Journeyer
    Currently Being Moderated
    can you try setting it to 'system'? restart remotingcontainer, and retest.
  • 7. Re: Problem with ad-hoc Report
    SinfoMichele Newbie
    Currently Being Moderated
    Hi Matt,
    I solved the problem by removing the attribute default = "true" in the node ProdikaReporting / ReportConfig / ServiceConfig / ReportEngine (file EnvironmentSettings.config), without changing the value of Prodika.RemotingContainer.SysUser

    Thanks for your help.

    Michele

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points