Author: digitaleagle

Customer Connection

digitaleagle Change Assistant, Server Administration, Uncategorized Leave a comment

Customer Connection is set to migrate to MetaLink3 not this weekend but the next.  Currently, you should be logging into the new MetaLink3 and making sure that you have access.  That way you are ready for the change.

Change is always exciting, and I am hoping that this new site provides users an easier-to-use interface.  I always had trouble searching through the old Customer Connection.  Currently, it is hard to tell because none of the customer connection information exists in the new system.

I haven’t read all of the documentation yet, and so, I probably shouldn’t be commenting yet, but I first thought that Oracle was combining MetaLink and Customer Connection.  But, why do we have two separate systems?  From what I can tell, I will have to access MetaLink for my Oracle patches and MetaLink3 for PeopleSoft patches.

Another thing I found funny was that the Customer Connection Login page does not have a note or warning about the change.  Since the change is only a couple of weeks away, I would have thought I would see something reminding me.

I did find a thread going for comments on the changes.  Please share your comments.

Resources

SQL Server Take Offline

digitaleagle Server Administration, Uncategorized Leave a comment

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.

Resources

SQL for taking databases offline

PeopleTools 8.50 Preview

digitaleagle PeopleTools, Uncategorized Leave a comment

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!

Resources

Step By Step Virtual PS Install: Install Wine

digitaleagle Server Administration, Uncategorized, VMWare 4 Comments

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.

Read More

Deleting Files from PeopleCode

digitaleagle Java, PeopleCode, Uncategorized 8 Comments

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();

Update (8/20/2014):

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.)

Resources