AnsweredAssumed Answered

Julian date issue with Multi-versioned views

Question asked by pramodharithsa on Jan 6, 2016
Latest reply on Mar 31, 2016 by david.allan

Hi All,

 

The "Instead of" triggers created on Multi - version views for Updating, Inserting and Deleting records have an issue with the date field.

An update or insert command executed using the views throws the below error,

ORA-01835: day of week conflicts with Julian date

ORA-06512: at "ADMIN.V2356_UPDATE", line 1

ORA-04088: error during execution of trigger 'ADMIN.V2356_UPDATE'

ORA-02063: preceding 3 lines from ARCGIS

 

The date format used in these triggers doesn't comply with the format defined in the feature class.

The trigger uses the format: 9999/12/31 23:59:59 6:365','YYYY/MM/DD HH24:MI:SS D:DDD as against the format defined for the feature class 31/12/9999 23:59:59','DD/MM/YYYY HH24:MI:SS

 

Is this a know issue/bug? The only way I could fix this was by replacing the date format in all the triggers.

 

Database used: Oracle 11g

Geodatabase version: 10.2.1

 

Regards,

Pramod

Outcomes