My Oracle Support Banner

"Cannot identify/lock data file 201 - see DBWR trace file" Error when running PFT Allocation Rule (Doc ID 1469644.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Profitability Management (PFT), when attempting to run an allocation, the following error occurs in the batch log file:

ERROR
[UMMLOG] Jun 7,12 11:24:23 : [DACDATABASEGATEWAY]
java.sql.SQLException: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/app/oracle/oradata/ofsaa/temp01.dbf'

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)


[UMMLOG] Jun 7,12 11:24:23 : [SMSDACGATEWAY]Error while Executing query :Error Executing Query. Error: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/app/oracle/oradata/ofsaa/temp01.dbf'

 The issue can be reproduced at will with the following steps:

1. Run an allocation
2. The allocation fails with error

Cause

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
Symptoms
Cause
Solution


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