Home	RDP Sales	Contact Us	Training
RDP Support		Open a Web Support Ticket
RDPWin Knowledge Base	RDP-DOS Knowledge Base	IRM and IRM.Net Knowledge Base	Crystal Knowledge Base

Column not in Table

Added 1/20/2006 - Article ID#: KWin0014

Overview

The database structure of RDPWin and RDP-DOS consists of various files, like HReserve.dat and tables (RDP090), like Table C2, where the room types are stored. RDPWin stores the fields or columns of each file and table in the XMLFiles folder under the RDP root folder for quicker access.

After an update, there may be various changes to files and tables in the system. Normally, an RDPWin update deletes the entire XMLFiles folder so the system can start rebuilding these files. If the update does not complete correctly because a user was in the system during the Server Update, then the XML files may not get deleted and may get out of synch.

If this happens then the system may issue an error like:

"Column <Column Name> is not in table <Table or File Name>"

Solution

Check the DDF files to make sure they are the correct date and time as of the last update.
Check the RDPWin log file to make sure RDPWin.upd was run in the last update.
Make sure the customer updated RDP-DOS at the same time as RDPWin
Delete the XMLFiles folder. This can be done at anytime even with users in the system.

Home	RDPWin	RDP-DOS	IRM/IRM.Net	Open A Web Support Ticket
	Version 2.xxx	Upgrade to RDPWin	Link to Marketing Site	Contact Us
	Training	Vendor Interfaces	Troubleshooting	RDP Sales Website