SendMaster Fail to Start With Error "java.lang.IllegalArgumentException: No attributes are implemented

SendMaster Fail to Start With Error "java.lang.IllegalArgumentException: No attributes are implemented"

Steps to resolve the issue:

If PS_HOME directory not present in your  local system, do the below

1.      Copy jre, secvault, sendmaster folders from ps_home location to your local location

       

2.      Go to sendmaster folder and edit file StartSendMaster.bat with notepad.

Set PS_HOME = {folder name}

                         In my case c:\sendmaster

                  

3.      Inside sendmaster folder and look for lib folder,remove xerces.jar from it

For eg:  C:\sendmaster\sendmaster\lib

With above steps you should be able to open sendmaster

SqlCl / SdSql on LDAP

At least some of you might have heard about SqlCL. if you don't, you guys know how to find it ..easy ( google it..!! or refer to http://www.thatjeffsmith.com)


SqlCL - In Simple words..works same as sqlplus but with additional (I will say Cool) set of new commands to interact with database.


so how do you install it.


Pre-requisite:
             SQL Developer(latest version)
             Database Client (either Full or Instant Client).
             Correct environment variable.


Download here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html





unzip the folder , below is the dir structure
                          for eg: C:\Temp\sqlcl
                                                             \bin
                                                                   \sql.bat
                                                                   \sql.exe
                                                                   \sql
                                                             \lib
                                                                    \.. some jar files


 if windows, you will open sql.exe or sql.bat file to open the command line.  if you open up sql.bat file, you'll see two different environment  variables SQL_HOME and ORACLE_HOME make sure those are right. (in my case I edited the file to modify file set SQL_HOME path set to direct sql developer path)

If you've local database or database client with TNS file installation is straightforward.
   
         Click on Sql.exe
                       enter username/password@dbname
                or
         Open Command line:
                       C:\temp\sqlcl\bin>sql /nolog
                       sql>connect test_user\test_pwd@test_servicename
                               connected.


If are using LDAP to sign in Database, below additional to step to follow.


Set the environment LDAPCON (by setting up in windows environment variable or by using set or export command

set LDAPCON jdbc:oracle:thin:@ldap://ldap.test.com:123/#ENTRY#,cn=OracleContext,dc=test1,dc=test1

(All the bold lettered information typically you will find in LDAP.ora file in ORACLE_HOME folder)


         Click on Sql.exe
                       enter username/password@dbname
                or
         Open Command line:
                       C:\temp\sqlcl\bin>sql /nolog
                       sql>connect test_user\test_pwd@test_servicename
                               connected.

for commands help refer to http://www.thatjeffsmith.com blog.

:-)

PeopleTools 8.54 Dynamic Alert Sliding Window Demo/ Event Notifications

The dynamic alert sliding windows concept is interesting and notifications are real time. It uses  web socket Push technology in Webserver.

I gave shot on configuring the event notification and its pretty simple when compared to the REN Server configuration. Impressed. 

Click below link to see the demo 

PeopleSoft Application Engine Drop Temp Tables & re-Create

Several time based on the requirements we have to remove and rebuild the temp tables which are specified in AE.

Below are the steps I followed to delete.

1. Find out the temp tables which are used by specific table using below query.

   select  table_name from all_tables where table_name like '%ABCTAO3%';
 
2. Using below sql generate the Drop Script.
 
     select 'DROP TABLE '||table_name||';' from all_tables where table_name like '%ABCTAO3%';



3. Execute the generated script in Database. I prefer to run these in DataMover.

Then build the table in Appdesigner.

Note:- Sometime after deleting temp tables from Database, I tried to build from AE the temp table again it doesnot create temp table instances. (How I know its created or not - look at the build script which generated). So I have to increase or decrease temp table instance count,save the AE and then change the instance count again back to original and save then Build the temp table.

for more information about temp table, you could follow the link too..

http://blog.psftdba.com/2009/01/managing-changes-to-number-of-instances.html

:-)

JOLT_CAT:1626: ERROR: Jolt client (ip address) does not have proper application password

Trying to login PIA, 

   I got below error messages

   CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ServiceException: Invalid Session 
      or
 application server down at this moment.

So I looked at the app server log &  below error message

So obviously I googled, I got information from below site managed by Nicolas:

http://gasparotto.blogspot.com/2011/11/domainconnectionpwd-parameter.html.

So I checked web server configuration.properties for DomainConnectPswd parameter. Found the value its encrypted like {V1.1}qeurng=. 

& I checked in app server for the same parameter it has some value ENCRYPT. From Nicolas, he says both places this parameter should be same.

So what i did was manually opened psappsrv.cfg & changed DomainConnectPswd parameter to blank.

& Rebooted the app server. Whoa!! able to connect PIA.. Thanks Nicolas providing wonderful info.

PeopleTools 8.53/ PS 9.2 : PS Query :New Functionality Transformations Using XSLT

In PeopleTools 8.53, Oracle has added a new tab called Transformation. Hmm Transformation heard somewhere.. ya.. used in Integration broker in order to transform(or format) the input message. 

So what is this transformation do with PS/Query ?

PeopleBooks:
PeopleBooks Query Transformations

Basically If you want to transform the PS Query output to a different presentation format rather providing in standard table format.

for eg;  you want table header background with different color & you need some heading for report & want CSV output report readily...etc i..e User Defined Output

In Order to achieve all these kind of things need to have little about  XSLT, HTML and XPATH language.

 basics can be found http://www.w3schools.com/

So I have tried my self example :

Created query & In the Transformation tab & Click Add XSLT name you XSLT (Why naming XSLT coz you can have n number of XSLT formats I dont know the max limit ).

Click & click on Preview XSLT

Solution : TNS:listener does not currently know of SID given in connect descriptor

When em trying to connect db client with the problem TNS the db throws below error

Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor.

Checked the TNS everything looks fine.

Login to db server :

Checked ORACLE_SID & ORACLE_HOME environment variables are properly set or not. They looks fine.

Next in command line or putty

$lsnrctl status         (to the know the status of current listener)

the log indicated me  listener started with no services. Googled the to understand the issue found out I need to run below command inorder to link db with listener.

Logged as : sqlplus / as sysdba & excuted below command by changing the host & port

alter system set local_listener=' (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.local)(PORT=1521)))'

Then excuted the $lsnrctl status

the log indicated listener connected with db instance, and TNS entries may be the issue need to verify TNS entry at db client.

after that successfully connected to oracle db client

:-)

      

Solution : ORA-01017: invalid username/password; logon denied (Peoplesoft Application Designer)

Recently when em working with PeopleSoft VM template faced below problem while loging to Application designer.

SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied 

Solution:

1. Run the grant.sql script (available in /scripts folder)
       & modified the script - replace the with people
   

                  grant select on PSSTATUS to people;

                  grant select on PSOPRDEFN to people;

                  grant select on PSACCESSPRFL to people;

      Executed with sysadm/sysadm user.

2. Checked the PSACCESSPRFL table for accessid & password.

       select * from PSACCESSPRFL; 

  The accessid & accesspwd fields are encrypted so I dont know the existing existing userid & password so I  ran below script to modify the table.

      update PSACCESSPRFL set accessid = 'sysadm',accesspswd = 'sysadm', encrypted =0;

after all these I am able to login successfully to app designer.