The Task: Take and load, using MySQL, a flatfile of over 450 colums and over 145,000 rows of data and put it into a staging table.
The Conditions: The data may not be altered prior to the staging load, or in the staging load. Only when the data is loaded from staging to the final tables may it be altered.
Oracle BPA Suite 10.1.3.4 is now available from Oracle and has some excellent enhancements, especially in the way of transformation and integration with Oracle BPEL: Oracle BPA 10.1.3.4 Download for Windows Oracle_BPA_Suite_10.1.3.4_download.zip The download comes with: Oracle Business Process Architect (Windows) Oracle Business Process Publisher (Windows) Important Note: Unlike the previous Oracle BPA downloads on oracle.com, the 10.1.3.4 download does NOT contain the Oracle Business Process Repository Server (Windows and Solaris). We have been using BPA Suite since beta, but for those of you who don’t already know, Oracle BPA Suite provides tools for process modeling and simulation, with integration … Read More
Undeploying a single application in Oracle Application Server is pretty straightforward. However, I had a scenario where I needed to undeploy many human tasks (since each of them is deployed as an application in OracleAS) and undeploying them one-by-one was becoming painful. I recalled finding a place to undeploy mutiple applications, but couldn’t remember it exactly. After digging a little, I figured it out again and wanted to write it here in case it can help you (or me in the likely event that I forget again). From the Cluster Topology page of Enterprise Manager Application Server Control, you get … Read More
Views make the world appear differently. The concept was familiar to me, although under a different concept. Virtual tables. Creating something you can query and use as if it were a table, even though it’s not. Great tool for smoothing things out, and easing the work load on the DBA.
I return again to my APEX SQL command box, break open my books and guides, and prepare once more to do battle. In the time I spent away from it, I had many concepts and ideas floating in my head, and rather than do the smart thing and look them up in the book, I first try them out in my own example system.
So you want to learn SQL. Not a problem. You want to learn Oracle SQL, not a problem. You have no knowledge of SQL, not a real problem. All you need is some patience, access to a computer and the internet, and a little bit a familiarity with how to use a computer.
This is a very, very common complaint I hear from Oracle BPEL developers, testers, and production support.
I find there are a couple reasons that this can happen:
1. The flow has faulted sometime after the wait activity, but never…
Are you running out of disk space because your domain.log is growing too fast? Open BPEL_HOME/domains//config/log4j-config.xml Change the appender class from com.collaxa.cube.util.CXRollingFileAppender to org.apache.log4j.RollingFileAppender Add a new parameter: 1 <param value="50MB" name="MaxFileSize" /><param value="50MB" name="MaxFileSize" /> Here is an example of what the file should look like in the end: 1 2 3 4 5 6 7 <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender class="org.apache.log4j.RollingFileAppender" name="A1"> <param value="true" name="ImmediateFlush" /> <param value="false" name="Append" /> <param value="D:/soa/product/10.1.3.1/as_1/bpel/domains/default/logs/domain.log" name="File" /> <param value="50MB" name="MaxFileSize" /> <param value="10? name="MaxBackupIndex" /><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender class="org.apache.log4j.RollingFileAppender" name="A1"> <param value="true" name="ImmediateFlush" /> <param value="false" name="Append" /> <param value="D:/soa/product/10.1.3.1/as_1/bpel/domains/default/logs/domain.log" name="File" /> <param value="50MB" … Read More
