After running Automation I got all the reult percentages as Zeros. Could you please help me why I got that. I mentioned my log for batch is attched below

Question

[echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Process test case [01-batches]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Drop [carddemo_jics] database and restore it from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_jics.backup]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Kill sessions on database carddemo_jics
     [echo] Execute PSQL command on database postgres : SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'carddemo_jics'
     [exec]  pg_terminate_backend 
     [exec] ----------------------
     [exec] (0 rows)
     [exec] 
     [echo] Drop database carddemo_jics
     [echo] Execute PSQL command on database postgres : DROP DATABASE IF EXISTS "carddemo_jics"
     [exec] DROP DATABASE
     [echo] Create database carddemo_jics
     [echo] Execute PSQL command on database postgres : CREATE DATABASE "carddemo_jics" WITH OWNER = carddemo
     [exec] CREATE DATABASE
     [echo] Restore carddemo_jics from backup D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_jics.backup
     [exec] pg_restore: while PROCESSING TOC:
     [exec] pg_restore: from TOC entry 4; 2615 2200 SCHEMA public postgres
     [exec] pg_restore: error: could not execute query: ERROR:  schema "public" already exists
     [exec] Command was: CREATE SCHEMA public;
     [exec] 
     [exec] 
     [exec] pg_restore: warning: errors ignored on restore: 1
     [exec] Result: 1
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Drop [carddemo_bluesam] database and restore it from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_bluesam.backup]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Kill sessions on database carddemo_bluesam
     [echo] Execute PSQL command on database postgres : SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'carddemo_bluesam'
     [exec]  pg_terminate_backend 
     [exec] ----------------------
     [exec] (0 rows)
     [exec] 
     [echo] Drop database carddemo_bluesam
     [echo] Execute PSQL command on database postgres : DROP DATABASE IF EXISTS "carddemo_bluesam"
     [exec] DROP DATABASE
     [echo] Create database carddemo_bluesam
     [echo] Execute PSQL command on database postgres : CREATE DATABASE "carddemo_bluesam" WITH OWNER = carddemo
     [exec] CREATE DATABASE
     [echo] Restore carddemo_bluesam from backup D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_bluesam.backup
     [exec] pg_restore: while PROCESSING TOC:
     [exec] pg_restore: from TOC entry 5; 2615 2200 SCHEMA public carddemo
     [exec] pg_restore: error: could not execute query: ERROR:  schema "public" already exists
     [exec] Command was: CREATE SCHEMA public;
     [exec] 
     [exec] 
     [exec] pg_restore: warning: errors ignored on restore: 1
     [exec] Result: 1
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Drop [carddemo_bac] database and restore it from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_bac.backup]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Kill sessions on database carddemo_bac
     [echo] Execute PSQL command on database postgres : SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'carddemo_bac'
     [exec]  pg_terminate_backend 
     [exec] ----------------------
     [exec] (0 rows)
     [exec] 
     [echo] Drop database carddemo_bac
     [echo] Execute PSQL command on database postgres : DROP DATABASE IF EXISTS "carddemo_bac"
     [exec] DROP DATABASE
     [echo] Create database carddemo_bac
     [echo] Execute PSQL command on database postgres : CREATE DATABASE "carddemo_bac" WITH OWNER = carddemo
     [exec] CREATE DATABASE
     [echo] Restore carddemo_bac from backup D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_bac.backup
     [exec] pg_restore: while PROCESSING TOC:
     [exec] pg_restore: from TOC entry 4; 2615 2200 SCHEMA public postgres
     [exec] pg_restore: error: could not execute query: ERROR:  schema "public" already exists
     [exec] Command was: CREATE SCHEMA public;
     [exec] 
     [exec] 
     [exec] pg_restore: warning: errors ignored on restore: 1
     [exec] Result: 1
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Drop [carddemo_primary] database and restore it from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_primary.backup]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Kill sessions on database carddemo_primary
     [echo] Execute PSQL command on database postgres : SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'carddemo_primary'
     [exec]  pg_terminate_backend 
     [exec] ----------------------
     [exec] (0 rows)
     [exec] 
     [echo] Drop database carddemo_primary
     [echo] Execute PSQL command on database postgres : DROP DATABASE IF EXISTS "carddemo_primary"
     [exec] DROP DATABASE
     [echo] Create database carddemo_primary
     [echo] Execute PSQL command on database postgres : CREATE DATABASE "carddemo_primary" WITH OWNER = carddemo
     [exec] CREATE DATABASE
     [echo] Restore carddemo_primary from backup D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/backups/carddemo_primary.backup
     [exec] pg_restore: while PROCESSING TOC:
     [exec] pg_restore: from TOC entry 4; 2615 2200 SCHEMA public postgres
     [exec] pg_restore: error: could not execute query: ERROR:  schema "public" already exists
     [exec] Command was: CREATE SCHEMA public;
     [exec] 
     [exec] 
     [exec] pg_restore: warning: errors ignored on restore: 1
     [exec] Result: 1
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Initialize working directory from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tests-cases/00-default/working-directory]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [copy] Copying 14 files to D:\PhotonUser\Workshop\working-directory
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Start Tomcat from [D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] 
     [echo] Clean Tomcat logs and temporary files from D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat
     [echo] 
     [exec] Using CATALINA_BASE:   "D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat"
     [exec] Using CATALINA_HOME:   "D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat"
     [exec] Using CATALINA_TMPDIR: "D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat	emp"
     [exec] Using JRE_HOME:        "C:\Work\Programs\jdk17.0.10_7"
     [exec] Using CLASSPATH:       "D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat\bin\bootstrap.jar;D:\PhotonUser\Workshop\workspace\carddemo-automation/tomcat\bin	omcat-juli.jar"
     [exec] Using CATALINA_OPTS:   " -Dlogback.ContextSelector=JNDI -javaagent:C:\Work\Programs\jacoco\lib\jacocoagent.jar=output=tcpserver,append=false,includes=aws.bluage.l3.workshop.*"
2025-06-09 23:12:35.567 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:38.572 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:41.586 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:44.590 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:47.594 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:50.598 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:53.602 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:56.636 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:12:59.644 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:02.650 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:05.654 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:08.665 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:11.682 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:14.696 - Checking for http://localhost:8080 - server does not respond in less than 1 sec
2025-06-09 23:13:16.706 - Checking for http://localhost:8080 - return code : 200 / expected : 200 ==> ok !
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Execute test case [01-batches]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------

execute:
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [TRANBKP]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/TRANBKP
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\TRANBKP.log
     [echo] { "exitCode": 0, "stepName": "STEP10", "program": "IDCAMS", "status": "Succeeded" }
   [delete] Deleting: D:\PhotonUser\Workshop\workspace\carddemo-automation\TRANBKP.log
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [POSTTRAN]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/POSTTRAN
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\POSTTRAN.log
     [echo] { "exitCode": 4, "stepName": "STEP15", "program": "CBTRN02C", "status": "Succeeded" }
   [delete] Deleting: D:\PhotonUser\Workshop\workspace\carddemo-automation\POSTTRAN.log
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [INTCALC]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/INTCALC
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\INTCALC.log
     [echo] { "exitCode": 0, "stepName": "STEP15", "program": "CBACT04C", "status": "Succeeded" }
   [delete] Deleting: D:\PhotonUser\Workshop\workspace\carddemo-automation\INTCALC.log
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [TRANBKP]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/TRANBKP
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\TRANBKP.log
     [echo] { "exitCode": 0, "stepName": "STEP10", "program": "IDCAMS", "status": "Succeeded" }
   [delete] Deleting: D:\PhotonUser\Workshop\workspace\carddemo-automation\TRANBKP.log
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [COMBTRAN]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/COMBTRAN
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\COMBTRAN.log
     [echo] { "exitCode": 0, "stepName": "STEP10", "program": "IDCAMS", "status": "Succeeded" }
   [delete] Deleting: D:\PhotonUser\Workshop\workspace\carddemo-automation\COMBTRAN.log
     [echo] 
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
     [echo] Run batch job: [CREASTMT]
     [echo] ------------------------------------------------------------------------------------------------------------------------------------------------
      [get] Getting: http://localhost:8080/gapwalk-application/script/CREASTMT
      [get] To: D:\PhotonUser\Workshop\workspace\carddemo-automation\CREASTMT.log
     [echo] { "exitCode": 0, "stepName": "STEP040

Agung Sidharta · Answer

Hi Parameswar, I need more context about the automation and the percentage before able to answer the questions.
I also see error message like this in your printed log:
default/backups/carddemo_jics.backup [exec] pg_restore: while PROCESSING TOC: [exec] pg_restore: from TOC entry 4; 2615 2200 SCHEMA public postgres [exec] pg_restore: error: could not execute query: ERROR: schema "public" already exists [exec] Command was: CREATE SCHEMA public; [exec] [exec] [exec] pg_restore: warning: errors ignored on restore: 1 [exec] Result: 1 [echo] [echo]

Are you trying to restore a database ?

re:Post Agent · Answer

The issue you're experiencing with all result percentages showing as zeros after running Automation could be due to several factors:

1. Data Initialization: It's possible that the databases were not properly initialized or restored. The log shows that while databases were dropped and recreated, there were some errors during the restore process. For example, there were errors like "schema "public" already exists" for all databases. This might have resulted in incomplete or incorrect data restoration.

2. Tomcat Server Issues: The log indicates that there were difficulties starting the Tomcat server. It took multiple attempts before the server responded, which could have affected the execution of your batch jobs or the collection of metrics.

3. Batch Job Execution: While the log shows that batch jobs like TRANBKP, POSTTRAN, INTCALC, COMBTRAN, and CREASTMT were executed, it doesn't provide detailed information about their results or any metrics they might have generated.

4. Metric Collection: There might be an issue with how the metrics are being collected or calculated after the batch jobs run. The automation process might not be correctly capturing or processing the results of these jobs.

5. Configuration Issues: There could be misconfigurations in how the automation is set up to calculate and report percentages.

To troubleshoot this:

1. Check the database restore process and ensure all data is being properly loaded.
2. Verify that the Tomcat server is starting correctly and all necessary services are running.
3. Review the individual batch job logs for more detailed information on their execution and results.
4. Examine how metrics are being collected and calculated after the batch jobs run.
5. Double-check the automation configuration to ensure it's set up correctly to gather and report percentages.

If the issue persists after these checks, you may need to review the specific code or configuration responsible for calculating and reporting the percentages, as the problem might lie in how these results are being processed after the batch jobs complete.  
**Sources**  
[AWS Blu Age L3 Workshop - Error on Automation - Execute | AWS re:Post](https://repost.aws/questions/QUxZ5bcYtgTCC-rev5Vfk2Cg/aws-blu-age-l3-workshop-error-on-automation-execute)  
[Tomcat server failed to start due to below error - Please help! | AWS re:Post](https://repost.aws/questions/QUPbD1exCmRtiiXKt_7-W_9w/tomcat-server-failed-to-start-due-to-below-error-please-help)

After running Automation I got all the reult percentages as Zeros. Could you please help me why I got that. I mentioned my log for batch is attched below

Relevant content