Troubleshooting

Question

Where is the Micro Focus VSAM file ACCTFIL?

This file should have been created when you ran the CICS tutorial. (For information on this tutorial, see the section Preparation.

Question

Why did I get file error 35 on OPEN INPUT ACCT-IN?

• Verify that the file was created, as in the previous question.
• To determine the location of the data file, refer to the section Determining the Key Layout.
• Verify that the environment is set up correctly. See the discussion of this in the section Code Sample.

Question

Why did I get file error 39 on OPEN INPUT ACCT-IN?

The actual key definition of ACCTFIL does not directly match up to existing fields in the copy book acctrec.cpy. You need to modify the record description. See the discussion of this in the section Code Sample.

Question

Why did I get file error 9k or 9,107 on OPEN OUTPUT ACCT-OUT?

A Database Connectors-specific error has occurred. You need to rerun your application using an emitter to determine the exact nature of the error. See the section Turning on Tracing for details on how to turn on tracing and configure an emitter for use with Database Connectors.

Once you have a trace file, search for the error 9k to determine the source of the issue. There is a block of information providing details on the error, for example:

MF.RTS 51 1 : "  f_errno: 19"
MF.RTS 51 1 : "  f_int_errno: 3"
MF.RTS 51 1 : "  f_int2_errno: 2"
MF.RTS 51 1 : "  f_errmsg: Unable to open XFD file for 'DBACCTFIL',
                 error = 2"
MF.RTS 51 1 : "  9k or 9,107"

This error indicates the run time system was unable to locate the data dictionary (XFD) for the file. To resolve this, ensure that you compiled with the $SET CREATEXFD directive (see the section Creating XFD Files. If your XFD files are not in the current directory, you need to set the XFD-DIRECTORY variable in your Database Connectors configuration file to the directory in which your XFD files are stored (see the section Setting Up the Configuration File.

MF.RTS 51 1 : "  f_errno: 19"
MF.RTS 51 1 : "  f_int_errno: 18456"
MF.RTS 51 1 : "  f_int2_errno: 0"
MF.RTS 51 1 : "  f_errmsg: Login failed for user 'testuser'."
MF.RTS 51 1 : "  9k or 9,107"

This error indicates that Database Connectors was unable to log into the Microsoft SQL Server database. To resolve this, ensure that you have provided the correct configuration information for access to your MSSQL database (see the section Setting Up the Configuration File. The variables in question are:

• A-MSSQL_DEFAULT-CONNECTION
• A-MSSQL-DATABASE
• A-MSSQL-LOGIN
• A-MSSQL-PASSWD

Question

Why is the file DBACCTFIL is being created as a Micro Focus VSAM file, and not an MSSQL table?

Verify the following:

• You are running on Version 6.0
• You have created an environment variable, A_CONFIG, pointing to your Database Connectors configuration file (see the section Setting the Environment Variable.
• Your configuration file contains the following entry:

  DBACCTFIL-HOST mssql

For a more complete discussion of troubleshooting your application using Micro Focus Database Connectors, refer to the chapter Performance and Troubleshooting of your Database Connectors User’s Guide.

Question

Why do I receive an error 9k when I try to create a table in Microsoft SQL Server?

You might be using the wrong server name in the A-MSSQL-DEFAULT-CONNECTION variable. One way you can verify the server name is by following the steps below. This method is useful if you don't have the client tools for SQL Server installed.

1. Create a new ODBC Datasource for SQL Server.
2. When prompted for the server name, select your local server from the drop-down list of available servers.
3. Connect to this server using ODBC Administrator.

   This provides you with the name of the server you need to use in the A-MSSQL-DEFAULT-CONNECTION variable.