error after bundles applied

Fold

rao (guest) 01 Dec 2010 00:33

I am getting the error "Invalid data. No data could be found based on the required key fields passed in (18137, 1128 )". when i am accessing the "Add/Update a Person" or "Maintain Applications" or "Emergency Contacts" in 9.0 Under Campus Solutions Module .

Reply | Options

Unfold error after bundles applied by

rao (guest), 01 Dec 2010 00:33

Fold

Re: error after bundles applied

Praj 01 Dec 2010 01:50

Have you a run a SQL trace to see which data/tables it is using behind the scenes to get to this message?

Reply | Options

Unfold Re: error after bundles applied by

Praj, 01 Dec 2010 01:50

Fold

Adam (guest) 21 Jun 2011 20:18

Having the same problem here. Have checked out the address,ethnicity and telephone number info and they all look ok. are there other usual suspects for this issue?

Reply | Options

Unfold by

Adam (guest), 21 Jun 2011 20:18

Fold

Praj 21 Jun 2011 21:08

Maybe it's an App Package doing something in the buffer that you can't see. A trace will help you find the PeopleCode that is causing the error. Try doing just an each statement PeopleCode trace to see where it gets to before the error occurs. A SQL trace may be helpful too.

Reply | Options

Unfold by

Praj, 21 Jun 2011 21:08

Fold

Adam (guest) 22 Jun 2011 16:10

The trace gave us CannotGetCIException HCR_PERSONAL_DATA_SRV. When this happened before the users personal data was corrupt, this time it does not "seem" to be that. Still looking at the log for any clues.

Reply | Options

Unfold by

Adam (guest), 22 Jun 2011 16:10

Fold

Praj 23 Jun 2011 00:32

Nothing to do with changes to security to the HCR_PERSONAL_DATA_SRV component interface?

This SQL will tell you which permission lists have access:

select CLASSID from PSAUTHBUSCOMP where BCNAME = 'HCR_PERSONAL_DATA_SRV';

You can take it one step further to check if a user has security:

select * from PSOPRCLS
where OPRCLASS in (
    select CLASSID from PSAUTHBUSCOMP where BCNAME = 'HCR_PERSONAL_DATA_SRV'
) and OPRID = '<OPRID'>

Reply | Options

Unfold by

Praj, 23 Jun 2011 00:32

Fold

Adam (guest) 23 Jun 2011 17:21

The security is there, that was one of the first things I checked. When I run the CI Tester in Application Designer it fails on the get method with error "No matching buffer found for level. (15,26)" so we are looking for an orphaned record at this point.

Reply | Options

Unfold by

Adam (guest), 23 Jun 2011 17:21

Fold

Praj 23 Jun 2011 20:50

Cool, sounds like you are on track. A SQL trace looking for rollbacks might help to find the orphaned record.

Options

Unfold by

Praj, 23 Jun 2011 20:50

Fold

Adam (guest) 24 Jun 2011 15:05

Turned out to be an invalid Address type in PS_ADDRESSES and PS_ADDRESSES_SA. The type was not in the address type table. Once the table was changed via SQL update the error was resolved.

Reply | Options

Unfold by

Adam (guest), 24 Jun 2011 15:05

PeopleSoft Wiki

Wiki

Membership

Forums

Partners

Top Articles

Resources

Links