Problem

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

Process Started

line 1, column 6:

Process Complete

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

OR

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 started
Line 1, column 6:
Process Complete

OR 

3. In form NM0105 when editing  an element get

Unexpected error occurred
OR
A-02620: Error paring SQL: ORA-00933: SQL command not properly ended
ORA-06512: at "atlas.nm3FLX", line 1402
ORA-06512: at "atlas.
nm3FLX", line 1474
ORA-06512: at "atlas.

If i try to create a street in ArcMap i get the same SQL error

Solution

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.