Integration Broker has become a critical service for PeopleSoft applications. If you are new to Integration Broker or are having trouble with Integration Broker configuration, then take a look at this new Integration Broker course published by my friends at CGI consulting. The course consists of an 84 page instructional PDF and a couple of source files. The course covers everything from configuration to using SoapUI. Here are some highlights:
- Setting up Integration Broker
- Publishing a CI based service
- Testing a web service (CI or otherwise) with SoapUI
- Calling a service from PeopleCode
- Application Class PeopleCode handlers
- Routing transformations
- JDeveloper XSLT Mapper
- App Engine Service Operation handlers
- And much, much more
One item I noticed that is NOT covered is creating custom listeners and targets using the Integration Broker SDK. Not to worry, though because I cover creating custom targets in my book PeopleTools Tips & Techniques.
The CGI Integration Broker course is a great read. I recommend downloading and saving a copy for future reference.
184 comments:
Jim, I am sending through the IB form data from a pdf document. It comes in OK and I can process it, but the gateway is sending a response back with a content header text/xml; charset = UTF-8 and abobe is barking at it saying it cannot process this content type. Do you know of a way I can override this to say application/pdf. When I change HEADER properties on my node it still seems to pass text/xml; charset = UTF-8.
Any Thoughts?
@JCook, I have had the same frustration. I spoke with Integration Broker development about this a few years ago. In PeopleTools 8.52 REST services you will see a drop-down to select the response Content-Type, but it is limited to just the items in the list.
The work-around I have employed is to change the response header in my Apache httpd reverse proxy (everyone should use a reverse proxy). I use mod_headers to update the content-type header. You can use the Location and LocationMatch directives to match your Integration Broker URL.
If you don't have a reverse proxy, then you can write a ServletFilter and register it with your PeopleSoft web server using a URL mapping that matches your Integration Broker URL.
Subject: How to use PeopleSoft Campus Solution Delivered Web Services??
Jim, I’m new to PeopleSoft and getting multiple issues during the testing of PeopleSoft Campus Solution delivered web services (like SSR_COURSE, SSR_ENROLLEMENT …). I had tested these web services by soapUI and getting following errors: Any help in this regards would be greatly appreciated.
The default node is “PSFT_HR”
(Note: - I’ve used documents “Enrollment Web Services Users Guide” & “Enrollment Web Services Developers Guide” as a reference document)
Test 1:
Service Name = SSR_COURSE
Service Operation = SSR_GET_COURSE
Request in SoapUI:
INSTITUTION * = PSUNV
SSR_ALPHANUM =
SUBJECT = STATS
SSR_CRS_SRCH_MODE = D
ASOFDATE = 2011-05-27
Response in soapUI:
Fault code: Client
Fault string: An Error occurred processing this request (14098,286)
Default Title: Integration Broker Response
Message ID: 14732-6
Default Message: Error during Get Courses, Contact the Administrator
Security Message: E
Test 2:
Service Name = SSR_ENROLLMENT
Service Operation = SSR_GET_ ENROLLMENT
Request in SoapUI:
EMPLID = SR13454
ACAD_CAREER = UGRD
INSTITUTION = PSUNV
STRM = 0530
Response in soapUI:
Fault code: SOAP-ENV: Server
Fault string: null
IB Response type="error
Default Title: Integration Broker Response
Status Code: 20
Message ID: 974
Default Message: Integration Broker Sync Handler: OnRequest for message SSR_GET_ENROLLMENT could not run to completion on node PSFT_HR. (158,974)
Parameter: SSR_GET_ENROLLMENT
Parameter: PSFT_HR
@Imran, did you look at errorLog.html or msgLog.html? These files exist in the PSIGW web app's directory in your weblogic (or websphere) PeopleSoft domain directory. You can configure the log level in the integrationGateway.properties file or online in the Domain advanced configuration page. This Post tells you how to change the log level.
Hello Jim,
I am testing a CI based web service using SoapUI. The CI is based on a delivered component. When I test the CI through app designer in 2-tier and 3-tier mode it is working fine. But when I expose the same CI as a web service, I get an error message (Error Saving Component Interface). I have given all the necessary permissions to the user to access the CI. Am I missing something?
@Narender, you might want to look in the app server log and also increase your IB log level and look at the msgLog.html and errorLog.html to see if there is more information regarding the error. The app server log should show why it can't save. It may have to do with data, and not security.
You might also want to post this question on the OTN PeopleSoft General Discussion forum.
Hello Jim,
I configured the IB between HR 9.1 and CS9.0 after the CS-HR split.
Our org. decided to use Subscriber Only model,
So I configured the IB on both the systems CS 9.0 and HR 9.1 Local gateways, Local nodes and remote nodes, we often get the boomerang issues once in a week or once in two weeks, not sure how to fix this, Currently we are doing the following to fix it, we set up a notification, text message to cell phone and an email, we'll receive if we see a bunch of messages are transferring between the systems. And then we inactivate the Service operation and cancel the message that causes the boomerang issue, and activate the service operation.
Is there any better solution that i can follow, the solution that oracle gave in the document in the Feature Pack 4, has lot of configuration has to be done, So i am looking for a better solution,
Thank You
@Afjal, I am familiar with the CS/HR split, but I am not familiar with a boomerang issue. Messages coming into an Integration Gateway/Integration Broker instance are routed based on configuration. Normally, for each service operation, you will have a system of record (the publisher) and a subscriber. In the subscriber system, you will have an inbound routing. In the publisher system, you will have an outbound routing. The publisher should NOT have an inbound routing. The subscriber should NOT have an outbound routing.
It is possible to have routings that send from one node to another, with no local subscription. This is common in a hub/spoke model, but it sounds like you are using a point-to-point model. If you have any hub/spoke node to node routings, then this may be causing your problem because it sounds like you intended to configure for point to point.
It really sounds like a routing configuration issue. Make sure only have the necessary routings configured. You shouldn't have any to local or local to local routings unless specifically identified by you or the configuration documents (for example, HR uses local to local routings to subscribe to worker and personnel messages).
Let me know if I misunderstood the issue.
Jim,
Each database has their own Local Gateway & Local nodes configured as per the oracle documentation, and I configured the IB for some of the service operations to go the messages both directions (As per Oracle terminology its called Subscriber Only model, We call as bidirectional), from CS to HR and HR to CS in the routing definitions., I am sure I did inactivated all the other Routing's are inactivated in the Routing Definitions. Only Routing's active are CS to HR and HR to CS.
Thank You
That is what I thought. For each service operation, a node should either be a publisher or a subscriber, not both. A node can be a publisher and a subscriber, but each service operation should be one or the other. It should not be both with the same service operation and the same nodes. You can configure it this way, but it is not a best practice.
Think of it this way, which system is the system of record for the PERSON_BASIC_SYNC message? It should be HCM, right? If that is the case, then HCM will ONLY have publish (outbound) routings for the PERSON_BASIC_SYNC service operation and every other system will only have inbound/subscribing routings for that same service operation.
Another common example is USER_PROFILE. If you allow each node to maintain and publish USER_PROFILE changes, then each node will be a publisher and a subscriber. You can do this, but it is not recommended. The best practice is to make one node the system of record and have publish (outbound) routings only. All other nodes have subscription (inbound) routings only.
Hi Jim,
I have created an App package based webservice and exposed it to 3rd party. this service and its service operations utilizes rowset based messages. Request message consists of emplid whereas response message comprises of compensation and other critical data.As a part of SOAP request, authentication headers have been taken care as well.
My 1st part of job is done. Now I am supposed to implement security via digital certificates or encryption on the response which is going back to 3rd party in webservice soap response. Can you help me with the steps i need to follow to implement the same? I tried going through peoplebooks but could not find a sure shot solution for the same query.
Thanks
Anuj
@Anuj did you see this PeopleBook entry? It is quite lengthy, so it will be a bit much to repeat here in the comments. After you start on this, if you have specific questions about any of the steps, you may want to ask the question in the PeopleSoft General Discussion OTN forum where several people can help answer your questions.
Hi Jim, I need some guidance on how to proceed with an Integration Broker - JMS Connector issue that I am facing with.
I am trying to integrate Peoplesoft with a third party factory system through IBM MQs. JMS Target Connector is configured properly and I am able to send out messages succesfully. But the issue is Peoplesoft has a delivered bug wherein "Correlation ID does not match" error is occuring upon receipt of response messages. When I checked with Oracle, this seems to be a delivered bug (Bug 16012124)which has been internally fixed and to be delivered in 8.54. As we are still in Tools 8.51, we have to do our own fix on this.
Issue:- For outgoing synchronous JMS messages, Peoplesoft sets Correlation ID = Transaction ID. The third party sends the same ID back as correlation ID. But PS expects the Message ID in the correlation ID and hence throws the error.PS is wrongly sending the Transaction ID in place of the Message ID which is the delivered bug.I am not able to identify the exact portion where the Correlation ID is getting set in the IB connector. Would you be able to help me with it?
@Stefy, I don't know either. Have you requested a one-off or back port of the solution?
Hi Jim.
Stefy again.
As Oracle failed to provide us the solution, we thought we could modify JMSTargetConnector java file. We were able to locate the .class file at location /sandisk/appselm2/peoplesoft/elmdev03/webserv/ELMDEV03/applications/peoplesoft/PSIGW.war/WEB-INF/classes/com/peoplesoft/pt/integrationgateway/targetconnector/; we decompiled it and saved the file as JMSTargetConnector.java and saved it at the same location. We found out that the correlation id exception was occuring due to code:
if (!objectMessageJMSCorrelationID.equals(msgJMSMessageID))
{
throw new ExternalApplicationException("JMSTargetConnector:ExternalApplicationException. Correlation ID does not match.", new MessageCatalogEntry(10624), null);
}
We modified the code to suite our requirement.
Now the question we are facing is how to compile the .java file. Whenver we try to compile we get many class not found excpetion. Please let me know if our approach is correct. If yes what steps we need to follow when modifying a devliverd java connector class as we are doing. If not what alternate solutions we may have. Need urgent help. Thanks in advance, Stefy Baby
@Stefy, for the record, I'm probably supposed to tell you not to decompile someone else's code ;). But the fact is, I've been in your position and done the exact same thing. The key difference, though, was that I renamed my source file so the generated connector had a new name. I suggest you do the same. That way your connector will still exist after the next upgrade.
Yes, you can compile target connectors. You just need to setup your compile environment to include all of the required jars and class files. This PeopleBook entry will help you prepare your environment for compilation. At the end, it also tells you how to install Target Connectors. Basically, you just copy them into the same folder as the one you found. After that, go into your gateway settings online and click the Load Connectors button. This should bring in your new connector. Once loaded, though, you have to restart your web server each time you change your target connector.
I have a step-by-step example of this in my PeopleSoft PeopleTools Tips and Techniques book.
Jim - the link to the PDF document appears to have gone stale. Do you know if it's available anywhere else?
Josh
@Josh, the owner is moving that blog. I will update when it is available.
I had a doubt related with CI based webservice. Please do help me with it.
Actually I am creating a webservice using CI.
I created a response message , a request message and used the handler 'Create' which was already was created by default when CI was created.
But when i run it through SoapUI, it gives error "Integration Broker Sync Handler: OnRequest for message ABC could not run to completion on node QE_LOCAL. (158,974). Can you please tel me hjow to resolve.
Or does it happen as Im using wrong handler. Basically what needs to be written in the handler function if i want to create my own method?
Thanks in advance,
Shobha
@Shobha, SoapUI is a common test tool for PeopleSoft CI's. You should try posting your question in the PeopleSoft General OTN Forum.
Hello Jim,
I have developing a synchronous message for integrating with third party system which runs on .NET.
I have create my request message using Part rowset & container message and for response message, I have created schema using jdeveloper.
When the external system sends a response, I am able to parse it and do internal processing. But when I send the response, the external system is receiving it as null. I have also tested my message using SoapUI. When I send a request the response comes back with proper SOAP wrapping which is well formed.
When I validate the response message, it shows an error like below
line -1: Missing message part with name [{http://xmlns.oracle.com/Enterprise/FSCM/schema/NQ_CUSTOMER_CREATE_RESP.V1}NQ_CUSTOMER_CREATE_RESP]
This is my SOAP response
WS_TEST19
Below is the schema definition
Your help will be much appreciated.
@Narender, I see the same question over here on the OTN forum. I'll post my response there.
Hello Jim,
I figured out the reason why it is not validating. I miss-spelt the namespace.
I have defined targetnamespace as
http://xmls.oracle.com/Enterprise/FSCM/schema/MESSAGE_NAME.V1
And in my handler code, I wrote this
http://xmls.oracle.com/Enterprise/FSCM/schemas/MESSAGE_NAME.V1
it should be "schema" not "schemas" the "s" made all the difference. I clearly Overlooked that part.
Hi Jim,
I tried to use the link to:
http://bloggingaboutoracleapplications.org/integration-broker-basics-peoplesoft-developer/
and I get a 404 Error.
@ChicagoMom, thanks! Hakan's blog moved, so I updated the link. It should work now.
Hi Jim,
Could you please shed some light on how integration broker behaves in a Disaster Recovery Scenario?
@Pankaj, you might want to ask that question on the document's author's web site, or in the PeopleSoft General Discussion forum.
Hi Jim,
We have a requirement to send the terminated employee id's from PS HRMS to SUN IM. For this we have decided to place the java class file in PS web server. So whenever an employee is terminated we will invoke the class file which in turn triggers workflow in SUN IM. Also we have to capture every transaction (to check whether it is success or failure) through IB. Could you please provide us some inputs on invoking the class file through IB.
@Vinusaravanan, if you create an Integration Broker custom target connector, then placing your class files on the web server makes sense. The PeopleSoft IB SDK tells you where to place the connector and how to write it. My book also has a chapter showing how to create a custom target connector.
The alternative, that might be easier, is to put the class files in your app server classpath and use GetJavaObject and CreateJavaClass in your PeopleCode request handler. You may have to create a local-to-local routing for this.
Thanks for your inputs, Jim.
Hi Jim,
I am surrently working setting up a 3rd Party Web Service from PeopleSoft 9.2 (PT8.53) and while testing the service operation I am getting following Error:
"Integration Synchronous Handler: No destination node can be determined for the request on node PSFT_HR. (158,963) IBTREE_WRK.IB_INVOKEOPER.FieldChange PCPC:5083 Statement:110 "
have any ideas where can start looking for ?
Thanks for the help!!
@Ajain2882, did you enable the any to local routing? Did you add the destination node to your end point configuration in PeopleTools > Integration Broker > Configuration > Service Configuration/
@Jim I was able to rectify the previous issue.I have one more issue with my another Synchronous web service. I have created a Rowset base request and response messages and trying to provide the Web Service to 3rd party system.While testing the service Operation I am getting an error This method can only be used by nonrowset-based messages. (2,852)]
So is there a restriction to use Row Set base messages for Synchronous type of operation? What else could be the issue.
Thanks for you help!!
@Ajain2882, their is no limitation from the configuration perspective. Your error sounds more like a PeopleCode problem. For example, if you have a Rowset based message, you can't use MSG.SetXmlDoc.
Hi Jim,
Can you provide some info on the best practice for PS IB namespace selection? It is my understanding, perhaps incorrect, that the sole purpose of the namespace is to disambiguate XML tags so that using the same tag name as someone else does not cause a collision. If this is the case, should not the namespaces in the Service Configuration component be set using the local institution's URL?
Jim Rowan
SCU
@Jim, your understanding of XML namespaces is correct. Whether you change the namespace, or keep it the generic PeopleSoft/Oracle namespace depends on how you define ambiguous. For example, all PeopleSoft customer institutions have personal data, oprid data, depts, etc. The contents may differ, the definitions of these terms may differ, but the structure will remain the same. PeopleSoft's understanding of the data will remain the same.
The only time where I can see it being a concern is when two separate institutions share data and have an XML structure that is similar, but slightly different. For example, one is using person/name to be employee, and another is using person/name to be student and the root of the document is identical, so the context doesn't distinguish between the two.
I just updated the link again to keep up with the file location. In Hakan's post, look for the text "The training can be downloaded using the following link" and click the word "link."
Hi Jim,
Thank you for your wonderful posts. I am trying to process a data upload where I am trying to publish the messages through PeopleSoft over Integration Broker asynchronously in an Application Engine. The whole point is to be able to send several messages and consume them in the same node. Before I send the messages, I am storing the data on a table (say T1) to store all the field values in the upload file.
While consuming I am trying to expose each message to the Component Interface and the exceptions are logged onto the same table T1. Let's say for each transaction we are flagging the table field (say Processed_flag ='Y').
I need a mechanism where I could just wait for all the asynchronous messages to complete. I am thinking of checking the T1 table, if there are any rows on the T1 table where Processed_flag is 'N', just make the thread sleep for more time. While all the messages are not processed keep it sleeping and don't let the application engine complete.
The only benefit I can get is I don't have to wait for multiple instances at once or does not have to make the synchronous call. The whole idea is to use the component by different transactions ( as if it was used by say 100 people -> 100 transactions ).
Unless those 100 transactions are complete, we will be make sure out T1 table keeps a record of what goes on and off. If something is wrong, it can log the exceptions catched by the CI.
Any comments on this approach would be appreciated. Thanks in advance!
@Sandeep, it is common to add the Process Instance to rows processed by an App Engine. I'm not sure that sleeping will help you much. If you have a PeopleCode subscription processing the message and updating the table, that will happen in the app server, not the process scheduler, and will be in a different session. In fact, if you are writing the process instance in the App Engine, but don't commit, and then try to update the same row through IB, then the IB process will likely fail because it can't lock the row for update.
I am wondering if it would be better to publish your messages, like you intend and just let your App Engine finish. Schedule your app engine to run periodically. If it sees rows that already have a Process Instance and value of N, then those are your problem rows and you can address them.
@Jim
You are right, not committing the data would result in locking on the tables.
Even if we are able to validate the data on those tables before app engine completes, the whole idea to send the messages asynchronously is of no use. In that case, using synchronous messages would be better and run the processes in parallel.
So, we decided to let the application engine complete and publish all the chunks of data through messages and make sure the messages are completely consumed in the same node.
1. We will be updating the table T1, for all the processed / successful / failed rows as we keep consuming the messages and use them as needed.
2. We will keep an audit or counter for all the rows published and consumed. Since exposing the same component to multiple transactions would be a huge performance impact. We want to make sure how it would be helpful if say 50 users are updating the same tables behind component using the same CI ( of course different instances ). I will completing mu proof of concept and hopefully it will be much better than running the processes in parallel.
Thank you for your precious time to look at my question and providing your feedback.
Hi Jim,
I am trying to publish the message by populating the message through LoadXMLstring. Below is the code I have used. I am able to generate the XML string with the required fields but I am unable to execute LoadXML string (error message -Message name W_PS_TEST_MSG not in message data. The expected message name was not found in the message data at the correct location. Examine the raw XML message data in the Integration Broker Monitor.")Please note the message-W_PS_TEST_MSG exists in Service Operation-W_PS_TEST. Could you please help me to rectify this issue.
Code:
Local SOAPDoc &SOAPDoc;
&SOAPDoc = CreateSOAPDoc();
&SOAPDoc.AddEnvelope(0);
&SOAPDoc.AddBody();
&SOAPDocXM = &SOAPDoc.XmlDoc;
Local XmlNode &SOAPDocXML = &SOAPDocXM.DocumentElement;
Local XmlNode &empl_id = &SOAPDocXML.AddElement("EMPLID");
&empl_id.NodeValue = "12345";
Local XmlNode &Oprid = &SOAPDocXML.AddElement("OPRID");
&Oprid.NodeValue = "12345";
Local XmlNode &first_name = &SOAPDocXML.AddElement("FIRST_NAME");
&first_name.NodeValue = "test";
Local XmlNode &last_name = &SOAPDocXML.AddElement("LAST_NAME");
&last_name.NodeValue = "test";
Local XmlNode &status = &SOAPDocXML.AddElement("HR_STATUS");
&status.NodeValue = "I";
&strXml = &SOAPDocXM.GenXmlString();
MessageBox(0, "", 0, 0, &strXml);
&MSG = CreateMessage(Operation.W_PS_TEST);
&MSG.LoadXMLString(&strXml);
&IntBroker = %IntBroker;
&IntBroker.Publish(&MSG);
@Vinusaravanan, I noticed a few things in your code that I am wondering about:
1. Is your message an unstructured message?
2. Did you know that you can copy the XmlDoc from the SOAPDoc directly into the Message by using the SOAPDoc.XmlDoc property and the Message.SetXmlDoc methods? You don't need to convert to a string in the middle.
3. It is unusual to publish a SOAP asynchronous message. Usually SOAP is synchronous, where you send a request and expect a response. You can see an example of using SOAPDoc in this manner in PeopleBooks here.
Thanks for your inputs, Jim. My message is a structured(asynchronous) type. I used copyrowset and publish to send the message. Now am able to publish the message.
Hi Jim,
I recently published a rowset based asynchronous message on Local to local routing.
I created two service operations
say FT_SEND and FT_RECEIVE, both of these service operations use different messages and local to local routings.
1. FT_SEND does not implement any handler and is able to publish the messages in my app engine.
2. FT_RECEIVE implements INotificationhandler and OnNotify method through Application Package.
Service operations/handler/queues are active for both service operations.
1. FT_SEND : The messages are published through service operation FT_SEND and completed as 'Done'.
2.FT_RECEIVE : Somehow the messages are not consumed with service operation FT_RECEIVE even though the configuration seems fine.
Can you guess what might be wrong with this configuration?
Thanks in advance for your precious time.
@Sandeep, I'm a little confused. Are you expecting FT_RECEIVE to process data from FT_SEND? If so, that is not how it works. In a local to local routing, it is the same service operation. A service operation doesn't necessarily communicate direction. The routing communicates direction. So if you want to process FT_SEND locally, then you need to add the handler to FT_SEND along with a local to local routing.
You guessed it right. I was expecting FT_RECEIVE to receive those messages and process them because earlier I had tried adding the onNotify Handler to the same service operation FT_SEND instead of FT_RECEIVE and it seems like the message is stuck in New Status once published.
And as soon as I remove the handler from FT_SEND, it publishes the messages and the messages go the success on publish or resubmission.
Also, I checked when I looked at the auto generated routing for FT_RECEIVE the routing type was generated as 'Outbound Request'
What would be your suggestion on this scenario?
Thanks
@Sandeep, add a local to local routing on FT_SEND and configure your handler on FT_SEND. If the message is stuck in new status, that is different. There are actually 3 places it could be in new status: instance, publication, and subscription. Whichever queue is stuck, it shouldn't be caused by the existence of a handler on FT_SEND.
You are correct, Jim. Now, I implemented the handler on FT_SEND and it worked fine. The only thing I had to do is to cancel those messages and resubmit those and those messages flowed through the PUB/SUB and processed the business logic as needed.
They were stuck as opreation instances.
Why they got stuck in New Status, is something I have to investigate further.
Do you think clearing the IB cache is going to help in this scenario?
Thank you very much for your time.
Jim We are sending a request from Peoplesoft to sharepoint. We are getting a default response everytime we send a request and the 3rd party receive no data it shows as getting blank xml content value. I gotto deliver this in a day and i am still stuck with it. Please any suggestion would be highly appreciated.
@Suresh, configure Integration Broker to use a debugging proxy such as Fiddler2 or WebScarab. Then you can see what IB is REALLY sending.
Hello Jim, thanks for all the tips and techniques over the years. I have a JMS-related question that maybe only you can answer. I'm using JMS Connector to get to MQ for sending asynchronous payment messages. Do you know if JMS Connector sends back a transaction id if connection property JMSAcknowledgement is set to Auto.Acknowledgement? My goal is to get a confirmation that the target JMS connector has received this message. Thanks a lot!!
LH
@LH, Unfortunately, I have no experience with JMS. I suggest you ask your question on the PeopleSoft General Discussion OTN Forum.
Thanks you Jim.
Hi Jim,
Is there any delivered components or process to handle reimbursemetns in Peoplesoft Campus Solutions
Hi Jim
Can you please help me capture a fault string exception. I am working on FSCM 9.1 and tools 8.52 Integration broker . I am sending a request through the webservices to a third party service. If everything is OK with the XML, it returns the response message. But when something wrong with the XML, it is giving me HTTP 500 error. Where as the same request when i send through the SOAPUI I am getting fault string which gives me an indication of where my XML request is wrong. I want to be able to capture that fault string and display in error/log files which I am unable to do when I invoke the service from peoplesoft. Did anyone come across this kind of situation before, Please help me with the sample code. The request I am generating is by using XML doc classes.
@Mohd, I suggest you post your question on Hakan's page at http://hakanbiroglu.blogspot.com/2013/01/integration-broker-basics-for.html. This post is just a link to his course.
@Jim, the training document does not indicate how to catch the fault string. can you please throw some light on it. Thanks
@Mohd, I think your question is a great question. I just don't know the answer. My experience is mostly with PeopleSoft as a provider, not as a consumer. This is why I think you may want to ask your question of the post's author on the author's blog.
Dear Jim , I am getting this Publication Contract Error Messages :
UserID PS not authorized for Service Operation KS_RA_CAMPUS_ID_FULLSYNC_SOR .
I have assigned the require permission lists (HCSPSERVICE , HCSPSERVICETL ,OHCSPSRSERVIVE ) TO PS .
Any Thoughts ?
@Munib, from the Service Operation definition, did you click the Service Operation Security link and verify that the permission lists match?
I work on tools V 8.52 doing an integration with Fusion Middleware wherein i subscribe async messages. i am able to recieve the messages but the messages are going in error state with the error message: "Error occured while parsing the XML. XML is empty or not an XML." i have set the authentication type as null. please help me find a solution
@Nischay Integration Broker problems can be quite complicated. I suggest you file a ticket with My Oracle Support.
did that.. didnt get an understandable solution.
@Nischay, you might try posting your question on the author's blog at http://hakanbiroglu.blogspot.com/2013/01/integration-broker-basics-for.html.
Hi Jim,
We have a custom component for leave application. When we apply leave using this component, it triggers an AWE workflow (approval and notification). It works fine.
Now the same component when exposed to Web Service (using CI based web service) and invoked by 3rd party system, Workflow event is triggered, but the email is not.
Please need your help, is it a bug?
@Tushar, I am not sure. It is certainly worth entering a case in global support.
hi Jim,
we are trying to test a synchronous inbound message in development environment using both send master and handler.
Handler tester will return confirmation 0 and do not hit synchronous services in monitor. where as send master hit synchronous services in error below.
SOAP-ENV:ServernullIntegration Broker Response20968
dev is local node and inbound is external node.
Please advise.
Hi for all,
At present I have a problem with a web service which is invoked by another system to receive information, the error shown in the log message say the next:
Type Error
ErrorLevel Standard Gateway Exception
Description null
MessageCatalog MessageSet:180 MessageID:69 DefaultMessage: Function %1 does not return a result. (180,69)
Stack Trace
com.peoplesoft.pt.integrationgateway.common.GeneralFrameworkException
at com.peoplesoft.pt.integrationgateway.listeningconnector.PeopleSoftServiceListeningConnector.service(PeopleSoftServiceListeningConnector.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java(Inlined Compiled Code))
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java(Compiled Code))
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java(Compiled Code))
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java(Compiled Code))
at com.peoplesoft.pt.integrationgateway.common.IBFilter.doFilter(IBFilter.java:69)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java(Inlined Compiled Code))
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java(Compiled Code))
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java(Compiled Code))
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java(Inlined Compiled Code))
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java(Compiled Code))
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java(Compiled Code))
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java(Compiled Code))
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Request
Message-ID: <1747824397.1418218602805.JavaMail.psoft@crmdev>
Date: Wed, 10 Dec 2014 09:06:42 -0430 (GMT-04:30)
Mime-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_573_510619402.1418218602710"
Content-ID: PeopleSoft-Integration-Broker-Internal-Mime-Message
PeopleSoft-ToolsRelease: 8.48
------=_Part_573_510619402.1418218602710
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Content-ID: IBInfo
ContentSection0N
------=_Part_573_510619402.1418218602710
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Content-ID: ContentSection0
V004399644
------=_Part_573_510619402.1418218602710--
Response
Message-ID: <2055483149.1418218602805.JavaMail.psoft@crmdev>
Date: Wed, 10 Dec 2014 09:06:42 -0430 (GMT-04:30)
Mime-Version: 1.0
Content-Type: multipart/related; boundary="Integration_Server_MIME_Boundary"
Content-ID: PeopleSoft-Integration-Broker-Internal-Mime-Message
PeopleSoft-ToolsRelease: 8.48
--Integration_Server_MIME_Boundary
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Content-ID: IBInfo
2018069Function OnRequest does not return a result. (180,69) CTV_MSG_INT006.CTV_MSG_INT006_OnRequest.OnExecute Name:OnRequest PCPC:13008 Statement:146ContentSection0N
--Integration_Server_MIME_Boundary
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-ID: ContentSection0
Content-Disposition: inline
Function %1 does not return a result. (180,69)
--Integration_Server_MIME_Boundary--
In the soapUI we observe the following:
SOAP-ENV:Server
null
Integration Broker Response
20
69
Function %1 does not return a result. (180,69)
I would appreciate your help or insight regarding this the error, thanks.
Hey Jim,
I'm working on CRM 8.48. i am consuming a web service from a third party system. i was facing issues while generating a request XML so i have generated an XML by concatenating various strings via peoplecode. this XML is exactly identical to the request XML in SOAP UI. I now need to pass that very XML as my request XML during consumption. could you help me out with the coding aspect of that? cuz i feel the one i generated is probably not being considered as an XML- its being taken as a string
@eNVi, it kind of depends on how you are invoking the external service, but the basics are the same:
* Create or acquire an instance of XmlDoc (Message.GetXmlDoc, etc).
* Load the XmlDoc using something like XmlDoc.ParseXmlFromString.
Hi Jim
I am providing a webservice to .NET. I received request and gave a response. However, the name space in the response is different from the WSDL I have. In the reponse it is
xmlns=http://peoplesoft.com/COMBO_CF_EDIT_REPLYResponse
Whereas, the correct name space should be
xmlns=http://xmlns.oracle.com/Enterprise/Tools/schemas/COMBO_CF_EDIT_REPLY.VERSION_1
Due to which, the other system is unable to deserialize the responses.
What could be the cause of this issue and could I fix it myself?
Thanks
Hi Jim,
We are trying to send a request to a 3rd party (non-peoplesoft system). The 3rd party requires us to digitally sign the request with a certificate, which we are able to do. However, PeopleSoft automatically appends a Username Token to the request, which causes the 3rd party to not accept the request. We tried setting the "Exclude PSFT Auth Token" option for our service operation, but since the request is going to a non-peoplesoft system, the token is included anyway. Do you know of a way to exclude the token? Oracle has confirmed that our settings are correct, but because the 3rd party is a non-peoplesoft system, the token is included, but we are wondering if there is a way to exclude it.
Thanks
@BBunes, sending a PeopleSoft auth token to a non-PeopleSoft nodes sounds like a security problem. Is the node configured as an external node?
Jim,
Yes, our sending node is configured as an external node. Oracle has said that the UsernameToken is always included in the request if the request is sent to a non-PeopleSoft system, even if the "Exclude PSFT Auth Token" option is selected for that operation.
To clarify, we are on PT 8.53 and this is being sent from ELM 9.2. The specific xml node we are trying to remove is below.
xxxxxxxx
Hello Jim,
I am using IB Sync to transmit an XML file that's already formatted. Part of the XML file was created in UNIX using PERL and carriage returns are replaced with
in the script. This is then appended to the rest of the message created using XMLDOC in peoplecode. But when I use SetXMLDoc and call a Sync message, IB (as expected) tries to format the XML and escapes the & in "
" to 
 - which invalidates the message now. So 1)how to make the IB not to replace the & in
or 2) how to generate the
as its not being done automatically for Carriage return as of now..
Many thanks...
Karthik
I noticed in my earlier message my ampersands were taken out by the site. so let me try to use the literal ampersand for "&".
so basically I would like to know if IB can leave a XML which has a valid escape value "ampersand#xd;" for carriage return as is and not to escape the "ampersand" in that value to "ameprsandamp;#xd;" or can we have IB generate that escape value "ampersand#xd;" for carriage return. Also The receiver will not accept tags for this node as we are sending a signature in that node. (we are generating the signature using PERL script in UNIX and passing it in the XML message)
Hi Jim,
we have a requirement where we get a GPG encrypted message through IB from third party and we have to decrypt it on our side.
I know I can install GPG on the server and decrypt a file using the below command.
Exec("echo passphrase |pgp.exe --passphrase-fd -o c:\xxxx\Test.txt -d c:\xxxx\Test.pgp") .
How can we do the same with messages , I know we can run a command line statement in Exec but don't know how I can decrypt the encrypted fields coming in a message,
Can this be done? it would be help full if you can give me the command that I can use inside the exec for each field and how can I catch the decrypted field value into a variable.
Thanks
@Vinjas, take a look at PeopleSoft's pluggable encryption.
Hi Jim
I have one question , how to notify / get notification as soon as some IB message struck in error. Because we are facing some issues like we are unable to come to know the failures in html email approvals?
Thanks
viswanathareddy K
@Viswanathareddy, there is a delivered notification process that you can schedule, but that isn't immediate. Alternatively, you can create an App Engine daemon process to check the IB tables for messages in error status.
Jim, love your book (PPT&T). We have a web service that times out on synchronous on large messages due to the component processing being large (BI_ENTRY). Upping the timeout is not an option according to our Admins. If we switch to asynchronous and deliver the keys in a separate process, would we still have timeout issues on the DoSave() not finishing in time? In other words, is the 50 second CI processing timeout applicable to sync *and* async messages?
Thanks.
Jeff
@Jeff, the large amount of data pushed through a CI within a web service will cause you problems. The apps FullSync messages have a similar problem. The way they handle it is to insert the received data into a staging table and then use the ProcessRequest API to schedule an App Engine to process the received data. The web service can then return a result before the App Engine finishes (and maybe even before it starts).
@Jim. Thanks for the info. Does that web service CI limitation issue apply to Asynch messages as well? We don't mind if it takes longer as long as it runs. The staging table via web service is they way I am definitely leaning (even before your reply) but I have to answer the asynch option question that was posed to me. Thanks!
@Jeff, I am not sure. Usually a timeout is on the sender's side, not the side doing the processing. The timeout is just a resource management technique. It frees up resources on the sender's side if the receiver hangs onto a connection indefinitely.
Hi Jim,
I know I can use encryption profile PS_CREDIT_CARD_Decrypt to decrypt a field that is encrypted using PS_CREDIT_CARD_encryp on an other PeopleSoft system like HR and sent to finance through ib(I tried it and it worked). can we use the same decrypt function to decrypt a base64 encrypted value from third party?
@Vinjas, as you probably know, Base64 is not encryption, but encoding. What this means is there are no public or private keys. Anyone can encode or decode someone else's base64 data. There are a good dozen ways to encode and decode base64 with PeopleCode. You can find examples in these posts on my blog.
HI Jim,
We are working on Customers CI interface through Asyn messaging. We are receiving the Customer data as a message from third party system. We have the subscription app package written on handler class. The App package calls a CI to validate the data. But the problem here is when Insert fails due to CI validation we are unable to know that it failed to load a customer and the service operation monitor still shows the status as DONE.. Any suggestions to handle this scenario??
@Mohd, there are 3 IB queues. The subscription queue should show an error if the CI fails. I have seen CI errors in the IB queue many times. The instance queue will show as DONE, but the subscription queue should say ERROR.
Hi Jim,
I am trying to send messages from Peoplesoft 8.52 to weblogic JMS Queues, the messages are in new status. Created JMS Server/Connection Factory/JMS Queue on weblogic server. Created an external node in Peoplesoft with Connector ID as JMSTARGET and used the JMS queue. Ping node is working and the ping messages are visible in JMS Queue. Created a Peoplesoft non-rowset based message and Service operation(Asynchronous one way) and provided a routing from local node to the external node. I tried to publish messages to the service operation from peoplecode, the meesages are all in new status. Please provide your inputs to resolve this issue.
Thanks,
Vijaya
Hi Jim,
We are receiving messages from a third party through JMS queue. We wanted to capture the transaction ID of the inbound message that we get through the OnNotify handler peopleCode.
I used the IB class property &msg.transactionid but that generates some new Id which does not match with the transaction ID I see in the Asynchronous monitor for that message. Could you please help me understand if there is Any different way to Capture the transaction ID for the Aynchronous inbound message I get from the third party?
@Mohd, when I look at an async service in the service operation monitor, I notice that each instance has at least 2 transaction IDs: The initial instance transaction ID and one transaction ID for each publication or subscription contract. Did you check the transaction ID against the appropriate queue to see if the ID matches one of the other queues?
Thanks for the quick response Jim.
As you said there are a couple Transaction IDS. One being initial and other being the Subscription Transaction ID. The one that &msg.Transactionid fetching me is the Subscription.
Thanks I dint realize that its atleast matching the Subscription ID, but is there a way to Capture the initial Trasaction Id? because if we want to search for ab Ib transaction we would do it using the Initial ID right? because if i search using the Subscription Transaction Id it does not find the transaction. Any hint from your end regarding this would be a lot help me to me. Thanks you again.
Hi Jim
I am working on a requirement where a custom request-id property has to be set on the response header in a REST synchronous transaction. While I am able to do this over the response message when all is good using the below code snippet, i am unable to do the same on the fault message.
&resMessage.IBInfo.IBConnectorInfo.AddConnectorProperties("Request-id", &requestid, %HttpHeader);
When onError method is invoked by IB, it just returns a string and we dont have a hold of the response object to set any property on it.
Can you please share any possible way to do this?
Thanks in advance.
Vivek
@Vivek, you may want to post that question on the PeopleSoft General OTN Discussion forum.
Hi Jim, Can we sent picture/Image from Peoplesoft HCM to the third party system using integration broker?If possible can you mention the steps?
@Som, yes, there are a couple of ways to do this. PeopleSoft supports MTOM, so that is recommended. Another way is to base64 encode the binary data and insert it into an XML node.
Hi Jim,
Hope you are doing great. We are getting the xml messages to our jms queue. However, under some circumstances qhen there is a an issue with the structure of the xml the subscription contract goes to error. Is there a way to fire a custom peoplecode if a subscription contract is in error ??
Thanks in advance
@Mohd, I believe there is an App Engine job you can schedule that will notify you of messages in error. A long time ago I wrote an App Engine daemon process to do this.
@Mohd, there is delivered app engine program which notifies you of any messages in error. You need to have a permission list assigned to get this notification. It will also place them in your worklist to view the error messages.
Thanks
OK.. I will look for that App Engine.
Thanks Jim Marion and Narender Dontu.
HI Jim,
Hope you are doing well. I have a question around IB message delivery. I am publishing an XML message using the %INTBROKER.Publish(&msg) function. and Once the message is sent I am required to delete some data from PeopleSoft tables. The Service operation is Async One way. So my question is , is there a way to make sure that the target system received my message before I delete any data from PeopleSoft. Does changing the Service operation type to Async request response will help? If yes do I need to tell to third party to send some response or it happens automatically?? Please advise.
Thanks
SHAIK
@Mohd, there are a couple of things to think about here. Yes, having the recipient send an async response that identifies the batch that was sent will definitely give you assurance that the recipient received the data. Another is to convert to synchronous. The final thought is non repudiation.
Hello Jim,
I am trying to generate a BI publisher report from a web service. But it keeps throwing a warning 'system-temp-dir' property is not defined in xdo.cfg
Is there any additional configuration needed to call BI publisher reports from a web service?
Thanks,
Narender
@Narender, I have never tried it. I suggest you ask this same question on the PeopleSoft General Discussion OTN forum.
Hi Jim, I require help regarding Peoplesoft - TIBCO integration.Can you please provide me a document\example for these.
1) Peoplesoft publish data to TIBCO . Then TIBCO provides data to 3rd party application. (Outbound)
2) 3rd party publishes data to TIBCo, then TIBCO in turn publishes data to Peoplesoft.(Inbound).
3)Can we sent/Publish Document from Peoplesoft to Sharepoint.
Hi Jim, I am trying to configure IB for client authentication using certificates. I can establish connection with secured Third Party Vendor using SSL at the transport layer, but they require a second layer client authentication certificate. I am trying to attach a certificate to a SOAP message request. I have tried non-repudiation from the default local node, but that does not seem to be working. I have also tried importing a private key into PeopleSoft for the local node.
I was wonder if you have tried anything like this. I have a signed private & public key from a trusted CA stored in a ".pfx" file , PKCS#12 archive. I wish to import this private/public key combination into PeopleSoft and attach to a soap message to be used in client authentication with a third party vendor.
Hi Jim,
I am very new to Integration.Can you please share a documentation/manual for Peoplsoft - TIBCO - 3rd party integration(Inbound & Outbound for both the scenario).
Thanks for your help in advance.
@Som, I would love to help, but I am not familiar with TIBCO. I suggest you ask your question on the PeopleSoft General Discussion OTN forum.
Hi Jim, thanks for the blog. We having been using SOAP messaging to non-PS systems for years but we are now asked to call 3rd party web services using REST. On the SOAP messages we are able to easily capture the attribute values from the response. With REST, we have it setup as a message using a document (not a rowset and unstructured) so we call a GET as shown below. We can see the response xml fine but how do we get the attribute values from the xml elements since I can't use xml class methods? I'm not sure if there is something obvious I'm missing or if I need to possibly do a transform. Thanks and hope it makes sense...
&RESP = %IntBroker.SyncRequest(&MSG);
@John, in my opinion, the documents module is somewhat limiting. If you know the structure of the response document, I would be tempted to specify the integration point as a non-rowset, no document message (possibly unstructured?) and then use XPath with the XmlDocument PeopleCode object to identify the important pieces.
Hi Jim,
I am facing a very strange issue. I am trying to expose my peoplesoft functionality through Integration Broker. My code is working fine when tested through handler tester. But when I am trying to consume the generated WSDl through SoapUI, the request message is not appearing in it while the response message is appearing in the input window and the output window( where response message appears) is blank. I have thoroughly checked my service operation. The response and request message appears fine. Even the services that were already working are also showing same behavior when using SoapUI. I am not quite sure where the problem lies. Is it with SoapUi or the Configuration setup at gateway level. Any solution?
@savvy, great questions to which I do not have an answer. You might want to try your question in the PeopleSoft General Discussion OTN forum.
Hi Jim,
I am trying to expose my logic through Web Service. The web service is responding fine when tested with Handler Tester. But when I am trying to test it with SoapUI, one of the tags is showing 'False'. This tag basically handles the error message that pops up during online testing. I have captured this message in a string and it prints perfectly with Handler tester but why not SoapUI. Also the data is not being pushed to DB even when the case is right. What is the difference between testing through SoapUI and Handler tester except that SoapUI being a 3rd party.
100118
False
Hi Jim,
How can we implement Security while sending data (secure data) to 3rd party.
I know using Web Services Security. But can you help me to implement in a simple way, with less complexity and min customization involved.
@Som, if you already know about WS-security and SSL/TLS, there isn't much more I can share with you. You might want to ask your question on the PeopleSoft OTN Discussion forum.
Hi Jim, Can we encrypt data using Peoplesoft Integration Broker.Is there is any delivered peoplesoft functionality?
@Som, yes and PeopleSoft does deliver encryption options using PeopleSoft's pluggable encryption (PET). I have a sample here: Base64 Encoding with Pluggable Encryption
Hi Jim
We have a requirement to integrate our PeopleSoft Application with 3rd Party
3rd party provides Http Post url
I chose to use http target connectors with in PeopleSoft
Configured Services,Service Operations,Messages,Nodes,Routing (Outbound)
I was able to call their Post Method and interact with their application
Problem:
3rd Party Application expects Authorization Header to be send across along with XML Message
I tried Configuring Header at Gateway level, Routing level, Target Node Connector Properties
Alternatively at PeopleCode level used
&msg.IBInfo.LoadConnectorProp("HttpTargetConnector");
&msg.IBInfo.IBConnectorInfo.AddConnectorProperties("Authorization", "Basic b2JqZWN0aXZlOg==", %HttpHeader);
None of this things is working
We are getting error message as response from 3rd Party Application
Empty username for specified action
Tried using VB.net where we passed header and it works
Looked into IB Logs and saw in IB Info section
None of our header parameters are reflecting
------=_Part_839_63708743.1463456636177
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Content-ID: IBInfo
is there any other place we have missed?? at IB Configuration or is it a PeopleTools Defect?? Your help is really appreciated
Thanks
Chandra
@Chandra, that is strange. I know I have done this through the node properties. You may want to open a case in my oracle support.
Hi Jim,
Making Sync IB Calls from a Component is locking the IB tables during peak traffic to that component.
Any design suggestions would be appreciated.
Thanks,
Ravi
@Ravi, that is a great question. There are plenty of options including using Async messaging, but I'm sure you have a reason for using sync. I suggest you ask this question on the PeopleSoft General Discussion OTN forum where you can get answers from a lot more people than just me.
Hi Jim,
I'm implementing a new service operation in a existing service. I'm testing it through soapUI. when I'm testing with a already existing response message, I'm output message with needed details. But, I want to test it with a new response message which I created. When I'm testing with new message, no tags are added to output message. I'm seeing only the header message and no child nodes are added in output message. Please suggest how to fix this issue.
Use Fidler tool to Intercept IB Traffic, you will be able to figure out what went wrong
Thanks
Chandra
Hi All, Can you please provide information on Asynchornous - Synchronous Communication?
Peoplesoft Async (send data) and Target in Synchronous mode (sends acknowledment) .Peoplesoft receives the acknowledgement.
I have seen this type of Service Operation in Peoplesoft 9.2 and also you can search with ASync - Sync type in Service Operation Search.
I tried to get information in google but not much answers aviable.
Hi Jim, Do you know about Mass updates?
How Peoplesoft will call the integration in cases of massive updates??Legacy system expects data to be received from integration broker, record by
record.
Hi Jim,
Can we have multiple Listening Connectors (e.g. HTTP listening connector,JMS listening connector,AS2 listening connector etc) configured for the same Gateway as in the Gateway Set up page I am able to see that I will be able to load multiple Target Connectors (using "Load Gateway Connectors") but in the URL I will be able to add only one Listening Connectors.
@Arnab, you can have as many connectors as you want, even custom connectors. There is only one Gateway URL, but there can be multiple connectors. For example, PeopleSoft comes with HttpListeningConnector and RestListeningConnector all configured on the same server with slightly different URL patterns. Some of those protocols you mentioned don't have the concept of a URL.
Thank you Jim for the quick response,but could you please give me a brief idea of how I would be able to add multiple distinct Listening Connector's URLs (e.g. HttpListeningConnector, RestListeningConnector, PeopleSoftListeningConnector etc.) when all of them would be active as I am able to see only one Gateway URL can be added for any listening Connector in the Gateway Configuration page.
@Arnab, the gateway and the listener are two different things. The gateway holds the configuration information, but may or may not be the listener. Likewise, most connectors do NOT use HTTP or URL's, so having a URL doesn't make sense. The PeopleSoftListeningConnector is a great example. It is app server to app server. When you configure that connector, you are really configuring the app server connection information for each node that will communicate through integration points. No URL is involved. the Http style connectors, such as RestListeningConnector and HttpListeningConnector work as servlets configured and installed in the PSIGW web app. You don't have to install or configure those delivered servlets. That is out of the box. From here you will find information on configuring each of the different types of connectors: PeopleBooks > Understanding Listening Connectors.
Thanks for your reply Jim, could you please address my following concerns,
1.When multiple request are coming from an external system at the same time how the Gateway Manager will be able to know which Listening Connectors needs to be utilized, e.g. in the Gateway Configuration page I am mentioning my Listening connectors as PeopleSoftListeningConnector, but when a request is coming from an external system as REST/HTTP/Peoplesoft Based Service how it is able to pick the correct listening connector.
2.For PeopleSoftListeningConnector when it is connected through app server to app server, I hope the request is not coming from an external system.
@Arnab, I think maybe the confusion is that the requests don't actually go to the gateway URL. The gateway holds the configurations and the gateway itself is usually the first stopping point for a message when routing, but that URL that you see at the top of the gateway configuration page is NOT necessarily the URL the source system will use. A gateway is an IB instance and IB uses more than just URLs to communicate. Incoming traffic for JMS, PeopleSoftListeningConnector, etc does not use URLs. Every one of those items you mentioned, REST, HTTP, and PeopleSoft use a different URL or protocol. The PeopleSoftListeningConnector doesn't use URLs.
Jim,
Good day. I have a requirement to monitor a process request and when it errors out it should automatically invoke a 3rd party web service to create a service ticket. I was trying to invoke the 3rd party sync web service on the OnNotify method of the the PSFT_REPORTING_FOLDERS which is failing as I am trying to invoke a non rowset based message from a Async handler. I am looking for other alternative to achieve this. Any help is appreciated. We aren't going to have a separate AE to monitor the process request.
thanks,
Sudha
Hi Jim,
We are using SOAP to CI using XML Messages sent from a portal to PeopleSoft Job CI.
The issue we are having is we are using Correction Mode (DataUpdate) and it works for Job fields EXCEPT EFFDT.
There is an error message when we try and update EFFDT which is a key on the Job record.
Why would EFFDT have an issue when correction mode works for other fields.
I have been told that when we pass the new value for the Effdt, the CI cannot locate the Effdt record, which is true, but we are updating the field, not search for it.
Any guidance you can give on Key updates in Correction Mode using SOAPCI.
Thank you.
Hi Jim,
I need your valuable inputs on exposing the webservice from peoplesoft.
can we expose any peoplesoft webservice with out their version numbering in any of message, service, service operation, xsds and wsdl?
I have just provided a peoplesoft generated wsdl file to our customer but they are not accepting it because it doesn't suit their existing SOA format like targetnamespaces, the inclusion of versions of message, service, service operations, xsds and doesn't contain ws addressing, wsam-action elements? can it be done?
If I modify the wsdl manually as per their criteria by removing versioning and adding some extra elements can I invoke our peoplesoft webservice?
Please advise me on this as it is critical our development.
Thanks,
shiva.
Hi Jim,
Adding to my previous query what is ws:addressing and wsam:action in wsdl file? these are not generated in peoplesoft generated wsdl file? where to and how to add them in manual wsdl generation?
thanks,
Shiva.
Hi Jim,
Sorry for not consolidating all the queries at one time.
Here are few more queries.
In PeopleSoft when we expose a service the esdl file has service, service operations namespaces are actually type URL but can we make it as urn?
For example: from http://XML.com/service/ to urn:companyname:service
Is it possible to expose a service/ service operation without a version number in wsdl file? If I modify the wsdl file by removing the version number can PeopleSoft identify that service routings for its message?
Thanks,
Shiva.
Hi Jim,
We are in PT8.55 and imported a wsdl from third party using wizard and got ServOP(Syncnorous WS) created with Request message of type Document. The document created says autogenerated and is not editable. Can it be made editable? I need to make changes to prefix as PS is generating as "common:Element". Also, I am trying to send SOAP msg using this Document msg and not sure how to Copy the Document populated with data onto SOAPDoc before calling SyncRequest menthod. I have tried converting document into XML String using GenXMLString function and converting to XMLdoc using CreateXMLdoc and copy to SOAPdoc inside SOAP-Body. Getting Fatal error Parsing XML String error. Is this the right way to do? Any help is much appreciated. Thanks.
Raj.
@Raj, I'm sure there are several ways to handle this. One would be to forget PeopleTools has a wizard and create all of the metadata yourself. Another is to use an XSL Transform on the routing to replace the node name with the appropriate name. I would likely opt for the XSL transform so you can retain all of the metadata created by PeopleTools.
As far as populating the XML document, it has been a really long time since I had to do this, but I thought the service operation had a method to get the XML doc. You would then populate the XML doc directly. About your Parsing error when trying to load XML from a string, that should only happen if the XML is really invalid. I believe the error you are seeing is at a very low level inside the XML parser (Xerces). What I would do is print the GenXMLString to file and confirm that the generated content is valid XML. It should be since it is a DOM document coming in and going out, but that is what I would do to confirm
Thank you Jim,
I am able to complete the WS successfully with one issue left to resolve. Everything works fine when I send good xml request and I receive response (&ResponseMsg = %IntBroker.SyncRequest(&ReqMsg);) And when Fault occurs, the 3rd party SOA middle ware system is sending http 500 error and I don't get a response i.e. &ResponseMsg is null. I tested with SOAPUI and get the fault message with 500 error. Do you know why the PSIB is not returning the fault msg in response? I see the fault msg in the app server log.
Raj.
Hi Jim,
Thanks for all your help. Currently, we are having this issue related to sending files segments(MTOM) with the SOAP response in an Synchronous WS. We are providing a Synchronous service where in the 3rd party requests a file in the Request and we are sending Binary file as a segment using &responseMessage.CreateNextSegment() method and while testing in SOAPUI we are getting just the body and not getting any segments. I wrote the &responseMessage.GetContentString before returning the &responseMessage and the Segment is there but is missing in the Gateway logfile(msglog.html). I believe the segment is getting stripped by IB. In People books it only talks about sending or Receiving in Async WS only. I am wondering, can we even do this in Synchronous model? Also the routing that is automatically generated does not allow me to change the receiving node(PSFT_HR which has PSFTTARGET COnnector) to any other HTTP connector, if that is the problem, but not sure? Please help in making me understanding how to send segments as MIME (MTOM
)in the response of a Synchronous WS which I am providing to a 3rd party. Thanks for your help. Here is what I have in my OnRequest handler. And the Auto generated Routing is ANY to PSFT_HR Inbound.
import PS_PT:Integration:IRequestHandler;
class BC_PUSH_FILE_NRS implements PS_PT:Integration:IRequestHandler
method BC_PUSH_FILE_NRS();
method OnRequest(&requestMessage As Message) Returns Message;
end-class;
method BC_PUSH_FILE_NRS; /* constructor */
end-method;
method OnRequest
Local Message &responseMessage = CreateMessage(Operation.BCGETPROVIDERFILE, %IntBroker_Response);
Local Message &fault_msg = CreateMessage(Operation.BCGETPROVIDERFILE, %IntBroker_Fault);
&req_XMLdoc = &requestMessage.GetXmlDoc();
/*** PROCESS REQUEST ***/
&theFile = GetFile(&binaryfilename, "R", "A", %FilePath_Absolute);
If &theFile.IsOpen Then
&theBase64encodedString = &theFile.GetBase64StringFromBinary();
&theFile.Close();
&myClass.logfile.WriteLine("getting base 64 binary string");
End-If;
&responseMessage.SetXmlDoc(&ReqSdoc.XmlDoc);
&responseMessage.CreateNextSegment();
If (&responseMessage.SetContentString(&theBase64encodedString)) Then
&responseMessage.SegmentContentType = "application/octet-stream";
rem &responseMessage.SegmentContentType = "text/xml";
&responseMessage.SegmentContentTransfer = %ContentTransfer_Binary;
End-If;
Return &responseMessage;
end-method;
Just an Update on my issue with Sending binary files(segments) in MIME(MTOM). Oracle said that it can not be done in Synchronous response. It is only possible in Async model. I am still somewhat skeptical about oracle's response as the document says it can be used in synchronous, but it doesn't say it clearly. Any thoughts about this? Also can anyone explain me how psftxopinclude works in XOP processing? there is not much in Pbooks. Thanks for all your help!
@rajcheck, thanks for the update.
Hi Jim,
We are trying to invoke 3rd party rest service to peoplesoft. As part the header we need to pass some header values with the rest URL.
One of the header in that needs to be "HMAC SHA256 digest of the entire HTTP request using auth string as the encrypted key"
Note: Auth string is computed as Base 64 encoded string as “username:password”
My question is how I need to pass auth string key value for HMAC SHA256 in peoplesoft pluggable encryption.
Could you please help me on this.
Hi Nagesh
I have used something like this it worked for me
You can also cross check header Information if you intercept the Integration Traffic using Fidler Tool
&msgRequest.IBInfo.ConnectorOverride = True;
&msgRequest.IBInfo.IBConnectorInfo.ConnectorClassName = "HttpTargetConnector";
&msgRequest.IBInfo.IBConnectorInfo.ConnectorName = "HTTPTARGET";
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("Authorization", &strEncodeResult, "HEADER");
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("Content-Type", "application/xml", "HEADER");
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("sendUncompressed", "Y", "HEADER");
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("Method", "POST", "HTTPPROPERTY");
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("SOAPUpContent", "N", "HTTPPROPERTY");
&ret = &msgRequest.IBInfo.IBConnectorInfo.AddConnectorProperties("URL", "", "PRIMARYURL");
Thanks,
Chandra
Thanks for the update chandra.
Could you please help me on below.
in rest service One of the header needs to be "HMAC SHA256 digest of the entire HTTP request using auth string as the encrypted key"
Note: Auth string is computed as Base 64 encoded string as “username:password”.
how I need to pass auth string as key value to HMAC SHA256 in peoplesoft?
Hello Jim,
I am publishing a synchronous JSON message to a 3rd party. But when I use %intbroker.syncrequest(&msg). The output generated is in xml format.
How can I achieve JSON output .
Hi Jim,
I am new to integration broker. I need help on how to to convert 3rd party xml to peoplesoft xml format and how I need to to pass the xml to integration broker.
We are getting 3rd party invoice data into peoplesoft.
Please help me on this.
@Nagesh, there are a few options. First, if it is possible to transform the XML from one format to the other, then you can use XSL or PeopleCode to perform the transformation and attach the transform App Engine to you integration routing.
You don't have to transform the XML, however. You can write subscription PeopleCode to read the XML and process the information through a Component Interface.
Hi Jim,
I am trying to consume an external REST based api into Peoplesoft. I followed all the steps in peoplebooks on how to create a REST service and service operation, but every time it's creating an inbound routing automatically and, I am not able to change the REST base url in the service operation (I guess because it's assuming the api is inbound).
Somehow it doesn't look like as straight forward as consuming a SOAP based webservice. Can you please suggest any ideas on how to overcome this?
Thank you!
@Narender, you are correct. I may be mistaken, but I believe all of the REST configuration information allows external applications to connect to PeopleSoft using REST. I don't believe there are options for connecting to a REST service. I'm not sure you need any because you can just invoke %IntBroker.ConnectorRequestUrl to make a REST request.
Hi Jim,
We are trying to create a dedicated Messaging Server for Workflow approvals. Could you please help me with what service operation queues need to be added to the new messaging server? Is EOAW_APPROVALS the right service operation queue to be added?
Hi Jim,
Is there any difference between testing a Synchronous CI based web service (where third party integration is involved) using SOAPUI and handler tester (Peoplesoft Delivered), as for me handler tester was working fine, but the same was being tested with SOAPUI, the WSDL was not working.
@Arnab, SOAPUI is going to be a lot more like real life. I always attempt to get services working in SOAPUI or another external tool before moving onto a real integration.
Hi Jim,
I am currently looking for a solution to process the CXML messages for posting Invoice into the PeopleSoft Financial application. Here the CXML message has to be processed from a FTP / SFTP location and not as a HTTPS POST. I am trying to leverage the delivered service operiation EM_VOUCHER_IN for this purpose, and interested to use the delivered file utilities in PeopleTools IB. Have anyone implemented any similar solutions earlier ? please suggest.
@Ram, your direction is a good direction. I would do likewise. I have used the FTP target connector, but have found it isn't flexible enough. I have seen people use to put files on an intermediate/temporary FTP server, and then have a "watcher" process on the FTP server to rename and resend them to the intended recipient. The approach I prefer is to clone the FTPTargetConnector Java code and create a new Target Connector that meets your needs.
Thanks Jim for your reply. we have decided to go with the old school approach because of the complexity involved. We are going to read the file, copy to the record rowset / read xml element.
Hi Jim, I am trying to call the OnRequest method used inside CXML:RequestHandler from another PeopleCode event / Application engine program PeopleCode. Instead of calling the service operation, I am trying to call the handler onRequest Method. This way I can internally access the service operation functionality. Can you please suggest how can I possibly achieve this ?
Thanks,
Ram
Hi Jim,
I have a question about using Outbound Asynchronous Nonrowset-based messages. I have a requirement to run an App Engine to publish a SOAP xml to a third party, there will be no response or request from the third party. I created a message and loaded a schema onto it, set up services, operations etc. In my App Engine PCode I'm currently create a message, loading a string variable with xml then creating Soapdoc, xmldoc and publishing which works fine.
&MSG = CreateMessage(Operation.DIR_DEPOSIT_WD);
&Message_Input = "";
etc etc
&SOAPDoc = CreateSOAPDoc(&Message_Input);
&xmlDoc = CreateXmlDoc(&SOAPDoc.GenXmlString());
&MSG.SetXmlDoc(&xmlDoc);
%IntBroker.Publish(&MSG);
I was wondering if there was another way to load the xml using tagnames.
When I try &xmldoc.DocumentElementit fails however.
&xmldoc = &MSG.GetXmlDoc();
&root = &xmldoc.DocumentElement;
Error: First operand of . is NULL, so cannot access member DocumentElement
I assume this is expected but maybe I'm missing something?
Thanks,
Tim.
Jim
I am looking for an answer to Previous question , But I cant Find an Answer...
I created a Simple Peoplesoft Rowset Message With A Rqst and a response... and created a WSDL
I gave it to a third party, to create an interface...
When I use SOAPUI.. It looks great.. Both the Request and Response.
The THrid party used Visual Editior and , with the WSDL I gave them .. it created classes...
But when the message goes out.. it returns null...
When I try to edit the response in the SOUPUI . I get a message
line -1: Missing message part with name [{http://xmlns.oracle.com/Enterprise/FSCM/schema/GET_ITAM_RSP.V1}GET_ITAM_RSP]
Why or where would this need to be set.. Some one mention namespace So on the service I changed
Namespace to http://xmlns.oracle.com/Enterprise/EnterprisePortal/services
cleared cache and rebuilt wsdl...
What AM I missing
W
I have a row set message.. But the response seems to be creating an error for my Thirdparty User using Virtual Editor and Loaded the PS WSDL to create Classes.
From the looks of it
people-soft is building the XML Record response tag like this
But it should build it like this , As it has been defined in there own WSDL
What needs to be adjusted or fix to correct this issue
@Unknown, I believe what you need is CreateXMLDoc to create a stand alone XmlDoc and then use &MSG.SetXmlDoc.
Hi Jim
I want to create single iso20022 file which handles all kinds of payments and send that file to chase bank . Can u suggest me how to create a xml file . There is no integration broker or xslt message involved here.
@Kkvc, PeopleCode loves XML. If you don't need Integration Broker, then just use PeopleCode to generate the file. I would likely run this through Process Scheduler and have the output generated to the process output directory.
Hello Jim,
I got one requirement to sync outlook emails with peoplesoft, for example if any AP person sends an email to Vendor and vendor responds to AP person. system should read these conversation and keep a notes in peoplesoft screen with date and time stamp. do you have any example to do this.
Thanks,
RRCPREDDY
Hi Jim,
I have created a synchronous web service for providing data to Third party.As i tested on soap UI data is fetching correctly. But I want to provide this web service to Third party ,
So What type of node configuration are to be done? and also please tell how i will configure it.
Thanks in advance
Hi all,
Can anyone help me on this.
I have to provide web services to third party.
What are the node configuration that are needed?
Will i take node type as external ?
And what about sender and receiver node?
Please help
Thanks in advance
@Shubham, since it is working from SoapUI, you are good to go! it sounds like it is probably configured for the anonymous node. If you want to further secure it, you can configure a routing for a specific named node. The node type would be "external."
Hi ,
Can anyone help me ,how do i configure Web security IB in people-soft while providing web service to 3rd party? such that when I test on soap ,it would ask username and password on soap .
like this .
IBUSER
IBUSER1
Main Point: How do I provide secure web service to 3rd third such that header in soap validate username and password then allow to fetch data to 3 party?
Thanks in advance!
@Shubham, check the box on the upper right corner of the service operation that says, "User/Password Required." If you check this box, then we recommend that you also enforce a secure transmission protocol through the Req Verification drop-down. Keep in mind that Req Verification requires SSL termination all the way back to PeopleSoft. Many organizations terminate SSL at the load balancer.
Thanks for reply!
As our requirements is for required 'username and password',we don't want req verification.
As I fix my issue .
I have to check username and password in service operation then I configure username and password in new external node ,then given this username and password in soap ui for testing purposes.
Thanks
@Shubham, you can use user/password without req verification. If you are going to send username and password in plain text anyway, you might as well leverage PeopleSoft's built-in security. Otherwise, you can parse the user/password out of the posted content, and then use SwitchUser to become a different user.
Hi,
I am getting the below error while testing the service operation
"Integration Synchronous Handler: No destination node can be determined for the request on node PSFT_HR. After applying filters for sender specified routing, node transactions, relationship transactions and the PeopleCode event OnRouteSend, a destination node cannot be found."
I have verified all points which mentioned in this blog. But couldn't resolve the issue. Please help me on this.
Service Operation Type - REST
Hi Jim, could you please suggest on this issue.
We have PS integration with a dot net system wherein we have consumed dotnet wsdl at PS side. The request XML is given appropriate parameters for the method being called at dotnet side. However, all three parameters are received as Null on dot net.
Tried the same requets XML via handler tester. Still same.
However it works and updated fine when the same XML is invoked via soap hi tester.
Thank you.
Hi Jim,
I have a quick question. I am sending synchronous messages currently but my client is asking for a "full sync". I am building an app engine to do this however was wondering if I can lump all the document type messages into one big message then post it rather than posting each one by one. The programmer on the API side that I am working with changed it to become an array of messages so if there is a way to send an array of IB messages that would work. Below is a dummy example:
[{emplid : "1"
type" "" : "A"},{emplid : "2"
type" "" : "B"}]
Any suggestions would be greatly appreciated.
Thank You.
Hi Jim,
I have a quick question. I am sending synchronous messages currently but my client is asking for a "full sync". I am building an app engine to do this however was wondering if I can lump all the document type messages into one big message then post it rather than posting each one by one. The programmer on the API side that I am working with changed it to become an array of messages so if there is a way to send an array of IB messages that would work. Below is a dummy example:
[{emplid : "1"
type" "" : "A"},{emplid : "2"
type" "" : "B"}]
Any suggestions would be greatly appreciated.
Thank You,
Travis
Hi Jim,
We have a vendor with the spec below to provide images from a PeopleSoft application:
img src="https://{clientURL}/{item_id}"
If we wanted to do this, do you have any ideas on what the best approach might be?
If an image tag sends an HTTP Get request, would the HTTP Listening connector or HTTP Target connector work?
I did look at MTOM but isn't the content type of the response going to be XML?
Thanks for any information you can provide.
Hi Andy,
Are you POST'ing images to the target or are you trying to provide an endpoint to an image stored in the PeopleSoft database? The reason I am asking is that the code fragment looks like an HTML image tag. In this case, you would have a listener waiting for a request and then return an image. Unfortunately, Integration Broker will not directly return an image. Integration Broker only supports text-based MIME types (except for multi-part MTOM). With that in mind, here are a few options:
1. Don't use PeopleSoft to serve the images. Use a stand-alone web app.
2. Write your own listener using the Integration Broker SDK that returns whatever you desire.
3. Create a "proxy" program that listens for image requests, then makes the IB request to get standard XML/JSON/Whatever-text from PeopleSoft, and then transforms and replies to the originator with the real data. With this approach, I would just base64 encode the image data, and then base64 decode the image data through the "proxy" program.
There are other options as well.
If you are sending binary data to a system, then you may need to skip Integration Broker and use Java through PeopleCode instead. This is a common workaround.
@Unknown. It sounds like you are sending data to another system, so PeopleSoft is initiating the connection, rather than the external system initiating the request, and your OnRequest handler returning a response. I'm assuming this because of the App Engine. If this were purely OnRequest, then you would not have an App Engine.
Yes, you may return an array. Yes, you can do it with Documents, but documents are really, really hard to get a custom structure. The documents module seems to be designed around OpenAPI, which is the standard Oracle adopted.
Instead of using Documents, I would use JsonObject and JsonArray. They offer a lot of flexibility. They appeared in PeopleTools in 8.55 and in PeopleBooks in 8.57.
Folks
For files/pdf/images files in Json or Soap .. I started to send 64Bit strings .. and it worked great either way ..
Below I created a json Object and load the File into it , And then send it thru a GEneric Message , But you can build it anyway you wish .
&RSPHeader = CreateJsonObject();
&AttFile = GetFile(&NewFileName, "R", %FilePath_Absolute);
&RSPHeader.AddProperty("base64", &AttFile.GetBase64StringFromBinary());
&RSPHeader.AddProperty("filename", &NewFileName);
Nice
Hi Jim, i need help on how to override the PRIMARYURL connector property configured on the Routing definition of a Service Operation(Synchronous SOAP outbound) from the peoplecode. We have a need to change the Target URL dynamically at runtime depending the targets for the same message. Is it possible to change it before the executing the SyncRequest command ?&ResponseMsg = %IntBroker.SyncRequest(&ReqMsg);
I believe what you want is &connectorInfo.AddConnectorProperties("URL", &sUrl, %HttpProperty); You can find a full code listing in our blog post https://blog.jsmpros.com/2022/09/simple-code-only-rest-request.html
Post a Comment