1 Reply Latest reply on Apr 24, 2019 4:24 AM by Nico Heinze

    RR_4049 SQL Query issued to database

    Turab Aliyev New Member

      Hi All,

       

      Thread [TRANSF_2_2_1] created for [the transformation stage] of partition point [SQ_PATIENTS_FIRST_LAST_DOB_EDW] has completed.

      Total Run Time = [32.524875] secs

      Total Idle Time = [0.000000] secs

      Busy Percentage = [100.000000]

      Transformation-specific statistics for this thread were not accurate enough to report.

       

       

      Thank you

        • 1. Re: RR_4049 SQL Query issued to database
          Nico Heinze Guru

          And what is your actual question?

          What this message means?

          If yes, here's the short explanation:

           

          First PowerCenter issues a SELECT query for each source qualifier to the respective source database (no matter whether this is a "manually written" SELECT statement or a SELECT statement generated by PowerCenter itself). This point in time is logged in the session log with this RR_4049 message.

           

          Now when the source DB either delivers the first record or the information "no data avaiable", you will get another message in the session log. The time difference between the RR_4049 and this second message is (roughly) the time that the source DB needs to prepare and execute the SELECT statement.

           

          Finally, when the source DB deivers the last record to PowerCenter and indicates that this has been the last source record, PowerCenter will issue another message (something like "last record delivered by database at ...:...:...") in the session log.

           

          Otherwise please explain in a bit more detail what exactly you want to know.

           

          Regards,

          Nico