SG Connector for SCCM - Last Run datetime

mb27
Tera Expert

‎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?

 

 

0 Helpfuls
  • 759 Views
1 REPLY 1

AJ-TechTrek
Giga Sage
Giga Sage

‎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://www.servicenow.com/community/itom-forum/sccm-last-run-datetime-compare-to-lasthwscan/m-p/103...

 

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

0 Helpfuls