1 Reply Latest reply on Jun 1, 2011 12:50 PM by Amith Y

    Ibots delivering twice.

    Swamkrishna
      Hi,

      We are having a strange issue in Ibot delivery. Some of the ibots are getting delivered to user group twice or sometimes thrice. I am the administrator and my email id is in recipiants for those ibots('Me' in recipiants list). But i am receicing them only once. When checking the scheduler logs for these ibots, there are some error messages, I have provided them below.


      +++ ThreadID: a10 : 2011-05-24 12:05:18.805

      iBotID: XXXXXXXXXXXXXXXXXXXXXX

      *[nQSError: 16001] ODBC error state: 40001 code: -2631 message: [NCR][ODBC Teradata Driver][Teradata Database] Transaction ABORTed due to deadlock. .*

      *[nQSError: 16015] SQL statement execution failed. at stage of execute transaction command with data source: XXXXXXXXX*

      +++ ThreadID: a10 : 2011-05-24 12:05:18.805

      iBotID: XXXXXXXXXXXXXXXXXXXXXX

      ...Trying SMTP Delivery loop again


      +++ ThreadID: a10 : 2011-05-24 12:05:18.836

      ... Sleeping for 5 seconds.

      Please let me know what causes this issue.

      Thanks
      krishna
        • 1. Re: Ibots delivering twice.
          Amith Y
          Hi Swami,

          Basically you need to check if your SMTP server process is running. That is a different topic for troubleshooting

          Second you need to check if there are any firewalls or port blocking from your server to the smtp server etc

          Basically an infrastructure issue and nothing to do with OBIEE.

          Hope this helps.

          Thanks,
          -Amith.
          1 person found this helpful