Yes I need urgent help. Can we please setup a call or a WebEx for tomorrow Sunday 9:30AM (South Africa time)
I have an issue during the installation.
Installation is complete and the service are reported to be running.
However, when reaching the app from the browser, it gives me the below error.
Please find attached the logs
In aveksaServer.log, I see the following errors:
08/03/2018 18:54:46.244 ERROR (ServerService Thread Pool -- 89) [com.aveksa.migration.jdbctool.CheckDatabase] Error reading Aveksa_System.cfg
java.io.IOException: No space left on device
That would be the first place to check.
Can you attach /tmp/aveksa-install.log as well?
Hi Boris,
It look like this was a fake error. Lol
I ended up running a script that will show me all the invalid objects in the DB and ran the below statements which helped re-compile them and then I restarted the DB and application.
1. Run this script to find invalid objects
2. Run the below to update permissions and resolve the issue (which will re-compiled the invalid package)
GRANT SELECT ON dba_pending_transactions TO AVUSER;
GRANT SELECT ON pending_trans$ TO AVUSER;
GRANT SELECT ON dba_2pc_pending TO AVUSER;
GRANT EXECUTE ON dbms_xa TO AVUSER;
GRANT READ, WRITE ON directory AVEKSA_EXPORTIMPORT_DIRECTORY TO AVUSER; --optional but better to do it
GRANT SELECT ON dba_free_space TO AVUSER;
GRANT SELECT ON gv_$parameter TO AVUSER;
Regards
Armel Lupapi
Access Management | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”
Hi Boris,
It look like this was a fake error. Lol
I ended up running a script that will show me all the invalid objects in the DB and ran the below statements which helped re-compile them and then I restarted the DB and application.
1. Run this script to find invalid objects
2. Run the below to update permissions and resolve the issue (which will re-compiled the invalid package)
GRANT SELECT ON dba_pending_transactions TO AVUSER;
GRANT SELECT ON pending_trans$ TO AVUSER;
GRANT SELECT ON dba_2pc_pending TO AVUSER;
GRANT EXECUTE ON dbms_xa TO AVUSER;
GRANT READ, WRITE ON directory AVEKSA_EXPORTIMPORT_DIRECTORY TO AVUSER; --optional but better to do it
GRANT SELECT ON dba_free_space TO AVUSER;
GRANT SELECT ON gv_$parameter TO AVUSER;
Regards
Armel Lupapi
Access Management | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”