6 Replies Latest reply on Jan 11, 2018 10:08 AM by Ganim Altiok

    Different Physical SQL's Generated on Two Systems

    Ganim Altiok

      Hello All,

       

      We have a test and prod environments (12.2.1.3) which are almost identical systems except connection pool data source names.

      So we have the same report on two systems and almost the same NQSConfig.INI (prod has usage tracking).

      But these systems generate different SQL's.

       

      Things I checked:

      • RPD Database Types
      • Connection Pool Features
      • NQSConfig.INI
      • Moved report from test to prod (Archive-Unarchive)

       

      So is there anything else I should check to how OBIEE generates physical SQL ?