OraFAQ Forum: Data Integration » oracle warehouse builder: Please advice Urgent

Home » Developer & Programmer » Data Integration » oracle warehouse builder: Please advice Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle warehouse builder: Please advice Urgent [message #61023]

Sun, 21 March 2004 05:49

Vinny75
Messages: 44
Registered: October 2003

Member

hello,

I just installed trial version of OWB on my win2k desktop. It installed the OBW client and server components and also created the designer and runtime repository. The source and target db is on Oracle DB on Solaris box. My OWB client is on my win2k desktop. I managed to create simple transformation. But when attempting to deploy from OWB client, I get this error. Why does it say runtime service is not available? My installation should have created all the required services on my desktop. Please help.

oracle.wh.repos.sdk.exceptions.WBException: ORA-20029: The runtime service is not currently available
ORA-06512: at "OWB_RRU.WB_RTI_EXCEPTIONS", line 82
ORA-06512: at "OWB_RRU.WB_RTI_QUEUES", line 197
ORA-25207: enqueue failed, queue OWB_RRU.WB_RT_SERVICE_QUEUE is disabled from enqueueing
ORA-06512: at "OWB_RRU.WB_RTI_SERVICE_DEPLOYMENT", line 63
ORA-06512: at "OWB_RRU.WB_RTI_SERVICE_DEPLOYMENT", line 263
ORA-06512: at "OWB_RRU.WB_RT_DEPLOYMENT_CONTROL", line 38
ORA-06512: at line 1

oracle.wh.repos.sdk.exceptions.WBException: ORA-20029: The runtime service is not currently available
ORA-06512: at "OWB_RRU.WB_RTI_EXCEPTIONS", line 82
ORA-06512: at "OWB_RRU.WB_RTI_QUEUES", line 197
ORA-25207: enqueue failed, queue OWB_RRU.WB_RT_SERVICE_QUEUE is disabled from enqueueing
ORA-06512: at "OWB_RRU.WB_RTI_SERVICE_DEPLOYMENT", line 63
ORA-06512: at "OWB_RRU.WB_RTI_SERVICE_DEPLOYMENT", line 263
ORA-06512: at "OWB_RRU.WB_RT_DEPLOYMENT_CONTROL", line 38
ORA-06512: at line 1

Report message to a moderator

Re: oracle warehouse builder: Please advice Urgent [message #61024 is a reply to message #61023]

Sun, 21 March 2004 06:15

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

I don't know anything about Warehouse Builder, but I've dealt with some ORA-25207 "enqueue failed, queue_name is disabled from enqueueing" errors before.

Try to enable the DB queue manually:

execute DBMS_AQADM.START_QUEUE('OWB_RRU.WB_RTI_EXCEPTIONS', TRUE, TRUE);

Best regards.

Frank

Report message to a moderator

Previous Topic:	Oracle Warehouse Builder Trial : Urgent Help
Next Topic:	infomatica doubts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:54:32 CST 2024