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

Invalid object name on everyday

Guest
Feb 23, 2017 Feb 23, 2017

Copy link to clipboard

Copied

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.

Views

567

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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....

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

LATEST

Please mark the correct answer. Thank you.

Votes

Translate

Translate

Report

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
Documentation