Apurva Tripathi

Author Archives: Apurva Tripathi

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

1

How to reset the administrator login password for accessing to the IB gateway advanced setup page?

When you logon to Integration Broker and navigate to PeopleTools -> Integration Broker -> Configuration -> Gateway and try to open the Gateway Properties file, you will have to provide the userid and password to access this file. Sometimes, especially after PeopleTools upgrade or Integration Broker changes, when you try to access this integrationGateway.properties file […]

Continue reading

Duplicate Routing Error – Routing xxx already exists. Please select a unique name. (158, 2075)

Routings in PeopleSoft Integration Broker are used to carry a predefined function. A routing definition defines the sending and receiving nodes for a transaction, specifies any inbound and outbound transformations to invoke and defines external aliases. It also defines overrides that the default integration gateway and the default target connector that the local node use to […]

Continue reading
1

Configuring Integration Broker Messaging Between PeopleSoft Instances at Different PeopleTools Levels

There are scenarios especially when doing a PeopleTools upgrade that you might have to establish PeopleSoft Integration Broker messaging between instances running at different PeopleTools levels. Let me give you an example – Say you have the following solutions implemented on PeopleTools 8.50.08: PeopleSoft HCM 9.1, PeopleSoft CRM 9.1, PeopleSoft FMS 9.1, PeopleSoft Portal 9.1 […]

Continue reading

Cloud Acronyms Explained

Cloud computing offers a wide array of services ranging and thus employs a number of acronyms, which are easy to get confused with if your work does not deal with these acronyms on a daily basis. Understanding what you read about cloud computing will require a good memory for acronyms. Bookmark this page or keep […]

Continue reading
1

The program can’t start because MSVCR100.dll is missing from your computer

“The program can’t start because MSVCR100.dll is missing from your computer” is quite common issue when application was writen using C++ dll and not distributed with those dll’s or installation had some issues. When you try to bring up AppDesigner in 2-tier or 3-tier mode, you might see this error. This error has been common especially […]

Continue reading

Integration Broker Authentication: Invalid Authentication type (AUTHOPTN) for node PSFT_LM. (158,452)

This issue “Integration Broker Authentication: Invalid Authentication type (AUTHOPTN) for node PSFT_LM. (158,452)” has been documented in Oracle Support as well with ID 1127403.1. The reason for this error is that the two nodes are not able to talk to each other because of different authentication type (hint is in the error – Invalid Authentication […]

Continue reading
1

Integration Gateway Message Unmarshalling: Missing value for the following field : ConnectorClassNam

I was doing Integration Broker setup when I got this error: Integration Gateway Message Unmarshalling: Missing value for the following field : ConnectorClassNam This error is received when you try to ping a node: I checked in MyOracleSupport and found a case related to the same – ID 752128.1 The case said that the error […]

Continue reading

ORA-01555: snapshot too old

We were doing stress testing in PeopleSoft ELM and ran the Mass Enrollment AppEngine. After running for about 90 minutes, it failed with the error ORA-01555: snapshot too old: rollback segment number 19 with name “_SYSSMU19_1270741541$” too small The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running […]

Continue reading

Common Database Errors

Common Database Errors Following is a list of known SQL errors, and potential solutions to the problems that they represent. Known Database Error Codes Database Error Code SQL State Message Solution DB2 -803 23505 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are […]

Continue reading

Why Upgrade to PeopleSoft 9.2 – Infographic

What is an Infographic? Infographics or Information graphics are graphic visual representations of information, data or knowledge intended to present complex information quickly and clearly. They can improve cognition by utilizing graphics to enhance the human visual system’s ability to see patterns and trends. The process of creating infographics can be referred to as data […]

Continue reading
1

How to Perform Load Testing in PeopleSoft

Load testing has several names – load testing, stress testing, regression testing, performance testing, scalability testing and so on. Essentially what these names refer to a testing where you can simulate the real-time environment and perform testing before you go-live with your system. When it comes to PeopleSoft, such scenarios are common when you plan […]

Continue reading

Function Based Indexes in PeopleSoft

Those who have not comes across performance issues in PeopleSoft, especially PeopleSoft on Oracle might not be aware of this thing called performance issues due to function based indexes. PeopleSoft has given a lot of headache to Oracle database engineers as well as customers when it comes to function based indexes. By definition, a function-based […]

Continue reading