ORA-00913 Error When inserting record with decimal field

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

ORA-00913 Error When inserting record with decimal field

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 >> ORA-00913 Error When inserting record with decimal field

Page: [1]

Message

<< Older Topic Newer Topic >>

ORA-00913 Error When inserting record with decimal field - 17 January 2007

well0549

Posts: 15
Score: 0
Joined: 4 December 2006
Status: offline

Ok I have the following insert statement constructed. The field Vasteprijs is of Type Decimal and the adapter substitutes a , for a decimal point. But this is wrong cause then I get the error below.
Is there anyone who knows how to solve this ?

Event Type: Information
Event Source: BizTalk Utilities Adapter for Databases Transmitter
Event Category: None
Event ID: 0
Date:  17-1-2007
Time:  15:39:53
User:  N/A
Computer: NLIIS214
Description:
BTSUtils.Adapters.Databases.EnterpriseInstrumentation.Schema.TraceEvents.CustomEvents.Databases.Transmit.Command
{
String Message = "ns0:Insert"
String CommandText = "INSERT INTO CDL_CONTRACT_PRIJZEN
(
TARIEF_COMPONENT_CODE,
BEGIN_GELDIGHEID,
EIND_GELDIGHEID,
ENECO_CONTRACT_NUMMER,
VASTE_PRIJS,
EXT_PARTIJ,
EXT_REFERENTIE_AVR,
PINUP,
EAN_CODE_ASN
)
VALUES
(
'DIENSTV',
'01-Jan-2007',
'01-Feb-2007',
15409,
14562,288333333,
'BOB-CBH',
'000021898',
'IN',
'871692150000025068'
)"
Int32 CommandTimeout = 0
String CommandType = "Text"
Int32 Counter = 1
Parameter[] Parameters = {
}
Int32 ProcessID = 11440
String ProcessName = "D:\apps\BTS2K4\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = <null>
WindowsSecurityInfo WindowsSecurity = <null>
ManagedSecurityInfo ManagedSecurity = <null>
String StackTrace = ""
String EventSourceInstance = "91bed0ba-d873-438a-832e-eed50fe4acc2"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 521
String EventSchemaVersion = "2.0.4.0"
DateTime TimeStamp = 17-1-2007 15:39:53
String AppDomainName = "DefaultDomain"
String MachineName = "NLIIS214"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 4
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

And when the adapter tries to insert this record I get
Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Transmitter
Event Category: None
Event ID: 0
Date:  17-1-2007
Time:  15:39:53
User:  N/A
Computer: NLIIS214
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Database Transport.
Oracle.DataAccess.Client.OracleException
ORA-00913: too many values"
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 11440
String ProcessName = "D:\apps\BTS2K4\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "energie\s-biztalkservice"
     String ProcessAccountName = "BUILTIN\Administrators"
}
ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Updategram.Client.Execute(Group group)
at BTSUtils.Adapters.Databases.Transmit.Batch.SendMessages(IBaseMessage[] messages)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "91bed0ba-d873-438a-832e-eed50fe4acc2"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 522
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 17-1-2007 15:39:53
String AppDomainName = "DefaultDomain"
String MachineName = "NLIIS214"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Post #: 1

RE: ORA-00913 Error When inserting record with decimal ... - 18 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

What value are you passig in during mapping?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to well0549)

Post #: 2

RE: ORA-00913 Error When inserting record with decimal ... - 18 January 2007

well0549

Posts: 15
Score: 0
Joined: 4 December 2006
Status: offline

well if I safe the XML from the Send pipeline i can see :

<ns0:ContractPrijzenRequest xmlns:ns0="http://Eneco.Source.Generiek.MVS.ContractPrijzen">
<ns0:Operation1>
   <ns0:CDL_CONTRACT_PRIJZEN>
     <ns0:Insert>
       <ns0:Values>
         <ns0:TARIEF_COMPONENT_CODE>DIENSTV</ns0:TARIEF_COMPONENT_CODE>
         <ns0:BEGIN_GELDIGHEID>2007-01-01T00:00:00</ns0:BEGIN_GELDIGHEID>
         <ns0:EIND_GELDIGHEID>2007-02-01</ns0:EIND_GELDIGHEID>
         <ns0:ENECO_CONTRACT_NUMMER>15405</ns0:ENECO_CONTRACT_NUMMER>
         <ns0:VASTE_PRIJS>1663.731666667</ns0:VASTE_PRIJS>
         <ns0:EXT_PARTIJ>BOB-CBH</ns0:EXT_PARTIJ>
         <ns0:EXT_REFERENTIE_AVR>000021848</ns0:EXT_REFERENTIE_AVR>
         <ns0:PINUP>IN</ns0:PINUP>
         <ns0:EAN_CODE_ASN>871692150000024375</ns0:EAN_CODE_ASN>
       </ns0:Values>
     </ns0:Insert>
   </ns0:CDL_CONTRACT_PRIJZEN>
</ns0:Operation1>
</ns0:ContractPrijzenRequest>

So the decimal point is there. And the Adapter translates it to a comma, Resulting in an invalid Insert statement

(in reply to Pieter)

Post #: 3

RE: ORA-00913 Error When inserting record with decimal ... - 18 January 2007

well0549

Posts: 15
Score: 0
Joined: 4 December 2006
Status: offline

Ok, additional info, I did a little test and replaces the . with a comma in my input message. Then I got the following error message. You can see it cannot translate the value correct since it is not a valid decimal anymore......

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Transmitter
Event Category: None
Event ID: 0
Date:  18-1-2007
Time:  10:15:15
User:  N/A
Computer: NLIIS214
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Database Transport.
BTSUtils.Adapters.Databases.Updategram.Exceptions.TranslatorColumnValueException
An Exception occurred attempting to translate a column value.
Column: VASTE_PRIJS
Type: decimal
Value: 2061,583333333
System.FormatException: Input string was not in a correct format.
at System.Number.ParseDecimal(String s, NumberStyles style, NumberFormatInfo info)
at System.Decimal.Parse(String s, NumberStyles style, IFormatProvider provider)
at System.Xml.XmlConvert.ToDecimal(String s)
at BTSUtils.Adapters.Databases.Translator.Core.Default.Value(String value, String xsdType, String provider)
at BTSUtils.Adapters.Databases.Translator.Oracle.Client.Value(String value, String xsdType, String provider)
at BTSUtils.Adapters.Databases.Updategram.Insert.Execute(String dbObject, XmlElement element, XmlSchemaElement request, IDbTransaction transaction, Int32 commandTimeout, Boolean noRowsException, Int32 counter)"
Exception InnerException = {
    String HelpLink = <null>
    String Message = "Input string was not in a correct format."
    String Source = "mscorlib"
    String StackTrace = "   at System.Number.ParseDecimal(String s, NumberStyles style, NumberFormatInfo info)
at System.Decimal.Parse(String s, NumberStyles style, IFormatProvider provider)
at System.Xml.XmlConvert.ToDecimal(String s)
at BTSUtils.Adapters.Databases.Translator.Core.Default.Value(String value, String xsdType, String provider)
at BTSUtils.Adapters.Databases.Translator.Oracle.Client.Value(String value, String xsdType, String provider)
at BTSUtils.Adapters.Databases.Updategram.Insert.Execute(String dbObject, XmlElement element, XmlSchemaElement request, IDbTransaction transaction, Int32 commandTimeout, Boolean noRowsException, Int32 counter)"
    String TargetSite = "System.Reflection.RuntimeMethodInfo.ParseDecimal"
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 14436
String ProcessName = "D:\apps\BTS2K4\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
    String ActivityID = ""
    String ApplicationID = ""
    String TransactionID = ""
    String DirectCaller = ""
    String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
    String CurrentAccountName = "energie\s-biztalkservice"
    String ProcessAccountName = "BUILTIN\Administrators"
}
ManagedSecurityInfo ManagedSecurity = {
    String IdentityName = ""
    String AuthenticationType = ""
    Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Updategram.Client.Execute(Group group)
at BTSUtils.Adapters.Databases.Transmit.Batch.SendMessages(IBaseMessage[] messages)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "db8fb60e-5e20-4218-8331-ccb41ed7dfb8"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 156
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 18-1-2007 10:15:15
String AppDomainName = "DefaultDomain"
String MachineName = "NLIIS214"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

< Message edited by well0549 -- 18 January 2007 >

(in reply to well0549)

Post #: 4