1 2 Previous Next 22 Replies Latest reply on Mar 3, 2017 12:01 AM by EC57812 Go to original post
      • 15. Error running session
        New Member

        Did you try increasing the precision and scale of the timestamps in PowerCenter? (eg from 19.6 to 36.9)

        • 16. Error running session
          Guru

          Hi Manikandan,

           

          Can you please update statistics of all the source tables that are in the mapping and try to rerun the session again? Just to ensure all is well in DB before data being populated using Infa.

           

          Thanks,

          Sridhar.

          • 17. Error running session
            Guru

            Also, can you please check if the following KB is of any help. Like I said in my previous post, we'll debug from DB before we further analyse in Informatica.

             

            https://communities.informatica.com/infakb/solution/13/Pages/107081.aspx

             

            Thanks,

            Sridhar.

            • 18. Re: Error running session
              Guru

              You can also try the following solution; I buy your argument that it has run fine for several weeks but we never know.

               

              Problem Description

              The following error occurs running a PowerCenter session with an Oracle source:

              FATAL ERROR : An unexpected condition occurred in file [/export/home/build_root/86HotFix1_build/powrmart/common/odl/oracle8/oradbcol.cpp] line [1563].  Aborting the DTM process.  Contact Informatica Global Customer Support.
              Cause
              This  issue occurs due to a timestamp column in one of the Oracle tables. The  timestamp column has subsecond value and the length of the data is not  equal to 11.
              Solution

              To  resolve this issue, make sure that the definition of the timestamp  column in the Oracle table in the mapping matches the length of the  actual data.
              More Information

              Alternatively you can configure the session to convert the Oracle Timestamp datatype to the Oracle Date datatype as follows:

              1. Edit the session
              2. Click the Config Object tab
              3. Select the Pre 85 Timestamp Compatibility option.
              4. Save the changes.
              5. Run the session.

               

              Thanks

              Sri.

              • 19. Re: Error running session
                Active Member

                Friends,

                 

                Great to see so many responses. I am stuck with some production deployment due to which i could not respond to any of your replies.

                 

                I will check all the solutions you have provided and update you all tomorrow if things worked.

                 

                Once again thanks a lot for your timely help

                • 20. Error running session
                  Active Member

                  Sridhar,

                   

                  You nailed the problem. The above solution you gave - checking the Pre 85 Timestamp Compatibilty option solved the issue.

                   

                  Thanks for taking time to help resolve this issue.

                   

                  Keep up your great work.

                   

                  Thanks again.

                  • 21. Error running session
                    Guru

                    Great to hear that the issue got resolved;

                     

                    Thanks,

                    Sri.

                    • 22. Re: Error running session
                      Seasoned Veteran

                      Hi,

                       

                      Below steps worked for me.

                       

                      Thanks

                       

                      1. Edit the session
                      2. Click the Config Object tab
                      3. Select the Pre 85 Timestamp Compatibility option.
                      4. Save the changes.
                      5. Run the session.

                       

                      Regards,

                      Rajendra

                      1 2 Previous Next