nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

I am getting this error on Tomcat server

hamsa

Hi

Pls help me on this error.

Table table:
- Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11. (Element ID:11)
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11. (Element ID:11)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:164)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:780)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:661)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Find more posts tagged with

Comments

hamsa

import java.io.IOException; 
import java.util.ArrayList; 
 
import org.eclipse.birt.core.framework.Platform; 
import org.eclipse.birt.report.model.api.CellHandle; 
import org.eclipse.birt.report.model.api.DataItemHandle; 
import org.eclipse.birt.report.model.api.DesignConfig; 
import org.eclipse.birt.report.model.api.ElementFactory; 
import org.eclipse.birt.report.model.api.IDesignEngine; 
import org.eclipse.birt.report.model.api.IDesignEngineFactory; 
import org.eclipse.birt.report.model.api.LabelHandle; 
import org.eclipse.birt.report.model.api.OdaDataSetHandle; 
import org.eclipse.birt.report.model.api.OdaDataSourceHandle; 
import org.eclipse.birt.report.model.api.PropertyHandle; 
import org.eclipse.birt.report.model.api.ReportDesignHandle; 
import org.eclipse.birt.report.model.api.RowHandle; 
import org.eclipse.birt.report.model.api.SessionHandle; 
import org.eclipse.birt.report.model.api.SlotHandle; 
import org.eclipse.birt.report.model.api.StructureFactory; 
import org.eclipse.birt.report.model.api.TextItemHandle; 
import org.eclipse.birt.report.model.api.TableHandle; 
import org.eclipse.birt.report.model.api.ListHandle; 
import org.eclipse.birt.report.model.api.SharedStyleHandle; 
import org.eclipse.birt.report.model.api.activity.SemanticException; 
import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn; 
import org.eclipse.birt.report.model.api.StyleHandle; 
import org.eclipse.birt.report.model.api.elements.structures.HighlightRule; 
 
import com.ibm.icu.util.ULocale; 
import org.eclipse.birt.report.model.api.elements.DesignChoiceConstants; 
 
/** 
* Use the Design Engine API (model api) to design a report instead of the 
* BIRT designer. This class will generate a similar report as 
* derby_sample.rptdesign that was created using the Eclipse BIRT designer. 
*/ 
public class SampleDEAPIReport 
{ 
ReportDesignHandle designHandle = null; 
ElementFactory designFactory = null; 
StructureFactory structFactory = null; 
 
public static SessionHandle setup() 
{ 
 
//Configure the Engine and start the Platform 
DesignConfig config = new DesignConfig( ); 
config.setProperty("BIRT_HOME", System.getProperty("BIRT_HOME")); 
IDesignEngine engine = null; 
try{ 
Platform.startup( config ); 
IDesignEngineFactory factory = (IDesignEngineFactory) Platform 
.createFactoryObject( IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY ); 
engine = factory.createDesignEngine( config ); 
 
}catch( Exception ex){ 
ex.printStackTrace(); 
} 
SessionHandle session = engine.newSessionHandle( ULocale.ENGLISH ) ; 
return session; 
} 
 
public static ReportDesignHandle createReport(SessionHandle session) 
{ 
// create a design or a template 
ReportDesignHandle reportDesignHandle = session.createDesign(); 
 
return reportDesignHandle; 
} 
 
 
 
public static void main( String[] args ) 
{ 
try 
{ 
String qry = "select SAMP.DEPARTMENT.DEPTNAME,SAMP.EMPLOYEE.FIRSTNME,SAMP.EMPLOYEE.LASTNAME,SAMP.EMPLOYEE.JOB,CHAR(SAMP.EMPLOYEE.HIREDATE) as Hiredate,SAMP.EMPLOYEE.SALARY,SAMP.EMPLOYEE.BONUS,SAMP.EMPLOYEE.COMM"+ 
" from SAMP.EMPLOYEE, SAMP.DEPARTMENT where SAMP.DEPARTMENT.DEPTNO = SAMP.EMPLOYEE.WORKDEPT order by SAMP.DEPARTMENT.DEPTNAME"; 
String dataSourceName = "Sample Derby"; 
String dataSetName ="Sample Derby Data Set"; 
 
SessionHandle session = setup(); 
ReportDesignHandle reportDesignHandle = createReport(session); 
 
addDataSource(reportDesignHandle,dataSourceName,"org.apache.derby.jdbc.EmbeddedDriver","jdbc:derby:C:/birt/demo/sample","APP","PWD"); 
buildDataSet(reportDesignHandle,dataSetName,dataSourceName,qry); 
 
ElementFactory elementFactory = reportDesignHandle.getElementFactory(); 
 
// Create Styles. 
StyleHandle labelStyle = elementFactory.newStyle( "headerLabel" ); 
labelStyle.setProperty( StyleHandle.FONT_WEIGHT_PROP, 
DesignChoiceConstants.FONT_WEIGHT_BOLD ); 
labelStyle.setProperty( StyleHandle.FONT_FAMILY_PROP, "Andalus" ); 
labelStyle.setProperty( StyleHandle.COLOR_PROP, "red" ); 
labelStyle.setProperty( StyleHandle.BACKGROUND_COLOR_PROP,"aqua"); 
labelStyle.setProperty( StyleHandle.FONT_SIZE_PROP,"larger" ); 
labelStyle.setProperty( StyleHandle.COLOR_PROP, "red" );//$NON-NLS-1$ 
reportDesignHandle.getStyles( ).add( labelStyle ); 
 
 
StyleHandle detailStyle = elementFactory.newStyle( "detailStyle" ); 
detailStyle.setProperty( StyleHandle.FONT_WEIGHT_PROP, 
DesignChoiceConstants.FONT_WEIGHT_BOLD ); 
detailStyle.setProperty( StyleHandle.BACKGROUND_COLOR_PROP,"#C0C0C0"); 
detailStyle.setProperty( StyleHandle.TEXT_ALIGN_PROP,"center"); 
PropertyHandle highlightRules = detailStyle.getPropertyHandle("highlightRules"); 
 
 
HighlightRule rules = StructureFactory.createHighlightRule(); 
rules.setOperator("eq"); 
rules.setProperty("backgroundColor","#80FFFF"); 
rules.setTestExpression("Total.runningCount() % 2"); 
rules.setValue1("0"); 
highlightRules.addItem(rules); 
reportDesignHandle.getStyles( ).add( detailStyle ); 
StyleHandle dateStyle = elementFactory.newStyle( "dateStyle" ); 
dateStyle.setDateTimeFormat("DD_MM_YYYY"); 
dateStyle.setDateTimeFormatCategory("Medium Date"); 
//dateStyle.setD 
reportDesignHandle.getStyles( ).add( dateStyle ); 
 
 
TextItemHandle text = elementFactory.newTextItem("text"); 
text.setContent("Employee Report"); 
reportDesignHandle.getComponents().add(text); 
 
// create a new table in the report with 5 columns 
TableHandle table = elementFactory.newTableItem( "table", 5 ); 
table.setWidth( "100%" ); 
 
// associate the dataset for this table 
table.setDataSet( reportDesignHandle.findDataSet(dataSetName ) ); 
 
// columns that are retrieved as part of the query in dataset 
String[] cols ={ 
"DEPTNAME", 
"FIRSTNME", 
"LASTNAME", 
"JOB", 
"HIREDATE", 
"SALARY", 
"BONUS", 
"COMM" 
}; 
 
// columns that are used in the report 
String[][] reportCols ={ 
{"DEPTNAME","Dept Name"}, 
{"LASTNAME","Last Name"}, 
{"JOB","Job"}, 
{"HIREDATE","Hire Date"}, 
{"Total Income","Total Income"} 
}; 
 
// Set Column Bindings 
PropertyHandle computedSet = table.getColumnBindings( ); 
ComputedColumn cs1 = null; 
 
// DEPTNAME expression. 
cs1 = StructureFactory.createComputedColumn(); 
cs1.setName(reportCols[0][0]); 
cs1.setExpression("var newOutput = dataSetRow[\"DEPTNAME\"].substr(0,1);"+ 
"var input = dataSetRow[\"DEPTNAME\"].substr(1).toLowerCase();"+ 
"var j;"+ 
"for(i = 0;i<=input.length; i++) {"+ 
"if(input.charAt(i)==\" \") {"+ 
"newOutput = newOutput + input.charAt(i) + input.charAt(i+1).toUpperCase();"+ 
"j = i + 1;"+ 
"}else {if(i!=j) {newOutput = newOutput + input.charAt(i);}}}newOutput;"); 
computedSet.addItem(cs1); 
 
for( int i=1; i < cols.length; i++){ 
cs1 = StructureFactory.createComputedColumn(); 
cs1.setName(cols); 
cs1.setExpression("dataSetRow[\"" + cols + "\"]"); 
computedSet.addItem(cs1); 
} 
 
// Computed Column 
cs1 = StructureFactory.createComputedColumn(); 
cs1.setName("Total Income"); 
cs1.setExpression("row[\"SALARY\"]+row[\"BONUS\"]+row[\"COMM\"]"); 
computedSet.addItem(cs1); 
 
// get the table header 
RowHandle tableheader = (RowHandle) table.getHeader( ).get( 0 ); 
 
// associate the columns in the header row. 
for( int i=0; i < reportCols.length; i++){ 
LabelHandle label1 = elementFactory.newLabel( reportCols[1]); 
label1.setStyleName("headerLabel"); 
label1.setText(reportCols[1]); 
CellHandle cell = (CellHandle) tableheader.getCells( ).get( i ); 
cell.getContent( ).add( label1 ); 
} 
 
// HighlightRules 
HighlightRule incomeRule = StructureFactory.createHighlightRule(); 
incomeRule.setOperator("le"); 
incomeRule.setProperty("backgroundColor","#FF0000"); 
incomeRule.setProperty("fontStyle","italic"); 
 
incomeRule.setTestExpression("row[\"Total Income\"]"); 
incomeRule.setValue1("25000"); 
 
// table detail 
RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 ); 
for( int i=0; i < reportCols.length; i++){ 
CellHandle cell = (CellHandle) tabledetail.getCells( ).get( i ); 
DataItemHandle data = elementFactory.newDataItem( "data_"+reportCols[0] ); 
data.setResultSetColumn(reportCols[0]); 
if(reportCols[0].equalsIgnoreCase("LASTNAME") || 
reportCols[0].equalsIgnoreCase("Total Income") ) 
{ 
cell.getPropertyHandle("highlightRules").addItem(incomeRule); 
 
} 
if(reportCols[0].equalsIgnoreCase("HIREDATE")) 
{ 
data.setStyleName("dateStyle"); 
cell.setStyleName("dateStyle"); 
} 
 
cell.getContent( ).add( data ); 
} 
 
tabledetail.setStyleName("detailStyle"); 
 
 
// format the date element , ie the fourth column. 
 
// Create a label 
LabelHandle label = reportDesignHandle.getElementFactory().newLabel(null); 
 
// Set the properties for the heading 
label.setStringProperty("fontSize", "24pt"); 
label.setStringProperty("fontWeight", "bold"); 
label.setStringProperty("marginTop", "2pt"); 
label.setStringProperty("marginBottom", "5pt"); 
label.setStringProperty("textAlign", "center"); 
label.setStringProperty("color","blue"); 
// The text property 
label.setText("Employee Report 2"); 
 
// get the body of the report 
SlotHandle body = reportDesignHandle.getBody(); 
 
// add the report caption label to the body of the report 
body.add(label); 
 
// add the table 
reportDesignHandle.getBody( ).add( table ); 
reportDesignHandle.saveAs( "c:/techstack/addons/apache/webapps/BIRT/report/sampledeapi.rptdesign" ); //$NON-NLS-1$ 
reportDesignHandle.close( ); 
 
} 
catch ( IOException e ) 
{ 
e.printStackTrace(); 
} 
catch ( SemanticException e ) 
{ 
e.printStackTrace(); 
} 
} 
 
/** 
* Build data source. 
* @throws SemanticException 
*/ 
public static void addDataSource(ReportDesignHandle hdl,String dsName,String driver,String url,String user, String pwd) 
throws SemanticException 
{ 
OdaDataSourceHandle dsHdl = (OdaDataSourceHandle)hdl.findDataSource(dsName); 
if (dsHdl == null ) 
{ 
dsHdl = hdl.getElementFactory().newOdaDataSource( 
dsName, "org.eclipse.birt.report.data.oda.jdbc" ); 
// add the newly created data source 
hdl.getDataSources().add(dsHdl); 
} 
 
// update the properties of the datasource 
dsHdl.setProperty( "odaDriverClass",driver); 
dsHdl.setProperty( "odaURL", url); 
dsHdl.setProperty( "odaUser", user); 
dsHdl.setProperty( "odaPassword", pwd ); 
 
} 
 
void print(String msg) 
{ 
System.out.println(msg); 
} 
 
/** 
* Build the query ( data set to use in the report). 
*/ 
static void buildDataSet(ReportDesignHandle hdl,String dataSetName,String dataSourceName,String qry) 
throws SemanticException 
{ 
OdaDataSetHandle dataSetHandle = hdl.getElementFactory().newOdaDataSet( dataSetName,"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" ); 
dataSetHandle.setDataSource( dataSourceName ); 
dataSetHandle.setQueryText( qry ); 
 
PropertyHandle computedSet = dataSetHandle.getPropertyHandle( OdaDataSetHandle.COMPUTED_COLUMNS_PROP ); 
// Structure of the computed Column. 
ComputedColumn computedCol = StructureFactory.createComputedColumn();//"ComputedColumns"); 
computedCol.setName("Total Income"); 
computedCol.setExpression("row[\"SALARY\"]+row[\"BONUS\"]+row[\"COMM\"]"); 
computedCol.setDataType("decimal"); 
computedSet.addItem( computedCol ); 
 
hdl.getDataSets( ).add( dataSetHandle ); 
} 
 
}

JasonW

Do you have the derby jar in the web-inf/lib? If you are using 3.7 or higher of birt you do not need to set a birt home.
//only for osgi runtime. The default for 3.7 > is a POJO runtime
//config.setProperty("BIRT_HOME", System.getProperty("BIRT_HOME"));

Jason

hamsa

Thanks for help. I will check that jar. In Tomcat server i need to check right.

Thanks
Hamsa