Skip to main content
Question

Trouble Deleting spatial rows in Informix

  • June 20, 2018
  • 3 replies
  • 21 views
C
Forum|alt.badge.img

Hello! I am getting errors while trying to delete records from using the Informix ODBC writers. I am putting the columns to match in the delete column row and getting an error that those columns do not exist:

IBM Informix Spatial Writer: Error - No column named ltt_id found in table xxxxx

A fatal error has occurred. Check the logfile above for details

Or just that there was error:

A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...

and the only other thing written is a warning about assuming the geometry is 2D.

Has anyone else had any trouble with this?

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    3 replies

    debbiatsafe
    Safer
    Forum|alt.badge.img+21
    • debbiatsafeSafer
    • Safer
    • 648 replies
    • June 21, 2018
    Hi @colleenk_1

     

    I would recommend checking the value of the parameter used to specify the table name in your writer. You could add it as an attribute to your features and use transformers to edit the value if necessary.

     

    C
    Forum|alt.badge.img
    • colleenk_1
    • Author
    • 14 replies
    • June 25, 2018
    Hi @colleenk_1

     

    I would recommend checking the value of the parameter used to specify the table name in your writer. You could add it as an attribute to your features and use transformers to edit the value if necessary.

     

    job-6237.txt

     

    Hi @DebbiAtSafe! I changed the names for the schema in the dynamic, and I had spaces after my commas in the delete key column line which gave me the above "not found in table error"

     

    I am now getting that the job is successful and that a record was written to my table, but the delete doesn't actually happen, ie the record is still there when I look at the table in DBeaver.
    debbiatsafe
    Safer
    Forum|alt.badge.img+21
    • debbiatsafeSafer
    • Safer
    • 648 replies
    • June 25, 2018
    job-6237.txt

     

    Hi @DebbiAtSafe! I changed the names for the schema in the dynamic, and I had spaces after my commas in the delete key column line which gave me the above "not found in table error"

     

    I am now getting that the job is successful and that a record was written to my table, but the delete doesn't actually happen, ie the record is still there when I look at the table in DBeaver.
    Hi @colleenk_1

     

    According to the Informix writer documentation, the infx_overwrite_table parameter should always be set to YES in the update and delete mode. Can you verify this writer parameter is set YES?

     

    If you are still running into issues, please feel free to file a support case at https://www.safe.com/support/report-a-problem/

    Community Stats

    32,085
    Posts
    121,845
    Replies
    39,726
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.