Client not Syncing

[revsmitty]

I just loaded this up and added 3 clients. 2 out of 3 are populating, but it is failing on 1 of our clients.

[revsmitty]

I added a 4th client today and ran a manual scan and the one client not syncing is still not updating. The following are the logs from the manual scan:

Starting data collection from Office365
Validating script folder is available

Uploading Office365 script
Executing MSOL User Scans on [4] Clients

Processing [client1] -> Updating LabTech
Processing [client2] -> Updating LabTech
Processing [client3] -> Updating LabTech
Processing [client4] -> Updating LabTech

Uploading Exchange script
Executing Exchange Scans on [4] Clients

Processing [client1] -> Client Failed Update
Processing [client2] -> Updating LabTech
Processing [client3] -> Updating LabTech
Processing [client4] -> Updating LabTech

Uploading Exchange groups script
Executing Exchange Groups Scans on [4] Clients

Processing [client1] -> Updating LabTech
Processing [client2] -> Updating LabTech
Processing [client3] -> Updating LabTech
Processing [client4] -> Updating LabTech

Uploading Sharepoint script
Executing Sharepoint Scans on [4] Clients

Processing [client1] -> Client has a Sharepoint URL that is incorrect.
Processing [client2] -> Client has a Sharepoint URL that is incorrect.
Processing [client3] -> Client has a Sharepoint URL that is incorrect.
Processing [client4] -> Client Missing Domain Host Value in the URL section of Client Password Tab for Offices365 account.

[Cubert]

Ok well lets turn on DeBug and see whats going on.

Under your Scanner Config windows, While holding down the left Shift and Ctrl keys (one or the other) you can toggle on and off debuging. This will then print out raw outputs during scanning for more information from powershell on the scanner.

See what that spits out.

[revsmitty]

Running it now. How should I get you the results. Pretty sure my owner doesn't want all the company and user information out in the public.

[revsmitty]

I sent an email last night with the information. Let me know if anything else is needed. looking like a great plugin so far.

[revsmitty]

Just an update. I added another client and that pulled fine. Is there a limit on how much info is pulled? The one client that isn't syncing would be our largest Office365 partner.

-Thanks

[Cubert]

Have you tried the debug mode?

What is printed out during a scan. Select and unselect the different scans to pin point the issue and post data here. Could be as simple as a bad record in the SQL queries returned.

Let's grab those queries and and have a peak to see if a odd entry is killing the insert.

[Cubert]

Also if your on 10.5 or 11, and on the latest LT patch, you should now be getting logs for each plugin in the LabTech\Logs folder of your LT server. Open this up and lets see whats inside. Make sure to have debug turned on.

[revsmitty]

I'm using Labtech 10.5 patch 5. I've sent the debug logs via the email option on here a few days ago.

[revsmitty]

I'm seeing this in Plugin_Office365ForLabTech_Errors.txt:

LTAgent v105.273 - 7/2/2016 1:12:23 PM - Plugin Error Office365ForLabTech, Version=2.0.0.43, Culture=neutral, PublicKeyToken=null: SetSQLYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Malley', 'Sean O'Malley', 'US', '', '', '', '10037FFE930624C7', '', '', 'True', ' at line 973:::