Receive error "[OpenAccess SDK Service] Required User name is missing" when trying to configure CA Service Desk Manager (CA SDM ) Data Partitions enforcement for CA Business Intelligence (CABI) reports.

book

Article ID: 49284

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

After configuring CA SDM Universe's connection to "Use BusinessObjects credentials" option to in order to enforce data partition constraints on report results, when logging into CABI Designer and trying to view data or verify the Universe connection results in the error error: "A database error occured. The database error text is: [DataDirect][ODBCOpenAccess SDK Driver] [OpenAccess SDK Service] Required User name is missing (WIS 10901)"

Solution:

When you configure the CA SDM - CABI integration to enforce CA SDM data partitions, there are a few mandatory steps that need to be performed:

  1. The Username and Password fields in CABI MUST match the Userid and Password fields in CA SDM respectively

  2. Ensure that the option "Enable and Update User's Data Source Credentials at Logon Time" is enabled for the Alias Type for the CABI username in question. This option is enabled either via AUTHENTICATION->ENTERPRISE or AUTHENTICATION->LDAP within the CABI Central Management Console (CMC).

The most common cause of the "A database error occured. The database error text is : [DataDirect][ODBCOpenAccess SDK Driver] [OpenAccess SDK Service] Required User name is missing (WIS 10901)" error is if step #2 above is not performed.

Refer to TEC565067 CA Support Online for details on how to configure CABI reports to enforce Multi-Tenancy/Data Partition constraints.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: