Upgrade from 21.0.3 to 21.0.5 shows . U00038252 Could not find file '../db/oracle/21.0/create_xevents.sql"

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Upgrade from 21.0.3 to 21.0.5 shows . U00038252  Could not find file '../db/oracle/21.0/create_xevents.sql".

Environment

Release : 21.0.5

Resolution

Try Blow Steps :

- Check if file create_xevents.sql exist in path with right permission (777). 

- Check with your DBA to grant the create trigger to the user being used in Automic for connecting to AE DB: GRANT create trigger.

Create Trigger Rights  documented in below link. 

GRANT create table, create sequence, create session, create procedure, create trigger, execute any procedure, create public synonym, drop public synonym, create view, alter session, select any dictionary TO uc4;
GRANT execute ON dbms_lock TO uc4;
GRANT unlimited tablespace TO uc4;

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.5/Automic%20Automation%20Guides/Content/Installation_Manual/AE/SetUptheAEDatabase.htm?Highlight=Setting%20Up%20the%20AE%20Database

- If you are executing DBload from bin directory of utilities . Ensure DB is under utilities directory .

- The load copies checkprivileges.sql to checkprivileges[timestamp].sql in the /db/[database_type]/[version] folder. Check if its exist.

- Make sure all utility files are from new version including DB directory. 

- Check if you have a message like below . Specifically 2nd line shows does not match with the path. 
...
20230324/132138.235 - ----------------------------------------------------------------------------------------------------
20230324/132138.235 - U00038091 Change application directory to '../db
20230324/132138.236 - U00038261 "The path ""'/UC4/Global215/Utility/db/general/21.0/UC_UPD.TXT'"" does not match with the path ""'/UC4/GLOBAL21/UTILITY/DB'"" defined in ucybdbld.ini, however, the Initial data are loaded from the path defined in the ini file!"
20230324/132138.236 - U00038091 Change application directory to '../db/'.
 
This is because of configuration within the INIfile '../db' but uses on the command line '/UC4/GLOBAL21/UTILITY/DB'...
 
within the folder structure '..db\oracle\21.0' a file called 'create_xevents.sql' must be located...
this is from the file to be processed:
 
```message           Loading Initialdata ...
load_file         ..\db\general\&vers\uc_ini.txt  REPLACE
db_execute        INSERT INTO UC_SVALU SELECT DISTINCT SVALF_FullVName, 1 FROM UC_SVALF WHERE NOT EXISTS (SELECT 1 FROM UC_SVALU WHERE SVALU_SVALF_FVName=SVALF_FullVName) AND NOT SVALF_FullVName IS NULL;
db_execute        delete from ofs where ofs_link = 1 and ofs_oh_idnr_o < 100000 and ofs_oh_idnr_o not in (select ofs_oh_idnr_o from ofs where ofs_link = 0);
db_execute        update host set host_liccategory = 'cloud_agent' where host_htyp_sw = 'ORACLEERPCLOUD';
MIGRATEPASSWORD
ilm_install       chngilm.sql
ilm_switch_in     ilmswitch.sql
process_sql_file  create_xevents.sql
MIGRATE_TO_SEQUENCE
set_vers          21.0
check_db_version```
 
and this is from the the resulting log:
 
```20230324/132312.700 - U00038082 update host set host_liccategory = 'cloud_agent' where host_htyp_sw = 'ORACLEERPCLOUD'
20230324/132312.737 - U00038294 Password hashing initiated.
20230324/132312.737 - U00038042 ../db/oracle/21.0/create_xevents.sql
20230324/132312.737 - U00038252 Could not find file '../db/oracle/21.0/create_xevents.sql'.```
 
In above log we can see once 'process_sql_file  create_xevents.sql' is reached the utility tries to open that file but receives -> Could not find file.
 
Solution is to have both options set correctly (command line argument and config file) and make sure the db.tar.gz was extracted in the correct path and this files exists.