'[OpenAccess error 5531] Too many parameters specified' error received when attempting to reinstall the CA Service Desk Manager (CA SDM) ODBC server and client services

Article Id: 18496
Status: Published
Updated On: 21-03-2018 07:12
Legacy Id: TEC611802
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:

While attempting to reinstall the CA SDM ODBC server (CA Service Desk Manager ODBC Data Access) service and ODBC client (CA Service Desk Manager ODBC Agent) service via the OA60_SERVER_SETUP and OA60_CLIENT_SETUP commands, the following error is received

C:\Program Files (x86)\CA\Service Desk Manager\add-ons>oa60_server_setup

10.3.2.3-2 Copying agent service template...

ERROR: command failed: "C:\Program Files (x86)\CA\Service Desk Manager\add-ons\oaserver60\admin\oaclasil.exe" -e "C:\Users\XXXXX\AppData\Local\Temp\oaserver.log" -dbg ServiceTemplateCopy OA6_Agent "C:\Program Files (x86)\CA\Service Desk Manager\add-ons\oaserver60\cfg\oadm_ori.ini" "C:\Program Files (x86)\CA\Service Desk Manager\add-ons\oaserver60\cfg\oadm.ini"

[OpenAccess error 5531] Too many parameters specified.

Solution:

As stated in TEC603601, this is a result of Windows 8.3 directory/file notation.

As indicated in the CA SDM Release Notes documentation, it is mandatory to enable 8.3 directory/file notation on Windows prior to the CA SDM installation.

To verify if Windows 8.3 directory/file notation is indeed enabled, the Microsoft FSUTIL command can be used.

For example: 


C:\Program Files (x86)\CA\Service Desk Manager>FSUTIL.EXE 8dot3name query C:
The volume state for Disable8dot3 is 0 (8dot3 name creation is enabled).
The registry state of NtfsDisable8dot3NameCreation is 2, the default (Volume level setting).

Based on the above two settings, 8dot3 name creation is enabled on C:.

If Windows 8.3 directory/file notation is NOT enabled, you must uninstall CA SDM (including deleting the CA SDM installation directory - NX_ROOT), enable 8.3 directory/file notation and then reinstall CA SDM. For the steps to enable 8.3 directory/file notation within the Windows Server OS, please contact your Windows Administrator or refer to the Online Help and support documentation for your Windows Operating System.

If you have confirmed that Windows 8.3 directory/file notation IS enabled, try the following:

  1. Login as to the CA SDM server as an Administrator
  2. Ensure that you do NOT have the Services Control Panel or Windows Explorer opened
  3. Launch a Command Prompt with 'Run as Administrator'
  4. Run the following commands to uninstall the CA SDM ODBC services
    oa60_client_uninstall
    oa60_server_uninstall
  5. Verify via the Services Control Panel that the two (2) CA SDM ODBC services have been removed. If not, restart the server.
  6. From the command prompt, type NXCD - this should take you directly to the NX_ROOT directory.
  7. Navigate to the ADD-ONS directory (i.e. C:\PROGRA~2\CA\SERVIC~1\add-ons>)
  8. Run below commands to reinstall the CA SDM ODBC services
    oa60_server_setup
    oa60_client_setup

Environment:

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