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:
Is the message origin.
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.
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:
The message text and explanation appear in the Console Log area.
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.
Server log messages for agent termination are listed below:
(ICM18175) Agent terminated by operator.
The agent was killed by an administrator or operator.
(ICM18174) Agent has been forced to terminate.
The agent was hard killed or crashed.
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) or an email message.
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 has not 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 or password that you entered was invalid for the selected server.
error <NGS> failed to connect to IP address:port, 10061Connection refused
Error (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 |