I was handed a task to build an install guide from the higher ups. They asked for clear instructions, documented steps and screenshots to go with it all. I was already looking forward to it.
Conditionally Purge BPEL Instances on 10.1.3.x
Marc Kelderman wrote a helpful article on this topic: http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html One of the users there notes: Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date. Trying to do something more elaborate we have noticed that if you use the script in this article as a basis then rows in xml_document table are not removed. We have written code to conditionally purge BPEL instances in a sophisticated manner, taking into account custom logic, scheduling, and performance for multiple customers in SOA/BPEL versions 10.1.2 and 10.1.3.x. … Read More
Oracle BAM – SQL to List Users and Roles
I don’t really like what Oracle did with BAM user/roles and authentication. I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a look at your users and their roles as BAM understands them: 1 2 3 4 SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur WHERE iur."UserID" = iu."SysIterID" ORDER BY iu."SysIterName"SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur … Read More
JDeveloper Freezing – Optimize Performance for Large BPEL Flows
I was running into issues with my Jdev being inadequately slow, hanging, or freezing when working with large BPEL process even though the computer CPU and memory were not even close to maxed out. A little trick I learned in the past to help this problem is increasing the heap size for JDev to use.
Underpowering Oracle Portal 10.1.4 on purpose….and winning.
Our friends at Oracle give us a nice list of requirements for their Application Server and Portal products, to help us define to our customers what is needed to run these mammoths of ability and power. But can you make it run on less? And if so, how much less?
Note: Oracle does not condone or recommend any of the following practices. In a real production environment, I agree. This was done as a test to see if it could be done.
Oracle says that to run Application Server 10g you need a few things. For this post, we are on the Windows Server OS. It is put forth you need to be on at least SP1 of Server 2003, Have a minimum 300 MHz CPU (although they recommend a 450, and really recommend 2 GHz and up), and 1 GB of RAM, on an NTFS file system. There is of course the need for a Network interface, and some other ancillary items, but above are the core hardware specs, pulled from their installation documents.
If I said you could make it work in 640 MB of RAM, at 1.4 GHz of CPU on a desktop motherboard, you might say I’m crazy…
Oracle BPEL Email Notification – Remove Attachment
If you have used the email notification activity in Oracle BPEL (up through the latest version at the time of this writing, 10.1.3.3.1), you might have found that you always get an attachment for your email body, even if you don’t want one. There is a solution: Once in the scope of the email notification activity, look for a copy block like the following. It typically contains ‘NotificationAttachment1.html’: 1 2 3 4 5 <copy> <from expression=”string(’NotificationAttachment1.html’)”/> <to variable=”varNotificationReq” part=”EmailPayload” query=”/EmailPayload/ns1:Content/ns1:ContentBody/ns1:MultiPart/ns1:BodyPart[1]/ns1:BodyPartName”/> </copy><copy> <from expression=”string(’NotificationAttachment1.html’)”/> <to variable=”varNotificationReq” part=”EmailPayload” query=”/EmailPayload/ns1:Content/ns1:ContentBody/ns1:MultiPart/ns1:BodyPart[1]/ns1:BodyPartName”/> </copy> You should remove this completely and voila – you’re email with show … Read More
Salesforce.com Error Migrating 10.0 to 11.1 API – Oracle BPEL
If you have experienced issues when moving from Salesforce.com API version 10.0 to 11.1, you should double check your content headers and security setup. Following is the error you might receive in Oracle BPEL: 1 2 3 4 5 6 7 8 9 10 11 <remoteFault xmlns="http://schemas.oracle.com/bpel/extension”> <part name="summary"> <summary> exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: oracle.j2ee.ws.saaj.ContentTypeException: Not a valid SOAP Content-Type: text/html; charset=UTF-8 </summary> </part> </remoteFault><remoteFault xmlns="http://schemas.oracle.com/bpel/extension”> <part name="summary"> <summary> exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: oracle.j2ee.ws.saaj.ContentTypeException: Not a valid SOAP Content-Type: text/html; charset=UTF-8 </summary> </part> </remoteFault>
Oracle BAM Sucks, For Now
Our team has been working with BAM since Oracle took it on (we rolled out BAM reports in 2007). The product is certainly “interesting” and has some cool auto-refresh capabilities that make for a nice demo to executives. However, there are a few pieces to the overall reporting puzzle that, well, leave me a little puzzled… No ability to write reports that query an RDBMS or even the BAM data objects — I hope you like simple query logic. No ability to manipulate data in the BAM data objects: I just want to run an update statement people. Filters that … Read More