Ora Oci 8 not loading to the table

[kollurianu]

Hi all,

input is a file in which it has an update indicators I --insert

U-update
D-delete

so target is table , and i have a transformer in which i have

following constraints

Trim(insandupdtrec.Updt_ind) = 'U'

Trim(insandupdtrec.Updt_ind) = 'I'
Trim(insandupdtrec.Updt_ind) = 'D'

and for the target table transaction handling accordingly choosen

and sql is generated one for type of transaction code

i donot nothing is coming out of the out links , for now i have records
that have update indicator as "I"

no errors
no warnings
just datasource is empty

i tried with target as sequential file instead of table then filtering is done
accordingly.

could some one please explain me where iam missing,

thank you all,

[kcbland]

Did you check the job log for reject messages? Did you add a reject link to collect DB rejects?

If the same exact link with constraint can write to a sequential text file, then the only issue is the database. What do the link statistics show for the job?

[kollurianu]

Thank you very much Ken,

i created a reject file and every row is rejected for the following error

BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =

Code: Select all

BUSINESSATTCOMLOADTBLE..fmtrec: ORA-01843: not a valid month

could some one please help me ,

i checked the date for is fine

the following are the derivations used in the date fields

if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")

2nd one

Oconv(Date() , "D4/MDY")

thank you all

[Bala R]

Is your oracle date format is in MM/DD/YYYY?. Verify what format your oracle DB accepts. Usually it is in YYYY-MM-DD format. HTH.

[kollurianu]

Thank you very much Ken,

i created a reject file and every row is rejected for the following error

BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =

Code: Select all

BUSINESSATTCOMLOADTBLE..fmtrec: ORA-01843: not a valid month

could some one please help me ,

i checked the date for is fine

the following are the derivations used in the date fields

if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")

2nd one

Oconv(Date() , "D4/MDY")

thank you all

[kollurianu]

Hi All,

i could insert in to oracle with the following format,

Oconv(Date() , "D4-YMD"):"00:00:00"

Thank you all

[ray.wurlod]

You're lucky it's after the 9th of the month and after September, so you're automatically getting two-digits in the month and day. You need to force two digits as follows:

Code: Select all

Oconv(Date(), "D-YMD[4,2,2]") : " 00:00:00"