Error can occur with a number of scenarios.
1. Loading an Inspection File through the Maintenance Inspection Loader spawns a process that fails in the Process Monitor with message
line 1, column 6:
more details may also show
line1, column 6:
PLS-00103: Encountered the symbol "||CHR(10)||" when expecting one of the following
( begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> < a bind variable. <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
The symbol "begin was inserted before "||CHR(10)||" to continue
2. This issue has also occurred trying to schedule Alerts in Enquiry Manager the process monitor displays
Fails to run scheduled alerts the alert process returns an outcome of "failed" with details;
Process startedLine 1, column 6:Process Complete
3. In form NM0105 when editing an element get
Unexpected error occurredORA-02620: Error paring SQL: ORA-00933: SQL command not properly endedORA-06512: at "atlas.nm3FLX", line 1402ORA-06512: at "atlas.nm3FLX", line 1474ORA-06512: at "atlas.
If i try to create a street in ArcMap i get the same SQL error
Check if fix NET 4700 FIX23 has been applied, if it has then check the version of package nm3flx, if it is at version 2.17 then this error will occur. To resolve revert package to version 2.16 as this will overcome. NET4700 FIX23 (Build 2) should be applied which does not overwrite the package above and leaves at 2.16.Please contact Support to get relevant patch and package or to discuss.