4 Replies Latest reply on Mar 3, 2017 4:20 AM by BKBK

    Invalid object name on everyday

    jothirajan

      Dear All.,

       

      My CF website is going down daily at a particular time in evening and the log is detailing that 'Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'XYZ'.'

       

      I can solve this by going to CFADMIN >> Data source >> Edit the Password (or doing any other edits) to the datasource and the site will be back.

       

      I am having 10 datasources and this is happening to a particular datasource and not to all.

       

      Please let me know what is the reason for this down, particularly for a datasource, and tables inside the datasource came as invalid object name.