Error Occurred In Routine Send Soap Request
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security excel to ci error occurred in routine sendsoaprequest_getcishape Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE
Error Occurred In Routine Sendsoaprequest_getcishape Error Number
A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX the response text is not valid xml. login data cleared VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus PCMag Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca iudithm Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Thawte
Peoplesoft Excel To Ci Operation Timed Out
Oracle CloudLock Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics PeopleSoft Groups Ask a New Question PeopleTools A forum where peers share technical expertise, solve problems, and discuss issues related to PeopleTools. Home | Invite Peers | More PeopleSoft Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create excel to ci in peoplesoft your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Setting up ExcelToCI.xls for VNDR ID and receiving error in routine sentSOAPRequest GetCIShape Jennifer Sieber asked Dec 21, 2007 | Replies (2) We are looking into setting up the Vendor Load Component Interface in Financials 8.9 (MP6) on Tools 8.48.10. We are trying to insert the template and we receive the following error: Error occurred in routine sendSOAPRequest_GetCIShape: Error: Number: -2146697208 Description: The download of the specified resourse has failed. Anyone have any ideas? Thanks, Jennifer Join this group Popular White Paper On This Topic The Best PDF Features Businesses Don't Use 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Savin
April 07, 2011 ExcelToCI Error occurred in routine sendSOAPRequest_SubmitToDB: The operation timed out. When trying to upload about 7000 rows using ExcelToCI for a custom component, users are getting the following error. Error occurred in routine
Oracle Support
sendSOAPRequest_SubmitToDB: Error: Number: -2147012894 Description: The operation timed out After doing my investigation, checking the web server and appserver access log I found the following issues, and here is what i did to resolve the issue. This is not documented anywhere. Please create a resolution if possible to help others. 1. Found that ExcelToCI uses SERVERXMLHTTP MSXML 6.0 object to send the SOAP request to the webserver, http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/setting-up-exceltocixls-for-vndr_id-and-receiving-error-in-routine-sentsoaprequest_getcishape-1787380 Set xHTTP = CreateObject("MSXML2.SERVERXMLHTTP.6.0") This request has a default 30 second timeout for receiving a packet of response data from the target server, See link : http://msdn.microsoft.com/en-us/library/ms760403 for more details on timeouts. 2. After checking the webserver access log (PIA_Access.log), determined that some of the POST request are taking about 59 seconds to complete and therefore we were receiving the error. To resolve http://peoplesoftexperts.blogspot.com/2011/04/exceltoci-error-occurred-in-routine.html this issue, change the VB Macro code in ExcelToCI spreadsheet as follows ======================================================= Add this line before xHTTP.send xDoc.xml in StagingAndSubmission Module under function sendSOAPRequest_SubmitToDB Dim lResolve, lConnect, lSend, lReceive As Long lResolve = 60 * CLng(1000) lConnect = 90 * CLng(1000) lSend = 90 * CLng(1000) lReceive = 120 * CLng(1000) xHTTP.setTimeouts lResolve, lConnect, lSend, lReceive ======================================================= After changing this value, the ExcelToCI was still failing. Once again I checked the web Server and App server log and found that after loading about 50 to 60 rows, request is taking more than 5 minutes to respond and appserver is killing the appserv thread and therefore error was received saying that The Operation time out. I had two options 1. Increase the XMLHTTP timeout and also increase the appserver timeout or find out why a request is taking more than 5 minutes to complete. Used Precise i3 performance monitoring tool and also the live Oracle session and determined the following issue. 1. CI was firing sql to fetch location code description using a view that was not correctly joined with other large table using location code. 2. A Save Edit Peoplecode was written at Level 2 to fetch
Recent blog posts How to resubmit on Integration Broker message with DONE status Message cannot be changed. Message referenced in runtime tables (Doc http://www.compshack.com/forum/peoplesoft/peoplesoft-technical/issue-excel-ci ID 660969.1) PeopleSoft Object Type List PeopleSoft Data Integrity Error (124,85) Unwanted Save Warnings in Display Only Pages Breadcrumb SQL to find the Navigation path for the component in the http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RERR_gen PIA Application Designer Index naming convention How to create Trigger in DB2 Emplid increment automatically How can we romove multiple duplicate rows of data printing under each Print command in error occurred SQR Program? more Who's new LillianMob sunmoon alizajersey96385295 gay iGamerz zohebak Les Kernodle qizhen0926 Simpalm nikhilkubba_86 Home › Forums › PeopleSoft › PeopleSoft Technical You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more. Issue with Excel to error occurred in CI 5 replies [Last post] Tue, 04/08/2008 - 9:30pm Guest Hey, I am having an issue with Excel TO CI i don have any web libraries and component interface name in my perrmissionlist so i added component interface to my permission list and also for tht permission i added a weblibrary called WEBLIB_SOAPTOCI and i went to component interface tab in the appropiate permissionlist and given fullaccess for the methods and also for the weblibrary too.. now when i am using the excel to CI i am feeling strange tht my EXCEL TO CI is not working and i am getting an error "error occured in routine sends SOAP request_submit to DB:" ERROR NUMBER: -2147467259 Decrpition:Method open of object'IXMLHTTPREQUEST' FAILED Bookmark/Search this post with Top 13955 reads Wed, 04/09/2008 - 3:44pm #1 CompShack Offline Joined: 12/09/2007 Posts: 167 Excel to CI I'm not familiar with this type of error but have you tried if this works for certain user but not another (may be use VP1 for testing)? If so, then get to the permissions list and l
General Error Messages ] Search: This document contains tables of numeric error codes and their corresponding error messages. Commonly, these error codes are reported as ERROR #nnn. These error codes are sometimes referred to as %Status error codes. The $SYSTEM.Status class methods used for handling these error codes are documented in the InterSystems Class Reference. You can determine the error message for a specified error code using the DisplayError() and Error() methods, as shown in the following example displaying error code #101, where the embedded message variables are %1="5", %2="10", and %3="2.7": DO $SYSTEM.Status.DisplayError($SYSTEM.Status.Error(101,"5","10","2.7")) Two error codes, 83 and 5001, are provided to enable you to generate your own custom error messages. For details refer to the %SYSTEM.Status class in the InterSystems Class Reference. Two error codes, 5521 and 5540 are provided for SQLCODE errors. For details refer to the %SYSTEM.Error class in the InterSystems Class Reference. For more information on using these error codes, refer to %Status Error Processing in the Error Processing chapter of Using Caché ObjectScript. For more information on CSP-related error codes, see the CSP Error Notes section of Using Caché Server Pages (CSP). General Error Codes - 0 to 199 Error Code Description 1 the volume already exists 2 the read of the map block failed 3 error writing map blk of primary volume 4 unable to read the global directory map block 5 unable to write the global directory map block 6 unable to write the global directory block 13 failed opening the next volume 14 failed reading the next volume's map block 15 the directory name is too long 16 the number of maps is invalid 17 the size is out of range 18 failed creating a new volume 19 the file was already mounted 20 the file already exists 21 a file create is in progress 22 the current # of maps is too small 23 unable to expand the file 24 the file is cluster mounted 25 unable to allocate CFN 26 incompatible mount state or db does not exist 27 the system mgr's database cannot be cluster mounted 28 the database is in transition 30 the system is not part o