Clarity PPM

Expand all | Collapse all

Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

Christopher Hackett08-18-2015 05:31 PM

  • 1.  Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 08-18-2015 05:26 PM

    Hello fellow community members,


    I thought I will go ahead and share some of the Jaspersoft troubleshooting tips I encountered with issues or whilst troubleshooting my servers. Please feel free to use them to solve your JS issues. I tried to organize them a little bit better, hopefully like this it will be easier for you to find and use the information. Enjoy!

    Jaspersoft Setup

     

    1. The Advanced Reporting server connects to its own ppm_jaspersoft database that holds some users and other JS server related information. If you recreate this database, you will have to reinstall Jaspersoft in order for it to be able to connect and function.

    2. For testing purposes, it's possible to replace the connection to Jaspersoft database, the details are in the file:

    $JSTomcat \webapps\reportservice\META-INF\context.xml

    To replace the connection,

    Replace the details on the connection, enter the pwd in non-encrypted way for Oracle, save and restart Jaspersoft.

    3.  If you want to reimport the PMO content, here are two ways to do it:

    a) If content has been already imported, run the command:

    admin content-jaspersoft csk upgrade -userName superuser –password superuser

    This will drop and reimport all the PMO content that is already imported. Please bear in mind that if you have created any custom content in CA Clarity folder, it will be dropped too. In order to preserve any custom reports, please ensure you create them as per best practices (outside of CA Clarity folder, recommended to use Shared folder for public, or User folder for non-public reports).

    b)To completely recreate and reimport the content from scratch, follow the steps below:

    Delete the organization from Jaspersoft server

    Create a new organization in CSA

    Save, and restart JS Tomcat 

    Recreate the keystore

    Import the content without the upgrade option

    admin content-jaspersoft csk -userName superuser –password superuser

    4. The keystore key is used to authenticate between Clarity PPM and Jaspersoft.

    Keystore when generated is saved here:

    $clarityppm/META-INF/reporting/store

    You may remove it from $clarityppm/config when copying over to $JSTomcat/webapps/reportservice/WEB-INF/config but you must not delete it from clarity\META-INF\reporting\store.

    Datasources

     

    The reporting server retrieves data from PPM and DWH database through a Bean connection (datasource imported on the server).  The datasources can be tested from the Advanced Reporting server, for this you have to open the Datasource connection, and click Test. Same can be done from Jaspersoft embedded UI too if a there is an issue with the connections.

     

    If a datasource doesn't test successfully, from Jaspersoft:

     

    1.            Check the ports are open and db accessible, and you are able to connect to db from JS server (with SQL plus or similar)

    2.            If yes, check the logs. Is there a difference when testing from JS or Clarity embedded UI?

    3.            To find out what happens, enable the debug logs in Jaspersoft on com.ca.jasper.jdbc (see above how to enable them)

    4.            Test the datasource, get the jasperserver.log and look for errors, or which line is incorrect

    5.            Also try recreating a JS datasource from Jaspersoft server :

    a.            Connect to JS server

    b.            Datasources - Create

    c.             Specify JDBC Driver, correct database details to connect to the server, then click on Test.

    See if this works. If it doesn't, check the log from this stage too. Here is an example screenshot of my connection:

     

    Debug

     

    Working with Jaspersoft debugging logs:

     

    1. To debug an issue:

     

    a) Connect to Jaspersoft console UI as superuser.

    b) Go to Manage - Server Settings - Log Settings

    c) At the bottom there will be an empty text box, enter the debug value, and select log mode to debug.

    d) Restart JS Tomcat if needed (depending on the exact issue)

    e) Observe the log:

     

    $JSTomcat/webapps/reportservice/WEB-INF/logs/jasperserver.log

     

     

     

    2.            To disable the debug messages:

     

    a) Connect to Jaspersoft console UI as superuser

    b) Go to Repository/System Properties/GlobalPropertiesList

    c) Remove the loggers

     

    3.  Modifying the logger file as indicated in some solutions found on Google :

    $JSTomcat/webapps/reportservice/WEB-INF/log4j.properties

    Does not work for Clarity Jaspersoft, all changes must go through UI as above.

     

     

    Jaspersoft Parameters Setup (ppmParameters)

     

    If you see that some of ppmParameters is incorrect, for example:

    2015-06-15 17:55:10,270 DEBUG EngineServiceImpl,http-apr-8081-exec-3:2261 - Setting report parameter ppmDBVendor to oracle

    2015-06-15 17:55:10,270 DEBUG EngineServiceImpl,http-apr-8081-exec-3:2261 - Setting report parameter ppmDBName to clarity

    2015-06-15 17:55:10,286 DEBUG EngineServiceImpl,http-apr-8081-exec-3:2261 - Setting report parameter ppmDBSchema to CLARITY142

    2015-06-15 17:55:10,286 DEBUG EngineServiceImpl,http-apr-8081-exec-3:2261 - Setting report parameter ppmAppServer to http://claritynam9/niku/nu

     

    The ppm parameters are saved on Jaspersoft level in the details for the user jasperadmin  (not ppmjasperadmin, just jasperadmin). Here is how it looks in UI:

       

     

    If any of those environmental details is incorrect in logs, this means that you will have to reset them.

    The properties are encrypted, so you will not be able to see the exact value in UI, but you can note when there is a difference when you update them with the command below.

    Run the command

    admin update jasperParameters

    This will reset the parameters on jasperadmin user to the ones set in the properties.xml file.

     

     

     

     

    Here is the link to my previous Jaspersoft tips in case you are interested:

     

    https://communities.ca.com/message/241783601#241783601

     

     

     

     

     

     



  • 2.  Re: Jaspersoft Tips and tricks : Version 2: How to troubleshoot Jaspersoft issues

    Posted 08-18-2015 05:31 PM

    Thanks for the tip Nika!



  • 3.  Re: Jaspersoft Tips and tricks : Version 2: How to troubleshoot Jaspersoft issues

    Posted 08-19-2015 03:41 AM

    Thanks for sharing this useful tip, NIka

     

    Regards

    NJ



  • 4.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 09-07-2015 07:40 AM

    Hi Nika,

     

    Thanks for sharing this.

     

    I have tried with the DEBUG method. however i could not find the log file at the location - $JSTomcat/webapps/reportservice/WEB-INF/logs/jasperserver.log

     

    Any idea ??

     

    Regards,

    Khushboo



  • 5.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 09-14-2015 11:31 AM

    Hi Khushboo

     

    Is your webservice named reportservice? We have encountered issues in which when you named the reportservice anything else than reportservice it's not creating the Jasperserver log.
    Do you have the folder $JSTomcat/webapps/reportservice/WEB-INF/logs just empty?

     

    Kind Regards

    Nika Hadzhikidi



  • 6.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 09-16-2015 03:05 AM

    Hi Nika,

     

    Yes, the name is other than reportservice. I got the solution from the post - https://communities.ca.com/thread/241738497?sr=stream

    Thanks for the response.

     

    Regards,

    Khushboo



  • 7.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 10:21 AM

    Hi Nika,

     

    We upgraded from 14.1. Our jaspersoft setup worked fine initially but we had some issues in upgrade so we did a fresh upgrade(recreated all schemas) again but now jaspersoft seems to have gone inconsistent and does not start. I feel reinstalling Jaspersoft will solve the issue. Can you tell what are the steps to reinstall? The key question I have is whether I need to recreate ppm_dwh and and ppm_jaspersoft schemas?

     

    Regards,

    Suhas

     

    LOG

     

    cat catalina.out

    Nov 30, 2015 9:38:44 AM org.apache.catalina.core.AprLifecycleListener init

    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib

    Nov 30, 2015 9:38:44 AM org.apache.coyote.AbstractProtocol init

    INFO: Initializing ProtocolHandler ["http-bio-9780"]

    Nov 30, 2015 9:38:44 AM org.apache.coyote.AbstractProtocol init

    INFO: Initializing ProtocolHandler ["ajp-bio-8009"]

    Nov 30, 2015 9:38:44 AM org.apache.catalina.startup.Catalina load

    INFO: Initialization processed in 857 ms

    Nov 30, 2015 9:38:44 AM org.apache.catalina.core.StandardService startInternal

    INFO: Starting service Catalina

    Nov 30, 2015 9:38:44 AM org.apache.catalina.core.StandardEngine startInternal

    INFO: Starting Servlet Engine: Apache Tomcat/7.0.55

    Nov 30, 2015 9:38:44 AM org.apache.catalina.startup.HostConfig deployDirectory

    INFO: Deploying web application directory /480fs01/tomcat_jasper/webapps/examples

    Nov 30, 2015 9:38:46 AM org.apache.catalina.startup.HostConfig deployDirectory

    INFO: Deployment of web application directory /480fs01/tomcat_jasper/webapps/examples has finished in 2,078 ms

    Nov 30, 2015 9:38:46 AM org.apache.catalina.startup.HostConfig deployDirectory

    INFO: Deploying web application directory /480fs01/tomcat_jasper/webapps/reportservice

    Nov 30, 2015 9:39:02 AM org.apache.catalina.startup.TaglibUriRule body

    INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined

    Nov 30, 2015 9:39:02 AM org.apache.catalina.startup.TaglibUriRule body

    INFO: TLD skipped. URI: http://www.tonbeller.com/jpivot/core is already defined

    Nov 30, 2015 9:39:03 AM org.apache.catalina.startup.TaglibUriRule body

    INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined

    15/11/30 09:39:03 INFO crypto.KeystoreManager: KeystoreManager constructor

    Creating ActionModelService object.

    Creating action model infrastructure.

    2015-11-30 09:39:26,592 ERROR JDBCExceptionReporter,localhost-startStop-1:101 - ORA-00942: table or view does not exist

     

     

    -- JasperServer:  EhCacheImpl shutdown called.  This normal shutdown operation.

    -- JasperServer:  EhCacheImpl calling cleanerTimer.cancel().  This normal shutdown operation.

    2015-11-30 09:39:26,886 ERROR ContextLoader,localhost-startStop-1:318 - Context initialization failed

    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id5_0_, this_.version as version5_0_, this_.uri as uri5_0_, this_.hidden as hidden5_0_, this_.name as name5_0_, this_.label as label5_0_, this_.description as descript7_5_0_, this_.parent_folder as parent8_5_0_, this_.creation_date as creation9_5_0_, this_.update_date as update10_5_0_ from JIResourceFolder this_ where (this_.uri=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

            at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)



  • 8.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 11:07 AM

    Hi Suhas,

     

    It looks like one of the Jaspersoft tables may be missing. I would rather reinstall Jaspersoft only at this point, and leave PPM_DWH as it is.  Please could you follow the steps to cleanly reinstall Jaspersoft:

     

    Clean Jaspersoft reinstall:

     

    1. Stop the Tomcat service
    2. Delete the Jaspersoft Tomcat instance ( the entire folder)
    3. Drop the PPM_JASPERSOFT schema from the database
    4. Now recreate the PPM_JASPERSOFT user as per the instructions in the Installation Guide
    5. Install a new Tomcat for Jaspersoft
    6. Navigate to your Jaspersoft installation files directory and start the Jaspersoft installation as per the Installation Guide:
    install
    7. Once the installation finished successfully, recreate the Jaspersoft keystore files.
    8. Then import the Jaspersoft PMO Content with the import command
    admin content-jaspersoft csk upgrade -userName superuser -password superuser -retryCount 50
    9. Restart Jaspersoft Tomcat
    10. Connect to Clarity PPM UI and run Create Jaspersoft Users job

     

    Please let me know how it goes.

     

    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer



  • 9.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 12:15 PM

    Thanks Nika, it worked

     

    Can you tell what admin content-jaspersoft csk upgrade command does with respect to the schemas?

     

    Regards,

    Suhas



  • 10.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 12:41 PM

    Hi Suhas,

     

    The import command would import the PMO Jaspersoft content in Jaspersoft. It mainly uses PPM_JASPERSOFT schema to import the data, but also utilizes the DWH database and connection, so it's important to have the Data Warehouse properly set up and configured in CSA when the import command is run.

     

    Please let me know for any questions.

     

    Kind Regards

     

    Nika Hadzhikidi

    CA Technologies

    Principal Support Engineer



  • 11.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 01:09 PM

    Thanks,

     

    all worked fine but

    Load datawarehouse fails with below error

     

    FYI: custom DB link is unchecked

     

    ERROR 2015-11-30 12:02:27,724 [Dispatch pool-5-thread-9 : (tenant=clarity)] dwh.event ETL Job Failed. Log details below:

    2015/11/30 12:02:27 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :

    2015/11/30 12:02:27 - dwh_db_check_ - Couldn't execute SQL: BEGIN

    2015/11/30 12:02:27 - dwh_db_check_ - DWH_CFG_PRE_CONFIG_SP(

    2015/11/30 12:02:27 - dwh_db_check_ - P_DBLINK => 'CLARITYDBLINK'

    2015/11/30 12:02:27 - dwh_db_check_ - );

    2015/11/30 12:02:27 - dwh_db_check_ - END;

    2015/11/30 12:02:27 - dwh_db_check_ -

    2015/11/30 12:02:27 - dwh_db_check_ - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02019: connection description for remote database not found

    2015/11/30 12:02:27 - dwh_db_check_ - ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 37

    2015/11/30 12:02:27 - dwh_db_check_ - ORA-06512: at line 2

    null



  • 12.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 02:54 PM

    After looking at the wiki,

     

    I created the custom Database link

     

    CREATE DATABASE LINK PPMDBLINK

    CONNECT TO user

    IDENTIFIED BY pwd

    USING 'SID';

     

    set CSA property to use custom DB link.

     

    And then ran the Load Dataware house job, still failed with error Entity not setup in Datawarehouse settings.

     

    I then went to general settings and selected the entity and now the job is running fine.



  • 13.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 11-30-2015 05:17 PM

    Great to hear all the issues are now solved, thanks for letting me know Suhas.



  • 14.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 12-01-2015 07:27 AM

    Thanks for this Nika, excellent content.



  • 15.  Re: Jaspersoft Tips and tricks : Part 2: How to troubleshoot Jaspersoft issues

    Posted 03-23-2017 11:59 AM

    Hi Nika,

     

    Hope you are doing fine, i have below two issues with Jaspersoft, was trying in all avenues but could not resolve.

     

    We were on Clarity 14.2 and Jasper 5.6.1 On premise. Migrating to Clarity 15.1 and Jasper 6.2.1 and also migrating servers to AWS.  having below issue any inputs are really appreciated.

     

    1. Very few reports are throwing this error, while running the report from UI. when scheduled running fine. also the CA PPM BEAN and CA PPM DWH BEAN are showing as test failed when i login to direct url (/reportservice).

     

    Error Details
    HTML response error code: 502, error

    HTML response was: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">

    Proxy Error

    The proxy server received an invalid response from an upstream server.
    The proxy server could not handle the request POST /reportservice/flow.html.

    Reason: Error reading from remote server

     

    2. Output to Host File system option not working | Jaspersoft Community 

    Output to Host File System option which used to work in 5.6.1 Even after doing this as suggested in Jasper documents it is not working.
     .../WEB-INF/applicationContext.xml enableSaveToHostFS Set the value from "false" (the default) to "true".
    Also uncommented the code in these files: ./webapps/reportservice/optimized-scripts/bower_components/jrs-ui/src/scheduler/template/editor/outputTabTemplate.htm ./webapps/reportservice/scripts/bower_components/jrs-ui/src/scheduler/template/editor/outputTabTemplate.htm
    Any help is appreciated!