Production problem with Oracle Insert

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Production problem with Oracle Insert - Please assist

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Production problem with Oracle Insert - Please assist

Page: [1]

Message

<< Older Topic Newer Topic >>

Production problem with Oracle Insert - Please assist - 24 June 2008

niros

Posts: 4
Score: 0
Joined: 3 June 2007
Status: offline

Hi,
I'm using the BizTalk Adapter for Database transport to update my Oracle databse.
The generated schema is using the insert statement to update few tables (in one schema).

We did lots of testing for it and we didn't faced any problem from some reason in production we get this oracle error for few of the transactions:
"ORA-01830: date format picture ends before converting entire input string".
Of course we tried to validate all dates fields but all of them look just fine.
After long research we came to the thing that once we restart the BizTalk Host, resume these transactions (message type) all is working just fine, unfortunately we get this error again after a day.

This is a production issue, does someone have any idea?

10X in advance.