OS: Oracle Linux 7.9
Java-Runtime-Version: 17.0.13
JasperReports-Version: 6.20.6
Tomcat version: 9.0.95
Database: Oracle Database 19.3.0.0.0
Made by: js-studiocomm_6.21.0_windows_x86_64
This is the log of the Report
16:37:23 [INFO] jasper.webapp.ReportWrapper.service - *** servlet /report START
16:37:23 [INFO] oc.servlet.ServletUtilities.logRequestParameters - Request parameters:
16:37:23 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repName: REPORTRUNNEW
16:37:23 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repFormat: pdf
16:37:23 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _dataSource: bmtfqa
16:37:23 [INFO] oc.servlet.ServletUtilities.logRequestParameters - printDebugToScreen: true
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - URL parameters including defaults:
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - dataSource=bmtfqa
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - repName=REPORTRUNNEW
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - repFormat=pdf
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - repLocale=de_DE
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - repEncoding=UTF-8
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - repTimeZone=Asia/Dhaka
16:37:23 [DEBUG] jasper.webapp.URLCallInterface.<init> - input values asserted
16:37:23 [DEBUG] oc.jasper.ReportUtilities.compileJRXMLIfNecessary - search for report REPORTRUNNEW in reportsPath: /u02/JRI211Jasper620/conf/../reports
16:37:23 [DEBUG] oc.jasper.ReportUtilities.getReportDefinitionFile - search for report REPORTRUNNEW in reportsPath: /u02/JRI211Jasper620/conf/../reports
16:37:23 [INFO] jasper.webapp.ReportWrapper.service - using report file: /u02/JRI211Jasper620/conf/../reports/REPORTRUNNEW.jasper
16:37:23 [DEBUG] jasper.webapp.ReportWrapper.service - set parameter BaseDir:/u02/JRI211Jasper620/conf/../reports
16:37:23 [DEBUG] jasper.webapp.ReportWrapper.service - set parameter SUBREPORT_DIR:/u02/JRI211Jasper620/conf/../reports/
16:37:23 [DEBUG] jasper.webapp.ReportWrapper.service - set parameter REPORT_LOCALE:de_DE
16:37:23 [DEBUG] jasper.webapp.ReportWrapper.service - set report timezone:Asia/Dhaka
16:37:23 [DEBUG] oc.db.ConnectionUtility.getConnection - use JDBC to lookup dataSource:bmtfqa
16:37:23 [DEBUG] oc.db.ConnectionUtility.getConnection - initial pool size: 5
16:37:23 [DEBUG] oc.db.ConnectionUtility.getConnection - min pool size: 5
16:37:23 [DEBUG] oc.db.ConnectionUtility.getConnection - max pool size: 50
16:37:23 [INFO] oc.db.ConnectionUtility.getConnection - successfully connected to jdbc:oracle:thin:@192.168.0.204:1521/hrmdb with user: bmtf_hr_qa
16:37:23 [DEBUG] jasper.webapp.ReportWrapper.service - fill report
16:37:23 [DEBUG] engine.fill.BaseReportFiller.<init> - Fill 1: created for contra_vouchar_version6
16:37:23 [DEBUG] engine.fill.BaseReportFiller.<init> - created delayed actions 1 for filler 1
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: BACKGROUND} for band 702253472
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: TITLE} for band 1255331508
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: PAGE_HEADER} for band 785478250
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: COLUMN_HEADER} for band 1639479514
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: DETAIL} for band 927031172
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: COLUMN_FOOTER} for band 198480484
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: PAGE_FOOTER} for band 925919627
16:37:23 [DEBUG] engine.fill.JRFillBand.setOrigin - Origin {reportName: null, groupName: null,bandType: SUMMARY} for band 491014771
16:37:23 [DEBUG] engine.fill.JRVerticalFiller.setPageHeight - Filler 1 - pageHeight: 842, columnFooterOffsetY: 688, lastPageColumnFooterOffsetY: 777
16:37:23 [DEBUG] engine.fill.JRBaseFiller.fill - Fill 1: filling report
16:37:23 [DEBUG] engine.fill.JRBaseFiller.getMaxPageWidth - max page width is 2097152000
16:37:23 [DEBUG] engine.fill.JRFillDataset.createQueryDatasource - Fill 1: Creating SQL query executer
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.<init> - DB is Oracle version Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0 (19/0)
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.<init> - driver is Oracle JDBC driver version 21.4.0.0.1 (21/4)
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.<init> - jdbc 4/2
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.<init> - connection URL is jdbc:oracle:thin:@192.168.0.204:1521/hrmdb
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - system timezone is sun.util.calendar.ZoneInfo[id="Asia/Dhaka",offset=21600000,dstSavings=0,useDaylight=false,transitions=8,lastRule=null]
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - report timezone is sun.util.calendar.ZoneInfo[id="Asia/Dhaka",offset=21600000,dstSavings=0,useDaylight=false,transitions=8,lastRule=null]
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC timezone parameter is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC timezone property is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC parameters timezone parameter is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC parameters timezone property is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - parameters timezone null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC fields timezone parameter is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - JDBC fields timezone property is null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.setTimeZone - fields timezone null
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.createStatement - SQL query string: WITH title AS (
SELECT ud_voucher_no,
voucher_dt,
narration,
fnc_empname(entered_by) AS prepared_by,
chq_no,
TO_CHAR(chq_date, 'DD-Mon-YYYY') AS chq_dt,
SUM(NVL(debit, 0)) AS total_debit,
SUM(NVL(credit, 0)) AS total_credit
FROM fn_vwvouchers
WHERE company_no = 1
AND auto_voucher_no ='M241101000729'
GROUP BY ud_voucher_no, voucher_dt, narration, entered_by, chq_no, chq_date
),
report AS (
SELECT ROWNUM AS RN,
UD_AC_NO,
UD_AC_NAME,
(CASE WHEN NVL(AMOUNT, 0) < 0 THEN 0 - NVL(AMOUNT, 0) END) AS DEBIT_AMOUNT,
(CASE WHEN NVL(AMOUNT, 0) > 0 THEN NVL(AMOUNT, 0) END) AS CREDIT_AMOUNT
FROM FN_VWVOUCHERS VR
WHERE COMPANY_NO = 1
AND AUTO_VOUCHER_NO = 'M241101000729'
ORDER BY (CASE WHEN NVL(AMOUNT, 0) < 0 THEN 0 ELSE 1 END)
),
header AS (
SELECT logo,
rpt_h1,
rpt_h2,
company_name,
address,
phone,
fax,
web_site
FROM hpmsv_reporting
WHERE COMPANY_NO = 1
),
IN_WORD AS (
SELECT SPELL_OUT(SUM(NVL(credit, 0))) AS spell_out
FROM FN_VWVOUCHERS vr
WHERE company_no = 1
AND auto_voucher_no = 'M241101000729'
)
select * from title a, report b,header c,IN_WORD D
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.createDatasource - Executing query
16:37:23 [DEBUG] engine.query.JRJdbcQueryExecuter.createDatasource - Query execution done
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field UD_VOUCHER_NO has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field VOUCHER_DT has type 93/DATE, class java.sql.Timestamp
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getFieldCalendar - calendar for field VOUCHER_DT is null
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.readTimestamp - timestamp field VOUCHER_DT is 2024-11-05 00:00:00.0 (1730743200000)
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field NARRATION has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field PREPARED_BY has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field CHQ_NO has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field CHQ_DT has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field TOTAL_DEBIT has type 2/NUMBER, class java.math.BigDecimal
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field TOTAL_CREDIT has type 2/NUMBER, class java.math.BigDecimal
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field RN has type 2/NUMBER, class java.math.BigDecimal
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field UD_AC_NO has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field UD_AC_NAME has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field DEBIT_AMOUNT has type 2/NUMBER, class java.math.BigDecimal
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field CREDIT_AMOUNT has type 2/NUMBER, class java.math.BigDecimal
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field LOGO has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field RPT_H1 has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field RPT_H2 has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field COMPANY_NAME has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field ADDRESS has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field PHONE has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field FAX has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field WEB_SITE has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] jasperreports.engine.JRResultSetDataSource.getColumnIndex - field SPELL_OUT has type 12/VARCHAR2, class java.lang.String
16:37:23 [DEBUG] engine.fill.JRBaseFiller.addPage - Fill 1: adding page 1
16:37:23 [DEBUG] engine.fill.JRVerticalFiller.fillTitle - Fill 1: title at 20
16:37:23 [DEBUG] engine.fill.SimpleTextLineWrapper.createElementFontInfosFillCache - creating element font infos cache of size 2000
16:37:23 [DEBUG] engine.fill.JRFillDataset.closeQueryExecuter - Fill 1: closing query executerThe log just ends here, and I get "Please contact your local administrator." on screen.
This is my "application.properties" file.
#====================================================================
# Application properties (global)
#====================================================================
[application]
configFileVersion=2.9.0
# set the jndiPrefix, this is different for different
# containers, e.g.
# for Glassfish: jndiPrefix=jdbc/
# for Tomcat : jndiPrefix=java:comp/env/jdbc/
jndiPrefix=java:comp/env/jdbc/
# infoPageIsEnabled will show the initial start page of the j2ee application
# including testing and the environment settings
infoPageIsEnabled=true
# this parameter is limiting access to the integration for the
# specified list of ip addresses, e.g.:
# ipAddressesAllowed=127.0.0.1,10.10.10.10,192.168.178.31
# if the list is empty, ALL addresses are allowed
# ipAddressesAllowed=0:0:0:0:0:0:0:1
# report definition files will be looked up in the following order as
# specified by the reportsPath, e.g.:
# Linux/macOS: reportsPath=../reports,/path/to/reports1,/path/to/reports2,/path/to/reports3
# Windows: reportsPath=..\\reports,c:\\path\\to\\reports1,c:\\path\\to\\reports2,c:\\path\\to\\reports3
# If the reportsPath is left empty or not defined, then the default is "../reports" (*nix) or
# "..\\reports" (windows) respectively, will start from the location of the application.properties (this)
# file
reportsPath=
# To enable detailed request error messages, set printDebugToScreen=true
# When this setting enabled, any request that produces an error response includes a detailed message,
# including a stack trace.
# This setting must not be enabled on productions systems due to the risk of sensitive information being
# revealed to an attacker.
# The default value is false
#printDebugToScreen=true
#====================================================================
# JDBC datasource configuration
# http://www.orafaq.com/wiki/JDBC#Thin_driver
# type=jndi|jdbc
#====================================================================
[datasource:bmtf_hr]
type=jdbc
url=jdbc:oracle:thin:@192.168.0.204:1521/hrmdb
username=bmtf_hr
password=***
[datasource:bmtfqa]
type=jdbc
url=jdbc:oracle:thin:@192.168.0.204:1521/hrmdb
username=bmtf_hr_qa
password=***
[datasource:vat_apex]
type=jdbc
url=jdbc:oracle:thin:@192.168.0.204:1521/vatdb
username=vat_apex
password=***
[datasource:BCSL_VAT]
type=jdbc
url=jdbc:oracle:thin:@192.168.0.204:1521/vatdb
username=BCSL_VAT
password=***
# this parameter is limiting access to the integration for the
# specified list of ip addresses, e.g.:
# ipAddressesAllowed=127.0.0.1,10.10.10.10,192.168.178.31
# if the list is empty, ALL addresses are allowed
#====================================================================
# Native JNDI datasource, to be configured in the application server
# name: jndi_test
#====================================================================
#[datasource:jndi_test]
#type=jndi
#name=jndi_test
# this parameter is limiting access to the integration for the
# specified list of ip addresses, e.g.:
# ipAddressesAllowed=127.0.0.1,10.10.10.10,192.168.178.31
# if the list is empty, ALL addresses are allowed
#====================================================================
# JDBC datasource configuration
# http://www.orafaq.com/wiki/JDBC#Thin_driver
# additional jdbc configurations, please uncomment
#====================================================================
#[datasource:test]
#type=jdbc
#url=jdbc:oracle:thin:@127.0.0.1:1521:XE
#username=my_oracle_user
#password=my_oracle_user_pwd
# this parameter is limiting access to the integration for the
# specified list of ip addresses, e.g.:
# ipAddressesAllowed=127.0.0.1,10.10.10.10,192.168.178.31
# if the list is empty, ALL addresses are allowed
#====================================================================
# Direct printing
#====================================================================
[directPrinting]
isEnabled=false
# for debugging purposes does it make sense to display the
# print dialog ON THE SERVER before printing. You can even cancel the
# request through the print dialog
# DON'T do that in production (displayPrintDialog=true)!!!
displayPrintDialog=false
#====================================================================
# Save File on Server
#====================================================================
[saveFileOnServer]
isEnabled=false
# allow only certain directories on the server to write to
# Use "," to separate between path entries
# On Windows, use the regular path denomination, no escaping necessary,
# e.g.: C:\app\jri-downloads
# All directories have to be named explicitly, not recursive file
# paths are possible
#directoryWhitelist=/Users/daust/oc-jasper/tmp,/Users/daust/oc-jasper
#====================================================================
## Syntax for specifying properties:
## http://commons.apache.org/configuration/userguide/howto_basicfeatures.html#Basic_features_and_AbstractConfiguration
#====================================================================- replies 0
- views 81
- likes 0
-