XCOMN0287E Error setting remote user id message for Trusted transfer

Products

• XCOM Data Transport - Windows

Issue/Introduction

Installed XCOM r11.6 SP03 on a Windows server for the first time. When a trusted transfer is initiated from z/OS to Windows it fails with message XCOMN0287E Error setting remote userid. 

We use the Trusted Transfer (XCOMTRST) database and we have to insert/add the information manually into our MySQL XCOMTRST database. In other words, we cannot use the XCOM GUI Trusted Transfer tab to enter the necessary remote systems and credentials to configure Trusted Transfer because:

a. The userid used to connect to the database has READ only access to the XCOMTRST database

b. For security reasons, remote connections to the MySQL database, which is on a different server, are not allowed.

The necessary record has been inserted to the database, but the transfer fails. What may be causing the problem?

Environment

XCOM™ Data Transport® for Windows

Cause

In this specific situation, the cause of the problem was due to having specified the password in text format for the userid in question in the trusted record. Here is the SQL "insert" command used:

insert into XCOM_TRUSTED_USERS (system_name, user_name, user_password, user_domain, group_name, sysname, sysid) values ('123.456.789.23', 'XCOMUSER', 'Xcompass', 'XCMDMN', 'xcmgrp', 'winsys', 'WIND');

 

Resolution

It is required that the password of the userid added/inserted to the XCOMTRST database be encrypted. Due to the security requirements at the site you can do the following:

1. You will create a text file with the following:

#!ENCRYPT
PASSWORD=your password

2. From a command prompt you will:

a. cd %XCOM_HOME%

b. issue this command: xcomencr input_file output_file

3. The output_file produced by the command will look like this:

# This file was created by processing c:\bev\Midnite1.txt with xcomencr utility.
# CA XCOM Data Transport r11.6 21072 SP03 64bit for Windows Family (CPIC & TCP/IP) 
# Copyright (c) 2012 CA.  All rights reserved. 
#!ENCRYPT
PASSWORD.ENCRYPTED=hex numbers

4. Copy the full hex numbers string into your SQL insert command:

insert into XCOM_TRUSTED_USERS (system_name, user_name, user_password, user_domain, group_name, sysname, sysid) values ('123.456.789.23', 'XCOMUSER', '77 5d 57 54 2e c8 c2 bd d3 d7 ae 0c 3d 40 39 3a 4b 30 2e 26 3f 22 3a 36 5d 31 2a 2b 49 24 1c 37 59 43 2b 37 4e 2f 1e 19 5a 3f 3d 28 4a 34 29 1b 3c 40 39 3a 4b 30 2e 26 3e 22 3a 36 5d 31 2a 2b 49 24 1c 37 59 43 2b 27 4e 2f 1e 19 5a 3f 3d 28 4a 34 29 1b 3c 40 39 3a 4b 30 2e 26 3e 22 3a 36 5d 31 2a 2b 49 24 1c 37 00', 'XCMDMN', 'xcmgrp', 'winsys', 'WIND');

5. Send the transfer from z/OS.

Additional Information

Keep in mind that using the XCOM GUI Trusted Transfer tab to configure the trusted record will insert an encrypted password and the above steps would not be necessary.