4 Replies Latest reply: Feb 3, 2014 8:48 AM by Kumar Lakshmipathy RSS

    SSRS / Custom Reports - View Model Error

    Kumar Lakshmipathy

      Hi,

       

      We have an issue in the custom report ( SSRS) module, the reports were working fine in 6.0 version , but we are getting error on the same report in 6.1 .

       

      When we tried to bebug the problem , we found that the custom viewmodel used in EQT search is having issue.

      For example the below EQT View model is not working.
      Example :

          <ParameterType type="PkgSpec" webControl="ReportingControls/EQTInput.ascx">

           <Model displayVariableIndex="1">SearchableView:Config:ProdikaSettings/EQTConfiguration/GSMsvSearchableMultiSelectViews,PackagingSpecViewSingleSelect</Model>

          </ParameterType>

       

      Error Information :

      Object reference not set to an instance of an object.

      Description:
      An unhandled exception occurred during the execution of the current web
      request. Please review the stack trace for more information about the error and
      where it originated in the code.

      Exception Details:
      System.NullReferenceException: Object reference not set to an instance of an
      object.


      However a different view model is working fine 6.1 and 6.0:

       

      <ParameterType type="Facility" webControl="ReportingControls/EQTInput.ascx">

           <Model displayVariableIndex="1">SearchableView:Config:ProdikaSettings/EQTConfiguration/PQSSearchableMultiSelectViews,FacilityViewSingleSelect</Model>

          </ParameterType>

       

      Expect the viewmodel change there is no difference between these two custom report configuration , please let us know, how to resolve this issue.

       

      Regards,
      Kumar

        • 1. Re: SSRS / Custom Reports - View Model Error
          Ivy Zhu-Oracle

          In view model:

          <ParameterType type="Facility" webControl="ReportingControls/EQTInput.ascx">

               <Model displayVariableIndex="1">SearchableView:Config:ProdikaSettings/EQTConfiguration/PQSSearchableMultiSelectViews,FacilityViewSingleSelect</Model>

              </ParameterType>

           

          PQSSearchableMultiSelectViews is provided by system. So the definition can be found.


          In view model:

            <ParameterType type="PkgSpec" webControl="ReportingControls/EQTInput.ascx">

               <Model displayVariableIndex="1">SearchableView:Config:ProdikaSettings/EQTConfiguration/GSMsvSearchableMultiSelectViews,PackagingSpecViewSingleSelect</Model>

              </ParameterType>

           

          I don't find the definition of GSMsvSearchableMultiSelectViews in system. It should be the extended view. After updated to 6.1, the definition in config file can be lost if using the system original config. So, you can find the definition place in 6.0, then add the definition to 6.1. Restart IIS, try to get the report.

          • 2. Re: SSRS / Custom Reports - View Model Error
            Kumar Lakshmipathy

            Ivy, thanks for quick response. I checked the view definition in the web.config file in reporting. But the definition is there, i checked them and added them, but not sure what's is that i am missing..

             

             

            section name="GSMsvSearchableMultiSelectViews" type="Xeno.Prodika.Config.PlatformXMLConfigAdapter,CoreAppPlatform" />

             

            GSMsvSearchableMultiSelectViews namespaceID="eqtui" xpath="models/GSMSpecViews" />

             

            • 3. Re: SSRS / Custom Reports - View Model Error
              Ivy Zhu-Oracle

              If the report can work fine after add the definition. So, the definition is added to right place and it is the missing definition.

              • 4. Re: SSRS / Custom Reports - View Model Error
                Kumar Lakshmipathy

                Thanks Ivy for assisting us. We have finally fixed this problem, for others benefit I am explaining it here. Let know if any addtional question,

                 

                a. the custom eqt view file was missing and we compared and added the custom view

                b. Looks like reference for custom eqt view was changed from prodikareporting to webcommon in 6.1 version. So we have updated this reference