Birt 2.5.2 report generates empty table data when run from a cron job

Posted by Trueblood on Stack Overflow See other posts from Stack Overflow or by Trueblood
Published on 2010-05-19T16:25:14Z Indexed on 2010/05/20 0:50 UTC
Read the original article Hit count: 440

Filed under:

birt

|

clearquest

|

cron

|

shell

|

script

I've got a shell script that runs genReport.sh in order to create a .pdf formatted report, and it works perfectly when it's run from the command line. The data source for the report is a ClearQuest database.

When it's run from a CRON job the .pdf file is created, except that only the various report and column headers are displayed, and the data of the report is missing. There are no errors reported to STDERR during the execution of the script.

This screams "environment variable" to me.

Currently, the shell script is defining the following:

CQ_HOME
BIRT_HOME
ODBCINI
ODBCINST
LD_LIBRARY_PATH

If it's an environmental thing, what part of the environment am I missing?

© Stack Overflow or respective owner

Related posts about birt

Facing Null Pointer Exception while using BIRT

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using BIRT APIs in a java program.My code is : package com.tecnotree.mdx.product.utils; import java.util.HashMap; import java.util.logging.Level; import org.eclipse.birt.core.exception.BirtException; import org.eclipse.birt.core.framework.Platform; import org.eclipse.birt.report.engine… >>> More
Formation Actuate BIRT gratuite le 11 juin à Paris, pour apprendre à faire des rapports avec BIRT Open Source et BIRT iHub

as seen on Developper.com - Search for 'Developper.com'
Il s'agit d'une journée de formation gratuite avec des démos et des ateliers pour apprendre à faire des rapports interactifs, Ad Hoc, OLAP en mémoire, dashboards, mashboards avec BIRT Open Source et BIRT iHub. BIRT (Business Intelligence and Reporting Tools) est un projet open source de la fondation… >>> More
BIRT vs Jasper Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I goggled for 2 hours to find what shall I use. I found that both are good and have good community. BIRT is supported by IBM, IBM integrated Tivoli reports with it. This proves it is good and will keep growing. Jasper Reports has fairly bid community and (probably) a better report designed… >>> More
BIRT number to word as computed column

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi fellow programmer I want to ask how to add a computed column in BIRT that compute a number to its word representation? (ex. 100 to "one hundred") So in my data set I can have a column that holds the string I'm new at BIRT hopefully there's a pointer or two for me >>> More
Eclipse BIRT: Problem with number of rows in a dataset

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello!:-) My new Problem is the following: An sql-query to a database (DB2) returns 1500 rows but BIRT shows me only 500 in the dataset-editior. To count them i used a computed column (Integer) with the following logic: Total.count(row["VPK"]) I'm using the RCP-Designer (BIRT 2.1.3). How can i get… >>> More

Related posts about clearquest

Clearquest Database Timeout

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a tool that is setup to query our Clearquest Database to return information to the user automatically every 9000 milliseconds. I came in today and the connection had timed out over the weekend, I found in the oSession object a "check heartbeat" function, but I'm not sure that is what I want… >>> More
TFS Integration with Rational ClearQuest and Requirement Manager

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on an integration approach for integrating Rationa (IBM Jazz) Requirement Manager (RM) and Clear Quest (CQ) with TFS. As the teams are moving from ClearCase to TFS, what we are looking at is still being able to manage the requirements in RM and manage testing using CQ. The flow will… >>> More
Show SQL query results in Sharepoint

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All I support Rational clearquest for my company and have been asked to show some of the data in Sharepoint. I can query the data in Clearquest no problem (Using Toad) but have no idea about how to go displaying it in Sharepoint. The data I'm querying contains dates and ideally I'd like to be… >>> More
Birt 2.5.2 report generates empty table data when run from a cron job

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a shell script that runs genReport.sh in order to create a .pdf formatted report, and it works perfectly when it's run from the command line. The data source for the report is a ClearQuest database. When it's run from a CRON job the .pdf file is created, except that only the various report… >>> More
How to manage two separate testing teams using different test tracking tools

as seen on Super User - Search for 'Super User'
I have two independent testing teams currently testing the same application. One team is using ClearQuest, and the other is using Mantis. It has been a huge effort to manage all of the duplicate reported bugs. What options would improve this situation? My constraint is that the ClearQuest team will… >>> More