I ran into this problem when I decided to re-number the entry IDs in one of my forms (via the SQL view in the data dictionary). This updated the entry IDs in the Txxx (data) table, but the corresponding entry IDs in the Hxxx (history) table were not updated. To correct the problem, I simply needed to run an addtional SQL against the Hxxx table to make the same update to the entry IDs. If you are in a similar situation, you simply need to make sure the entry IDs match up in the Txxx, Hxxx, and Bxxx (if there are any attachment fields) tables for each given record in your form.

Thomas Bean
CPI Corp.

----- Original Message -----
From: Bertram, Dieter
To: ARSLIST@LISTSERV.VISTAIT.COM
Sent: Tuesday, April 23, 2002 11:34 AM
Subject: AW: ARERR 556


Are you using ARS4.5.1?

-----Ursprungliche Nachricht-----
Von: Oertel, F [mailto:Frank.Oertel@T-SYSTEMS.COM]
Gesendet: Dienstag, 23. April 2002 13:05
An: ARSLIST@LISTSERV.VISTAIT.COM
Betreff: AW: ARERR 556


Hi,

your database is inconsistent!
Each entry in the Txxx table has an corresponding item in the Hxxx table (history table). For some reason you the lost the Hxxx entry.

Frank

-----Ursprungliche Nachricht-----
Von: Al West [mailto:awest93@HOTMAIL.COM]
Gesendet: Dienstag, 23. April 2002 11:03
An: ARSLIST@LISTSERV.VISTAIT.COM
Betreff: ARERR 556


Hi again list.

I am getting the following error when I click on a list in the results list.

ARERR 556 Missing entry in the SQL Database (H131)

There is no data showing in the form itself.

Does any one have any ideas?

Al