Latest topics for the forum "SQL Power DQguru Bugs"

What is the best bed bugs killer?

raqibjawa — GMT

After my tenants move in for two months, he got bed bug bits form his room, I have try every things also get ride of the carpet in his room, got the bed bugs power from the store,even so, he still have the bed bugs bit, Please tell me what should I do? and what is the best chemical or power I should buy? Thanks.

Initial repository creation on SQL Server 2008 fails with foreign key error

bretlowery — GMT

When initially installing the DQ repository on a MS SQL Server 2008 database, the install fails with a foreign key error:

ca.sqlpower.matchmaker.dao.hibernate.RepositoryException: Failed to create repository. See nested cause for more details.
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(RepositoryUtil.java:307)
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createOrUpdateRepositorySchema(RepositoryUtil.java:226)
at ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionImpl.(MatchMakerHibernateSessionImpl.java:194)
at ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionContext.createSession(MatchMakerHibernateSessionContext.java:147)
at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.createSession(SwingSessionContextImpl.java:227)
at ca.sqlpower.matchmaker.swingui.LoginDialog$LoginAction.doStuff(LoginDialog.java:147)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'step_output_input_fk' on table 'MM_MUNGE_STEP_INPUT' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:89)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(RepositoryUtil.java:302)
... 7 more

InstantiationException when saving new project

Benjamin — GMT

Hi,

I just downloaded the newest build of DQGuru. When creating a new project I get the following error:

"Error in trying to update result table when saving"

java.lang.InstantiationException
at sun.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at ca.sqlpower.architect.ddl.DDLUtils.createDDLGenerator(DDLUtils.java:182)
at ca.sqlpower.matchmaker.swingui.MMSUtils.createResultTable(MMSUtils.java:226)
at ca.sqlpower.matchmaker.swingui.ProjectEditor.applyChanges(ProjectEditor.java:626)
at ca.sqlpower.matchmaker.swingui.ProjectEditor$4.actionPerformed(ProjectEditor.java:234)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

New bug tracking database

Jeff — GMT

Hi everyone,

The DQguru development team has decided to try out using the Google Code Issues database for tracking bugs for the DQguru project. The reasoning for this is that we feel that the Google Code Issues user interface is simpler and friendlier to end users, and will help make it easier for users to report bugs more effectively. The new system is located at http://code.google.com/p/power-matchmaker/issues/list

There is a list of older bugs still in our Bugzilla database. These will remain there for reference, but you will no longer be able to enter new bugs through that interface. Instead, please report bugs in the new system (http://code.google.com/p/power-matchmaker/issues/list). Over time, we may transfer the bug reports from Bugzilla over to the new system.

Possible bug with Translate Word munge

desbonns — GMT

hello,

When I try to add a translate word munge I have this error:
[code]java.lang.RuntimeException: Error generating munge step component: ca.sqlpower.matchmaker.swingui.munge.TranslateWordMungeComponent. Possibly caused by an error thrown in the constructor.
at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:612)
at ca.sqlpower.matchmaker.swingui.munge.MungePen$MungePenMungeProcessListener.mmChildrenInserted(MungePen.java:812)
at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:219)
at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:175)
at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addImpl(AbstractMatchMakerObject.java:106)
at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:280)
at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:38)
at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addChild(AbstractMatchMakerObject.java:77)
at ca.sqlpower.matchmaker.swingui.munge.MungePen.addMungeStep(MungePen.java:586)
at ca.sqlpower.matchmaker.swingui.munge.MungePen.drop(MungePen.java:1067)
at java.awt.dnd.DropTarget.drop(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetEvent.dispatch(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processDropTargetEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:610)
... 30 more
Caused by: java.lang.RuntimeException: Failed to refresh step Translate Words
at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.(AbstractMungeComponent.java:255)
at ca.sqlpower.matchmaker.swingui.munge.TranslateWordMungeComponent.(TranslateWordMungeComponent.java:49)
... 35 more
Caused by: java.lang.NumberFormatException: null
at java.lang.Long.parseLong(Unknown Source)
at java.lang.Long.valueOf(Unknown Source)
at ca.sqlpower.matchmaker.munge.TranslateWordMungeStep.doOpen(TranslateWordMungeStep.java:152)
at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:502)
at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:480)
at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.(AbstractMungeComponent.java:251)
... 36 more[/code]

The munge component doesn't appear at the screen but it is created in my repository database. I have to remove the row manually because each time I try to open my transformation process the error appear.

Here is my config :
[quote]DQguru 0.9.5
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Windows XP 5.1 (x86)

Runtime Environment:
Java(TM) SE Runtime Environment
1.6.0_12-b04

VM info:
Java HotSpot(TM) Client VM
11.2-b01
Sun Microsystems Inc.

Memory:
337MiB allocated (1488MiB max); 39MiB free[/quote]

Thanks in advance for your help.

Sample table build fails for Postgres

argyllsock — GMT

Postgres 8.3.7
DQ Guru 0.9.5-20090423135916
Both running locally on Windows XP SP 2

When attempting to generate a sample table, the first time I click the 'Create' button, nothing happens (create button remains active). Second time I click the 'Create' button, I receive the following error messages:

ca.sqlpower.sqlobject.SQLObjectException: The table Demo_DB.JK.Demo_table already exists
at ca.sqlpower.sqlobject.SQLObjectUtils.addSimulatedTable(SQLObjectUtils.java:294)
at ca.sqlpower.matchmaker.swingui.BuildExampleTableDialog.generateTableSQL(BuildExampleTableDialog.java:306)
at ca.sqlpower.matchmaker.swingui.BuildExampleTableDialog$2.actionPerformed(BuildExampleTableDialog.java:248)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at java.awt.Window.setVisible(Unknown Source)
at java.awt.Dialog.setVisible(Unknown Source)
at ca.sqlpower.matchmaker.swingui.action.BuildExampleTableAction.actionPerformed(BuildExampleTableAction.java:44)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

My findings

Benjamin — GMT

Here are my findings, I post them in the forum as discussed earlier.

[b]Manual[/b]
Page 2: Old screenshot / labels
Page 3: Not all transformations listes
Page 6: Old link for address database
Page 8: Old screenshot
Page 9: Old link
Page 11: Old screenshot
Page 13: Old screenshot
Page 14: Old link
Page 27: Missing reference (bottom of page)
Page 29: Missing reference (below screenshot)
No information about Script Console
Not all transformations listed and explained (input/output)

[b]Handling[/b]
* Why menu item "Translate Words Manage" since it is in tree already.
* Database Schema has to be selected twice (Create example table)
* Preview can't be enabled
* Debug for cleansing doesn't work
* The Audit information is empty
* I would rename option 'New folder' to 'New project folder'
* Need of Shorter default name for example table so default values can be used for address correction (now default result table has more than 30 characters)
* in Address correction, exception pops up when clicking on 'Validate addresses' and no correction database exists
* Naming of 'Universal SQL Access' is not consistent in manual (SQL Query) and GUI (Universal SQL Access)
* Drag&Drop in SQL Query doesn't work
* Missing feature to backup repository (Manual recommends copying of folder)
* Enable option to rearrange order of projects
* What is the use of folder "Backup Projects"?

[b]Transformation steps[/b]
Google Address Lookup: Background exception because of missing Google API. Cant't start editor of transformation after adding the transformation step.

Translate Words: Exception "Failed to refresh step Translate words", Cant't start editor of transformation after adding the transformation step.

Extensions: Is it possible to extend DQguru with pluggable transformation steps?

[b]Bugzilla[/b]
Update naming from Matchmaker to DQguru

Benjamin

Run buttons

desbonns — GMT

Hi,

First of all:
MatchMaker version: 0.9.5-20090219170003
Os: Windows XP Pro SP3

It is possible to click two times on the "Run Match Engine" or "Run Merge Engine" button. This button become locked after the second click. This is not an important problem but the result is that the match will run two times and the "Abort!" button become locked after the first one (make sure to abort during the first run if you don't want to wait 2 times the duration of the run).

I tried to write this bug on Bugzilla but can you tell me in which section I should put it? (There is no "MatchMaker" section).

Sorry if my english is not really good!

Simon

Munge Create Failure on Postres

donn — GMT

Match Maker version 0.9.5 build #217, first spotted in 0.9.4
JRE 1.6.0_11
MatchMaker provided postgres JDBC driver
Accessing PostgreSQL 8.2
===================

Munge creation dialog accepts all required data for step creation, correctly finds the source table and creates the RESULTs table, but fails when displaying the munge design panel.

The contents of the java error stack suggests that an attempt is being made to open the source table with the right table name, but the wrong case. Postgres object names are case sensitive as I recall.

It looks like the munge creation dialog found the source table in uppercase (public.MDM_CUSTOMER), but then tries to access it by referencing the table with a lower case table name (public.mdm_customer), and therefore does not find the table.

How about "public"."MDM_CUSTOMER"?

Alert panel messages follow ======================================

java.lang.RuntimeException

Could not setup the input Munge step!

Java error stack follows =========================================

java.lang.RuntimeException: Could not set up the input munge step!
at ca.sqlpower.matchmaker.swingui.action.NewMungeProcessAction.actionPerformed(NewMungeProcessAction.java:91)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "public.mdm_customer" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.executeQuery(StatementDecorator.java:92)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at ca.sqlpower.matchmaker.munge.SQLInputStep.doOpen(SQLInputStep.java:190)
at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:483)
at ca.sqlpower.matchmaker.swingui.action.NewMungeProcessAction.actionPerformed(NewMungeProcessAction.java:87)
... 25 more

MatchMaker Repository Build is incomplete for Postgres

donn — GMT

Match Maker version 0.9.5 build #217, first spotted in 0.9.4
JRE 1.6.0_11
MatchMaker provided postgres JDBC driver
Accessing PostgreSQL 8.2
===================

The SQL generated for Postgres repository generation correctly qualifies all CREATE and ALTER commands with 'database_name.schema_name.', but fails to do so for the INSERT statements that populate initial table values. This results in a failure when a repository connection is later attempted by MatchMaker.

Exporting the generated SQL, making corrections and re-execution is an effective workaround.

The code subset below shows one correctly qualified object reference in an ALTER TABLE call, followed by INSERT statements with incomplete table qualifications as generated by the MatchMaker create repository dialog.

incorrecty generated code subset follows ==================================

...
ALTER TABLE data_quality.matchmaker.mm_munge_step_input ADD CONSTRAINT step_output_input_fk
FOREIGN KEY (munge_step_output_oid)
REFERENCES data_quality.matchmaker.mm_munge_step_output (munge_step_output_oid)
ON DELETE CASCADE
ON UPDATE CASCADE
DEFERRABLE INITIALLY DEFERRED;

insert into mm_schema_info values ('schema_version', '6.0.1')
;

INSERT INTO pl_group(group_name,group_desc,last_update_date,last_update_user,create_date)
VALUES('PL_ADMIN','Special PL group with ALL privileges',CURRENT_TIMESTAMP,'postgres',CURRENT_TIMESTAMP)
;

INSERT INTO pl_user (user_id, last_update_date, last_update_user,
default_kpi_frequency, show_red_ind, show_yellow_ind, show_green_ind, show_grey_ind)
VALUES (upper('postgres'), CURRENT_TIMESTAMP, 'postgres', 'MONTHLY', 'Y', 'Y', 'Y', 'Y')
;

INSERT INTO user_group (user_id, group_name, last_update_date, last_update_user)
VALUES (upper('postgres'), 'PL_ADMIN', CURRENT_TIMESTAMP, 'postgres')
;

Match Engine Failure - OJDBC invalid colum type on INSERT

donn — GMT

Match Maker version 0.9.5 build #217, first spotted in 0.9.4
JRE 1.6.0_11
JDBC Driver ojdbc14.jar
Accessing Oracle 9.2
===================

Match Engine finds matches successfully, but fails when inserting the Match Pool into the RESULTs table.

Failing Oracle calls follow =====================================

Error in SQL Query while storing the Match Pool!
Message: Invalid column type
SQL State: null
Query: INSERT INTO DC_METRICS.MDM_CUSTOMER_RESULT (DUP_CANDIDATE_10, DUP_CANDIDATE_20, MATCH_PERCENT, GROUP_ID, MATCH_STATUS, DUP1_MASTER_IND, MATCH_DATE, MATCH_STATUS_DATE, MATCH_STATUS_USER, DUP_ID0, MASTER_ID0)
VALUES (?, ?, ?, ?, ?, ?, TO_DATE('2009-02-04 14:57:14','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2009-02-04 14:57:14','YYYY-MM-DD HH24:MI:SS'), 'SA', ?, ?)

Error in SQL Query while storing the Match Pool!
Message: Invalid column type
SQL State: null
Query: INSERT INTO DC_METRICS.MDM_CUSTOMER_RESULT (DUP_CANDIDATE_10, DUP_CANDIDATE_20, MATCH_PERCENT, GROUP_ID, MATCH_STATUS, DUP1_MASTER_IND, MATCH_DATE, MATCH_STATUS_DATE, MATCH_STATUS_USER, DUP_ID0, MASTER_ID0)
VALUES (?, ?, ?, ?, ?, ?, TO_DATE('2009-02-04 14:58:53','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2009-02-04 14:58:53','YYYY-MM-DD HH24:MI:SS'), 'SA', ?, ?)

Leading log messages and Java error stack follow =========================

2009-02-04 14:26:56,133 INFO Checking Match Engine Preconditions
2009-02-04 14:27:26,429 INFO Starting Match Engine
2009-02-04 14:27:28,600 INFO Clearing Match Pool
2009-02-04 14:27:29,600 INFO Searching for matches
2009-02-04 14:27:30,553 INFO Munge Process 'MDM_CUSTOMER Munge' found 3 matches
2009-02-04 14:27:30,553 INFO Match Engine found a total of 3 matches
2009-02-04 14:27:30,553 INFO Storing matches
2009-02-04 14:27:31,460 ERROR 800/900: Match Engine failed
2009-02-04 14:27:31,538 ERROR Error during engine run
java.lang.RuntimeException: java.sql.SQLException: Invalid column type
at ca.sqlpower.matchmaker.MatchEngineImpl.call(MatchEngineImpl.java:258)
at ca.sqlpower.matchmaker.swingui.engine.EngineWorker.doStuff(EngineWorker.java:107)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:73)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Invalid column type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:6411)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:1358)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2795)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3221)
at ca.sqlpower.sql.jdbcwrapper.PreparedStatementDecorator.setObject(PreparedStatementDecorator.java:323)
at ca.sqlpower.matchmaker.MatchPool.store(MatchPool.java:599)
at ca.sqlpower.matchmaker.MatchPool.store(MatchPool.java:368)
at ca.sqlpower.matchmaker.MatchEngineImpl.call(MatchEngineImpl.java:239)
... 3 more

Match Statistics - Status UNMATCH

lilihammer — GMT

Currently, if a user was to automatch a specific munge process, in the match validation screen it shows a specific number of rows now marked as matched, and then it also shows the remainder as UNMATCH.
The user would assume that the match validation screen should mark the remainder as NO-MATCH.

Translation Groups - Not Refreshing

lilihammer — GMT

OS: Windows
Version: Nightly Build 20080828

Multiple people logged onto the same repository. User 1 creates a Translation group. User 2 cannot see the translation group in the tree, but User 2 can see the translation group in the drop down of the Translate Word munge process. The Translate group tree is not update for User 2 until they log out and back into the match maker.

There is a Refresh option on the Translate Groups folder in the tree, but when clicked on it does not refresh the list.

I would expect the refresh option to refresh the list with all new translation groups.

MatchMaker bugs

misha — GMT

1. There should be a Progress Bar or a message displayed when performing an Automatch

2. 'Use Regular Expression' should be clicked by default in Munge Process definitions.

Can not save Munge process

misha — GMT

Get this error message when trying to save a munge process:

org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: ca.sqlpower.matchmaker.munge.MungeProcess
at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219)
at org.hibernate.collection.AbstractPersistentCollection.getOrphans(AbstractPersistentCollection.java:889)
at org.hibernate.collection.PersistentBag.getOrphans(PersistentBag.java:120)
at org.hibernate.engine.CollectionEntry.getOrphans(CollectionEntry.java:350)
at org.hibernate.engine.Cascade.deleteOrphans(Cascade.java:340)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:324)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:121)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at ca.sqlpower.matchmaker.dao.hibernate.AbstractMatchMakerDAOHibernate.save(Unknown Source)
at ca.sqlpower.matchmaker.dao.hibernate.AbstractMatchMakerDAOHibernate.save(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MatchMakerSwingSession.save(Unknown Source)
at ca.sqlpower.matchmaker.undo.AbstractUndoableEditorPane.applyChanges(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MungeProcessEditor.applyChanges(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MungeProcessEditor$5.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)