leeensminger / OED_Wetlands

0 stars 0 forks source link

Add New Mitigation Site fails when a date is included. #74

Closed sfabijanski closed 8 years ago

sfabijanski commented 8 years ago

If I select an expiration date, when adding a new mitigation site, the service (AddMitSite) fails with error: Add Mit Site Error: ORA-01843: not a valid month ORA-06512: at line 1 . Data for the expiration date field is: "OFFSITE_PERMIT_WQC_EXPIRATION":"10/30/2015"

However, if I edit the record afterward and add a date, the post to EditMitSite is successful, with expiration field exactly the same: "OFFSITE_PERMIT_WQC_EXPIRATION":"10/30/2015"

Is it really the date field, or is there something else wrong?

Full offending request:

Referer: http://localhost:8000/flexviewer_2.2/gov/sha/widgets/wetlands/Wetland.swf Content-type: application/json Content-length: 657 {"SITE_NAME":"","COMMENTS":"","OFFSITE_PERMIT_CAC":"","OFFSITE_PERMIT_ES":"","ON_SITE":"2","OFFSITE_PERMIT_OTHER_DESC":"","OFFSITE_PERMIT_WWC":"","PROJECT_ID":"881aaf2e-80bb-4d75-897c-174666abaefe","SITE_DESCRIPTION":"","PDMS_NUMBER":"","SHAPE":"POLYGON ( ( 1314628.5619520831 423056.0698385593,1314662.894256168 423048.91553703987,1314662.4770957294 422988.84443390253,1314620.6984778184 423022.63442941726,1314628.5619520831 423056.0698385593 ) )","PROJECT_MANAGER":"","OFFSITE_PERMIT_WQC_EXPIRATION":"10/30/2015","ADC_LOC":"","MITIGATION_AREA_STATUS":"PENDING","CONSTRUCTION_CONTRACT":"","OFFSITE_PERMIT_OTHER":"","OFFSITE_PERMIT_WQC":"","FAP_NUMBER":""}
sfabijanski commented 8 years ago

Now working with latest service updates.