Skip to main content
Question

Trouble Deleting spatial rows in Informix

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?

    3 replies

    debbiatsafe
    Safer
    Forum|alt.badge.img+20
    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
    • June 25, 2018
    debbiatsafe wrote:
    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+20
    colleenk_1 wrote:
    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/

    Reply


    Helpful Members This Week

    Community Stats

    31,496
    Posts
    119,401
    Replies
    39,117
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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.