Regarding Polymorphic View Usage Behavior -2

Hi Steve,

I tried the solution you listed in the forum post, but still the value is not coming up at the UI.
Here, want to show you the steps I did, and where I stand right now:
As show in the following figure:

I am using PolyTestTableBase1VO as my Base VO. Now I filtered the query to fetch only the records with descriminator value as ONE.
As a result I just need to add 1 subtype to the Base VO to test the pageDef changes. The descriminator value in BaseVO is null to get all the records.
In the following figure, you can see that the descriminator value in ChildVO is ONE, and its added as a subtype to Base VO in AM's data model, and the attribute value is visible in AM Tester:

The following figure shows the structure of the page, where the BaseVO is dropped to create the table, and I added the extra column to render ExtraAttr1 value.
I want to render column always so no condition is added for rendering.

The following figure shows the pageDef content, where the subtype details are added as second nodeDef:

And the following figure shows that the value is not visible:

Could you please tell me what I am missing now?

Thanks.

Regarding Polymorphic View Usage Behavior

AM Tester shows extra attributes in case of polymorphic view usage behavior :

The data model is pretty much same as used in the following forum post :
https://forums.oracle.com/forums/thread.jspa?messageID=10039357&#10039357

VO Not Getting Added To Jar.

First, clean all.

Deploy Model

The BaseParamUserEmailVVO is not visible in the JAR

Compile the VO manually:

Deploy the JAR again, and you can see the VO is added now in the JAR:

Solution to ORA-01261: When Control Files are deleted.

I was trying to start my local DB, but suddenly it started throwing the following error:

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

Later on figure out that control file is not there anymore and flash_recovery_area folder is corrupt.
From the following forum:
https://forums.oracle.com/forums/thread.jspa?threadID=431560&start=15&tstart=0

Figured out that following needs to be done:

1) SQL> startup nomount
2) SQL> create control file noresetlogs ...
3) SQL> alter database open;

The CREAT CONTROL FILE command that I used is as follows:

CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:\oracle\product\10.2.0\oradata\orcl\REDO01.LOG' size 50m,
GROUP 2 'D:\oracle\product\10.2.0\oradata\orcl\REDO02.LOG' size 50m,
GROUP 3 'D:\oracle\product\10.2.0\oradata\orcl\REDO03.LOG' size 50m
DATAFILE
'D:\oracle\product\10.2.0\oradata\orcl\ATTRS1_OID.DBF',
'D:\oracle\product\10.2.0\oradata\orcl\BATTRS1_OID.DBF',
'D:\oracle\product\10.2.0\oradata\orcl\DEV_APM.DBF',
...
//List of all the DATA FILES except TEMP DATA FILES
...
'D:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'D:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'

CHARACTER SET WE8MSWIN1252
;

After following the above 3 steps, I was able to restart my DB.

How To Remove Account Locked Warning Messages.

If you see messages like these while starting the server:

<Apr 3, 2011 2:05:16 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

<Apr 3, 2011 2:05:17 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

<Apr 3, 2011 2:05:18 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

Than what you need to do to avoid them is :

1. Open Admin Console
2. Go to JDBC Data Sources
3. Select mds-SpacesDS data source name.
4. Go to the Connection Pool tab and from the properties section, fetch user value, example as shown below:

user=DEV_MDS

oracle.net.CONNECT_TIMEOUT=10000

abandonedConnectionTimeout=600

sendStreamAsBlob=true

Here, the user DEV_MDS is locked.

Connect to database as sys user and run the following command:

ALTER USER DEV_MDS ACCOUNT UNLOCK;

That's it.