SQL Power Software Forum

This message was edited 1 time. Last update was at 2010-03-11 18:12:08

----------------------------------------
SQL Power DQguru version: 0.9.7
Operating System: Windows XP 5.1 (x86)
Runtime Environment: Java(TM) SE Runtime 1.6.0_03-b05
Database: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
---------------------------------------
I have test project to find duplicates. When I run the Match Engine without any transformations, it runs fine. However, when I add a transformation, it fails with the following exception:

java.lang.RuntimeException: java.sql.SQLException: Cannot convert Oracle Timestamp class because the an exception was encountered

If I remove the transformation and run Match Engine, it works fine.

I wanted to attach the log file but Attach Files button does not seem to work, so log file contents are pasted below.

Thanks,
Sameer
------------------------------------------------------------------
2010-03-11 16:01:57,854 INFO Checking Match Engine Preconditions
2010-03-11 16:02:01,731 INFO Starting Match Engine
2010-03-11 16:02:01,997 INFO Searching for matches
2010-03-11 16:02:01,997 DEBUG 0/7338: Running transformation New Transformation 1
2010-03-11 16:02:01,997 DEBUG Order of processing: [COMPANY: opened=false committed=false rolledBack=true [Inputs:] [Outputs: <COMPANY_ID: 1578> <COMPANY_NAME: Bernett Research> <DATE_CREATED: null> <DATE_CHANGED: null> <WEB_SITE: null> <DATE_DELETED: null> <COMPANY_NOTE: null> <COMPANY_DESCRIPTION: null> <COMPANY_BANNER_URL: null> <PSFT_CUST_ID: null> <PSFT_CUST_STATUS: null> <PSFT_CUST_STATUS_DATE: null> <SFA_ACCOUNT_ID: null> <PARENT_COMPANY_ID: null> <PO_REQUIRED: null> <COMPANY_ONHOLD: null> <CURRENCY_CODE: null>] [Parameters: <expanded:true> <y:30> <x:30>], Substring: opened=false committed=false rolledBack=true [Inputs: <COMPANY_NAME: Bernett Research>] [Outputs: <substringOutput: null>] [Parameters: <beginIndex:0> <endIndex:3> <expanded:true> <y:173> <x:85>], Transformation Results: opened=false committed=false rolledBack=true [Inputs: <substringOutput: null> null] [Outputs:] [Parameters: <expanded:true> <y:350> <x:30>]]
2010-03-11 16:02:01,997 DEBUG Opening MungeStep COMPANY
2010-03-11 16:02:01,997 DEBUG Attempting to execute input query: SELECT
COMPANY_ID,
COMPANY_NAME,
DATE_CREATED,
DATE_CHANGED,
WEB_SITE,
DATE_DELETED,
COMPANY_NOTE,
COMPANY_DESCRIPTION,
COMPANY_BANNER_URL,
PSFT_CUST_ID,
PSFT_CUST_STATUS,
PSFT_CUST_STATUS_DATE,
SFA_ACCOUNT_ID,
PARENT_COMPANY_ID,
PO_REQUIRED,
COMPANY_ONHOLD,
CURRENCY_CODE
FROM ECOWADMIN.COMPANY
WHERE COMPANY_NAME = COMPANY_NAME
2010-03-11 16:02:02,012 DEBUG ResultSet fetch size is: 100
2010-03-11 16:02:02,012 DEBUG Opening MungeStep Substring
2010-03-11 16:02:02,012 DEBUG Opening MungeStep Transformation Results
2010-03-11 16:02:02,012 DEBUG Searching for MungeStepOuput with name COMPANY_ID
2010-03-11 16:02:02,028 DEBUG Found MungeStepOuput <COMPANY_ID: 1578>
2010-03-11 16:02:02,028 DEBUG COMPANY Inputs:
2010-03-11 16:02:02,028 DEBUG Rolling back COMPANY
2010-03-11 16:02:02,028 DEBUG Closing MungeStep COMPANY
2010-03-11 16:02:02,028 DEBUG Closing MungeStep Substring
2010-03-11 16:02:02,028 DEBUG Closing MungeStep Transformation Results
2010-03-11 16:02:02,028 ERROR 0/7338: Match Engine failed
2010-03-11 16:02:02,263 ERROR Error during engine run
java.lang.RuntimeException: java.sql.SQLException: Cannot convert Oracle Timestamp class because the an exception was encountered
at ca.sqlpower.matchmaker.MatchEngineImpl.call(MatchEngineImpl.java:254)
at ca.sqlpower.matchmaker.swingui.engine.EngineWorker.doStuff(EngineWorker.java:117)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Cannot convert Oracle Timestamp class because the an exception was encountered
at ca.sqlpower.sql.jdbcwrapper.OracleResultSetDecorator.convertTimestamp(OracleResultSetDecorator.java:118)
at ca.sqlpower.sql.jdbcwrapper.OracleResultSetDecorator.getTimestamp(OracleResultSetDecorator.java:74)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:211)
at ca.sqlpower.matchmaker.munge.SQLInputStep.doCall(SQLInputStep.java:118)
at ca.sqlpower.matchmaker.munge.AbstractMungeStep.call(AbstractMungeStep.java:646)
at ca.sqlpower.matchmaker.munge.MungeProcessor.call(MungeProcessor.java:100)
at ca.sqlpower.matchmaker.munge.MungeProcessor.call(MungeProcessor.java:62)
at ca.sqlpower.matchmaker.MatchEngineImpl.mungeAndMatch(MatchEngineImpl.java:281)
at ca.sqlpower.matchmaker.MatchEngineImpl.call(MatchEngineImpl.java:229)
... 3 more
Caused by: java.lang.NullPointerException
at ca.sqlpower.sql.jdbcwrapper.OracleResultSetDecorator.convertTimestamp(OracleResultSetDecorator.java:98)
... 11 more