|
Title: SQL Database Professional Post by: MrCurryLover on October 22, 2014, 04:54:17 PM Hi,
We are using the SQL Database Professional plugin to export our data to a MSSQL database. In the 'Handling Errors' screen we have set it to 'Write data to a temporary file, then try to write to the database again', so far so good. When it does get an error though it writes the data successfully to the temporary file, the problem then occurs when it then reads the data from the temporary file and inserts in to the database. It successfully writes the data but it doesn't then remove the data or flag it as inserted in to the database, so it keeps writing the data to the database every time it reads from the file. The error log has full read/write permissions and it does sometimes successfully write to the database once and the data is then removed from the log. If I manually remove the text from the error log it stops writing the multiple entries to the database and if I then add the data back to the log it starts inserting the data multiple times again so i'm pretty sure that this is where the problem is occurring. Thanks Title: Re: SQL Database Professional Post by: Arthur Grasin on October 22, 2014, 05:01:01 PM Could you send me your configuration, database structure and this text file? I'll verify it.
Title: Re: SQL Database Professional Post by: MrCurryLover on October 23, 2014, 10:59:47 AM Hi Arthur,
I have emailed you the requested files. Title: Re: SQL Database Professional Post by: mvanderveer on December 07, 2014, 05:49:21 PM Hi,
Has this been resolved? I have an issue where a new row starts with an empty rule. Only when the connection is used the first time it looks ok. Thanks, Martijn Title: Re: SQL Database Professional Post by: mvanderveer on December 07, 2014, 10:23:06 PM Nevermind. Fixed it with some extra query's.
|