Join wMUsers | Blog at wMUsers | Edit my wMUsers Profile | Site Map | webMethods Jobs |For Employers

wMUsers  
  #11  
Old 01-20-2010, 13:16
reamon's Avatar
reamon reamon is offline
Premium Member
 
Join Date: Apr 2003
Posts: 4,789
Thanks: 61
Thanked 177 Times in 140 Posts
Default

How many PO numbers do you need to keep track of and for how long? What happens if IS goes down for a brief time?

I think you need to get away from trying to store the PO numbers in memory. Using pub.storage services isn't advisable either as that facility isn't intended for data such as this.

What are the issues/concerns with storing the numbers in a DB table?
__________________
-Rob
http://reamon.squarespace.com
Reply With Quote
  #12  
Old 01-20-2010, 13:43
DevNull43 DevNull43 is offline
Senior Member
 
Join Date: Dec 2009
Posts: 330
Thanks: 5
Thanked 36 Times in 33 Posts
Default

If you are using a file port, one of the configuration parameters is the number of invocation threads.

If you set 1 thread, the same file won't be processed twice.
Or are you getting the file again after a period of time?

Regards.
Reply With Quote
  #13  
Old 01-20-2010, 14:20
reamon's Avatar
reamon reamon is offline
Premium Member
 
Join Date: Apr 2003
Posts: 4,789
Thanks: 61
Thanked 177 Times in 140 Posts
Default

My understanding is that it's not the same file. It is a new file but contains a PO number that has been seen and processed before. The source system is spitting out duplicates.
__________________
-Rob
http://reamon.squarespace.com
Reply With Quote
  #14  
Old 01-21-2010, 12:28
pdeeps pdeeps is offline
Junior Member
 
Join Date: Mar 2006
Posts: 21
Thanks: 3
Thanked 0 Times in 0 Posts
Default

..its not the same fileName..its content repeats the same PONumber that was just processed in the previous attempt resulting in duplicate processing error
Reply With Quote
  #15  
Old 01-22-2010, 20:43
sam1234 sam1234 is offline
Member
 
Join Date: Jul 2009
Posts: 80
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can use HashMap/Hashtable, but this is not recommended in production, since its not shared among clustered IS and that too, if IS went down and after IS restart you can't retrieve back values from HashMap/Hashtable. What Rob suggested is the best, instead using DB, in other way you can do is store the PONumbers in a file, refer this file before processing the request, instead using DB.

Regards,
Sam
Reply With Quote
  #16  
Old 01-26-2010, 01:40
Suren Suren is offline
Member
 
Join Date: Jul 2008
Posts: 91
Thanks: 13
Thanked 11 Times in 8 Posts
Default

Please disregard my previous post.

You can go for a file storage if you are sure that duplicates are always from just the previous file if not then better to take Rob's suggestion to go for a db table.

Last edited by Suren; 01-26-2010 at 01:56.
Reply With Quote
  #17  
Old 01-29-2010, 03:33
devexpert devexpert is offline
Senior Member
 
Join Date: Jun 2008
Posts: 293
Thanks: 9
Thanked 27 Times in 27 Posts
Default

please be advise that if you are saving this information in memory (using any HASH table or datastore) it will be gone on server restart, so you ur vital information will be lost.
Saving in DB looks a good option to me as well..

-nD
Reply With Quote
  #18  
Old 01-29-2010, 09:33
reamon's Avatar
reamon reamon is offline
Premium Member
 
Join Date: Apr 2003
Posts: 4,789
Thanks: 61
Thanked 177 Times in 140 Posts
Default

Quote:
Originally Posted by DevNull43 View Post
If you are using a file port, one of the configuration parameters is the number of invocation threads.

If you set 1 thread, the same file won't be processed twice.
Or are you getting the file again after a period of time?
To clarify for those coming upon this thread in the future...

When properly using a file polling port there is not a risk of a single file being processed multiple times even when "Maximum Number of Invocation Threads" is greater than 1. The file management facilities of the polling port are such that this will not happen.
__________________
-Rob
http://reamon.squarespace.com
Reply With Quote
  #19  
Old 02-08-2010, 04:02
wm_member wm_member is offline
Junior Member
 
Join Date: Feb 2009
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Post

please have a look below suggestions:

1)
create a file in the file system and keep appending the file with new PO number...

on every run match the new Po number with the PO numbers stored in the temp file...
for successful Match Do nothing or throw error.
else keep processing ...

2)
if the duplicate PO is coming in the very next file ...
then use pub.storage service ... but use it carefully in clustered environment else you will see lock issues on the storage ... and you will not be able to release the lock then ....
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In PRT configuration, process completion stracking store Bright Modeler / Designer / Process Engine 0 07-26-2006 20:05
AuditLogManager Runtime Exception Invalid column name bSESSIONIDb desmat Managing webMethods 6 / 7 6 12-03-2005 22:35
Using SCOPE to call services a_j_burgess Flow and Java services 6 08-10-2005 03:37
JMS Adapter 61 starup errors in Webmethods 601 bharu78 Managing webMethods Broker 9 09-09-2004 17:19
Using the %25 SQL wildcard after a variable in execSQL alasko Flow and Java services 1 05-20-2004 14:19


All times are GMT -6. The time now is 00:29.


.
All Content Copyright ©2002-2009, Conneva, Inc. DBA wMUsers.Com

wMUsers is an independent organization and is not sponsored in any manner by Software AG or webMethods, Inc.

Page generated in 0.09843 seconds with 18 queries