search

bluesoft-rnd / aperte-reports

Automatically exported from code.google.com/p/aperte-reports
0 stars 4 forks source link

Same report, Generate Works & Generate in Background does not... #36

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Configure Aperte JDBC + JMS Configurations
2. Deploy Aperte Reports
3. Using Reports Manager upload "liferay-users" sample report
 * Made a change to use same account as portal (Liferay tables and AR tables have same schema owner)
4. Click on Show Paramaters -> Generate
5. Report exports as PDF just fine.
6. Click Generate in Background
7. Display shows Unknown Error.

What is the expected output? What do you see instead?

Attached logs for more detail, but basically the sql error shows the following:

java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - 
got CLOB

...and suspect it is trying to fetch a record from the AR_RECORD_ORDER table 
which does not exist (in fact table is completely empty on manual inspection)

What version of the product are you using? On what operating system?
Liferay 6.1
Latest 2.3 Aperte Reports
Tomcat 7 OR Weblogic 10.3 (same error on both containers)
Linux (Fedora 17)
Oracle DB 10G

Please provide any additional information below.

1. Believe that the JMS queues are setup properly, the "JMS disabled message 
(something like that)" that appears in the Aperte Cyclic Reports portlet is NOT 
showing.
Is there another way to be certain?

2. Originally tried the Cyclic Reports to kick off the background generate and 
produce identical error stack trace.

Original issue reported on code.google.com by nicholas...@gmail.com on 18 Oct 2012 at 3:38

Attachments:

GoogleCodeExporter commented 9 years ago 
Further exploration to this, using the Weblogic Admin console have confirmed 
the following:

1. Active Pooled Connections - increases by 1 when Aperte Reports is turned on 
(aka deployed).  Leads me to believe its connecting ok.

2. Active Destinations tab - Displays 3 Destinations:

AperteReportsJMSModule!ARCyclicOrderResponseQueue
AperteReportsJMSModule!ARGenerateReportQueue
*AperteReportsJMSServer!AperteReportsJMSServer.TemporaryQueue1

* The temporary queue appears after starting up Aperte Reports

3. Whenever the Generate Report is kicked off from the portal, the Messages 
counter increases on the Temporary Queue not the named queues as I would 
expect....

Is this a defect, or am I missing a configuration property with the named 
queues?

Original comment by nicholas...@gmail.com on 18 Oct 2012 at 4:29

GoogleCodeExporter commented 9 years ago 
Would you be able to check if the error occurs with HSQL or other database?

Original comment by tsera...@bluesoft.net.pl on 27 Nov 2012 at 10:12

GoogleCodeExporter commented 9 years ago

Original comment by tsera...@bluesoft.net.pl on 28 Nov 2012 at 12:18

GoogleCodeExporter commented 9 years ago

Original comment by tsera...@bluesoft.net.pl on 29 Nov 2012 at 10:35

GoogleCodeExporter commented 9 years ago 
since 2.4

The problem relates to comparison LOBs object in Oracle database.

Original comment by tsera...@bluesoft.net.pl on 29 Nov 2012 at 11:07