US-EPA-CAMD / easey-ui

Project Management repo for EPA Clean Air Markets Division (CAMD) Business Suite of applications
MIT License
0 stars 0 forks source link

Bug: Empty XML zip files for 24q2 #6436

Open annalbrecht opened 4 weeks ago

annalbrecht commented 4 weeks ago

There are currently 13 XML zip files that are empty for 2024Q2. The problem originated on CAMDPUB and needs to be investigated and remediated in that environment.

The first step would be to review the log table(s) on CAMDPUB for these files and see if any errors were logged during the creation of these data sets. We can then re-trigger the creation of the zip files via a script, either from CAMDBSP (for the individual files) or on CAMDPUB.

The files affected include: 000613_242_EM.zip 000990_242_EM.zip 002446_242_EM.zip 006071_242_EM.zip 054785_242_EM.zip 055271_242_EM.zip 055327_242_EM.zip 055345_242_EM.zip 055965_242_EM.zip 056505_242_EM.zip 057185_242_EM.zip 058001_242_EM.zip 058284_242_EM.zip

alangmaid commented 4 weeks ago

In the near term we will find a way to get the files to the end user.

annalbrecht commented 4 weeks ago

I looked in XML_AUDIT_LOG for one facility and found the errors below.

SELECT * FROM XML_AUDIT_LOG WHERE fac_id = 806 AND file_type_cd = 'EM' AND year = 2024 AND quarter = '2' ORDER BY log_id desc;

ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CAMDDMW.FAC_YQ_TYPE_TRANS_U01) violated

ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: Invalid column name