Home > The Specified > No Rows Exist For The Specified Keys. 91 50

No Rows Exist For The Specified Keys. 91 50


I guess that already your get call fails if you try to update the table entry. It would be great if someone can pitch in and help us! Can anyone please help?? Are you able to take this action on the component that is behind the CI? have a peek at this web-site

Also, make sure you are not trying to do something in your code that the CI can't do. Why not? InteractiveMode = True; Exit(1) in Error Handler function - as when save fails Error Handler would be called and to retun to calling section. The system submits the data to the database in the chunks that you specified on the Connection Information sheet.

Row Already Exists With The Specified Keys

Abbasi Join this group Popular White Paper On This Topic Compare 20 Leading ERP Solutions 29 Ways 5Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't Kindly try to use this CI using Excel to CI and it wont work whereas it works fine when Testing Component Interface through Application Designer. Toolbox.com is not affiliated with or endorsed by any company listed at this site. I used this SQL to find a message catalog that would work easily: SELECT * FROM PSMSGCATDEFN WHERE MESSAGE_TEXT = '%1' Then, I added a new step.  First, you select Step

See Testing Component Interfaces. If you don't like rowsets..try using arrays. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Click Get Existing for the key that you are about to add, using the Excel to component interface utility.

Don't forget that a CI uses the security implemented by the underlying component. Row Already Exists With The Specified Keys. (91 49) more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Wikidot.com Privacy Policy. see this here Append content without editing the whole page source.

Why are my Findkeys missing certain fields? Engine. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Report it now – asterlan.com Top Articles Application Engine Auditing User Profiles Batch Scheduling Campus Solutions Tables CI Development FAQ Component Interfaces CI Based Web Services Consuming a Web Service Copying

Row Already Exists With The Specified Keys. (91 49)

Check your Component Search record if it has the Security joint tables included if its a view. For more info on Row Level Security Component Search Records visit - http://peoplesoftconcept.blogspot.com/2014/03/row-level-security-views-as-search.html To Resolve a Row level security issue visit- http://peoplesoftconcept.blogspot.com/2014/08/how-to-resolve-data-security-issue-in.html Santosh http://peoplesoftconcept.blogspot.com/ Top This thread has been closed due Row Already Exists With The Specified Keys Start a new thread here 984981 Related Discussions Component Interface Error AE through Ci dataconvertion (No rows exist for the specified keys.) CI Issue: No Rows Exits for the Specified Keys Row Already Exists With The Specified Keys Component Interface Balakirshna vv replied Mar 11, 2010 Hi Neha, Thanks for your reply.

Thankq once again. http://arnoldtechweb.com/the-specified/the-specified-table-does-not-exist-c.html Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Related Posted in App Engine, Component Interface, PeopleCode. 1 Comment » One Response to "Explorations in Component Interface:PeopleCode" Explorations in Component Interface: Handling Component Interface Errors « PSST0101 Says: January 7, The search record for your component does not have any search keys defined.

  1. Also make sure valid key field values are used.
  2. Sunil Kumari replied Dec 23, 2014 &oTLmActCi3.InteractiveMode = True; &oTLmActCi3.GetHistoryItems = True; &oTLmActCi3.EditHistoryItems = False; this is the way I have set Top White Papers and Webcasts Popular The Six Questions
  3. A few useful tools to manage this Site.
  4. alokkumarmac replied Dec 23, 2014 As you are getting error in TEST CI then it's more of data issue or security issue.
  5. The majority of component interface development issues revolve around not understanding how the underlying component works.
  6. All rights reserved.
  7. MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
  8. Top Fri, 02/20/2009 - 10:08pm #14 Guest (not verified) Re: component Interface correct your data first and then execute CI.These errors are coming due to improper data in your table.
  9. FoldUnfold Table of Contents When should I be using a component interface?

You are getting this issue with online or through app designer. If any are missing you can get unexpected results or none at all. However, I've had plenty of times when components work via the CI tester but not via psjoa. http://arnoldtechweb.com/the-specified/the-specified-agent-does-not-exist.html rem ***** Get the Component Interface *****;       &oBlgPersDtaCi = &oSession.GetCompIntfc(CompIntfc.BLG_PERS_DTA_CI);       If &oBlgPersDtaCi = Null Then          errorHandler();          throw CreateException(0, 0,

Additional info: PeopleTools 8.53.02 PeopleSoft HRMS 9.20.000 Attached is a screenshot of my Location CI. Using the tool you can simulate what your program is doing and potentially get feedback from the tester. When I run the AE program, it executed successfully, but an error is poping up at the log file as follows: Instance must exist to set property {BOOK_CI.CW_LIBRARY_BQUANTY} (91,14) Instance must

I am getting error in app designer.

No Business is Too Small for ERP Software ROI and ERP Companies Cisco Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow rem ***** Execute Get *****;       If Not &oBlgPersDtaCi.Get() Then          rem ***** No rows exist for the specified keys.*****;          errorHandler();      If it doesn't then you can't create anything in the component, and thus you can't create anything using the component interface. Adding a Log Step to the Program Before we dive into the PeopleCode, we need to add a second step to the program.  This step will come in handy for testing

I have already tested the CI from App Designer.But inApp Designer it is working fine and no errors. The supported tag styles are: , [foo]. Thanks in advance. have a peek here Remember the most important tip with component interfaces: Component Interfaces mimic component logic.

Any time there is an abend; the process looses the handle (sql starts getting weird results..cursor is gone) and CI gets confused. The version is PS HCM 8.9 (PeopleTools 8.47) with DB2 as the database. Top Fri, 07/11/2008 - 2:01am #6 Guest (not verified) Re: component Interface Hi.. In general, I've had most success when I get my interface code to duplicate exactly what happens when you use the web ui.

This is all what I can think of for now - please let us know how it goes. The keys for the CI are as follows (no CreateKeys) 1) GetKeys EMPLID EMPL_RCD 2) FindKeys EMPLID EMPL_RCD NAME LAST_NAME_SRCH NAME_AC PER_ORG BUSINESS_UNIT DEPT_ID When I test the CI in App Stay updated Subscribe with RSS Email Subscription Hall of Fame Most active contributors Most active commentors Most popular content CompShack is a user driven Dev2Dev IT community. Go back and define search keys as these are used as Getkeys.

You must enter a value for it before proceeding.{LOCATION.LOCATION_TBL(1).DESCR} (15,54), Error saving Component Interface. {LOCATION} (91,37), Failed to execute PSBusComp request" If the record exists, no error arises BUT the location Do I have to customize the update/insert operations using PeopleCode ? (1) and (2) ? You must specify your user ID and password. Sunil Kumari replied Dec 23, 2014 Function ActivityStatusUpdate() &oSession3 = %Session; &oSession3.PSMessagesMode = 1; &oSession3 = GetSession(); If (&oSession3.connect(1, "Existing", "", "", 0)) Then rem ***** Get the Component Interface *****;

Normally you just need to check your CI and add any missing fields. The permission list is HCSPCMPINT. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Why would two species of predator with the same prey cooperate?

Adam replied Apr 17, 2006 I have already given the CI full access through permissions so i dont think that is an issues; besides in that case the error that is When the data that created the error is corrected on the data input sheet, the data that was not submitted will be staged to the database.