SG Connector for SCCM - Last Run datetime
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024 01:05 AM
We've just upgraded a non production instance to version 3.4.2 of the SG Connector for SCCM
Imports are failing with a SQL error:
MID Server reported error: SQLState: S0001
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '08'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
It looks like the Last run datetime field on the Data Source record is causing the issue. If I blank this field, the import works OK and sets Last run datetime to "2024-05-29 08:46:02.0". Subsequent runs do not work unless I blank the field again.
I've tried setting the field to different formats, eg YYYY-MM-dd and back to a sate with dd<12 (05-05-2024 08:46:02.0)
Nothing works except blanking out the field.
Has anyone seen this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024 05:47 AM
Hi @mb27 ,
You should not updated the Last Run Datetime manually , just keep the blank 1st time and after imports runs , it will be set it up automatically, please try this.
Also i found the below article, which helps you.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0855348
Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.
Thanks
Ajay Kumar
Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/
ServiceNow Community Rising Star 2024