Database insert issue

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
BoschmanIT
Posts: 43
Joined: Fri Jul 16, 2021 4:08 am

Database insert issue

Post by BoschmanIT »

Hi Support,

We have a issue with inserting HM log data into our database. So we used to use the following insert query:

INSERT INTO IT_Internal.DBO.HMLOG
(TESTID, TESTNAME, STATUS, REPLY, EVENTTIME, RECURRENCES, TESTMETHOD)
VALUES
('%TestID%', '%TestName%', '%Status%', '%Reply%', '%DateTime%', '%Recurrences%', '%TestMethod%');

This was working just fine until the end of april. Now this insert query tells me he cannot convert to the right datetime output the database needs. We compared, and in april the datetime was inserted like 2025-05-15 12:00:00.000 but now it want to insert it like 15/may/2025 12:00:00 which the database does not seem to be able to convert.
Im not sure if/when something has changed in our environment. Is there a way to let Hostmonitor insert the datetime information like before?
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Re: Database insert issue

Post by KS-Soft »

Yes, I think you changed date format somehow.
May be you changed regional settings for account used by HostMonitor.
May be you changed account used by HostMonitor process (logged on as different user with different regional settings).
May be account used by HostMonitor service was locked/disabled so HostMonitor service now runs under local system account.
May be you are using "Use fixed date&time format" option and changed date format using settings located in the Options dialog, Misc page

Regards
Alex
BoschmanIT
Posts: 43
Joined: Fri Jul 16, 2021 4:08 am

Re: Database insert issue

Post by BoschmanIT »

Hi Alex,

So Hostmonitor follows the date time settings used by the user account that runs the hostmonitor service?
BoschmanIT
Posts: 43
Joined: Fri Jul 16, 2021 4:08 am

Re: Database insert issue

Post by BoschmanIT »

Ahh yeah so I found in hostmonitor the check for fixed date and time was set. I unset it so now its working again. thank you for this.
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Re: Database insert issue

Post by KS-Soft »

You are welcome

Regards
Alex
Post Reply