Bug report #19259
QGIS 3. Oracle error while adding features - ORA-01861
Status: | Open | ||
---|---|---|---|
Priority: | High | ||
Assignee: | Jürgen Fischer | ||
Category: | Data Provider/Oracle | ||
Affected QGIS version: | 3.2 | Regression?: | Yes |
Operating System: | Win 7 | Easy fix?: | No |
Pull Request or Patch supplied: | No | Resolution: | |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 27087 |
Description
When I add(edit) feature to layer with date field in oracle DB, I get this error:
Could not commit changes to layer WGK_SPRZATANIE
Errors: ERROR: 1 feature(s) not added.
Provider errors:
Oracle error while adding features: Oracle error: Could not insert feature -2
SQL: ORA-01861: literal does not match format string
Unable to execute statement
Error: INSERT INTO "Z_WGK"."WGK_SPRZATANIE"("SHAPE","ID","SPRAWA","DATA_INS_SPR","ZANIECZ_TER","G_PLASTIK","G_SZKLO","G_MAKULAT","G_ZMIESZANE","G_BIO","G_GABARYTY","G_BUDOWL_REMO","ODP_LISCIE","ODP_TRAWA","DZIEKIE_WYSYPISKA","DATA_INS_BD","OPIS_SPRAWY","ETAP","KOMENTARZ","ULICA","PKT_ADR","DZIALKA","DATA_ZMIANY","KTO_DODAL","KTO_ZMIENIL") VALUES (:a,:bb,:bc,:bd,:be,:bf,:bg,:bh,:bi,:bj,:bk,:bl,:bm,:bn,:bo,:bp,:cba,:cbb,:cbc,:cbd,:cbe,:cbf,:cbg,:cbh,:cbi)
In Qgis 2.18.21 it's ok
History
#1 Updated by Maxime Resibois almost 6 years ago
I had this issue too. Apparently it's a problem with the date format columns.
#2 Updated by dany Lefeuvre almost 6 years ago
I have the same problem. I confirm this is the date insertion that creates this error.
Last test on QGIS 3.4.1