Bug report #19259

QGIS 3. Oracle error while adding features - ORA-01861

Added by Marcin Lis over 5 years ago. Updated over 5 years ago.

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 over 5 years ago

I had this issue too. Apparently it's a problem with the date format columns.

#2 Updated by dany Lefeuvre over 5 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

Also available in: Atom PDF