Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Vinay,

Probably this is not Apache POI issue. I have used these dependencies to generate excel files, it involved several search operations and few content operations as well. It doesn't take much time usually (in few seconds). I have developed these operations in Spring REST service, deployed in the WebSphere.

How are you executing these operations? Code Module/ Java Utility / External Web Applications, Sync or Async etc..
May be fine tuning the app server helps, like java heap memory, threads, increase transaction timeouts etc..
Also FTP shouldn't take that much time, check the network speed between the servers (iperf).

------------------------------
Ramesh Bhat
------------------------------

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Ramesh,

   I think you didn't understand the problem. 
   The issue is running excel functionality with IBM BPM BAW v20.  In Eclipse application running perfectly without delay.
   
    If you have IBM tool then try it.

------------------------------
Vinay Sinha
------------------------------

Original Message:
Sent: Thu November 17, 2022 05:12 AM
From: Ramesh Bhat
Subject: Java application taking long time to run in IBM BAW.

Hi Vinay,

Probably this is not Apache POI issue. I have used these dependencies to generate excel files, it involved several search operations and few content operations as well. It doesn't take much time usually (in few seconds). I have developed these operations in Spring REST service, deployed in the WebSphere.

How are you executing these operations? Code Module/ Java Utility / External Web Applications, Sync or Async etc..
May be fine tuning the app server helps, like java heap memory, threads, increase transaction timeouts etc..
Also FTP shouldn't take that much time, check the network speed between the servers (iperf).

------------------------------
Ramesh Bhat

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Vinay,

I am calling the REST service from Custom Case page widget and also from CSHS on BAW OnPrem 21.0.3. That API uses Apache POI to generate excel documents. Operation involves reading the files from mounted directories on the linux box and few p8 searches and content operations in FileNet to create excel documents. I am using EJB connection to FileNet.
Your architecture may be different, but may be performance tuning help in your case.

------------------------------
Ramesh Bhat
------------------------------

Original Message:
Sent: Fri November 18, 2022 07:09 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi Ramesh,

   I think you didn't understand the problem. 
   The issue is running excel functionality with IBM BPM BAW v20.  In Eclipse application running perfectly without delay.
   
    If you have IBM tool then try it.

------------------------------
Vinay Sinha

Original Message:
Sent: Thu November 17, 2022 05:12 AM
From: Ramesh Bhat
Subject: Java application taking long time to run in IBM BAW.

Hi Vinay,

Probably this is not Apache POI issue. I have used these dependencies to generate excel files, it involved several search operations and few content operations as well. It doesn't take much time usually (in few seconds). I have developed these operations in Spring REST service, deployed in the WebSphere.

How are you executing these operations? Code Module/ Java Utility / External Web Applications, Sync or Async etc..
May be fine tuning the app server helps, like java heap memory, threads, increase transaction timeouts etc..
Also FTP shouldn't take that much time, check the network speed between the servers (iperf).

------------------------------
Ramesh Bhat

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Ramesh,

   I have a Java module which create an excel file. Inside Java module all dependents jars are available. And integrate that Java module's Jar in BAW. 

   I added all dependents jars of Java module in BAW also and that improve the performance of file creation.
    
   So, I think BAW first search dependents jars inside BAW and if jars available then it work fast otherwise it is taking time to search jars.

   As of now jars are available in Java module and BAW. Which is working fine but same jars are available in both applications that I think is not best practice.

------------------------------
Vinay Sinha
------------------------------

Original Message:
Sent: Fri November 18, 2022 08:28 AM
From: Ramesh Bhat
Subject: Java application taking long time to run in IBM BAW.

Hi Vinay,

I am calling the REST service from Custom Case page widget and also from CSHS on BAW OnPrem 21.0.3. That API uses Apache POI to generate excel documents. Operation involves reading the files from mounted directories on the linux box and few p8 searches and content operations in FileNet to create excel documents. I am using EJB connection to FileNet.
Your architecture may be different, but may be performance tuning help in your case.

------------------------------
Ramesh Bhat

Original Message:
Sent: Fri November 18, 2022 07:09 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi Ramesh,

   I think you didn't understand the problem. 
   The issue is running excel functionality with IBM BPM BAW v20.  In Eclipse application running perfectly without delay.
   
    If you have IBM tool then try it.

------------------------------
Vinay Sinha

Original Message:
Sent: Thu November 17, 2022 05:12 AM
From: Ramesh Bhat
Subject: Java application taking long time to run in IBM BAW.

Hi Vinay,

Probably this is not Apache POI issue. I have used these dependencies to generate excel files, it involved several search operations and few content operations as well. It doesn't take much time usually (in few seconds). I have developed these operations in Spring REST service, deployed in the WebSphere.

How are you executing these operations? Code Module/ Java Utility / External Web Applications, Sync or Async etc..
May be fine tuning the app server helps, like java heap memory, threads, increase transaction timeouts etc..
Also FTP shouldn't take that much time, check the network speed between the servers (iperf).

------------------------------
Ramesh Bhat

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Vinay,

I would suggest you to add logging at each step to identify the stage where it is taking longer than expected.

------------------------------
Atanu Roy
Solution Architect
Salient Process
------------------------------

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------

Hi Atanu,

  Logs are there.

------------------------------
Vinay Sinha
------------------------------

Original Message:
Sent: Fri November 18, 2022 08:54 AM
From: Atanu Roy
Subject: Java application taking long time to run in IBM BAW.

Hi Vinay,

I would suggest you to add logging at each step to identify the stage where it is taking longer than expected.

------------------------------
Atanu Roy
Solution Architect
Salient Process

Original Message:
Sent: Wed November 16, 2022 10:53 AM
From: Vinay Sinha
Subject: Java application taking long time to run in IBM BAW.

Hi,
     I have created a Java application which creates excel file and transfer the excel file to a location via FTP. In my local environment application executes in few seconds. But when I run the application first time in IBM BAW it complete execution in 6 to 7 minutes and second time it completes execution in less than 2 minute. 

    In Java module added all Apache poi and ftp jars dependency as reference library.
    Created a runnable jar and integrate with IBM BAW.
    First time it is taking around 4 to 5 minutes time to create an excel file then file transfer completes within in 1 minute. 
    Second time complete entire(excel fie creation and file transfer) process in less than 2 minute.
   
    Due to time taken issue transaction roll back happening on BPM side but java application complete all steps without error.

    Need support to fix this time taken issue of Apache poi.
    
Software - Eclipse, IBM BAW
Java - Jdk 1.8
Library - Apache poi v4.1.1, poi-ooxml v4.1.1, poi-ooxml-schemas v 4.1.1, xmlbeans v3.10


------------------------------
Vinay Sinha
------------------------------