Understanding reasons for errors

The TCL command net-errors sets the error handling behavior when accessing remote files.

See the D3 Reference Manual for more information on net-errors.

If Remote Error Notification and Intervention are enabled, all errors are displayed and an action must then be selected. For example:

*** Remote File System Error ***
Read (@OpenDB.host:odbc:table1) Cannot Connect to Remote
O=Logoff / Q=Quit / R=Retry / C=Continue ?

In some cases, an error number displays. For example:

*** Remote File System Error ***
Open (OpenDB.host:odbc:table1) RERR0019
O=Logoff / Q=Quit / R=Retry / C=Continue ?

In the example above, the error number RERR0019 specifies that the data types of one or more of the columns in the table are not supported.

The error number RERR0019 corresponds to 0x19 in the table below.

Error Number Error Message or Description Reasons for error
  Cannot connect to remote

or

No Remote Host
  • OpenDB is not started or is started on a different port than specified in the OSFI host data source.

  • Network name or TCP/IP address specified in OSFI host data source is invalid. From a computer running D3, attempt to /ping for the machine name or TCP/IP address.

  • The logon account and/or password may be incorrect.

  Invalid Remote Host
  • Driver number specified in OSFI host data source (attribute 1) is not driver 08.

  • Driver 08 is not activated on your system contact Customer Support.

0x01 Item/File not found  
0x02 Item locked  
0x03 Command not supported  
0x04 Field corruption  
0x05 Illegal command  
0x06 Server did not respond OpenDB is not started or if attempting multiple connections, server may be started in /debug mode which allows only one connection.
0x07 Remote file has been moved or deleted
  • Table specified in the Super Q-pointer was not located in the database; try a different schema or account on the database.

  • Table specified is locked because the table or database is opened by another application. For example, if using Microsoft Access, close the database that contains the files to be accessed.

0x08 Invalid driver Entry in dm,hosts, specifies an invalid driver number in attribute 1.
0x16 Not enough memory Unable to allocate the required memory on the computer running OpenDB.
0x17 Invalid ODBC Connect String specified in the Host Data Source
  • Check that the DSN specified in the host data source is the same as that in the ODBC Driver Manager.

  • Check that the database service is started.

  • Incomplete ODBC connection string (for example, password is needed).

  • In the Services dialog box, the logon account and/or password may be incorrect.

0x18 SQL returned an error
  • Ambiguous column name in a join. If more than one table has a column with the same name, it must be:{tablename}columnname

  • Incorrect spelling of column name.

  • Attempt to insert character data into numeric column.

  • Numeric value out of range.

  • Failed a constraint when inserting or updating, such as unique or foreign key.

0x19 Unsupported column type One or more of the columns was defined using an unsupported data type.
0x1A File is still open cannot delete  
0x1B Bad index correlative  
0x1C File deleted  
0x20 Improperly formatted item Length of item exceeds the defined column length.