otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


SysAdmin and Management Managing and monitoring OTM / G-Log and other administrative activities.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 30th, 2008, 10:34
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Info about transmission status

Hi there,

I would like to know what does a transmission with status fresh and redo means?

Thanks,
Rohan
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old January 30th, 2008, 12:23
Member and Blogger
 
Join Date: Jan 2007
Location: Haalderen, Netherlands
Posts: 117
Blog Entries: 1
Thanks: 7
Thanked 33 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bob_romijn is on a distinguished road
Send a message via Skype™ to bob_romijn
Re: Info about transmission status

Hi,

FRESH: Transmission is being processed or waiting for being processed
ERROR: Transmission failed (for a part or completely)
REDO: You can assign this status to a transmission according rules you set yourself. In Process management you can then create a recurring task to process every transmission in the REDO-status. The transmission will be then moved again to the FRESH status. The recurring task can be looking every 5 minutes (E.g.) for these transmissions.

Hope this helps.
__________________
Best Regards,

Bob Romijn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old January 30th, 2008, 12:37
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 199
Thanks: 0
Thanked 30 Times in 30 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
nick.polites is on a distinguished road
Re: Info about transmission status

Unless this has changed recently if a transmission is in a fresh status and the application is restarted it will also go into a redo status.
__________________
MavenWire Hosting Admin
The Oracle OTM / G-Log GC3 Experts
Offering Incubator and Production OTM instances
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old January 31st, 2008, 02:28
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Re: Info about transmission status

thanks bob
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old January 31st, 2008, 02:28
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Re: Info about transmission status

thank you for the info.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old January 31st, 2008, 09:51
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Re: Info about transmission status

Hi there,

I have a scenario in OTM where the transmission is sitting in a FRESH status and its related transaction has a status of processed. I don't quite understand this, how can this be possible. The transaction was meant to perform some kind of update on a shipment, it has finished with that however the actual transmission is still sitting in FRESH status.

Rohan
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old January 31st, 2008, 17:45
Member and Blogger
 
Join Date: Jan 2007
Location: Haalderen, Netherlands
Posts: 117
Blog Entries: 1
Thanks: 7
Thanked 33 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bob_romijn is on a distinguished road
Send a message via Skype™ to bob_romijn
Re: Info about transmission status

Hi,

This sounds very familiar to me, I saw that behaviour before. Only thing is that I really don;t know hoe this was solved. Most likely our DBA did something here.
At least, it shouldn't be the case.

Oracle should know it in their knowledge base.
__________________
Best Regards,

Bob Romijn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old February 1st, 2008, 00:00
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Re: Info about transmission status

thanks for the info...but i would like to know more about this...what are the possible reasons why this happens...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old February 2nd, 2008, 23:24
Junior Member
 
Join Date: Jan 2008
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Rowan is on a distinguished road
Re: Info about transmission status

I still haven't been able to figure out the exact cause of this behavior in OTM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old February 3rd, 2008, 19:28
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 199
Thanks: 0
Thanked 30 Times in 30 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
nick.polites is on a distinguished road
Re: Info about transmission status

I have seen this issue once before. I think the only way to fix it is via a direct sql update. You probably will need to contact Oracle support on why this occurs but most likely everything was committed in your transactions prior to a restart except the actual transmission.
__________________
MavenWire Hosting Admin
The Oracle OTM / G-Log GC3 Experts
Offering Incubator and Production OTM instances
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with 'Upload an XML/CSV Transmission' sgshah Data Loading 0 February 18th, 2008 23:05
dmidecode - full system info for Linux chrisplough SysAdmin and Management 0 January 24th, 2008 03:47
Transmission Reports in OAQ? krishna.kk Integration and Data Mapping 0 December 10th, 2007 03:54
[SOLVED] 'Staged' status of inbound Transmission in V5.5CU2 Sanju Integration and Data Mapping 2 January 22nd, 2007 04:04
OTM SIG Meetings : Dial-in Info chrisplough News and Events 0 December 12th, 2006 17:32



All times are GMT. The time now is 00:08.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37