search

AdhocAdam / smletsexchangeconnector

SMLets PowerShell based Exchange Connector for controlling Microsoft System Center Service Manager 2016+
https://adhocadam.github.io/smletsexchangeconnector/
GNU General Public License v3.0
29 stars 19 forks source link

Could not assign date ,SMLets.NewSCSMObjectProjectionCommand #218

Closed kirkcharlesworthcairns closed 3 years ago

kirkcharlesworthcairns commented 3 years ago

Script has been running perfectly for months, getting this error message about not assigning a date. I've fiddled round with date time formats etc but nothing is coming to me.

Are you able to help? Below is the error output with the section of script below

New-SCSMObjectProjection : Simple object value was not the proper type. At smletsExchangeConnector.ps1:2393 char:37

From:

$Projection = @{__CLASS = "$($WIObject.ClassName)";
                __SEED = $WIObject;
                $CommentClassName = @{__CLASS = $CommentClass;
                                    __OBJECT = @{Id = $NewGUID;
                                        DisplayName = $NewGUID;
                                        ActionType = $ActionType;
                                        $propDescriptionComment = $Comment;
                                        Title = "$($ActionEnum.DisplayName)";
                                        EnteredBy  = $EnteredBy;
                                        EnteredDate = (Get-Date).ToUniversalTime();
                                        IsPrivate = $IsPrivate;
                                    }
                }
}

#create the projection based on the work item class
switch ($WIObject.ClassName)
{
    "System.WorkItem.Incident" {New-SCSMObjectProjection -Type "System.WorkItem.IncidentPortalProjection$" -Projection $Projection @scsmMGMTParams}
    "System.WorkItem.ServiceRequest" {New-SCSMObjectProjection -Type "System.WorkItem.ServiceRequestProjection$" -Projection $Projection @scsmMGMTParams}
    "System.WorkItem.Problem" {New-SCSMObjectProjection -Type "System.WorkItem.Problem.ProjectionType$" -Projection $Projection @scsmMGMTParams}
    "System.WorkItem.ChangeRequest" {New-SCSMObjectProjection -Type "Cireson.ChangeRequest.ViewModel$" -Projection $Projection @scsmMGMTParams}
}

}

AdhocAdam commented 3 years ago

SCSM version? SMlets version? Connector version? All Work Items or just Incidents?

kirkcharlesworthcairns commented 3 years ago

Hi Adam,

Sorry that’s my first ever issue submission.

I’m running 2019 10.19.1035.0 Connector version 3.0 with SMLets version 1.0.1.0

I only use incidents at the moment via the Cireson community portal.

Kind Regards,

Kirk

Get Outlook for iOShttps://aka.ms/o0ukef

From: Adam notifications@github.com Sent: Friday, November 13, 2020 3:27:28 PM To: AdhocAdam/smletsexchangeconnector smletsexchangeconnector@noreply.github.com Cc: K.Charlesworth-Cairns k.charlesworth-cairns@rochdalesfc.ac.uk; Author author@noreply.github.com Subject: Re: [AdhocAdam/smletsexchangeconnector] Could not assign date ,SMLets.NewSCSMObjectProjectionCommand (#218)

SCSM version? SMlets version? Connector version? All Work Items or just Incidents?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FAdhocAdam%2Fsmletsexchangeconnector%2Fissues%2F218%23issuecomment-726827362&data=04%7C01%7Ck.charlesworth-cairns%40rochdalesfc.ac.uk%7Cfb26e5fbaf754c96628b08d887e8a2a7%7Cffc2abf7cc504e4c85f082c85fca7bc9%7C0%7C0%7C637408780529320525%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=X3CvwrBTEyF96HtfE941iHkH9C9C%2FDG3vuCOdl%2BusQ4%3D&reserved=0, or unsubscribehttps://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FARXXJFLHIGFFC67O4FMAJLTSPVF6BANCNFSM4TUR2C2A&data=04%7C01%7Ck.charlesworth-cairns%40rochdalesfc.ac.uk%7Cfb26e5fbaf754c96628b08d887e8a2a7%7Cffc2abf7cc504e4c85f082c85fca7bc9%7C0%7C0%7C637408780529330524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=zx7wChOlcbsLHPDl5ESPPlwwxauFD4xFLWziq5FmTXQ%3D&reserved=0.

This e-mail and any attached files are confidential and may also be legally privileged. They are intended solely for the intended addressee. If you are not the addressee please e-mail it back to the sender and then immediately, permanently delete it. Do not read, print, re-transmit, store or act in reliance on it. This e- mail may be monitored by Rochdale Sixth Form College in accordance with current regulations. This footnote also confirms that this e-mail message has been swept for the presence of computer viruses currently known to Rochdale Sixth Form College. However, the recipient is responsible for virus-checking before opening this message and any attachment. Unless otherwise stated, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Rochdale Sixth Form College. As a public body, Rochdale Sixth Form College may be required to disclose this email and/or any response under the Freedom of Information Act 2000 unless the information in the email and/or any response is covered by one of the exemptions in the Act.

AdhocAdam commented 3 years ago

No worries Kirk, just wanted to get some more context before troubleshooting! Couple of other questions:

I've just tested submitting a comment to a known Incident with:

and it was added successfully

kirkcharlesworthcairns commented 3 years ago

Hi Adam,

The script is being run as a scheduled task, I noticed that peoples comments and replies were no longer going in the action log and instead they were being attached as emails.

I’ve checked in the Add/Remove Programs for the installed version, it says its 1.0.1.0 [cid:image001.png@01D6BC18.1167CA60]

I’ve run this command ‘Get-SMLetsVersion’ to output the below.

TargetProduct : Microsoft System Center 2012 - Service Manager WorkingCopyRootPath : C:/Users/Administrator/Documents/WindowsPowerShell/CodePlex/smlets URL : https://smlets.svn.codeplex.com/svn/Main/Source/SMLets/SMLets RepositoryRoot : https://smlets.svn.codeplex.com/svn RepositoryUUID : e17a0e51-4ae3-4d35-97c3-1a29b211df97 Revision : 74609 LastChangedAuthor : unknown LastChangedRev : 70086 LastChangedDate : 2012-02-04 00:41:25 -0800 (Sat, 04 Feb 2012) IsPrivate : True Changes : {M WiX/SMLets.X86.msi, M WiX/SMLets.msi} SMCompiledVersion : 7.5.1561.0 SMInstalledVersion : 10.19.1035.0 SM2012 : True

I can log a new incident with the script no problem, its just replies. I decided to manually run the script in case there was an error message displayed, that’s how I got the original output.

Kind Regards,

Kirk

AdhocAdam commented 3 years ago

Unfortunately Github's email connector isn't that great when it comes to parsing screenshots so I can't see the above. But never the less, the output here is interesting for a couple reasons:

Perhaps we have different versions? Have you previously/ever installed SMLets from the PowerShell gallery via Install-Module SMLets or the MSI via GitHub? If there is a different way you obtained it and could share that could help me attempt to reproduce this.

kirkcharlesworthcairns commented 3 years ago

Hi Adam,

It seems that you have just fixed my issue and probably something I should have checked first!

I’ve downloaded the latest SMLets MSI from Github, uninstalled my previous version and installed this latest version.

Manually run the script and I don’t get any error messages! My comments go straight into the action log as expected.

I don’t know how I managed to download a March 2012 version of SMLets or know how it has been running fine until now.

Kind Regards,

Kirk

AdhocAdam commented 3 years ago

Huzzah! Most excellent to hear sir. Glad we could get this straightened out.

Thanks for using the connector!