DataMigrator Status Codes and Server Messages

In this section:

How to:

Error and server messages are displayed in the Message window.

The following types of messages are displayed:

The message typically begins with the following:

(XXXnnnn)

where:

XXX

Is the message origin.

nnnn

Is the message code.

Messages of this type may come directly from the iWay subserver during the retrieval of catalog information or rows from a source table, or from the Server as administrative messages.

Common codes of the above three types are described in the following topics. Also see the appropriate iWay Server documentation for your platform, and the Server codes at the end of this topic.


Top of page

x
Procedure: How to Get More Information About Messages

The iWay Messages and Codes manual and online help document contains a list of all message numbers with a corresponding an explanation. You can also get this information directly from the DMC.

In the DMC:

  1. Right-click on a server name and select Test Server.
  2. In the section Choose Query Type, select the radio button for Focus.
  3. In the input query area, type a question mark (?) followed by the message number. Then select Test.

    The message text and explanation appear in the Console Log area.


Top of page

x
Server Messages

Some common server messages are listed below:

FOC054.	EDA Security error

There is security on the synonym, and the password has not been set correctly. This should be done in the EDASPROF or the user profile for the server.

FOC14010	-column-name- IS NOT A VALID COLUMN NAME

DMC issues a PREPARE for the SQL command, and the column name does not match the synonym. If you have edited the synonym at the source, you may need to create the Synonym with Automatic Passthru turned off.

FOC1006	THE DDNAME REQUESTED IS NOT ALLOCATED OR DLBL'ED : table
FOC226	FILEDEF OR ALLOC MISSING FOR EXTERNAL FILE: table
FOC351	INPUT FILE NOT ALLOWED: file
FOC1400	SQLCODE IS  : 1006/000003EE
FOC1405	SQL PREPARE ERROR

These messages, or some combination of them, can display when an Synonym for a source file exists but the file it describes is not allocated on the server. These errors can occur upon exiting from the Query Builder or upon an attempt to run a Test Query. They can also occur when using Metadata Manager or some other tool to create a synonym.

FOC1538	4GL procedure doesn't exist: proc

One of the procedures required by the Server could not be found. This may indicate that a new version of the server is needed for full compatibility with the client version being used.

FOC35804	BAD STATUS CODE (-9) RECEIVED FROM SERVER subserve

The Server was unable to connect to a subserver listed in the server configuration file (ODIN.CFG).

FOC541  SU. CENTRAL DATABASE MACHINE ERROR: FOCSU01

The FDS service is down and the Scheduler is attempting to write in the ETTLOG.


Top of page

x
Server Log Message for a Missed Scheduled Request

The following is an example of a server message that is written if a request with a recurring schedule misses a run:

01/03/2010 18:04:37 E DM: procedure "baseapp/flow02" missed a scheduled run

To detect the run of the missed request, the Scheduler must be active and a custom routing event must be created. There is no filter needed for this event. Based on the Event Routing configuration, the server log message is written into a server log (edaprint.log) and/or into an e-mail message.


Top of page

x
iWay Connector Communications Errors

If there is a problem connecting to a Server, a message is displayed in the message window. The following are some of the more common errors:

Error (12029) – A connection with the server could not be established. 
Server is not running or wrong port number specified. This error commonly
occurs if the server simply hasn't started up yet. It could also occur if 
the host name or port number was incorrect.
Error (12152) – The server returned an invalid or unrecognized response. 
This error occurs when something other than a DataMigrator http server is 
listening on the specified port number. For example, if a port number 
for TCP or FTP server was specified.
Error (32034) – Authentication failed, password is invalid. This error could 
occur if either the user id or the password specified were incorrect.
Error (32033) -- user ID is invalid Disconnected from server
The user ID and/or password that you entered was invalid for the selected server.
error <NGS> failed to connect to IP address:port, 10061Connection 
refusedError (32007) communication error detected
The selected server was unavailable; it may not be running.
The iWay Connector configuration (ODIN.CFG) may be incorrect.

iWay Software