Create XSD from XML file

In case you need the XSD file for bursting option within XML Publisher, you may like to use the below converter:

http://www.flame-ware.com/products/xml-2-xsd/default.aspx

Note: XML Publisher created using PS Query, we have build in option to create XML and XSD files. But if you are using Application engine to generate XML file you have to use the above given link.

Thanks to Murali for providing the above info.

PeopleTools Compare/Copy Projects

I would like to share some findings/issues with Compare Projects between instances.

1. Issue: XML Objects will not be migrated properly when you copy.
Resolution: If you have XML Objects in your project, make sure that you add XML Objects to your project again, after you compare and before migrate. or in other words after you add XML objects you should not compare.
2. Issue: Roles will not be Compared.
Resolution: Don't Panic, Compare Manually. Open PIA of Source and Destination and compare manually.
3. Issue: Processes Definitions and Job Definition will be shown in Compare report even after migration was successful.
Resolution: Compare manually from PIA.

Intro to XML/BI Publisher demo

For those who are not familiar with the XML/BI Publisher, you may find a simple demo that walks you through creating a simple XML Publisher report:

http://oukc.oracle.com/static09/opn/apps09/fusion/84690/020410_84690_DEMO.html

Issue: PeopleSoft Webserver(WebSphere) not getting Stopped

Issue: Not Able to stop PeopleSoft Webserver(WebSphere).
Symptoms: When trying to stop service with command 'stopServer.sh server1', it has shown the following message
0000000a SSLConfigMana I CWPKI0027I: Disabling default hostname verification for HTTPS URL connections.
0000000a AdminTool A ADMU3201I: Server stop request issued. Waiting for stop status.

and after that i neither get the following confirmation message nor error message:

0000000a AdminTool A ADMU4000I: Server server1 stop completed.

Resolution: Resolution is to kill the WebService process. Difficult part is to find process ID to be killed. there is a way to findout the process ID of the WebService. in the following path

PSHOME:/psoft/[instance name]/webserv/[Instance Name]/logs/server1/

'*.pid' file will contain Process ID of the WebService. Before you kill make sure that you kill child processes if any.

Fix for VMWare error: Error while opening virtual machine. This virtual machine appears to be in use

I received the following error when trying start a VMware machine :

'Error while opening virtual machine. This virtual machine appears to be in use.'

To resolve the issue, delete all of the '.lck' files in the directory given in the error message. This allowed to start VM.