Hi all, to Import data from Text file to database record I have used Component Interface with Filelayouts. 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 exist to set property {BOOK_CI.CW_LIBRARY_STATUS} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_PUBID} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_CATEGRY} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_ISBN} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_AUTID} (91,14)
Application Engine program BOOK_CI ended normally.
Here 'BOOK_CI' is the Component Interface name and 'CW_LIBRARY_PUBID' is the record field name.
The Data is been updated to the record at database. Iam nt able to understand, Y this error message at log is poping up. I have checked with the Component Interface properties,methods,keys etc.,
can anyone kindly tell me the solution for this error.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
I have not personally gotten this error message before but here is what you can do to try fixing it. First and for most, try testing your CI in application designer just to make sure it runs with no errors.
This type of error might occur if the user's permission list doesn't have access to the CI (the BOOK_CI in your case). To resolve this, navigate to the user's permission list and click on the CI link and add the BOOK_CI. You now need to edit the properties of the CI and give full access to the methods that you see on the page. Save and try firing the Component Interface again.
This is all what I can think of for now - please let us know how it goes. Good luck!
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
I have checked with the user's permission list and this Component Interface is given full access to the methods.
When Testing the CI in application designer : As the CI tester window opens and clicked on the "Get Existing" button then a pop comes up as "More Than one row exists.{BOOK_CI} (91,51).
After clicking OK button another message box opens saying "Failed to get the Component Interface.(91,59)".
This explains as "An error occurred while getting the Component Interface. Check the Component Interface name and security settings. If the Component Interface name and security are correct, ensure that the definition is still valid by reviewing the Component Interface definition from within the Application Designer. Ensure that the appropriate keys are set".
I think there is an error with the Get key, pls help me and let me know wht error is it and how to rectify it.
The Component Interface name and security are correct.
Thankq once again.
Are you entering key values to the right of your key list before clicking "Get Existing"?
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Oops, i havent entered any value to the right of the keylist.
Now i have entered the values and clicked on the "Get Existing", no error are poping up. I think the CI at the Application Designer is working properly. Then why the error at the "
sorry i forgot to add this with the last comment.
then why the error is poping up at the log file when i run the AE program as follows:
"Instance must exist to set property {BOOK_CI.CW_LIBRARY_BQUANTY} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_STATUS} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_PUBID} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_CATEGRY} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_ISBN} (91,14)
Instance must exist to set property {BOOK_CI.CW_LIBRARY_AUTID} (91,14)
Application Engine program BOOK_CI ended normally."
This instance error is not poping up for key fields.
Hi.. Even i am facing the same issue. It would be great if someone can pitch in and help us!
U r missing one of the get key or required field in ur CI
Hi,
I am trying to insert data from a temp table to component using AE&CI.
I am selecting data from temp table using DoSelect Action and below doselect i used call section action - which calls a seperate section where CI peoplecode to insert data is written
When data from temp table is Invalid AE is abending, though i have set CI Peoplecode action properties on Return as Skip Step, On Error for the step as Ignore.
InteractiveMode = True;
Exit(1) in Error Handler function - as when save fails Error Handler would be called and to retun to calling section.
i want AE to write that into CI Error log and continue processing next rows from temp table
Your Do-Select is the culprit here.
Any time there is an abend; the process looses the handle (sql starts getting weird results..cursor is gone) and CI gets confused.
Instead of 'Do Select'..Use rowset in the same peoplecode (where you are calling the CI). You can use try..catch exception to trap all kinds of errors.
If you don't like rowsets..try using arrays.
In short..Write your code in one peoplecode step..rowset + call ci.
thanks
SP
hi . i get an error like this
Begin
(91,50) - No rows exist for the specified keys. {GR_CIMAIN} (91,50)
(2,214) - SetID not found for name='BUSINESS_UNIT', value='IN005' with record 'LED_FLDS_BAL_VW', tree ''. (2,214) JRNL_HEADER.DESCR254.RowInit PCPC:623 Statement:11
(91,24) - Error loading Component Processor {GR_CIMAIN} (91,24)
&oGrCimain.JRNL_PRCS_LIST = False
&oGrCimain.LINE_NBR = False
&oGrCimain.SAVE_INC_JRNL_0 = False
&oGrCimain.VISUAL_RATE = False
Cannot convert type Boolean to object type ApiObject. (180,604) GR_APMAIN1.MAIN.GBL.default.1900-01-01.CI.OnExecute PCPC:4487 Statement:70
End
i am trying to insert journal lines from excel file to peoplesoft database. Can anyone please help??
I think your requirement is to first get existing values and then insert from the excel in addition to exiting values - but its failing for the get keys.
Hope you are not inserting entirely new row.
hi,
i think you have to first create rowset,then use rowset.fill then use getrecord (your record) method to create record in buffer.and one more thing, all these steps should be before setting properties i.e include history,get history..etc..
try this and let me know if any
Hi Gokul,
Even I am getting the same error for my CI.In my case the process abends afyter running a few thousands of rows(not at a particular row as such(no data issue)).Would like to know if anyone
could resolve this issue.
This is the error message that I get.
Unexpected exception in CApiObjectAdapterObjRef::GetProperty for HCR_PERSONAL_DATA_SRV.PropertyInfoCollection (-1,-1)
Cannot convert type Boolean to object type ApiObject.
correct your data first and then execute CI.These errors are coming due to improper data in your table.
Hi Gokul/whom it may concern,
We are experiencing the same problem. The process randomly abends after some time with the "Cannot convert type Boolean to object type ApiObject" error message.
We've ran the same process multiple times for the same data set, and it abends at a separate point each time - therefore, pretty sure it's not data issues.
Any solutions?
Hi,
There is a bug in the system because of which following error comes when you are trying :
Begin
(91,50) - No rows exist for the specified keys. {GR_CIMAIN} (91,50)
(2,214) - SetID not found for name='BUSINESS_UNIT', value='IN005' with record 'LED_FLDS_BAL_VW', tree ''. (2,214) JRNL_HEADER.DESCR254.RowInit PCPC:623 Statement:11
(91,24) - Error loading Component Processor {GR_CIMAIN} (91,24)
&oGrCimain.JRNL_PRCS_LIST = False
&oGrCimain.LINE_NBR = False
&oGrCimain.SAVE_INC_JRNL_0 = False
&oGrCimain.VISUAL_RATE = False
Cannot convert type Boolean to object type ApiObject. (180,604) GR_APMAIN1.MAIN.GBL.default.1900-01-01.CI.OnExecute PCPC:4487 Statement:70
End
The reason for the the bug is that EMPLID is not a part of the child records whereas it is the key to the parent record.
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.
Kindly report it to Oracle to get the correct CI for the same or update the CI by including all key fields to the child record same as parent record.
Regards,
Vipin Chauhan
Hello, I am new to PCode and I am using PeopleCode to load into component through App. Engine. I have a scenario if an employee has more than one record based on different effdt, then the PCode should insert a row instead of updating the current record. If with same effdt, then it should skip and move on to the next employee. In other words, employee should have the add functionality on the page than updating current records with different effdt.
It would be great if you can provide an actual PeopleCode sample to insert data into Component.
Thanks!
i am getting the below mentioned error in app engine using CI..
Unexpected exception in CApiObjectAdapterObjRef::GetProperty for RE_TL_RPTD_TIME_CI.EMPL_RCD (-1,-1)
can somebody pl help..?