Deleted Statistics For Column:WF_USER_ROLE_ASSIGNMENTS in the DB Alert log After Upgrading the Database to 12 C (Doc ID 2257444.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3

After migrating 11gR2 DB from Linux to AIX ( 12c ) using transportable tablespaces method -
Now see following messages in DB alert.log after migration


ERROR
-----------------------

Deleted statistics for column:
SYS_STSANI#Z5CVOXUIE8I#880KGGY
of [sub]partition PQH_ROLE of table WF_USER_ROLE_ASSIGNMENTS
Deleted statistics for columns:
SYS_STSRQSM3$QAS3ZI4T0LUI3FRNN,
SYS_STS5YEACF8P2L5##_D1TPLE#Y7
of [sub]partition ENG_LIST of table WF_LOCAL_USER_ROLES
Deleted statistics for column:
SYS_STSANI#Z5CVOXUIE8I#880KGGY
of [sub]partition ENG_LIST of table WF_USER_ROLE_ASSIGNMENTS
Mon Apr 17 14:15:28 2017


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Occurs after migrating 11gR12  DB from Linux to AIX ( 12c ) using transportable tablespaces - method


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms