In this blog post, let’s learn about the error message “1232 A file error occurred when saving dropped table DDL for table table-name to oss-pathname.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1232 A file error occurred when saving dropped table DDL for table table-name to oss-pathname.
Reason for the Error
An OSS file system error occurred when you attempted to save a table DDL. Possible reasons are:
The directory /usr/tandem/sqlmx/ddl did not exist or could not be created.
The system did not have write access to /usr/tandem/sqlmx/ddl.
Insufficient OSS file space was available.
Solution
Either correct the file system problem and drop the table or perform a SHOWDDL on the existing table, capture the output, set. SAVE_DROPPED_TABLE_DDL to “OFF,” and drop the table
