IBM Datastage ISsues notes

[omsite45]

Always Review all type which has type DATE .S
image.png

ARCHIVE_DATE should be Timestamp in transformer ...

from LEFT and RIGHT side

image.png

Need to use Timestamp in Transformer+ VAR2DATE function in Connector:

Job 863:

Ora-24920 Error >> Column size too large for thew client :

image.png

Solution:

we get the error when data inside field is > 4000

check which field has data >4k.

use max(length(field)) in sql to find it

After running the query to find the field which has length >4000 we get this

image.png

A picture containing text, screenshot, font, line

Description automatically generated

Then do this >>

SUbSTR(T.NARRATIVE_TEXT__V,1,3800) as NARRATIVE_TEXT__V

This is using only substring of the text where the length is between 1 to 3800 this will ensure the length is NOT > 4k

ISSUE>> DW861 was NOT loading the data

Issue>>check the MBIDW_MNG.MNG_SUBJECTS

Table .

If it contains duplicate subject code then NO data loading in DW table will happen

select * from

MBIDW_MNG.MNG_SUBJECTS

where SUBJECT_CODE='861'

Solution>> delete all records belong to 861 and then insert only one time >>NO duplicates

Similarly check other tables from MNG insert and do the same solutions.

ISSUE>> Invalid Month .

You made timestamp on SRC and STG side But still this issue

Solutions >> Use Var2Date function

VAR2DATE(t.NEW_INFO_DATE__V , 'V') as NEW_INFO_DATE__V,