Skip to content
Thoroughbred Software InternationalThoroughbred Software InternationalThoroughbred DocumentationDocs

Troubleshooting

The following provides troubleshooting information specific to the Oracle Server.

Section titled “Link Error”

Error 0 occurs opening the Link and no locks seem to be active in Basic or from an Oracle application.

Since the Link header is read internally by Basic when opening the Link, this record needs to be accessible at open time. If it is extracted through Dictionary-IV, for example, the error 0 occurs. Setting the PRM READONLY parameter in the IPLINPUT file will clear this situation.

Server Table Error

Section titled “Server Table Error”

Error 12 opening server tables.

Verify that the DEV line for the server where the table resides is present in the appropriate IPLINPUT file.

tsoracle## will not start

Section titled “tsoracle## will not start”

Verify that the /usr/lib/basic directory is present and accessible on the system where tsoracle## is executed.

Unexpected Sorting Sequence or Errors Accessing Some Oracle Tables

Section titled “Unexpected Sorting Sequence or Errors Accessing Some Oracle Tables”
  • If a Link header has been configured to access a server table defined on the server as a view, unexpected results ranging from incorrectly sorted data to tsoracle## process failures may result. It is suggested that access to the server be limited to objects defined as tables. Oracle does not support certain operations on views such as SELECT …FOR UPDATE. This may also occur if a table has no index and the fields in the sort are defined as NULL. This can be resolved by adding an index and/or changing the field constraint to NOT NULL.
  • Be sure that the primary key index is present

Hanging on a WRITE

Section titled “Hanging on a WRITE”

Under certain circumstances a WRITE may hang if the row is locked in Oracle using a share (S) or share row exclusive (SRX) type lock. This occurs because the INSERT/UPDATE part of the SQL code for a WRITE statement does not support NOWAIT and will wait until the lock is removed by the Oracle process. The share and share row exclusive type locks are not generated by any Basic code, and therefore this situation cannot occur between Basic tasks.

Some Access Using Sorts is Very Slow

Section titled “Some Access Using Sorts is Very Slow”

Sorts that contain references to substrings of fields may not perform as well as sorts on full fields. This is because Oracle has no facility to define indexes on portions of fields. For more information see the Performance Tuning section of this manual.

From the TS DataServer for Oracle Reference, version 8.9.1. Open this page in the PDF