Sterling's work around for these issues on Windows 2003 servers are:
Documents stuck in send queue:
Under regedit/HKEY_LOCAL_MACHINE/Software/Sterling
Commerce/Gentran/Server/5.0/Server
1. Set the ResendStuckInterchanges parameter to 1
2. Set the UPIDValidationInterval to 2 times the longest
communication session you run. Ie: your comm. session takes 5 minutes,
set it to 10.....
Documents stuck in processing:
We execute this sql from a bat file.in our comm. session It logs what
partner had an issue then resets the processing status.
SELECT "PartnerKEY" Partner,substr("TransactionSetID",1,4)
Type,substr("DocumentName",1,10) Name,
substr("ReferenceData",1,10) RefData, decode("LocationStatus",
'4','Out Documents') Location,
substr("Mailbox",1,25) Mailbox
FROM "Document_tb"
WHERE ("Processing" = '1') AND ("LocationStatus" = '4') AND
("Direction" = '1')
/
prompt updating Documents in Document_tb stuck in Processing Queue
UPDATE "Document_tb"
SET "Processing" = '0'
WHERE ("Processing" = '1') AND ("LocationStatus" = '4') AND
("Direction" = '1')
/
We also set up a notification to page us when there are documents in the
"Queued" status. We will run this until we're comfortable with the work
around. I would contact Sterling and let them know your having an issue
before implementing these workarounds.
Thanks for your suggestions.....
Steve
Steve Joyce
EDI Technical Support
Shaw's / Star Markets Division
Phone:508-894-7284 or x37284
Fax : 508-894-7175 or x 37175
E-mail : [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
-----------------------------------------
This email, including any attachments, is for the designated
recipient(s) only and may contain confidential, proprietary, and/or
legally privileged information. If you are not a designated
recipient, or have received it in error, please notify the sender
and destroy it and all attachments and copies immediately, without
distributing, disclosing, or using it in any manner.
[Non-text portions of this message have been removed]
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
