We had an issue with taking a SQL database offline, and we found that the SQL allowed more control for rolling back in-progress transactions. Here is the article that listed the SQL.
I think our problem had something to do with the SQL Agent. We ended up having to kill the process that was accessing the database, and I am pretty sure it was a SQL Agent process. Then, the database went offline, and we able to restore it.
Peter Slager posted a new article about “What’s new in PeopleTools 8.50”. From the screenshots he posted, it looks very exciting. I am anxious to get in and try it out!
I read several posts about it coming out in late 2009. That is a long time to wait!
This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to copy files between the client and the host operating systems. To see the complete list of steps, click here.
This is a continuation of my virtual PeopleSoft installation. In this step, we will install Wine, a windows emulator that allows Linux users to run Windows-only programs. To see the complete list of posts, click here.
I apologize about the images. I tried to back them up, and I just found out that they did not backup properly. I have tried to take some after the fact.
We have an interface file that we want to delete for security reasons once we have processed the file. But, deleting it from the Application Engine was not as straight-forward as I would have thought.
This does not work:
RemoveDirectory("c:\temp\mytextfile.txt", %FilePath_Absolute);
So, Java to the rescue — this does:
Local JavaObject &javaFile;
&javaFile = CreateJavaObject("java.io.File", "c:\temp\mytextfile.txt");
&javaFile.delete();
Back when I wrote this post, I missed seeing the .Delete() method of the File API object. That would be the better way to make this work. Here’s an example:
Local File &file;
&file = GetFile("c:\temp\mytextfile.txt", "W", "A", %FilePath_Absolute);
&file.Delete();
(Thanks Tim and Andrew for pointing this out.)
I found an interesting site asking for the different Linux distributions on which people have installed PeopleSoft. Right now, it does not have many posts, but maybe over time people will add more as they experiment.
Ketan Kothari published an article and mentioned a new table PSPRUHTABPGLT.
Also, I had another problem with tablespaces and wanted to list all of the records in a tablespace. This is the table I needed: PSRECTBLSPC.
So, I updated the PeopleTools table list.
I added a few more tables to the PeopleSoft Tables listing from a post I saw at PeopleSoft Tipster.
I just came across this new certification (at least to my knowledge new). Somewhere I found a date of August 31st, but don’t quote me on that.
Any way, Oracle has a certification program for PeopleTools Developers. I hope to work toward that path, and you may see some basic posts as I review the topics for the exam. What better way to make sure you understand something than to explain it to someone else?
One question we have had is whether a “hands-on” course is required. If you are self-taught or experience-taught in PeopleTools, do you have to take one of Oracle’s classes anyway as a requirement. That has yet to be answered for me.
Check it out on Oracle’s website:
Just a quick note about some updates on the pages.
First, I added a few tables to the PeopleTools tables reference:
Then, I posted some more in the Step By Step series, but I didn’t add it to the page.