Error Codes in FileMaker

FileMaker can generate quite a number of possible errors in the course of a script. FileMaker generates errors at various times, such as during normal use of the applicationbut in general these errors are reported directly to the user, via a dialog box. Its only during scripting, or during certain interactions with the Web Publishing Engine, that developers are in a position to trap and examine the error codes FileMaker generates. To do so requires that Error Capture be set to On during the script, and that the script developer use the Get(LastError) function to inspect any possible errors.

The error list in the tables that follow is broken into two groups: those that can arise during normal operation of FileMaker or during ODBC access, which have numbers up to 1408, and those that are generated by the Web Publishing Engine, which have codes of 10000 or above.

Remember that the FileMaker error results that occur during scripts are transient. You must check for an error immediately after a script step. If script step A produces an error, and a subsequent script step B executes with no error, the error from script step A will be "forgotten" after script step B executes. Hence the name of the Get(LastError) function: It reports only the last error code, even if that error code is 0 (no error). (Note, though, that the error code from the last script step will be retained even after the script has stopped executing, until replaced by another script. Further, the script steps Exit Script and Halt Script do not clear the previous error code.)

FileMaker Error Codes

The following error codes may be encountered in the normal operation of the FileMaker Pro or Pro Advanced clients. These errors appear and are reported strictly within the client. FileMaker Server has its own error codes, which are not accessible from within a FileMaker database. Also note that error codes 951 through 958 are returned only by databases that are being accessed via the Web.

Table 11.1. FileMaker Error Codes

Code

Error Description

-1

Unknown error

0

No error

1

User canceled action

2

Memory error

3

Command is unavailable (for example, wrong operating system, wrong mode, and so on)

4

Command is unknown

5

Command is invalid (for example, a Set Field script step does not have a calculation specified)

6

File is read-only

7

Running out of memory

8

Empty result

9

Insufficient privileges

10

Requested data is missing

11

Name is not valid

12

Name already exists

13

File or object is in use

14

Out of range

15

Can divide by zero

16

Operation failed, request retry (for example, a user query)

17

Attempt to convert foreign character set to UTF-16 failed

18

Client must provide account information to proceed

19

String contains characters other than A-Z, a-z, 0-9 (ASCII)

100

File is missing

101

Record is missing

102

Field is missing

103

Relationship is missing

104

Script is missing

105

Layout is missing

106

Table is missing

107

Index is missing

108

Value list is missing

109

Privilege set is missing

110

Related tables are missing

111

Field repetition is invalid

112

Window is missing

113

Function is missing

114

File reference is missing

115

Specified menu set is not present

130

Files are damaged or missing and must be reinstalled

131

Language pack files are missing (such as template files)

200

Record access is denied

201

Field cannot be modified

202

Field access is denied

203

No records in file to print, or password doesn allow print access

204

No access to field(s) in sort order

205

User does not have access privileges to create new records; import will overwrite existing data

206

User does not have password change privileges, or file is not modifiable

207

User does not have sufficient privileges to change database schema, or file is not modifiable

208

Password does not contain enough characters

209

New password must be different from existing one

210

User account is inactive

211

Password has expired

212

Invalid user account and/or password. Please try again

213

User account and/or password does not exist

214

Too many login attempts

215

Administrator privileges cannot be duplicated

216

Guest account cannot be duplicated

217

User does not have sufficient privileges to modify administrator account

300

File is locked or in use

301

Record is in use by another user

302

Table is in use by another user

303

Database schema is in use by another user

304

Layout is in use by another user

306

Record modification ID does not match

400

Find criteria are empty

401

No records match the request

402

Selected field is not a match field for a lookup

403

Exceeding maximum record limit for trial version of FileMaker Pro

404

Sort order is invalid

405

Number of records specified exceeds number of records that can be omitted

406

Replace/Reserialize criteria are invalid

407

One or both match fields are missing (invalid relationship)

408

Specified field has inappropriate data type for this operation

409

Import order is invalid

410

Export order is invalid

412

Wrong version of FileMaker Pro used to recover file

413

Specified field has inappropriate field type

414

Layout cannot display the result

415

One or more required related records are not available

500

Date value does not meet validation entry options

501

Time value does not meet validation entry options

502

Number value does not meet validation entry options

503

Value in field is not within the range specified in validation entry options

504

Value in field is not unique as required in validation entry options

505

Value in field is not an existing value in the database file as required in validation entry options

506

Value in field is not listed on the value list specified in validation entry option

507

Value in field failed calculation test of validation entry option

508

Invalid value entered in Find mode

509

Field requires a valid value

510

Related value is empty or unavailable

511

Value in field exceeds maximum number of allowed characters

600

Print error has occurred

601

Combined header and footer exceed one page

602

Body doesn fit on a page for current column setup

603

Print connection lost

700

File is of the wrong file type for import

706

EPSF file has no preview image

707

Graphic translator cannot be found

708

Can import the file or need color monitor support to import file

709

QuickTime movie import failed

710

Unable to update QuickTime file reference because the database file is read-only

711

Import translator cannot be found

714

Password privileges do not allow the operation

715

Specified Excel worksheet or named range is missing

716

A SQL query using DELETE, INSERT, or UPDATE is not allowed for ODBC import

717

There is not enough XML/XSL information to proceed with the import or export

718

Error in parsing XML file (from Xerces)

719

Error in transforming XML using XSL (from Xalan)

720

Error when exporting; intended format does not support repeating fields

721

Unknown error occurred in the parser or the transformer

722

Cannot import data into a file that has no fields

723

You do not have permission to add records to or modify records in the target table

724

You do not have permission to add records to the target table

725

You do not have permission to modify records in the target table

726

There are more records in the import file than in the target table. Not all records were imported

727

There are more records in the target table than in the import file. Not all records were updated

729

Errors occurred during import. Records could not be imported

730

Unsupported Excel version. (Convert file to Excel 7.0 (Excel 95), Excel 97, 2000, or XP format and try again)

731

The file you are importing from contains no data

732

This file cannot be inserted because it contains other files

733

A table cannot be imported into itself

734

This file type cannot be displayed as a picture

735

This file type cannot be displayed as a picture. It will be inserted and displayed as a file

736

Too much data to export to this format. It will be truncated

800

Unable to create file on disk

801

Unable to create temporary file on System disk

802

Unable to open file

803

File is single user or host cannot be found

804

File cannot be opened as read-only in its current state

805

File is damaged; use Recover command

806

File cannot be opened with this version of FileMaker Pro

807

File is not a FileMaker Pro file or is severely damaged

808

Cannot open file because access privileges are damaged

809

Disk/volume is full

810

Disk/volume is locked

811

Temporary file cannot be opened as FileMaker Pro file

813

Record Synchronization error on network

814

File(s) cannot be opened because maximum number is open

815

Couldn open lookup file

816

Unable to convert file

817

Unable to open file because it does not belong to this solution

819

Cannot save a local copy of a remote file

820

File is in the process of being closed

821

Host forced a disconnect

822

FMI files not found; reinstall missing files

823

Cannot set file to single-user, guests are connected

824

File is damaged or not a FileMaker file

900

General spelling engine error

901

Main spelling dictionary not installed

902

Could not launch the Help system

903

Command cannot be used in a shared file

905

No active field selected; command can only be used if there is an active field

920

Can initialize the spelling engine

921

User dictionary cannot be loaded for editing

922

User dictionary cannot be found

923

User dictionary is read-only

951

An unexpected error occurred (web)

954

Unsupported XML grammar (web)

955

No database name (web)

956

Maximum number of database sessions exceeded (web)

957

Conflicting commands (web)

958

Parameter missing (web)

1200

Generic calculation error

1201

Too few parameters in the function

1202

Too many parameters in the function

1203

Unexpected end of calculation

1204

Number, text constant, field name or "(" expected

1205

Comment is not terminated with "*/"

1206

Text constant must end with a quotation mark

1207

Unbalanced parenthesis

1208

Operator missing, function not found or "(" not expected

1209

Name (such as field name or layout name) is missing

1210

Plug-in function has already been registered

1211

List usage is not allowed in this function

1212

An operator (for example, +, -, *) is expected here

1213

This variable has already been defined in the Let function

1214

AVERAGE, COUNT, EXTEND, GEtrEPETITION, MAX, MIN, NPV, STDEV, SUM, and GETSUMMARY: Expression found where a field alone is needed

1215

This parameter is an invalid Get function parameter

1216

Only Summary fields allowed as first argument in GETSUMMARY

1217

Break field is invalid

1218

Cannot evaluate the number

1219

A field cannot be used in its own formula

1220

Field type must be normal or calculated

1221

Data type must be number, date, time, or timestamp

1222

Calculation cannot be stored

1223

The function is not implemented

1224

The function is not defined

1300

The specified name can be used

1400

ODBC driver initialization failed; make sure the ODBC drivers are properly installed

1401

Failed to allocate environment (ODBC)

1402

Failed to free environment (ODBC)

1403

Failed to disconnect (ODBC)

1404

Failed to allocate connection (ODBC)

1405

Failed to free connection (ODBC)

1406

Failed check for SQL API (ODBC)

1407

Failed to allocate statement (ODBC)

1408

Extended error (ODBC)

Web Publishing Engine Error Codes

These errors are reported by FileMaker Server Advanceds Web Publishing Engine (WPE), and will only appear in XML data generated by the WPE.

Table 11.2. Publishing Engine Error Codes

Code

Error Description

10000

Invalid header name

10001

Invalid HTTP status code

10100

Unknown session error

10101

Requested session name is already used

10102

Session could not be accessedmaybe it does not exist

10103

Session has timed out

10104

Specified session object does not exist

10200

Unknown messaging error

10201

Message formatting error

10202

Message SMTP fields error

10203

Message "To Field" error

10204

Message "From Field" error

10205

Message "CC Field" error

10206

Message "BCC Field" error

10207

Message "Subject Field" error

10208

Message "Reply-To Field" error

10209

Message body error

10210

Recursive mail errorattempted to call send_email() inside an email XSLT stylesheet

10211

SMTP authentication erroreither login failed or wrong type of authentication provided

10212

Invalid function usageattempted to call set_header(), set_status_code(), or set_cookie() inside an email XSLT stylesheet

10213

SMTP server is invalid or is not working

Категории