Skip to main content
A
Anonymous
February 24, 2017
Question

Invalid object name on everyday

  • February 24, 2017
  • 2 replies
  • 860 views

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.

This topic has been closed for replies.

2 replies

v.jothirajan
v.jothirajan
Participant
March 3, 2017

Dear All.,

The original reason is there is a job in our site which is reassigning the datasource and thus caused this. Now the problem is solved....

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
March 3, 2017

Please mark the correct answer. Thank you.

H
haxtbh
Inspiring
February 24, 2017

I would say this is an issue with the SQL server rather then CF. Have you tried using a different user for the datasource to see if the issue still happens?

If its the same time everyday, I would look at maintenance tasks on the SQL server to see if they are doing something that causes this kind of behaviour.

    A
    Anonymous
    February 24, 2017

    Need to check the jobs.

    Also the default user name for the database was set... The other one which is running well is not having the default user name

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices