Jump to content

Can't Add Transactions to MySQL external database


This topic is 2722 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hey Guys... suddenly, after several months, I can't add transactions to my mysql database.

Periodically, I will offload transactions from my filemaker table to a mysql table (once the filemaker table has > 500,000 transactions).

The import to the mysql table takes place in a script.

I started getting a 729 import error on the mysql table import. (729 = Errors occurred during import...)

So... I manually tried to import and -0- records imported.  The "Import Summary" reads:

---------------------------------------------------------------------------

Total records added / updated: 1500

Total records skipped due to errors: 1500

Total fields skipped due to errors: 0

Table created: <none>

---------------------------------------------------------------------------

So... I tried to add one record to the mysql table.... that was several hours ago and filemaker "hangs" while working with the entire 3 million record found set.

(The mysql table presently has 3,484,495 records in it and the filemaker table has just over 800,000 records.)

If I, say, do a search on a specific date, to constrain the found set count in the mysql, I can add a record just fine.

So, it is importing with errors.

Can anyone suggest where I start looking for the error.  729 does not tell me much.

(The fm database is hosted on an fm server).

Thanks

Edited by CCBtx
More information
Link to comment
Share on other sites

SOLVED!!!

My data had gotten so big, a transaction counter had added a digit which made the data in that field 1 digit longer than the field length.

...sure wish there was a log that told me that rather than searching for it for 3 days :-(

Link to comment
Share on other sites

This topic is 2722 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.