Excel mini game beta

Decided to start a side project as refresher for Machine Learning and Artificial Intelligence (AI).

They always say that if you want to learn something, building a game is the best way to go. Below is a video demo of the mini game that I created using excel. 

-It’s based on the game called Salpakan(game of the generals).It is basically a cross between chess and battleship.

https://en.m.wikipedia.org/wiki/Game_of_the_Generals

-the rules is fully incorporated. 

-AI is in place, you can see how P1 piece move from cell to cell.

-Still a crappy AI, need to revise the algorithm. Currently, I’m just ranking the piece based on the position in the board and incorporate randomness on the direction of the movement. 

-will try to improve the AI by building a move datasets then evaluate the move instead of the position of the piece.

-player Vs player is something that I will look into as well. 

-since this is a side project, will post some more update once I make more progress

Tech buzzword

Some tech buzzword that you might want to incorporate in your Thesis, Research or Seminars:

-Cloud

-Big Data ang Analytics

-Machine Learning

-Block chain

-IoT(Internet of Things)

-Crowd Sourcing

-Virtual/Augmented Reality

-Artificial Intelligence

-Virtual assistance

Did I miss anything?

Add in the comment section

Peoplesoft Upgrade manager tables

 PS tables containing information of PUM image

PS_PTIASPRPTHEAD – Details of bug

PS_PTIASPRPTBODY- resolution info

PS_PTIASPRPTMOL – PS objects modified

PS_PTIASPRPTREQS – details of bug prereq

PS_PTIASPRPTRQPOVW – details of the bug post requirements

PS_PTIASTESTOBJREPO – component to test related to the bug

PeopleSoft Update Manager Dashboard (PUM Dashboard)

The Update Manager Dashboard provides a central location for all update tasks. The dashboard provides analytics for PUM (PeopleSoft Update Manager) that assist in determining your current level of maintenance. The various pivot grids provided on the dashboard, provide access into the maintenance logs and bug information for each database uploaded to the PeopleSoft Update Image.

While there is no question that it is a very useful feature specially the About PeopleSoft Image page which allows you  to display information about the PeopleSoft Image.

Select selectPeopleTools, then selectLifecycle Tools, then selectUpdate Manager Dashboard, then selectUpdate Manager Utilities, then selectAbout PeopleSoft Image

The interface is somewhat lacking specially as drilling down to the pre/post requisite bugs requires multiple click. The same process can easily be achieve via excel and macro. Below is the comparison between the excel macro and the About Update Image utilities

PeopleSoft integration with 3rd party using SSL

The PeopleSoft and 3rd party integration using SSL covers the following:

  • Installation of the 3rd party Root Certificate. 
  1. You can request the website owner to send you the copy, subsequently you can open the HTTPS website
  2. Click the padlock icon,view certificate 
  3. on the certificate pane, click on details then copy to file
  4. On the export pane, select base-64
  5. Provide the path and filename and finish the export
  6. Copy the certificare file exported in step 5 to the server hosting the application server
  7. Import the certificate in the IB key store(pskey by default) using the following command: keytool -import -file [pemfile] -alias [3rd party name] -keystore pskey
  8. You are done, the root ca is added to your keystore
  • Setup your SSL certificate
  1. Use keytool -genkey -alias [SPID] -keystore pskey
  2. Complete the prompt and provide the required details
  3. Get it signed by a public known CA by generating CSR use keytool -certreq -alias [SPID] -keystore pskey then send to the CA for signing to get the signed client certificate
  4. Import the signed CA certificate keytool -import -alias [SPID] -file [filename] -keystore pskey
  • Provide the rootCA used to signed your client SSL certificate to the 3rd party to import in their keystore
  • Update your integration gateway.properties file ig.certificateAlias=[SPID] ig.certificatePasswd=[encrypted password]

You are done. Congratulations!

8.55 tools upgrade cache issue

After upgrading to peopletools 8.55, our application engine started failing with a variety of cache error messages.It is a tricky scenario given our setup which is as follows:

  • The failing psae process are triggered via command line using ksh wrapper script with psae commands
  • Upgrade from 8.53 to 8.55 tools version
  • Filesystem is being shared between 2 Linux servers running multiple process  scheduler instance

Took as multiple cache parameters change in the process scheduler before identifying the issue. Turns out that the compatibility with the SAN filesystem is the culprit and has something to do with the filesystem locking mechanism for SAN v3

Errors messages

  • Meta-SQL error at or near position 177 
  • PSPAL: Abort: Unexpected signal received
  • errorno = 2-No such file or directory
  • errorno = 116-Stale file handle
  • errorno = 10-No child processes

 

 

excel search

This is the core function in most of my excel tools, a VBA for searching a rows

Public Function Find_First(my_string As Variant)
Dim Rng As Range
If Trim(my_string) <> “” Then
With Sheets(“Sheet1”).Range(“A:A”)
Set Rng = .Find(What:=epm_domain, _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
If Not Rng Is Nothing Then
MY_COLUMN2_VAL = Sheets(“Sheet1”).Cells(Rng.Row, 2).Value
Else
MsgBox “Nothing found”
End If
End With
End If
End Function

Linux memory script

Below is a simple script to check the total memory and cpu used by process

MY_USER=`id -u -n`
MY_HOST=`hostname`
> /tmp/my_mem_$MY_HOST.txt
echo `date` >> /tmp/my_mem_$MY_HOST.txt
ps -e -o rss,vsz,pcpu,user,args | grep $MY_USER > /tmp/$MY_HOST_prcs.txt
cat /tmp/$MY_HOST_prcs.txt | awk ‘{a=$1;b=$2;c=$3;x=x+a;y=y+b;z=z+c;ma=x/1024;mb=y/1024;{printf(”   Resident memory size is:   %s MB\n   CPU for Processes:        %s %%\n   Virtual memory size is:    %s MB\n”,ma,z,mb)}}’  | tail -3 >> /tmp/my_mem_$MY_HOST.txt
cat /tmp/my_mem_$MY_HOST.txt

which will report the total memory and virtual memory used together with CPU % by the particular user.

Mon Jul 25 01:45:40 EDT 2016
Resident memory size is:   12664.8 MB
CPU for Processes:        19.4 %
Virtual memory size is:    49755.9 MB

Can be modified and place inside a loop for monitoring.

 EPM tools

We are currently maintaining a number of servers for our EPM applications. When you are dealing with tons of servers, it is important to keep an inventory to keep track of the software component installed and the associated environment and servers. 

Since i’m a fan of automation, i created a tool for our inventory with Excel as my usual weapon of choice. The attached video contains the demo of the tool. Feature such as automated login and integration to Linux servers, sqlplus and nt servers are not included due to security reason