Hi there,
I'm using Analyzer 4.0.2 with Patch 1 build 20121128 and I'm using the
cleaning script example found in section 3.9.2 of the documentation to
change upper to lower case characters in email addresses.


Code:
--------------------
//From Section 3.9.2 of Analyzer Admin 4.0.2. KMaule 3 Oct 2013

aimReturnStatus = true;
aimReturnValue = aimValue;

if (aimValue != null)
{
lower = aimValue.toLowerCase();
if ( !aimValue.equals(lower) )
{
aimReturnStatus = false;
aimReturnValue = lower;
}
}

--------------------


Works great to modify the data in the column in question (email) but
when I then sort on any column the previously modified data changes so
that one bogus value is found in almost all cells. The error log is
showing multiple exceptions as well after this.
> java.sql.SQLException: Unexpected token: SULLIVAN in statement
> [sullivan]
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> at com.novell.aim.core.database.DBManager.executeSQL( Unknown Source)
> at com.novell.aim.core.database.DBManager.updateSingl eValue(Unknown
> Source)
> at com.novell.aim.core.database.DBManager.updateDBVal ueTables(Unknown
> Source)
> at com.novell.aim.databrowser.actions.MatchingCleaner Action.run(Unknown
> Source)
> at org.eclipse.jface.action.Action.runWithEvent(Actio n.java:498)
> at
> org.eclipse.jface.action.ActionContributionItem.ha ndleWidgetSelection(ActionContributionItem.java:54 6)
> at
> org.eclipse.jface.action.ActionContributionItem.ac cess$2(ActionContributionItem.java:490)
> at
> org.eclipse.jface.action.ActionContributionItem$5. handleEvent(ActionContributionItem.java:402)
> at org.eclipse.swt.widgets.EventTable.sendEvent(Event Table.java:66)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:938)
> at org.eclipse.swt.widgets.Display.runDeferredEvents( Display.java:3682)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Di splay.java:3293)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Wor kbench.java:2389)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench. java:2353)
> at org.eclipse.ui.internal.Workbench.access$4(Workben ch.java:2219)
> at org.eclipse.ui.internal.Workbench$4.run(Workbench. java:466)
> at
> org.eclipse.core.databinding.observable.Realm.runW ithDefault(Realm.java:289)
> at
> org.eclipse.ui.internal.Workbench.createAndRunWork bench(Workbench.java:461)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(Pl atformUI.java:149)
> at com.novell.aim.rcp.Application.start(Unknown Source)
> at
> org.eclipse.equinox.internal.app.EclipseAppHandle. run(EclipseAppHandle.java:169)
> at
> org.eclipse.core.runtime.internal.adaptor.EclipseA ppLauncher.runApplication(EclipseAppLauncher.java: 106)
> at
> org.eclipse.core.runtime.internal.adaptor.EclipseA ppLauncher.start(EclipseAppLauncher.java:76)
> at
> org.eclipse.core.runtime.adaptor.EclipseStarter.ru n(EclipseStarter.java:363)
> at
> org.eclipse.core.runtime.adaptor.EclipseStarter.ru n(EclipseStarter.java:176)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.equinox.launcher.Main.invokeFramework( Main.java:508)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.ja va:447)
> at org.eclipse.equinox.launcher.Main.run(Main.java:11 73)
>



--
kmaule
------------------------------------------------------------------------
kmaule's Profile: https://forums.netiq.com/member.php?userid=306
View this thread: https://forums.netiq.com/showthread.php?t=48843