Code: Select all
CSRFQ..X_RFQ.Out_RFQ_INSERT: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO STG_RFQ(SaleProbability, DateProposedEffective, SalesDeadLineDate, EligibleEmployees, CloseType, MemberCount, UserID, ClientID, BrokerID, CloseReason, RFQID, IsLifeQuote, IsDentalQuote, status_ind, RegionKey) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Datetime field overflow
there is another data field in the same table which i am passing to target of same where metadata of source is again timestamp 38 and target timestamp 23,3 which is passing without any problems
tthinking that there is some problem in thsi source I tried writng two routean to check validdate
and trimming the date
to trim date the routene used is
A = Iconv(Arg1[1,10], "DMDY")
Ans = OCONV(A, "DMDY")
this works fine if i test at routene level but when i try passing the values ds throws error dattype mismatch
and another routene i wrote is
Code: Select all
if len(Enter.DATE) < 6
Then
Ans = -1
End
Else
*DOB = Iconv(Enter.DATE, "D2")
DOB = Iconv(Enter.DATE, "DYMD")
ConvStatus = Status()
Ans = Enter.DATE
*Var1= Oconv(DOB, "D/DYMD")
ConvStatus = Status()
BEGIN CASE
CASE Enter.DATE = ""
Ans = -2
Case ConvStatus = 0
* ...conversion succeeded
Case ConvStatus = 1
Ans = -3
* ...conversion failed - Entered Date not parsable as a date
Case ConvStatus = 2
Ans = -4
* ...conversion failed - conversion "D2" invalid (unlikely!)
Case ConvStatus = 3
Ans = -5
CASE @True
Ans = Enter.DATE
END CASE
End
unable to insert values -1,
or -2
-3
-4
etc
and with out even passing any values
could some help me in this regard , i tried different options but i am not able to pass these values, funny part is about 45 thousands are passing then giving datatype overflow if i try passing the field with out any conversion
i am really struck on this issue