search

markddrake / YADAMU---Yet-Another-DAta-Migration-Utility

A utility for Migrating Data between Oracle, Postgres, MySQL MariaDB, Snowflake. Stage Data from supported database to Amazon S3 and Azure Blob Storage in JSON and CSV Formats
MIT License
17 stars 10 forks source link

Oracle21c: Unhandled Rejection comes from Query Stream when "ORA-13199: wk buffer merge failure" error reported #241

Closed markddrake closed 11 months ago

markddrake commented 12 months ago

It appears that when the Oracle Driver is run with degree of parallel > 2 and "ORA-13199: wk buffer merge failure" error is reported the exception is raised multiple times by the QueryStream Implementation. It also appears that the exception is raised in a such a manner that it causes an "unhandledRejection" exception condition.

markddrake commented 12 months ago

A workaround has been implemented that marks the exception as handled when it is trapped and processed. This allows the process level unhandled rejection handler to identify that the exception has been caught and processed correctly by Yadamu, and consequently ignore that the fact that is has caused an unhandledRejection condition.