You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

component Interface

18 replies [Last post]
bhargaviRoy's picture
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 05/07/2008
Posts: 3

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.

CompShack's picture
User offline. Last seen 5 weeks 3 hours ago. Offline
Joined: 12/09/2007
Posts: 167
Re: component Interface

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

bhargavi Roy's picture
bhargavi Roy (not verified)
Re: component Interface

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.

CompShack's picture
User offline. Last seen 5 weeks 3 hours ago. Offline
Joined: 12/09/2007
Posts: 167
Re: component Interface

As the CI tester window opens and clicked on the "Get Existing" button then a pop comes up as "More Than one row exists.

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

bhargavi Roy's picture
bhargavi Roy (not verified)
Re: component Interface

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 "

bhargaviRoy's picture
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 05/07/2008
Posts: 3
Re: component Interface

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.

Guest's picture
Guest (not verified)
Re: component Interface

Hi.. Even i am facing the same issue. It would be great if someone can pitch in and help us!

Guest's picture
Guest (not verified)
Re: component Interface

U r missing one of the get key or required field in ur CI

Mahipal's picture
Mahipal (not verified)
Re: component Interface

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

sp's picture
sp (not verified)
Re: component Interface

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

gokul's picture
gokul (not verified)
Re: component Interface

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??

Guest's picture
Guest (not verified)
Re: component Interface

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.

Guest's picture
Guest (not verified)
Re: component Interface

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

Anand's picture
Anand (not verified)
Re: component Interface

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.

Guest's picture
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.

Guest's picture
Guest (not verified)
Re: component Interface

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?

Vipin Chauhan's picture
Vipin Chauhan (not verified)
Re: component Interface

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

Guest's picture
Guest (not verified)
Re: component Interface to insert data using PeopleCode

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!

Gajanan's picture
Gajanan (not verified)
Re: component Interface

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..?

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
2 + 8 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Unanswered Forum Posts