FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Possible Bug - SQLite - V4.1.2

Possible Bug - SQLite - V4.1.2 2 months 3 weeks ago #3464

  • Keith Weatherhead
  • Keith Weatherhead's Avatar Topic Author
  • Offline
  • Posts: 16
Greetings,

I have run into an issue that I finally resolved, but only after a bunch of newbie experimenting.

I was going from CSV to SQLite3

I setup all my fields and setup a AUTO_INCREMENT as the first field. I then selected the Document Number
as a Primary Key. Turns out the Document Number was not unique. I got a UNIQUE ... Constraint Violation on
the Document Number field. I de-selected that as Primary Key and when I went to run the transformation again
I got the same error. So I went to remove the O/P DB (I was creating a new DB from scratch) and found I had to
Shutdown the Studio (see other post regarding that) and fired up Studio and when to run Transformation again.
I still got the error (UNIQUE ... Constraint Violation). I made the Auto_Increment the Primary and it ran.

It would appear that even though I removed the original Primary Key setting and the UI showed that it was cleared
that something was not getting reset properly in the in FH config file.

Through changing I got it to work BUT by the time I figured I should document this, the trail was gone. You might want
to see if you see anyway this can happen for correction in a future version.

Regards,
Keith

Please Log in or Create an account to join the conversation.

Possible Bug - SQLite - V4.1.2 2 months 3 weeks ago #3468

Hi Keith,

I´m not sure whether I understand you correctly.

I mean that´s not a bug/issue because if you switch the “Primary Key” or “Auto Increment” option in a FlowHeater Definition, FlowHeater does not change the underlying table schema. Only in the SQLite Adapter these options are using once in case the SQLite table should be created.

Note: Only the SQLite Adapter does currently support the feature to create not existing tables before importing.

If the table already exist these option are only using for information purpose (e.g. Auto Increment) or find some possible records for updating. In special cases with this you can tell the database Adapter do not use the tabled based primary key for updating just use the in the Definition defined Primary Key fields.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2018 by FlowHeater GmbH. All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en