search

OpenESignForms / openesignforms

Open eSignForms is the first open source SaaS web contracting platform
https://open.esignforms.com
107 stars 50 forks source link

Report search exception #105

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Run a report.
2. Enter a transaction id to search for.
3. Enter additional search criteria for user-defined fields.

What is the expected output? What do you see instead?
We received an exception.

Original issue reported on code.google.com by yoz...@gmail.com on 8 Jul 2013 at 5:06

GoogleCodeExporter commented 9 years ago 
The logs show this exception took place:

2013-07-08 10:03:00,098 DEBUG 
(com.esignforms.open.runtime.reports.ReportListingInfo) 
Manager.getMatching(con) - SELECT DISTINCT 
TRAN.id,TRAN.status,TRAN.status_text,TEMPLATE.path_name,PKG.path_name,TRAN.last_
updated_timestamp,TRAN.created_timestamp,TRAN.cancel_timestamp,TRAN.expire_times
tamp,TRAN.stall_timestamp,TRAN.created_by_user_id,TRAN.last_updated_by_user_id 
FROM esf_transaction TRAN,esf_transaction_template TEMPLATE,esf_package PKG 
WHERE TRAN.id=? AND TRAN.transaction_template_id=TEMPLATE.id AND 
TRAN.package_id=PKG.id AND TRAN.id IN ( SELECT DISTINCT transaction_id FROM 
esf_tran_report_field_string WHERE report_field_template_id=? AND 
lower(field_value) LIKE ? ) ORDER BY TRAN.last_updated_timestamp DESC
2013-07-08 10:03:00,145 ERROR 
(com.esignforms.open.runtime.reports.ReportListingInfo) SQLException: 
Manager.getMatching(08-Jun-2013 12:00 AM PDT,null):
2013-07-08 10:03:00,147 ERROR 
(com.esignforms.open.runtime.reports.ReportListingInfo)   Message:   No value 
specified for parameter 2.
org.postgresql.util.PSQLException: No value specified for parameter 2.
        at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:216)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:244)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
        at com.esignforms.open.db.DatabaseObject$EsfPreparedStatement.executeQuery(DatabaseObject.java:311)
        at com.esignforms.open.runtime.reports.ReportListingInfo$Manager.getMatching(ReportListingInfo.java:553)
        at com.esignforms.open.runtime.reports.ReportListingInfo$Manager.getMatching(ReportListingInfo.java:645)
        at com.esignforms.open.vaadin.report.ReportView.runReport(ReportView.java:771)
        at com.esignforms.open.vaadin.report.ReportView$3.buttonClick(ReportView.java:478)

Original comment by yoz...@gmail.com on 8 Jul 2013 at 5:06

GoogleCodeExporter commented 9 years ago 
Fixed in the 13.7.13 release to ignore user-specified search field values when 
doing a tran-id search.  The transaction id search should override all other 
search criteria as it's a unique key and thus is not really a search at all.

Original comment by yoz...@gmail.com on 12 Jul 2013 at 6:17