Home » Developer & Programmer » Data Integration » oracle warehouse builder: Please advice Urgent
oracle warehouse builder: Please advice Urgent [message #61023] Sun, 21 March 2004 05:49 Go to next message
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
Re: oracle warehouse builder: Please advice Urgent [message #61024 is a reply to message #61023] Sun, 21 March 2004 06:15 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: Oracle Warehouse Builder Trial : Urgent Help
Next Topic: infomatica doubts
Goto Forum:
  


Current Time: Thu Mar 28 03:46:36 CDT 2024