Native SQL Error: 512

[robprose]

Hello. I am a network administrator running GM 5.5 on Windows Server 2003. My users access it using Terminal Services to this server. The database is hosted on a dedicated MSSQL server hosted on another server.

Recently I had a user contact me saying that he couldn't update a few contacts. I logged in to my session and tried it myself and received the following error:

General SQL error.
Native SQL error: 512

Context: modifyRecord
MSSQL: GoldMine_Sales: dbo.CONTACT1

1: Server message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or wh

BDE Error Cat:Code: [51:3]
BDE: 500 [21/6/1999] GoldMine: 6.50.40321

User: RROSENHA
Window: Joe Shimek

Template:
Details:
NATIVEMSG: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery

Any thoughts would be appreciated.

Thank you.

 

[goner]

Sounds like you might have some duplicate contact1 records. This would be very bad. I would suggest havign a professional (like me, maybe?) take a look at your database and fix this situation ASAP.

Doug Castell
Castell Computers
(310)601-4738

http://www.castellcomputers.com