[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: sraavsarma.spw
Forum Index » Profile for sraavsarma.spw » Messages posted by sraavsarma.spw
Author Message
Hi,
it’s a memory problem.. You should give more space to the Java Heap..
If you are using tomcat server, open the file Catalina.sh (if you are running SpagoBI in a unix system) or Catalina.bat (if you are running SpagoBI in a windows system) and search for the line

JAVA_OPTS="$JAVA_OPTS -Xms512m -Xmx512m -XX:MaxPermSize=256m

Now increase the –Xmx . Give it the value 1024m
Create New Composed Document in Business Analysis>Cockpit.
open it and just Add Document and drag what ever Reports or charts into it and deploy into server.Hope this helps you.
Hi everyone, I need documentation for deploying spagoBI into JBoss Server.I have followed one pdf as posted in forum but unfortunately server failed to start.That documentation applied for spago 2.1 version but am using spagoBI 3.6 and JBoss version is 6.1 Final.Please help me out.
Hi Experts ,
can anybody help me!!!
I dont know how to pass parameters to the chart dynamically, if suppose i have table called TRANSACTION contains AMOUNT & DATE fields , now i want to give DATE as dynamic parameter value, based on date i need to fetch amount details on that particular day transaction.
is there any way to give parameter like in I REPORT parameter????
Hi..thank you so much its working fine in PDF upto 5 lakh records but getting same issue in XLXS. And more over I need to change PDF page size.My data is long by default its taking in A4 size I hope. The data is coming in messy manner means very conjusted. So I need to change page size,Where can I modify it?


Hi to all,
I need solution for exporting records more than 25 thousand either in PDF or XLS.
Even I have changed some parameters in qbe.xml but of no use. I have given task to export 1 lakh records. please help me out.
Hi
working on All in One(3.6)
Using JDK1.6 only. yes in application server.
Hi
My workspace environment as follows:

1.SpagoBI 3.6 version,
2.Oracle SQL Developer
3. Cent os(Linux-64 bit)


Log in SpagoBI QBE Engine

08 Apr 2013 18:15:45,059 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:96 - The error full stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineServiceException: An unpredicted error occurred while executing SET_WORKSHEET_DEFINITION_ACTION service.
The root cause of the error is: Could not initialize class it.eng.spagobi.engines.worksheet.widgets.CrosstabDefinition
at it.eng.spagobi.utilities.engines.SpagoBIEngineServiceExceptionHandler.getWrappedException(SpagoBIEngineServiceExceptionHandler.java:77)
at it.eng.spagobi.engines.worksheet.services.designer.SetWorkSheetDefinitionAction.service(SetWorkSheetDefinitionAction.java:52)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class it.eng.spagobi.engines.worksheet.widgets.CrosstabDefinition
at it.eng.spagobi.engines.qbe.crosstable.serializer.json.CrosstabJSONDeserializer.deserialize(CrosstabJSONDeserializer.java:55)
at it.eng.spagobi.engines.qbe.crosstable.serializer.json.CrosstabJSONDeserializer.deserialize(CrosstabJSONDeserializer.java:2
at it.eng.qbe.serializer.SerializationManager.deserialize(SerializationManager.java:39)
at it.eng.spagobi.engines.worksheet.serializer.json.WorkSheetJSONDeserializer.deserializeContent(WorkSheetJSONDeserializer.java:191)
at it.eng.spagobi.engines.worksheet.serializer.json.WorkSheetJSONDeserializer.deserializeSheet(WorkSheetJSONDeserializer.java:176)
at it.eng.spagobi.engines.worksheet.serializer.json.WorkSheetJSONDeserializer.deserializeSheets(WorkSheetJSONDeserializer.java:14
at it.eng.spagobi.engines.worksheet.serializer.json.WorkSheetJSONDeserializer.deserialize(WorkSheetJSONDeserializer.java:72)
at it.eng.spagobi.engines.worksheet.serializer.json.WorkSheetJSONDeserializer.deserialize(WorkSheetJSONDeserializer.java:42)
at it.eng.qbe.serializer.SerializationManager.deserialize(SerializationManager.java:39)
at it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction.updateWorksheetDefinition(AbstractWorksheetEngineAction.java:451)
at it.eng.spagobi.engines.worksheet.services.designer.SetWorkSheetDefinitionAction.service(SetWorkSheetDefinitionAction.java:49)
... 22 more
Hi....when am about generate BAR/PIE/PIVOT table in QBE worksheet am getting an error like


An unpredicted error occurred while executing SET_WORKSHEET_DEFINITION_ACTION service. The root cause of the error is: Could not initialize class it.eng.spagobi.engines.worksheet.widgets.CrosstabDefinition


Caused by: java.lang.NoClassDefFoundError: Could not initialize class it.eng.spagobi.engines.worksheet.widgets.CrosstabDefinition
at it.eng.spagobi.engines.qbe.crosstable.serializer.json.CrosstabJSONDeserializer.deserialize(CrosstabJSONDeserializer.java:55)
at it.eng.spagobi.engines.qbe.crosstable.serializer.json.CrosstabJSONDeserializer.deserialize(CrosstabJSONDeserializer.java:2
at it.eng.qbe.serializer.SerializationManager.deserialize(SerializationManager.java:39)
at it.eng.spagobi.engines.worksheet.services.runtime.LoadCrosstabAction.service(LoadCrosstabAction.java:117)
... 22 more
Ya I have changed that to maximum value,after changing I can be able to save upto 20-22 thousands only.My task is to save approximately 5 lakhs records in PDF/XLS


Anyway thanks for reply.
Hii Arasheed, while clicking on Worksheet preview in Pivot Table I got an error could you help me out in this issue please


An unpredicted error occurred while executing SET_WORKSHEET_DEFINITION_ACTION service. The root cause of the error is: Could not initialize class it.eng.spagobi.engines.worksheet.widgets.CrosstabDefinition
use jdk 1.6 I think you may resolve that issue.Spago is not support to jdk1.7
is it possible to export records more than 10000 in spagobi??Either in XLS or PDF.
Hii....when am trying to export more than 10 thousand records to XLS in QBE, am getting a log as follows:


SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError: An unpredicted error occurred while executing EXPORT_RESULT_ACTION service.
The root cause of the error is: Java heap space
it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError: The error root cause is: Java heap space
it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError: The error root cause stack trace is:
java.lang.OutOfMemoryError: Java heap space
at org.apache.poi.poifs.storage.DocumentBlock.<init>(DocumentBlock.java:84)
at org.apache.poi.poifs.storage.DocumentBlock.<init>(DocumentBlock.java:70)
at org.apache.poi.poifs.filesystem.POIFSDocument.<init>(POIFSDocument.java:15
at org.apache.poi.poifs.filesystem.POIFSDocument.<init>(POIFSDocument.java:182)
at org.apache.poi.poifs.filesystem.DirectoryNode.createDocument(DirectoryNode.java:309)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocument(POIFSFileSystem.java:265)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1157)
at it.eng.spagobi.engines.qbe.services.core.ExportResultAction.exportIntoXLS(ExportResultAction.java:27
at it.eng.spagobi.engines.qbe.services.core.ExportResultAction.service(ExportResultAction.java:180)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Hi Sadiq,

Thank you so much for you quick reply...
 
Forum Index » Profile for sraavsarma.spw » Messages posted by sraavsarma.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team