Product(s):	Exor Street Gazetteer Manager
	Version(s):	04.05.00.00
	Environment:	N/A
	Area:	NSG Gazetteer
	Subarea:	N/A

Problem Description

User gets SQL error (SQL execution error, ORA-20001: "IIT_END_DATE":invalid identifier) when trying to save the NSG Gazetteer form in Spatial Manager.

Steps to Resolve

1.Go to GIS THEMES for metadata and query for TP* layers.
2. Change the Start Date Column value to "START_DATE" (from "IIT_START_DATE").
3. Change the End Date Column value to "END_DATE" (from "IIT_END_DATE").
4. Save.

Original Author:

Kristina J.