Month: January 2010

Oracle Info on Sun Merge

This article interested me:

Computer World: Oracle to provide Sun road map next week

I am curious what this will mean for some of Sun products.  The ones that strike my curiosity are:

MySQL: Oracle bought a piece of MySQL already.  Now they are buying the whole thing.  I wonder what this means to the business model and distribution.  Are they going to keep it open source in the same fashion?  Note that Oracle already owns the Inno DB Engine for MySQL (see Wikipedia)

Solaris: Oracle already has Unbreakable Linux.   So, this makes the second OS for them.

Java: Oracle already has the JRocket VM from Bea.  Are they going to merge them, or do they fit different niches?

Virtual Box:  Oracle already has their Oracle VM, which is based off of Xen.  Again, will they try to merge them?

Hardware: I liked the suggestion that maybe Oracle might offer a Database Appliance with both their software and hardware.  The problem is that database implementations are so varied, it would be hard to create a one size fits all solution.

Open Office: I almost forgot this one.  This puts Oracle more in competition with Microsoft.  This is the one major alternative for MS Office.  This could put a big hurting on the world of Linux if Oracle harms Open Office.

Net Beans: Oracle already has JDeveloper.  Again, this is more redundancy.

Well, I guess we will find out more tomorrow.  Although, I still wonder if they are still changing their plans for PeopleSoft.  Sun is such a large company, there is no way they could come up with a perfect plan that they won’t have to change something.  We may have to wait 5 years or more to see where they take it.

Other related articles:

Bex Huf: Finally! Oracle Gets Approval for Sun Acquisition!

The H Open Source: Oracle clarifies plans for Java tools and OpenOffice

Information Work: MySQL Users Wary On Oracle Acquisition

What company is next?:

The ORACLE-BASE Blog: Red Hat heading for Oracle buyout?

I remember reading someone mentioning that when Red Hat bought JBoss, it put them in competition with Oracle.  Then, we saw Oracle start selling Unbreakable Linux.  I wonder if they are really on the radar?

Letter Generation Error

We had an error with the 3CEngine the other day.  Here is the error and the fix in case it helps anyone else or in case I have this same problem later on.

From the Application Engine Output:

File: e:pt84912b-retailpeopletoolssrcpsappengaedebug.hSQL error. Stmt #: 1603  Error Position: 0  Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_COMMUNICATION' with unique index 'PS_COMMUNICATION'.
Failed SQL stmt:INSERT INTO PS_COMMUNICATION (COMMON_ID, SEQ_3C, SA_ID_TYPE, COMM_DTTM, INSTITUTION, ADMIN_FUNCTION, COMM_CATEGORY, COMM_CONTEXT, COMM_METHOD, INCLUDE_ENCL, DEPTID, COMM_ID, COMM_DT, COMM_BEGIN_TM, COMM_END_TM, COMPLETED_COMM, COMPLETED_ID, COMPLETED_DT, COMM_DIRECTION, UNSUCCESSFUL, OUTCOME_REASON, SCC_LETTER_CD, LETTER_PRINTED_DT, LETTER_PRINTED_TM, CHECKLIST_SEQ_3C, CHECKLIST_SEQ, COMMENT_PRINT_FLAG, ORG_CONTACT, ORG_DEPARTMENT, ORG_LOCATION, PROCESS_INSTANCE, EXT_ORG_ID, VAR_DATA_SEQ, EMPLID_RELATED, JOINT_COMM, SCC_COMM_LANG, SCC_COMM_MTHD, SCC_COMM_PROC) SELECT A.COMMON_ID, 1, A.SA_ID_TYPE, GETDATE(), A.INSTITUTION, A.ADMIN_FUNCTION, A.COMM_CATEGORY, A.COMM_CONTEXT, A.COMM_METHOD, A.INCLUDE_ENCL, ' ', ' ', { fn CURDATE() }, NULL, NULL, 'N', ' ', NULL, A.COMM_DIRECTION, A.UNSUCCESSFUL, A.OUTCOME_REASON, A.SCC_LETTER_CD, NULL, NULL, A.CHECKLIST_SEQ_3C, A.CHECKLIST_SEQ, A.COMMENT_PRINT_FLAG, 0, 0, 0, 0, ' ', 0, A.EMPLID_RELATED, A.JOINT_COMM, ' ', ' ', ' ' FROM PS_ENG_COMM_TMP4 A WHERE COMMON_ID = '1784656' AND SA_ID_TYPE = 'P' AND INSTITUTION = 'NPCCS' AND EVENT_3CS_ID = 'F24_COMM' AND COMM_KEY = 'F24' AND SEQNO = 331

Process 11123 ABENDED at Step 3CENGINE_LIB.COMMINST.Step02 (SQL) -- RC = 805 (108,524)

The keys on the Communication Table are the COMMON_ID and the SEQ_3C.  So, most likely, the problem is that is trying to insert a Sequence number that already exists.

Here is some SQL that you can use to find the problem:

SELECT TOP 200 A.COMMON_ID, A.SEQ_3C, B.SEQ_COMM_LAST
FROM PS_COMMUNICATION A, PS_LAST_3CS_TBL B
WHERE A.SEQ_3C = (SELECT MAX(SEQ_3C)
FROM PS_COMMUNICATION
WHERE COMMON_ID = A.COMMON_ID)
AND A.COMMON_ID = B.COMMON_ID
AND B.SEQ_COMM_LAST < A.SEQ_3C

Here is some SQL that you can use to fix the problm:

UPDATE PS_LAST_3CS_TBL
SET SEQ_COMM_LAST = (SELECT MAX(SEQ_3C)
FROM PS_COMMUNICATION A
WHERE A.COMMON_ID =  PS_LAST_3CS_TBL.COMMON_ID)
WHERE EXISTS (SELECT ‘X’
FROM PS_COMMUNICATION A
WHERE A.COMMON_ID =  PS_LAST_3CS_TBL.COMMON_ID
AND A.SEQ_3C > PS_LAST_3CS_TBL.SEQ_COMM_LAST
AND A.SEQ_3C =  (SELECT MAX(SEQ_3C)
FROM PS_COMMUNICATION A
WHERE A.COMMON_ID =  PS_LAST_3CS_TBL.COMMON_ID) );

If you want to look at the code in the App Engine, the Sequence Number is calculated in the 3CENGINE_LIB.COMMLSEQ section.  It loads the Sequence number from the PS_LAST_3CS_TBL table.

PeopleSoft HCM9.1/PeopleTools 8.50 Virtual Images

Back in September, I talked about Virtual Images from Oracle.  Well, I have downloaded the images and started tinkering with a little bit.  It’s not much, but here is what I have so far.

You can download the images from:

http://edelivery.oracle.com/oraclevm

The images are compressed multiple times.  If you are in Windows, I would recommend using 7-zip for extracting.  WinZip will probably do the trick too.  In, Linux, FileRoller did the trick for me.  The unzip and tar commands would do just as well.

Here are the sizes that I found:

Application/Batch Server

  • V18477-01.zip = 3.6 GB
  • Extracts to OVM_EL5U2_X86_64_AB85002_HCM91_PVM.tgz = 3.6 GB
  • Extracts to folder: OVM_EL5U2_X86_64_AB85002_HCM91_PVM = 13.9 GB

Web Server

  • V18478-01.zip = 2.0 GB
  • Extracts to OVM_EL5U2_X86_64_PIA85002_PVM.tgz = 2.0 GB
  • Extracts to folder OVM_EL5U2_X86_64_PIA85002_PVM = 9.9 GB

Database

This one is a little more complicated because it came in two parts.

Part 1

V18479-01.zip = 3.4 GB

Extracts to OVM_EL5U2_X86_64_HCM91_PVM.tgz.1of2 = 3.5 GB

Part 2

V18480-01.zip = 3.2 GB

Extracts to OVM_EL5U2_X86_64_HCM91_PVM.tgz.2of2 = 3.3 GB

Combining:

cat OVM_EL5U2_X86_64_HCM91_PVM.tgz.1of2 OVM_EL5U2_X86_64_HCM91_PVM.tgz.2of2 > OVM_EL5U2_X86_64_HCM91_PVM.tgz

OVM_EL5U2_X86_64_HCM91_PVM.tgz = 6.8 GB

This extracted to the folder OVM_EL5U2_X86_64_HCM91_PVM = 55.6 GB

You could save yourself some disk space by piping the cat output directly to tar (I didn’t test this):

cat OVM_EL5U2_X86_64_HCM91_PVM.tgz.1of2 OVM_EL5U2_X86_64_HCM91_PVM.tgz.2of2 | tar -xz

Cat is a Linux/Unix command.  I am not sure how you would do that in Windows.

Now, that you have them extracted, the next step is to get them booted.  I didn’t try to install the Oracle VM or Xen.  My plan is try to get them to run in Virtual Box, but I haven’t accomplished that yet.  More on that to come.  I hope the file sizes and such help for now.