report PDF corrupted in Prod - Githubissues

barbacenasmc / armis-issues

1 stars 0 forks source link

report PDF corrupted in Prod #69

Open grg021 opened 8 years ago

grg021 commented 8 years ago

Steps to Replicate

login to https://armis.gov.ph/
once in dashboard click +more > Report
Select any report type and try to generate a PDF report

ACTUAL RESULT

PDF is downloaded but corrupted (cannot open PDF)

EXPECTED RESULT

PDF should be opened and contains the correct information

grg021 commented 8 years ago

RESOLUTION 1 - recreate DB

stop alfresco
dropped alfrescoreporting db
created new db - alfrescoreporting
ran - usermanagement_function_table (https://goo.gl/Oxw1Pe)
ran - armis_functions (https://goo.gl/LNM3kE)
start alfresco
login to /alfresco and under dictionary>reporting> (harvest data - both links)
ran - alfresco_reporting_index (https://goo.gl/rz0toX)
ran - trig sql (https://goo.gl/mPZlEH)
login to share - generate usermanagement report

RESULT

PDF still corrupted
tomcat error log - http://pastebin.com/NXAMnF30

grg021 commented 8 years ago

RESOLUTION 2 - manual PRPT

downloaded the UserManagement.prpt file from /alfresco -> Dictionary -> Reporting -> On Demand folder
opened PRPT in Pentaho
used JDBC instead of JNDI to connect to alfrescoreporting DB via VPN
generate PDF

RESULT

PDF was generated but no data (upon checking there are no data inside Alfrescoreporting DB -> usermanagement_report (table)