RTD.DB Troubleshooting

RTD.DB Troubleshooting

The RTD.DB window has two main parts: a table monitor and a log text box.

RTD.DB Interface

The table monitor shows the actual status for each updated table. See column meanings in the User Interface topic.

The log shows diagnostic and error messages.

Normally, you should see the following messages in the log:

  1. Connection ... added
  2. Database ... loaded
  3. Object ... has been created
  4. Server ... start status: 1
  5. Table ... added
  6. Table ... loaded

Here are possible issues and solutions:

If you do not see the Connection ... added message
Click File, Open Connection Manager, and test your connections.
If you do not see the Database ... loaded message
Check that your database has two required configuration tables.
If you do not see the Object ... has been created message
Check your formulas in the RealTimeFomulas table.
The formulas must use the same RTD or DDE server name as in regular Microsoft Excel formulas.
For example, TOS.RTD or esrtd.
If you work with Trader Workstation, specify TwsUserName in the application settings.
Also, try to run the instance with another bitness. For example, RTD.DB32.exe if you started RTD.DB.exe before.
If you have no Microsoft Excel installed, try to change the IsDynamicCalls setting in the application settings.
If you do not see the Server ... start status: 1 message
Check that you have started the trading platform. It is required.
If this is not the case, try to run the instance with another bitness. For example, RTD.DB32.exe if you started RTD.DB.exe before.
If you do not see the Table ... added message
Check the configuration in the real_time_tables.
It must contain the valid schema, name, and load code.
If you do not see the Table ... loaded message
Check the configuration in the real_time_tables.
It must contain the valid schema, name, and load code.

Normally, you should see non-empty values in the following columns:

  1. Rows
  2. Topics
  3. Last Notify
  4. Last Save
  5. Status

Here are possible issues and solutions:

If you see empty rows
Check the LOAD_CODE value in the real_time_tables table.
Check that your ticker table contains tickers.
If you see empty topics
Check the formulas in the real_time_formulas table.
For example, you can have the difference in a table schema or name.
Also, specified RTD or DDE formulas can be invalid.
If you see an empty Last Notify
This happens when the RTD or DDE server does not respond.
Check that the server is alive.
If you see an empty Last Save
Check that the real_time_formulas table contains primary key fields.
If you see an error message in the Status column
Read the message. It should explain the reason.

Here are possible issues and solutions for database data:

If you see empty columns or columns with wrong values
This is correct if you do not specify a column formula in the real_time_formulas table or disable the column update.
If the formulas are okay, try to set the English (United States) regional settings in the Windows Control Panel.
If this helps, please contact us to fix detecting settings.