My Oracle Support Banner

Logs with Incomplete Filenames are Generated when Executing SOA Purge Script for Microsoft SQL Server (Doc ID 1638718.1)

Last updated on MARCH 12, 2019

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


While executing the "soa.delete_instances" procedure as described in Oracle FMW Guide ( for purging instances in Microsoft SQL Server ,database execution logs are not getting generated correctly. If user set the input parameter @write_file of the procedure with the value '<FILE_PATH>\out1.txt', two files instead of one single file are generated: '<FILE_PATH>\out1.tx' and '<FILE_PATH>\out1.txt'.One file contains only the following entry : "20 NOV 2013 07:18: Number of rows in table soa.PRUNE_RUNNING_INSTS Workflow inserts into prune table = 0 "and the other file has the rest of the details. Ideally, the procedure should generate only one file with the name the user has provided.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.