Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OC4J Instance

445562Feb 12 2006 — edited Feb 27 2006
We just migrated our forms and report 6i to Developer Suite 10g Release 2 (10.1.2).
I need to start the oc4j instance to be able to run my form on my computer from form builder. But i have that windows open and it's bugging me. Is there a way to start that via a window service?

It take me 1-2 minute to execute a form from form builder. Is there a way to accelerate a form to execute?

Comments

Deepak Patil
Well this looks like that one of your columns or tables are not in the respective database.

Please review the query (step) on which the process has failed , and check if the column EMPLOYE_STATUS_NK is available in the target or source.

Thanks
Dk
759013
Deepak,

Thanks for qucik reply. First column is only present in targer so executing it in target as it's a reference to an Oracle Sequence. Third column employee_description is mapped to a table in stagin.


I confirmed ; column EMPLOYE_STATUS_NK is present in target database and mapped with primary key of source table. I am executing on Source. This column is also marked as key in target datastore. It still give same error.




Any suggestions ?
Deepak Patil
quicker way to resolve this will be if you can share the SQL in this step where you are getting this error.

Some points to check -

if it's a seq number make sure it runs on "target" , it should be "check not null" and of course the Sequence is present in the database (here in target).

Thanks
Dk
759013
Deepak,

I closely followed the sql as you mentioned and figured out why I was getting this error. I had renamed a column in the target database. I added an "_" in column name. ODI had intially created a error table for this table, however ot again tried to create a new table but with a warning that table ALREADY EXISTS.
This table still had old table defination and would give an error "invalid and name of column.

Thanks.
Greenwich
Deepak Patil
Good stuff... mark the post as resolve if possible :)...
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2006
Added on Feb 12 2006
4 comments
518 views