When deploying a process flow using the control center of OWB (11r1), following error is raised: Error: RPE-02062: ItemType PKG cannot be dropped as it has running Processes. You must first abort all the running processes using the Oracle Workflow Monitor.INFORMATIONALRPE-02071: Deployment has been aborted due to a previously reported critial error. I used following […]

  When trying to refresh a materialized view based on a query that uses a mssql table (using the SqlServer Gateway), I run into the following error: ORA-12008: error in materialized view refresh pathORA-01400: cannot insert NULL into (%s)ORA-02063: preceding line from MSSQLDB1ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2537ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2743ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2712 […]

For a data warehouse project I’m working on, I like to add a MS SQLServer database as a datasource to OWB. So the first thing I need is an ODBC Datasource. No problem, but there just one small issue which makes the creation of this ODBC datasource a bit less “default”: My database is running […]

This morning I opened Enterprise Manager and instead of the regular “login”-screen, I found following screen:   Everything is up and running but Enterprise Manager is not able to connect to the database instance. Sounds like a connection problem, not? These are the steps I followed to solve this issue and to reset the “sysman”-account: […]

A thing I did not know about my database…. The alert.log file chronologically records messages and errors about database operations such as startups and shutdowns, internal errors (ora-00600), links to trace files and much more.This often makes the alert.log-file, the primary file that needs to be consulted in order to identify and solve issues concerning […]