This page will help you to find a solution to the error Body (b'ERROR', b'53100', b'could not write block 48869735 of temporary file: No space left on device for the particular query - select data_id, start_id, end_id from aaa_is_dtg_to_export order by data_id which you may encounter, when you perform the Export of the application.
AIP Version | Yes/No |
---|---|
8.3.x |
Imaging version | Yes/No |
---|---|
2.x |
RDBMS | Yes/No |
---|---|
CSS |
If Imaging export is failing executing the query
Select data_id, start_id, end_id from aaa_is_dtg_to_export order by data_id,
even after having the suggested configuration and memory allocation (refer configuration) then please follow the below steps to resolve this:
- If your Imaging version is 1.6.x then please apply the below WA:
- Replace the attached 3 files aaa_is_ddl_install .sql, aaa_is_func_install .sql and aaa_is_init .sql which is located under imagingetl/scripts path of your imaging installation directory
- Rerun the exporter.
- If you are facing this issue in 1.7.x version then please apply the below WA:
In file aaa_is_data_install.sql Replace line 8 ( file is located under \imagingetl\scripts of 1.7.x)
insert into aaa_is_cfg_options (option_id, option_name, option_status) VALUES (3,'Data Call Graph Identification',1);
by
insert into aaa_is_cfg_options (option_id, option_name, option_status) VALUES (3,'Data Call Graph Identification',0);
- Rerun the exporter.
If the problem you are facing does not match any case listed in this page, report your problem to CAST Technical Support and provide the following Relevant Input