search cancel

Unable to add new OLEDB Data Source

book

Article ID: 215198

calendar_today

Updated On:

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

Cause

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

exported xml:

  <oleDbDataSource dataSourceType="SQLServer">
    <supportedOperations><![CDATA[None, Import]]></supportedOperations>
    <importTableName><![CDATA[vDatabases]]></importTableName>
    <dBServerName><![CDATA[sqlserver]]></dBServerName>
    <dBName><![CDATA[cms_helper]]></dBName>
    <extendedProperties><![CDATA[Excel 12.0;HDR=Yes;IMEX=1]]></extendedProperties>
    <extendedExportProperties><![CDATA[Excel 12.0;HDR=Yes]]></extendedExportProperties>
  </oleDbDataSource>

Environment

ITMS 8.6

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"

Attachments