Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Invalid object name on everyday

Guest
Feb 23, 2017 Feb 23, 2017

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.

765
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Feb 24, 2017 Feb 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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 24, 2017 Feb 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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 02, 2017 Mar 02, 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....

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 03, 2017 Mar 03, 2017
LATEST

Please mark the correct answer. Thank you.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources