Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Import Jaspersoft csk failed

  • 1.  Import Jaspersoft csk failed

    Posted May 18, 2017 05:00 PM
      |   view attached

    Dear Community
    I need your help
    We are doing a Jaspersoft installation  in our CA PPM 15.2, we get an error when we try to import  advance reporting content in the installation with this error : 


    --------------------------------------------------------- Failed to import content for tenant   com.ca.jasper.restAdapter.JasperException: No export task with id 0ec40f93-744e-410f-a8af-9de3ef631d96.      at com.ca.jasper.restAdapter.services.RestServiceBase.setJSErrorMesage(RestServiceBase.java:270)      at com.ca.jasper.restAdapter.services.RestServiceBase.setMetaInfo(RestServiceBase.java:286) ------------------------------------------- 


    I attached the admin.log for more details   Any idea ?   Thanks in advance for your help

    Attachment(s)

    zip
    admin.log.zip   1 KB 1 version


  • 2.  Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted May 19, 2017 02:25 AM

    Hi Mohammed,


    We need to see the full error log, can you share the admin log and ensure PMO is installed.

    Regards

    Suman Pramanik 



  • 3.  Re: Import Jaspersoft csk failed

    Posted May 19, 2017 06:15 PM

    Hi Suman, 

     

    Thanks for your reply, my problem is the same as the one resolved by Nika 

     

    Mohammed



  • 4.  Re: Import Jaspersoft csk failed
    Best Answer

    Broadcom Employee
    Posted May 19, 2017 04:56 PM
    Edited by Nika Hadzhikidi Apr 17, 2020 02:06 PM

    Hi Mohammed,

     

     

    I just posted a solution to the same error here:

    https://communities.ca.com/people/Nika_Hadzhikidi/blog/2017/05/19/unable-to-install-jaspersoft-content-import-fails-with-error-no-export-task-with-id

     EDIT: Correct link is here:
    https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1747&MessageKey=b7e14594-8492-4016-a728-4cc472a604b8&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d7f0cbca3-5f93-4d44-a369-1a8ce98f5578%26tab%3ddigestviewer

    Please check it out and try the steps to get this resolved. Let me know how this goes!

     

    Hope this helps -Nika  




  • 5.  Re: Import Jaspersoft csk failed

    Posted May 19, 2017 06:13 PM

    Hi Nika, 

     

    Thanks a lot for your message, my bug is fixed by following the instruction in your post

     

    Regards Mohammed 



  • 6.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 14, 2020 02:45 PM
    Dear Nika,

    I'm having the same issue (exactly the same) in a fresh installation of Clarity 15.8; unfortunately the link is broken (because the changes domain, community plataform). Could you please share again the procedure to solve the issue. The upgrade or restore domains didn't work (despite using the option force) because is a new installation and Clarity detects it.

    Kind regards,
    Daniel
    Original Message


  • 7.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 15, 2020 01:05 PM
    Hi Daniel

    Can you please share the exact problem you are facing, it will help if you can provide the admin log

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 8.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 15, 2020 03:30 PM
    Hi!!!

    Thanks a lot for your response!!! Here are the log and the screenshot. As you will see it's the same issue happened before.

    Regards,
    Daniel

    Attachment(s)

    log
    admin.log   6 KB 1 version
    Original Message


  • 9.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 16, 2020 04:10 AM
    Hi Daniel

    Thanks for sharing the admin log and the error i see is below and this is very generic error and i would like to have some additional information.

    1. What is your Jaspersoft version and version of Tomcat used. 
    2. What is your database? (Oracle/MSSQL) 
    3. Can you share your properties.xml and you can mask the IP and password's 

    4/15/20, 2:13 PM (admin) Failed to import content for tenant  4/15/20, 2:13 PM (admin) Failed to import content for tenant  com.ca.jasper.restAdapter.JasperException: No export task with id 48f5d450-25e6-402a-a02a-031c6a9eae34. at com.ca.jasper.restAdapter.services.RestServiceBase.setJSErrorMesage(RestServiceBase.java:291) at com.ca.jasper.restAdapter.services.RestServiceBase.setMetaInfo(RestServiceBase.java:308) at com.ca.jasper.restAdapter.services.RestServiceBase.restServiceGet(RestServiceBase.java:329) at com.ca.jasper.restAdapter.services.RestServiceBase.restServiceGet(RestServiceBase.java:318) at com.ca.jasper.restAdapter.services.ImportService.getImportStatus(ImportService.java:249) at com.niku.reporting.jasper.ClarityJasperAdmin.importContent(ClarityJasperAdmin.java:1259) at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:848) at com.niku.reporting.jasper.importexport.JasperContentCommand.execute(JasperContentCommand.java:191) at com.niku.reporting.jasper.ClarityJasperAdmin.executeCommand(ClarityJasperAdmin.java:3888) at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:311) at com.niku.nsa.service.AdminManager.execute(AdminManager.java:207) at com.niku.nsa.service.Admin.main(Admin.java:78) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.werken.forehead.Forehead.run(Forehead.java:551) at com.werken.forehead.Forehead.main(Forehead.java:581)

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 10.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 16, 2020 10:57 AM
      |   view attached
    Dear Suman,

    Thank you for your response!!! Here are the answers for your questions:

    1. What is your Jaspersoft version and version of Tomcat used. 
    Jasper 7.1.0_6.1.0.27 (from the media downloaded)
    Tomcat
    Using CATALINA_BASE: /opt/tomcat8-jasper
    Using CATALINA_HOME: /opt/tomcat8-jasper
    Using CATALINA_TMPDIR: /opt/tomcat8-jasper/temp
    Using JRE_HOME: /jdk1.8.0_171/jre
    Using CLASSPATH: /opt/tomcat8-jasper/bin/bootstrap.jar:/opt/tomcat8-jasper/bin/tomcat-juli.jar
    Server version: Apache Tomcat/8.5.49
    Server built: Nov 17 2019 18:45:30 UTC
    Server number: 8.5.49.0
    OS Name: Linux
    OS Version: 4.12.14-94.41-default
    Architecture: amd64
    JVM Version: 1.8.0_171-b11
    JVM Vendor: Oracle Corporation


    2. What is your database? (Oracle/MSSQL) 
    The database is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

    3. Can you share your properties.xml and you can mask the IP and password's 
    Yes!!! It's attached.

    I'll wait your kindly response!
    Thanks
    Daniel

    Attachment(s)

    xml
    properties.xml   8 KB 1 version
    Original Message


  • 11.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 16, 2020 02:44 PM
    Hi Daniel

    First change i would like to try 

    1. Stop all the clarity services
    2. Login to CSA and update the JDBC url using below syntax as example for oracle database 
    Oracle Standard/Enterprise Database -

    jdbc:clarity:oracle://xxx.broadcom.net:1521;SID=clarity;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;ConnectionRetryCount=400;ConnectionRetryDelay=3


                  Oracle RAC/Exadata/PDB  Database Edition

                  jdbc:clarity:oracle://server:1521;ServiceName=serviceTNS;BatchPerformanceWorkaround=true; InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;

        3. Re import the Jaspersoft content again using below command 

    admin content-jaspersoft csk -userName superuser -password superuser upgrade -retryCount 50 force

    Let me know how it goes

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 12.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 16, 2020 04:39 PM
    Edited by Daniel Galvez Apr 16, 2020 04:47 PM
    Dear Suman,

    Thanks again for your response. Unfortunately I'm at the same point; I'm getting the same error. There are several things that I notice
    1.- When the command "./admin jaspersoft keystore" it creates one file in uppercase the MSL.jks file and the other file is created in lowercase msl.properties.
    2.- I deleted every key generation the organization and the "clarity_ppm_user/jasperadmin" in Jasper; but when the command to install begins, it creates the organization and user, BUT the user that the command creates isn't ppmjasperadmin (as the properties.xml file) the command creates the user jasperadmin instead, the organization created again fine (fine at this point).
    3.- I already tried to use the user "jasperadmin" instead of ppmjasperadmin for the configuration and key generation but I'm getting the same error.
    4-. I guessing that I have some issue with the task generation (please take a look to the attached files) I think that the command can´t create the task and this is why the import doesn't works.
    5.- I deleted Jasper installation and install it again and I'm getting the same issue

    Kind regards,
    Daniel
    Original Message


  • 13.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 17, 2020 01:55 PM
    Hi Daniel

    Since all of this is tried, can you check if you have user has access to TEMP folder

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 14.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 23, 2020 06:57 PM
    Dear Suman,

    Unfortunately your suggestions didn't works :( I'm still with the same issue. What else can we do?


    Kind regads,
    Daniel
    Original Message


  • 15.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 23, 2020 06:58 PM
    Dear Suman,

    Unfortunately your suggestions didn't works :( I'm still with the same issue. What else can we do?


    Kind regads,
    Daniel
    Original Message


  • 16.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 17, 2020 01:44 PM
    Hi Daniel

    Sorry for the inconvenience, yes, the blog posts got lost in our migration. I reposted the same solution again here:
    https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1747&MessageKey=b7e14594-8492-4016-a728-4cc472a604b8&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d7f0cbca3-5f93-4d44-a369-1a8ce98f5578%26tab%3ddigestviewer

    Check it out and see if this helps! -Nika

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 17.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 23, 2020 06:59 PM
    Dear Nika,

    Unfortunately your suggestions didn't works :( I'm still with the same issue. The user has correct access to the temp directory; What else can we do?


    Kind regads,
    Daniel
    Original Message


  • 18.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 23, 2020 09:09 PM
    Hi Daniel

    Did you try resetting the TEMP directory in the admin script as described in my post?

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 19.  RE: Re: Import Jaspersoft csk failed

    Posted Apr 24, 2020 12:30 AM
    Dear Nika,

    Yes I did the modification of the script. The only thing is that my environment is running into a Linux box and I'm using root to run everything.

    regards,
    Daniel
    Original Message


  • 20.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted Apr 24, 2020 05:18 AM
    Hi Daniel

    I think we may need to look via support case as you have already tried all the suggestions.

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 21.  Re: Import Jaspersoft csk failed

    Posted Mar 06, 2018 06:05 AM

    Hi All

     

    We had a similar error(in the command line)  on 15.3 but not the same.

     

     

    JasperLogs gives you a lot of information. Our logs said:

     

    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The transaction log for database 'PPMTESTJasper' is full due to 'ACTIVE_TRANSACTION'.
     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

     

    Was fixed by DBA, he said to us that the disk (logs) got full He put them to simple.

     

    regards



  • 22.  RE: Re: Import Jaspersoft csk failed

    Posted May 05, 2020 10:59 AM
    Hi all,

    I'm facing a similar issue. 

    OS: CentOS 7
    Clarity version 15.8
    Jaspersoft version: 7.1.0
    DB: Oracle 12.1.0.2

    root@centos7 ~]# admin content-jaspersoft csk -userName superuser -password superuser
    Content File Name  jaspersoft_csk.zip
    Logging into server ... http://centos7:8080/reportservice
    Getting tenant information... organization_1
    Initiating importing on organization_1 with file name jaspersoft_csk.zip
    Preparing content to be deployed on  organization_1 using file /home/clarity/app/reporting/content/csk/jaspersoft/package/jaspersoft_csk.zip
    Importing prepared content.../tmp/jaasreports_5194228940840389672/export_15473388037653574557.zip
    Importing....
    Importing....
    Content import failed.No export task with id 1f3c4d3f-3188-4230-bdf2-f4203ec2b90c.
    Failed to import content for tenant  : No export task with id 1f3c4d3f-3188-4230-bdf2-f4203ec2b90c.com.niku.nsa.service.ExecutableException: com.ca.jasper.restAdapter.JasperException: No export task with id 1f3c4d3f-3188-4230-bdf2-f4203ec2b90c. at com.niku.reporting.jasper.importexport.JasperContentCommand.execute(JasperContentCommand.java:244) at com.niku.reporting.jasper.ClarityJasperAdmin.executeCommand(ClarityJasperAdmin.java:3888) at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:311) at com.niku.nsa.service.AdminManager.execute(AdminManager.java:207) at com.niku.nsa.service.Admin.main(Admin.java:78) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.werken.forehead.Forehead.run(Forehead.java:551) at com.werken.forehead.Forehead.main(Forehead.java:581)

    The Catalina.out log shows:
    2020-05-05 22:47:17,695 ERROR ImportRunnable,pool-14-thread-4:78 [root|superuser] - Import failed:2020-05-05 22:47:17,695 ERROR ImportRunnable,pool-14-thread-4:78 [root|superuser] - Import failed:
    com.jaspersoft.jasperserver.export.service.ImportFailedException: Import failed. Reason: A mapping for class com.jaspersoft.jasperserver.export.modules.repository.beans.ResourceBean already exists at com.jaspersoft.jasperserver.export.service.impl.ImportExportServiceImpl.startImport(ImportExportServiceImpl.java:236) at com.jaspersoft.ji.logging.audit.export.service.AuditCapableImportExportServiceImpl.startImport(AuditCapableImportExportServiceImpl.java:38) at com.jaspersoft.jasperserver.export.service.impl.ImportExportServiceImpl.doImport(ImportExportServiceImpl.java:143) at com.jaspersoft.jasperserver.remote.services.async.ImportRunnable.run(ImportRunnable.java:63) at com.jaspersoft.jasperserver.remote.services.async.ImportExportTask$1.run(ImportExportTask.java:124) at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
    Original Message


  • 23.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted May 05, 2020 11:32 AM
    Hi Arthur

    Is this a new install or a Jaspersoft upgrade? According to this it looks like it detects some data already being there:

    A mapping for class com.jaspersoft.jasperserver.export.modules.repository.beans.ResourceBean already exists

    If it's an upgrade you have to run the upgrade command instead. If it's a new install I would try to delete the organization and import again.

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 24.  RE: Re: Import Jaspersoft csk failed

    Posted May 06, 2020 03:08 AM
    Hi Nika,

    Thanks for the quick reply. 

    It is a new installation. 

    Even though it is a new installation, I tried again with the -upgrade option as per your suggestion but it didn't work. 

    I receive the following message:


    I also tried creating a new organisation, generating the keystone and running the command again but I got the same error message.

    Any ideas?

    Cheers,
    Arthur
    Original Message


  • 25.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted May 06, 2020 08:43 AM
    Hi Arthur - have you tried applying this solution yet: https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1747&MessageKey=b7e14594-8492-4016-a728-4cc472a604b8&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d7f0cbca3-5f93-4d44-a369-1a8ce98f5578%26tab%3ddigestviewer

    Let me know if this works for you. Thank you -Nika

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 26.  RE: Re: Import Jaspersoft csk failed

    Posted May 07, 2020 08:08 AM
    Hi Nika,

    I reinstalled Jaspersoft and it worked!

    I guess I was using a wrong version of Tomcat. 

    Thanks for your help!
    Arthur
    Original Message


  • 27.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted May 07, 2020 09:27 AM
    Great, thank you for letting us know Arthur!

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 28.  RE: Re: Import Jaspersoft csk failed

    Posted May 07, 2020 06:36 PM
    Hi Nika, Arthur and Suman,

    I also resolved the issue. Thanks to Arthur he gave me the "clue..." I used the same version from tomcat 8.5.49 from PPM server to the Jasper server and this is the issue. The installation from Jasper must use the version 8.5.30 when I change this version it works. The import works!

    Thank you very much Nika and Suman for your help and also Arthur for the feedback around the version.
    Kind regards,
    Daniel
    Original Message


  • 29.  RE: Re: Import Jaspersoft csk failed

    Broadcom Employee
    Posted May 07, 2020 10:00 PM
    This is great news, thank you for letting us know Daniel! -Nika

    ------------------------------
    Nika Hadzhikidi
    Sr Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message