Watson Marketing Ideas

Submit new product ideas for Campaign, Interact, Marketing Operations, Marketing Platform, Campaign Managed Hosted, interact Managed Hosted, Marketing Operations Managed Hosted, Digital Analytics, Tealeaf, Universal Behavior Exchange, Watson Customer Experience Analytics, Watson Marketing Insights, Watson Content Hub, Web Content Manager and WebSphere Portal solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

Connect with your peers and IBM experts on the Watson Marketing and Commerce Community

Submit ideas for other Watson Customer Engagement Products:

•  Watson Campaign Automation
Watson Commerce
Watson Supply Chain

"Ole Automation Procedures" are obsolete and should be removed from the reporting service

The reporting database free space reports in the Tealeaf Portal require "sys.sp_OACreate" related permissions. However, this is sometimes not possible as the 'sys.sp_OAGetProperty' of component 'Ole Automation Procedures' has been disabled in the security configuration.

This is an old method from the SQL 2000 era when it was hard to get information out of SQL Server. As modern versions have free space information available in the system catalog, can the sp_OA related calls be removed and replaced with something more native to the current SQL server versions? 

Related document links:

"sys.sp_OACreate" related permissions :  https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/cxImpactAdmin/CX/SQLSrvAdmin/AdditionalAdminLoginPermissions_28.html

'sys.sp_OAGetProperty' Disabled: https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/Troubleshooting/CX/TblS-TLDB/SQLServerBlocksAccessToProcedureSysSp_OAGetProperty_43.html

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Nov 7 2018
  • Under Consideration
How will this idea be used?

This enhancement is required to permit database storage monitoring from the Tealeaf Portal, when the SQL server's  Surface Area Configuration management has disabled OLE.

What is your industry? Computer Services
What is the idea priority? Medium
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files