| Nazeedah 2006-11-30, 7:21 pm |
| Hello,
i have project in Biztalk 2006 where i have to send data to a table in
Oracle from SQL 2005.
The problem is that it sends data to oracle only when i restart my PC else
it doesn't. Although i specified it to retry after 5 mins in the send port
and to polling interval of 10 mins in the receive Port that is SQL..
Can anyone help me out so that it send data every 10 mins ..
whenever i restart my pc . it send the data to oracle only once and when i
check my event log i found many errors and also the one below...
Event Type: Error
Event Source: Microsoft BizTalk Adapters for Enterprise Applications
Event Category: None
Event ID: 0
Date: 11/30/2006
Time: 9:37:03 AM
User: N/A
Computer: BIZTALK
Description:
Exception occurred:
Error Code: 604 (0x25c)
HY000 : [Oracle][ODBC][Ora]ORA-00604: error occurred at recursive
SQL level 1
ORA-00018: maximum number of sessions exceeded
Please advice...
Thanks a lot
Nazeedah
|