Expiry Table Insert Errors
Posted: Wed Jul 24, 2019 7:54 pm
After getting it working on our local network, I picked a co-managed client so we can work together to get it implemented and see what value they can get out of the notices.
After doing some local powershell testing to make sure I didn't have the same issues, I was able to configure the plugin to get past the issues we had on our network. However, after letting it run the full script, it returns an error I don't quite understand.
So it is successfully running the Powershell portion and creating the expirtyAD.sql file. But now it looks like it is having issues parsing the data and inserting it into the Expiry table.
After doing some local powershell testing to make sure I didn't have the same issues, I was able to configure the plugin to get past the issues we had on our network. However, after letting it run the full script, it returns an error I don't quite understand.
Code: Select all
The Script(6319) failed in the Then section at step 17. The reason: SQL Execute failed processing query
Script: S6319 - Starting at Server Time: Wednesday, July 24, 2019 2:24:56 PM
IF F1 T: 0.3269673
L1 F129 Jump (P1): :WEARESERVER T: 0.3279672
L3 F139 Note (P1): :WEARESERVER T: 0.3279672
L4 F109 Delimiter (P2): Variable (P3): PoShVersion T: 0.3289671
L5 F70 Value (P1): PoShVersion Comparer (P2): 6 To (P3): 2 Jump (P4): :EXECUTE T: 8.3301669
L8 F139 Note (P1): :EXECUTE T: 8.3301669
L9 F172 SqlStatement (P1): Select LDAPRoot FROM plugin_sw_expiry_configure WHERE ClientID = 10 T: 8.3301669
L10 F20 SetType(P1):1 Parameter(P2):OU=CIG Users,DC=cig-int,DC=net VariableName(P3):LDAPRoot T: 8.3311668
L11 F90 File (P1): c:\windows\ltsvc\expiryAD.ps1 T: 8.3321667
L12 F109 Delimiter (P2): Variable (P3): PoShCMD T: 10.3409658
L13 F114 File (P1): C:\windows\ltsvc\expiryAD.sql Check (P2): 1 Jump (P3): :LDAPFAILED T: 20.3419656
L14 F20 SetType(P1):7 Parameter(P2):C:\windows\ltsvc\expiryAD.sql VariableName(P3):SQLDATA T: 26.3443653
L15 F67 Sql (P1): UPDATE plugin_sw_expiry_configure SET LastRun = NOW() WHERE ClientID = 10 T: 32.3457651
L16 F67 Sql (P1): Delete from plugin_sw_expiry_email WHERE ClientID = 10 T: 32.3457651
L17 F67 Sql (P1): 'INSERT INTO plugin_sw_expiry_email (ClientID, UPN, Name, DaysLeft) Values (10, 'Jennifer...' T: 32.3477649