Sorry for the listing.
I went back over connecting settings and found the tcp port of our target server had been changed. I reset it and everything is now working. Dan Dan Wangler, MHS Remedy Support Team Science Applications International Corporation MHS Cyberinfrastructure Services (MCiS) 300 Convent St, Ste 1800, San Antonio, TX 78205 210-338-3162 * 972-979-1970 * [email protected] ________________________________ From: Wangler, Dan Sent: Monday, November 15, 2010 7:32 AM To: '[email protected]' Cc: Wangler, Dan Subject: DSO Transfer Failing with "* Access problem trying to get target form definition, retry later..." Dear List On Thursday, our DSO transfers from our production system to our reporting server started getting errors. The arsdist.log.default showed the following error "* Failure during mapping attempt" followed by Return Code: 2 Cancel, Delete pending item... I restarted ARServer on both the source machine and the target machine and the symptoms changed to the message "* Access problem trying to get target form definition, retry later...". And instead of deleting the pending request it is now saving it. Our environment * Two Windows Server 2003 running ARServer in a Server Group running production * one in a separate machine used for reporting and Analytics * Action Request System(R) Server Version 7.1.00 Patch 009 201003231347 * MSSQL 2005 server for our database On Wednesday, our primary Server Group server failed with a malloc error and hung. We recycle ARServer on the primary server. It did not look like the Server Group switched operations to the secondary server. After the recycle on the primary server, everything looked good. I include this because of the close proximity to the time DSO started failing, although that did not happen for another 30 hours. On Thursday, approximately 19:23 (13:23 CST),we started receiving the follow on arerror.log: "Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003)". Ardist.log.default reported Processing item number 0 (Thu Nov 11 2010 19:23:34.7030) <DIST> Pending type -- 1 <DIST> Source Form -- HPD:Help Desk <DIST> Source ID -- MHSINC000538466 <DIST> Pending Other -- <DIST> -m "MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server" -s "HPD:Help Desk" -x "MHSARMETRICS" <DIST> Get source structure <DIST> Using EXISTING cache definition for HPD:Help Desk (MHSAR) <DIST> Have source structure details, get entry <DIST> Have entry details, get mapping <DIST> Filter-specified mapping -- MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server <DIST> Filter-specified to form -- HPD:Help Desk <DIST> Filter-specified to server -- MHSARMETRICS <DIST> Mapping name -- MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server <DIST> Target form -- HPD:Help Desk <DIST> Target server -- MHSARMETRICS <DIST> Get target structure <DIST> Using EXISTING cache definition for HPD:Help Desk (MHSARMETRICS) <DIST> Perform mapping <DIST> * Failure during mapping attempt <DIST> --> To stage: 7 (of 8) Return Code: 2 CANCEL <DIST> Delete pending item - 000000012364566 And continued until we recycled ARServer on the primary Server Group server (source) and the reporting server (target). Then, ardist.log.default started with <DIST> Get a list of items to process (Sat Nov 13 2010 03:37:29.3120) <DIST> HandleDSOs: lastEntryId = <DIST> GetDefaultPendingList: lastEntryId = <DIST> GetDefaultPendingList: Error resetting lastEntryId. <DIST> 1 new item(s) found <DIST> Processing item number 0 (Sat Nov 13 2010 03:37:29.3120) <DIST> Pending type -- 1 <DIST> Source Form -- HPD:Help Desk <DIST> Source ID -- MHSINC000524195 <DIST> Pending Other -- <DIST> -m "MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server" -s "HPD:Help Desk" -x "MHSARMETRICS" <DIST> Get source structure <DIST> Using NEW cache definition for HPD:Help Desk (MHSAR) <DIST> Have source structure details, get entry <DIST> Have entry details, get mapping <DIST> Filter-specified mapping -- MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server <DIST> Filter-specified to form -- HPD:Help Desk <DIST> Filter-specified to server -- MHSARMETRICS <DIST> Mapping name -- MHS:BMCA:DSO Transfer from HPD:Help Desk to Analytics Server <DIST> Target form -- HPD:Help Desk <DIST> Target server -- MHSARMETRICS <DIST> Get target structure <DIST> * Access problem trying to get target form definition, retry later... <DIST> Sleeping for 24:01 minutes It is no longer deleting the pending records but it still having issues with the target form definition. I have checked definitions and everything seem to be correct and unchanged. Has anyone seen this issue with DSO before? Any help with this would be appreciated. Currently, we are no pushing records to our reporting server. Thanks Dan Wangler, MHS Remedy Support Team Science Applications International Corporation MHS Cyberinfrastructure Services (MCiS) 300 Convent St, Ste 1800, San Antonio, TX 78205 210-338-3162 * 972-979-1970 * [email protected] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
