Unable to add new OLEDB Data Source

Products

IT Management Suite

Issue/Introduction

After upgrading to Symantec Management Platform (SMP) 8.6, the customer is not able to create a new or edit existing OLEDB datasource.

The error message is:

Failed to save page details

The ExtendedProperties is only valid when the SourceType is set to MSExcel.

NS Log entry:

Failed to save page details

The ExtendedProperties is only valid when the SourceType is set to MSExcel.
[Altiris.Connector.Exceptions.DataConnectorException @ Altiris.Connector]
at Altiris.Connector.DataSource.OleDbDataSource.set_ExtendedProperties(String value)
at Altiris.Connector.Web.DataSource.OLEDBDataSource.SaveDetails()
at Altiris.Connector.Web.WebConnectorItemPage`1.Save()

Exception logged from:
at Altiris.Connector.Web.WebConnectorItemPage<T>.Save()
at Altiris.Connector.Web.DataSource.OLEDBDataSource.pageConfirmationControl_ClickApply(Object, EventArgs)
at Altiris.WebControls.ButtonState.RaiseClick()
at Altiris.WebControls.ButtonListControl.RaisePostBackEvent(String)
at System.Web.UI.Page.ProcessRequestMain(Boolean, Boolean)
at System.Web.UI.Page.ProcessRequest(Boolean, Boolean)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(System.Web.HttpContext)
at Altiris.NS.UI.Controls.PageCachePage.ProcessRequest(System.Web.HttpContext)
at Altiris.NS.UI.AltirisPage.ProcessRequest(System.Web.HttpContext)
at ComponentArt.Web.UI.CallbackHandler.ProcessRequest(System.Web.HttpContext)
at System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(System.Web.HttpApplication+IExecutionStep)
at System.Web.HttpApplication.ExecuteStep(System.Web.HttpApplication+IExecutionStep, Boolean&)
at System.Web.HttpApplication+PipelineStepManager.ResumeSteps(Exception)
at System.Web.HttpApplication.BeginProcessRequestNotification(System.Web.HttpContext, AsyncCallback)
at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(System.Web.Hosting.IIS7WorkerRequest, System.Web.HttpContext)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr, IntPtr, IntPtr, Int32)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr, IntPtr, IntPtr, Int32)

HTTP [POST]: https://localhost/Altiris/Connector/DataSource/OLEDBDataSource.aspx?Url=https://localhost/Altiris/Console/tree.aspx?ViewGuid=a57fb0e9-0676-4e00-929a-6bb37dc1f888&&ConsoleGuid=1b22db4e-a898-443f-9b99-855b1653d3f5&TreeGuid=a57fb0e9-0676-4e00-929a-6bb37dc1f888&ParentGuid=00000000-0000-0000-0000-000000000000&ItemGuid=d8873814-865e-45d7-b429-b93648674b21&ViewGuid=a57fb0e9-0676-4e00-929a-6bb37dc1f888&ConsoleGuid=1b22db4e-a898-443f-9b99-855b1653d3f5
ip: [::1]; languages: [de-DE]; content-length: [18437];
timings: [[R] 00:00:00.0625002(W: 00:00:00)];
response: [200 OK]; x-smp-nsversion: [8.6.1119.0];

-----------------------------------------------------------------------------------------------------
Date: 06.05.2021 13:14:16, Tick Count: 242289593 (2.19:18:09.5930000), Size: 2,96 KB
Process: w3wp (25512), Thread ID: 1209, Module: Altiris.Connector.Web.dll
Priority: 1, Source: Altiris.Connector.Web.WebConnectorItemPage`1.Save

Environment

ITMS 8.6

Cause

After further investigation, it was found out that the system always set extended property to ms excel:

exported xml:

Resolution

This issue has been fixed in the next ITMS 8.6 release: ITMS 8.6 RU1

A pointfix is available under KB 215121 "CUMULATIVE POST ITMS 8.6 POINT FIXES"