"Primary Key Missing" Errors With ESS Under Windows

[lannon]

Greetings Forum,

I have been encountering an issue with ESS and FMS 9. The server 9 machine is running Windows XP and has a DSN configured to an offsite MySQL server. Adding and working with MySQL table occurrences works fine. Interacting with the MySQL tables always works when connecting with a Mac client.

However, Windows clients require intermittent "Syncing" as Filemaker seems to drop the primary key from the MySQL tables. It would seem that this issue is related to Filemaker Pro client and not the server, as the problem only occurs when connecting via a Windows client.

When viewing a layout based on an ESS table, under Windows, all fields display "Primary Key Missing". At this point, I can click the "Sync" button in the external tables field definition dialog and, when prompted to select a primary key, can select the proper key.

All of the MySQL tables do have a primary key field specified.

Has anyone else encountered this error?

Regards,

John Lannon

[fabriceN]

Hi,

what I have is loss of primary key in FM9 after opening the file in FM10.

Are you sure your mac version is not 10 ?

[Baloo]

From what I've found I can open and create records in the ESS table with the FMA 10 client and have it still work in 9. Syncing in 10 still seems to keep things working in 9, but creating a calc field in the ESS table in 10 sometimes causes 9 to loose the key id. I've been trying to pin it down to a completely reproducible event before contacting Filemaker / Posting Here, but haven't been able too (I also haven't had too much time to look into it )

[golfblondi]

Hi there,

we actually have the same problem.

Server: FM 10.0.1.64 on Win 2003 Server

Clients: 9.0.3 (FMP) an 10.0.1 (FMP(A)) on Win XP SP2

After syncing an ESS Table (MySQL on Linux), the FMP 9 clients do not show any datasets and says "primary key missing", while the FMP 10 clients work without any problems.

Workaround: Sync the ESS tables with FMP(A) 9 client and set the primary key of ESS source manually.

My idea was: Is FMPA 10 trying to recognize primary key fields automatically?