7 Replies Latest reply: Nov 21, 2012 2:20 AM by SinfoMichele RSS

    Problem with ad-hoc Report

    SinfoMichele
      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
          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
            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
              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
                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
                  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
                    can you try setting it to 'system'? restart remotingcontainer, and retest.
                    • 7. Re: Problem with ad-hoc Report
                      SinfoMichele
                      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