AnsweredAssumed Answered

ESS Link and FMP 14 Crashes

Question asked by DDoughtie on Oct 30, 2015
Latest reply on Dec 3, 2015 by DDoughtie

I'm using ESS to pull data out of a readonly MS-SQL database. One table has 600,000 records. I recreated the fields on a native table and then use a simple script that collects the names of the fields on the ESS based layout then pushes the data via create new record in the FMP table. I loop through the records. I can get about 18,000 records across then Filemaker blows up. If i try and export to Excel or to a new Filemaker file it blows up. (Here's some of the crash code

Process:         FileMaker Pro [1151]

Path:            /Applications/FileMaker Pro 14 Advanced/FileMaker Pro Pro

Identifier:      com.filemaker.client.advanced12

Version:         14.0.3 (14.0.3)

Code Type:       X86-64 (Native)

Parent Process:  launchd [269]

Responsible:     FileMaker Pro [1151]

User ID:         501



Date/Time:       2015-10-30 12:34:49.701 -0400

OS Version:      Mac OS X 10.9.5 (13F1112)

Report Version:  11

Anonymous UUID:  83B1188F-21CE-738A-B030-CAB817543799





Crashed Thread:  0  Dispatch queue:




Exception Codes: EXC_I386_GPFLT




Luckily the records have dates so I've limited them to a date range and got the found set to around 15,000 per go and I can move them over but that will take a while. But let it try and handle the 600,000 at one time it crashes big time.


On FMPA 14.0.3, on a Mac running 10.9.5 on 8 Gigs Ram .I am using Actual ODBC Driver for SQL Server V3.3.4.


If you one has seen this or have a reason this might be happening let me know.


UPDATE. It crashed after only 9,000 records. This will take some time.