Archive
Fixed: Oracle iSetup XML Uploading Error
For the past month at work we have been experimenting with Oracle iSetup as a way to migrate Oracle R12 configurations from instance to instance. We had been using Rapid Solutions (Rapid e-Suite) in Oracle 11i in the past, but wanted to try something quicker, more robust, and seeded with Oracle.
The iSetup module worked pretty well in our proof of concept testing. But we ran into a problem when we started migrating our multi organization/business unit configurations. We have multiple business units because we are sharing the instance with another division at our company. Migrating configurations with iSetup brings all the ORGs and sites along with each configuration, however we only wanted our division’s configurations migrated. To solve the problem, we started editing the exported XML before loading it into the new instance.
Editing XML is relatively time consuming and prone to error when editing in a text editor compared to a program designed to edit XML. We tried to use the free Microsoft XML Notepad 2007, however, loading the exported files was causing iSetup to fail on upload. I found the problem and solved it as described below.
Conditions
- Oracle iSetup module in Oracle E-Business suite R12
- XML Documents edited by Microsoft XML Notepad 2007
Symptoms
- iSetup reports error when uploading edited XML files
- Log file as seen here:
oracle.xml.parser.v2.XMLParseException: Start of root element expected.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:320)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:341)at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:205)
at oracle.apps.az.r12.api.BC4JAPI.createAPIEntityItems(BC4JAPI.java:330)
at oracle.apps.az.r12.extractor.cpserver.UploaderContextImpl.validateExtract(UploaderContextImpl.java:170)
at oracle.apps.az.r12.extractor.cpserver.UploaderContextImpl.upload(UploaderContextImpl.java:105)
at oracle.apps.az.r12.extractor.cpserver.UploaderCp.runProgram(UploaderCp.java:74)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
Problem
- Oracle XML files are saved in ASNI text encoding even though the XML header specifies UTF-8
- Oracle iSetup expects ASNI encoded XML files contained within uploaded ZIP file
- Microsoft XML Notepad 2007 saves XML files in UTF-8 encoding
Solution
- Download extraction ZIP file generated by Oracle iSetup
- Extract ZIP file to your computer
- Edit and save extracted XML file in Microsoft XML Notepad
- Open saved file in Notepad (Text Editor)
- Save As ASNI encoding
- Replace existing file within original ZIP file
- ZIP file compression levels and algorithms must reamin intact
- 7-ZIP supports replacing files within an existing file using drag and drop functionality
- Upload updated ZIP file to Oracle iSetup as a new extraction.
- Load extraction into source instance
Conclusion
Fixed: Parted Magic 6.0 USB Boot Error
Conditions
A Windows XP Professional machine creating a Parted Magic USB Boot drive.
Symptoms
Booting from the Parted Magic 6.0 USB drive, the following error is displayed:
SYSLINUX 3.85 2010-02-20 EBIOS Copyright (C) 1994-2010 H. Peter Anvin et al
No DEFAULT or UI configuration directive found!
boot:
Solution
It turns out the non-zipped ISO is corrupt. Use the UNetbootin program to download the iso image or download the ISO zip file from Parted Magic’s website.
Norton’s $140 Free Support
One of my client’s computers recently got infected by several viruses. She attempted to solve the problem by installing Norton Antivirus 2010. After the instillation, her computer would not allow her to logon, so she gave me a call. After doing some research, being unable to solve the problem, which was likely caused by the instillation of Norton Antivirus, I called Norton to receive the “Free Support” that came with the software. The phone support reminded me of my recent post on foreign call centers; Norton’s support was unbelievable and unacceptable. Explaining my interactions with Norton’s support team will illustrate how Norton’s “low cost” foreign call centers destroy consumer trust, damage Norton’s brand, and ultimately reduced the company’s profitability.
Before I elaborate on Norton’s phone support, I want to point you to how I solved the problem. You can see the solution on how to fix a logon logoff loop on a previous post of mine.
Fixed: Windows XP Logon Logoff Loop
One of my clients caught a virus on her computer this last week. In an attempt to correct the problem, she installed Norton Antivirus 2010 before doing a full system scan using the boot disk. The first time she rebooted the computer, she got into a logon logoff loop; after entering her login information and submitting it, Windows XP would automatically logoff the account. It was at this point she contacted me and I came to help her solve the problem. [See the bottom of this post for the solution]
Fixed: LN-S4095DX Overscan
I had a problem with my Samsung LN-S4095DX cutting off the edges of the image and was able to fix it with a firmware update.
Fixed: RCN Hijacking Mistyped URLs
Late last week, I was having a problem with RCN hijacking my mistyped URLs. I was finally able to get them fixed! This post has two different distinct topics; the situation and how the problem was solved. In the near future I will post a new entry analyzing RCN’s business practices.
*Update – December 31st 2009*
I added a symptoms section and two guaranteed solutions at the bottom of this post.
ED HAYES 