LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Need help with the following LAL1 Fuzzy Join error. I am trying to run this node on a LAE 4.5.3 Enterprise Server. Why does this not work?

-- Errors for Fuzzy_Join_Engine
2012-06-08 09:43:31.653; ERROR: [dbParam] [ClassNotFoundException]
id: 10 chain: 0 group: 0
javaExceptionDetail: java.lang.ClassNotFoundException: 'org.hsqldb.jdbc.JDBCDriver';
stack trace:
java.net.URLClassLoader$1.run(URLClassLoader.java@ 202)
java.security.AccessController.doPrivileged(Access Controller.java@-2)
java.net.URLClassLoader.findClass(URLClassLoader.j ava@190)
java.lang.ClassLoader.loadClass(ClassLoader.java@3 06)
java.lang.ClassLoader.loadClass(ClassLoader.java@2 47)
java.lang.Class.forName0(Class.java@-2)
java.lang.Class.forName(Class.java@169)
com.lavastorm.brain.node.fuzzyJoin.BaseDatabaseEng ine.dbParam(BaseDatabaseEngine.java@357)
com.lavastorm.brain.node.fuzzyJoin.FuzzyJoin.proce ssAll(FuzzyJoin.java@204)
com.lavastorm.brain.node.NodeWrapper.nodeProcess(N odeWrapper.java@455)
com.lavastorm.brain.node.NodeWrapper.run(NodeWrapp er.java@673)
com.lavastorm.brain.node.NodeWrapper.main(NodeWrap per.java@1199)
javaDetail: com.lavastorm.brain.node.fuzzyJoin.BaseDatabaseEng ine.dbParam(BaseDatabaseEngine.java@373)
dataDetail:
inRight(in) row: 0
columns: ['TABLERIGHT_ID', 'java.lang.Long'], ['_FMKeyRight', 'java.lang.String'], ['_FMValueRight', 'com.lavastorm.lang.TimeStamp'], ['Right_ANUMBER', 'java.lang.String'], ['Right_BNUMBER', 'java.lang.String'], ['Right_CALLTIME', 'java.lang.String'], ['Right_SOURCE', 'java.lang.String'], ['Right_SS7Count', 'java.lang.String'], ['Right_DIRECTION', 'java.lang.String'], ['Right_CABSCount', 'java.lang.String'], ['Right_epocDateTime', 'com.lavastorm.lang.TimeStamp'], ['Right_DATEFORSTARTOFCHARGE', 'com.lavastorm.lang.Date'], ['Right_CALLDURATION', 'java.lang.Double'], ['Right_DATETIME', 'java.lang.Long'], ['Right_DURATION_BUCKET', 'java.lang.Long'], ['Right_LINEID', 'java.lang.Long']
rightorphan(out)
leftorphan(out)
multimatch(out)
inLeft(in) row: 0
columns: ['TABLELEFT_ID', 'java.lang.Long'], ['_FMKeyLeft', 'java.lang.String'], ['_FMValueLeft', 'com.lavastorm.lang.TimeStamp'], ['Left_ANUMBER', 'java.lang.String'], ['Left_BNUMBER', 'java.lang.String'], ['Left_CALLTIME', 'java.lang.String'], ['Left_SOURCE', 'java.lang.String'], ['Left_SS7Count', 'java.lang.String'], ['Left_DIRECTION', 'java.lang.String'], ['Left_CABSCount', 'java.lang.String'], ['Left_epocDateTime', 'com.lavastorm.lang.TimeStamp'], ['Left_DATEFORSTARTOFCHARGE', 'com.lavastorm.lang.Date'], ['Left_CALLDURATION', 'java.lang.Double'], ['Left_DATETIME', 'java.lang.Long'], ['Left_DURATION_BUCKET', 'java.lang.Long'], ['Left_LINEID', 'java.lang.Long']
uniquematch(out)

2012-06-08 09:43:31.660; ERROR: Node failed.
id: 12 chain: 11 group: 0
javaDetail: com.lavastorm.brain.node.NodeWrapper.run(NodeWrapp er.java@698)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

The text on our website is slightly unclear, but I think the release notes are a little more specific on this. Basically, in order for the Fuzzy nodes to work, there is a server component that needs to be in place. We will install that in all versions of 4.5.4, and it currently is included in 4.5.3, but ONLY the desktop version. Therefore, if you are using this in any enterprise solution right now, you would need to install the hsqldb software, per the release notes instructions.

Cheers
Rich