1 2 3 Previous Next 43 Replies Latest reply: Oct 27, 2012 11:56 AM by Nicolas.Gasparotto Go to original post RSS
      • 15. Re: Generate SOAP Template
        HakanBiroglu
        >
        <DefaultMessage>No rows exist for the specified keys. {MI_PERSONAL_CI} (91,50)</DefaultMessage>
        <MessageParameters>
        <keyinformation>
        <EMPLID>?</EMPLID>
        >

        As the message says, there a no rows for the specified keys.
        It looks like you have used the default request message generate by SoapUI, which fills all elements with a ?.
        You should replace this with actual PeopleSoft values.

        Before invoking the CI based service, first logon to PeopleSoft, navigate to your component and go to the search page by supplying keyvalue.
        If you can go past the search page (so data is found for this component), use the same keyvalues eg EMPLID in your service operation request.

        Something like:
        <EMPLID>KU0007</EMPLID>
        • 16. Re: Generate SOAP Template
          857877
          yes... for the GET function i supplied KEY Value ( EMP-ID )

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m65="http://xmlns.oracle.com/Enterprise/Tools/schemas/M650797.V1">
          <soapenv:Header/>
          <soapenv:Body>
          <m65:Get__CompIntfc__MI_PERSONAL_CI>
          <m65:EMPLID>0117/m65:EMPLID>
          </m65:Get__CompIntfc__MI_PERSONAL_CI>
          </soapenv:Body>
          </soapenv:Envelope>


          and i got the below output. But DATA is not getting displayed.

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
          <soapenv:Body>
          <m65:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m65="http://xmlns.oracle.com/Enterprise/Tools/schemas/M408969.V1">
          <m65:EMPLID>0117</m65:EMPLID>
          <m65:NAME/>
          <m65:PHONE/>
          <m65:ADDRESS1/>
          <m65:EMAILID/>
          <m65:CITY/>
          <m65:STATE/>
          <m65:ZIP/>
          <m65:MAR_STATUS/>
          <m65:CONTACT_NAME/>
          </m65:Get__CompIntfc__MI_PERSONAL_CIResponse>
          </soapenv:Body>
          </soapenv:Envelope>


          ===============================================================================================================

          And, for find operation, i am not geeting anything, I am getting errro


          <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
          <SOAP-ENV:Body>
          <SOAP-ENV:Fault>
          <faultcode>SOAP-ENV:Server</faultcode>
          <faultstring>Component Interface API.</faultstring>
          <detail>
          <CIFault xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/M116479.V1">
          <IBResponse type="Error">
          <DefaultTitle>Integration Broker Response</DefaultTitle>
          <StatusCode>20</StatusCode>
          <MessageSetID>91</MessageSetID>
          <MessageID>2</MessageID>
          <DefaultMessage>Cannot find Component Interface {CI_FPMSALSTEP_PNLResponse} (91,2)</DefaultMessage>
          <MessageParameters/>
          </IBResponse>
          <IBResponse type="Error">
          <DefaultTitle>Integration Broker Response</DefaultTitle>
          <StatusCode>20</StatusCode>
          <MessageSetID>90</MessageSetID>
          <MessageID>7</MessageID>
          <DefaultMessage>Initialization Failed (90,7)</DefaultMessage>
          <MessageParameters/>
          </IBResponse>
          <IBResponse type="Error">
          <DefaultTitle>Integration Broker Response</DefaultTitle>
          <StatusCode>20</StatusCode>
          <MessageSetID>90</MessageSetID>
          <MessageID>6</MessageID>
          <DefaultMessage>Not Authorized (90,6)</DefaultMessage>
          <MessageParameters/>
          </IBResponse>
          <IBResponse type="Error">
          <DefaultTitle>Integration Broker Response</DefaultTitle>
          <StatusCode>20</StatusCode>
          <MessageSetID>91</MessageSetID>
          <MessageID>20</MessageID>
          <DefaultMessage>Error initializing Component Interface {CI_FPMSALSTEP_PNLResponse}</DefaultMessage>
          <MessageParameters/>
          </IBResponse>
          </CIFault>
          </detail>
          </SOAP-ENV:Fault>
          </SOAP-ENV:Body>
          </SOAP-ENV:Envelope>
          • 17. Re: Generate SOAP Template
            HakanBiroglu
            Are you able to see data in the PeopleSoft component, after supplying emplid=0117?

            What I do not understand is that you have two different responses that look like to different CI Based Services:
            CI_FPMSALSTEP_PNL
            MI_PERSONAL_CI

            Are we talking about two CI based services on two different components?
            If so, lets start of by trying to fix one, because I am getting confused.

            Hakan
            • 18. Re: Generate SOAP Template
              857877
              Hello Hakan,

              I created WSDL file by using the compoent MI_PERSONAL_CI. I am not aware from where CI_FPMSALSTEP_PNL is coming up.

              I am using WSDL ( http://184.73.174.36:9080/PSIGW/PeopleSoftServiceListeningConnector/CI_MI_PERSONAL_CI.1.wsdl ) by SOAP UI.
              • 19. Re: Generate SOAP Template
                HakanBiroglu
                Delete the WSDL and redeploy the CI based Service, because it does not look correct. It has definitions of messages that do no have any relation to you CI.

                How to delete a WSDL?
                http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tibr/book.htm?File=tibr/htm/tibr21.htm#H4045
                • 20. Re: Generate SOAP Template
                  HakanBiroglu
                  By the way,

                  I see that your PeopleSoft Environment is actually running in the internet.
                  If I can logon to your Weblogic console, everyone else can too, with all possible consequences!!!!!

                  You might want to change some passwords or even take it off the net.

                  Regards,

                  Hakan
                  • 21. Re: Generate SOAP Template
                    857877
                    redeploy the CI based Service means do i have to create new WSDL file by following below documents link

                    http://peoplesoft.wikidot.com/component-interface-based-web-services
                    • 22. Re: Generate SOAP Template
                      857877
                      Also, do i have to clear

                           
                      Clear WSDL Export Status by clicking on the link (      
                      Clear WSDL Export Status )
                      • 23. Re: Generate SOAP Template
                        857877
                        i m in process of creating new WSDL file

                        but getting below error ..... kindly suggest




                        PSAPPSRV.1540 (4340) [10/23/12 16:28:27 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error. Function: SQLExec

                        Error Position: 0

                        Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSAUTHWS) violated

                        Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS FROM PSAUTHBUSCOMP A WHERE A.BCNAME=:1 AND A.BCMETHOD=:2

                        Original Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS from PSAUTHBUSCOMP A where A.BCNAME=:1 and A.BCMETHOD=:2
                        PSAPPSRV.1540 (4340) [10/23/12 16:28:27 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error in Exec. (2,280) PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:InheritCIPermissions PCPC:1279 Statement:17

                        Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:processoperations Statement:247

                        Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Statement:288
                        PSAPPSRV.1540 (4350) [10/23/12 16:37:29 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error. Function: SQLExec

                        Error Position: 0

                        Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSAUTHWS) violated

                        Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS FROM PSAUTHBUSCOMP A WHERE A.BCNAME=:1 AND A.BCMETHOD=:2

                        Original Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS from PSAUTHBUSCOMP A where A.BCNAME=:1 and A.BCMETHOD=:2
                        PSAPPSRV.1540 (4350) [10/23/12 16:37:29 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error in Exec. (2,280) PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:InheritCIPermissions PCPC:1279 Statement:17

                        Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:processoperations Statement:247

                        Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Statement:288
                        • 24. Re: Generate SOAP Template
                          857877
                          but still data is not reflecting .......................Hakan .............kindly suggest ............what i need to do now .................



                          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                          <soapenv:Body>
                          <m24:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M1021871.V1">
                          <m24:EMPLID>KU0090</m24:EMPLID>
                          <m24:NAME/>
                          <m24:PHONE/>
                          <m24:ADDRESS1/>
                          <m24:EMAILID/>
                          <m24:CITY/>
                          <m24:STATE/>
                          <m24:ZIP/>
                          <m24:MAR_STATUS/>
                          <m24:CONTACT_NAME/>
                          </m24:Get__CompIntfc__MI_PERSONAL_CIResponse>
                          </soapenv:Body>
                          </soapenv:Envelope>
                          • 25. Re: Generate SOAP Template
                            857877
                            Dear Hakan,

                            I am waiting for your feedback. Data is not reflecting .
                            <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                            <soapenv:Body>
                            <m24:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M1021871.V1">
                            <m24:EMPLID>KU0090</m24:EMPLID>
                            <m24:NAME/>
                            <m24:PHONE/>
                            <m24:ADDRESS1/>
                            <m24:EMAILID/>
                            <m24:CITY/>
                            <m24:STATE/>
                            <m24:ZIP/>
                            <m24:MAR_STATUS/>
                            <m24:CONTACT_NAME/>
                            </m24:Get__CompIntfc__MI_PERSONAL_CIResponse>
                            </soapenv:Body>
                            </soapenv:Envelope>
                            • 26. Re: Generate SOAP Template
                              HakanBiroglu
                              Do you provide a userid, password in your request? Please post you request message.

                              Can you access the component with the userid, password you supply in your request? Does it return data in the component with the keys you supply in your search page eg. request?
                              Which component are you using by the way?

                              Could be that your are hitting row level security?
                              If the component resides in several menu's, each menu can override the searchrecord.
                              Could be that your CI is set to a menu with row level security and you are accessing it online through a menu without row level security.

                              Please answer the questions above, so we can move forwards.

                              Regards,

                              Hakan
                              • 27. Re: Generate SOAP Template
                                857877
                                Question :- Do you provide a userid, password in your request? Please post you request message

                                Answer :- No. In My component there is no provision of giving user-id and Password.


                                <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M243680.V1">
                                <soapenv:Header/>
                                <soapenv:Body>
                                <m24:Get__CompIntfc__MI_PERSONAL_CI>
                                <m24:EMPLID>?</m24:EMPLID>
                                </m24:Get__CompIntfc__MI_PERSONAL_CI>
                                </soapenv:Body>
                                </soapenv:Envelope>


                                Question :- Can you access the component with the userid, password you supply in your request? Does it return data in the component with the keys you supply in your search page eg. request? Which component are you using by the way?

                                Answer :- In PIA, my user-id ( PS ) has an assign an ID. the data is getting displayed by picking that ID. Yes, it return the data. My compoent name MI_PERSONAL_CI.


                                Question :- Could be that your are hitting row level security?

                                Answer :- I am not sure on it.


                                Question :- If the component resides in several menu's, each menu can override the searchrecord.

                                Answer :- all are custom component . in other component several menu's are present. But, MI_PERSONAL_CI do not have several menu's


                                Question :- Could be that your CI is set to a menu with row level security and you are accessing it online through a menu without row level security.

                                Answer :- I am not sure of it. How would i check it
                                • 28. Re: Generate SOAP Template
                                  857877
                                  In other components like Payroll, I am not giving any user-id and Password. It is directly taking from ID assign to user-id ( PS )




                                  the body


                                  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m96="http://xmlns.oracle.com/Enterprise/Tools/schemas/M961811.V1">
                                  <soapenv:Header/>
                                  <soapenv:Body>
                                  <m96:Get__CompIntfc__MS_EMP_PAY_INFO_PG/>
                                  </soapenv:Body>
                                  </soapenv:Envelope>


                                  and the o/p

                                  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                                  <soapenv:Body>
                                  <m96:Get__CompIntfc__MS_EMP_PAY_INFO_PGResponse xmlns:m96="http://xmlns.oracle.com/Enterprise/Tools/schemas/M989918.V1">
                                  <m96:NAME>Ray Sun</m96:NAME>
                                  <m96:DESCR>24/10/2012</m96:DESCR>
                                  <m96:AMT1>38423.077</m96:AMT1>
                                  <m96:AMT2>9605.769</m96:AMT2>
                                  <m96:AMT3>1613.769</m96:AMT3>
                                  <m96:AMT4>557.135</m96:AMT4>
                                  <m96:AMT5>0</m96:AMT5>
                                  <m96:AMT6>26646.4</m96:AMT6>
                                  </m96:Get__CompIntfc__MS_EMP_PAY_INFO_PGResponse>
                                  </soapenv:Body>
                                  </soapenv:Envelope>
                                  • 29. Re: Generate SOAP Template
                                    HakanBiroglu
                                    First lets see if your component interface is working properly.
                                    Start Application Designer and open your component interface.
                                    Right click on the component interface and select Test.

                                    A second screen will start where you can run your CI in UI mode.
                                    Supply key values and click on Get.
                                    Do you get data?