tOracleInput Exception java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

[paresh1]

Hi ,

For the above flow getting exception at tOracleInput with Use fetch size enabled:

 java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

When I disable Use fetch size it is working fine.

Please help what can I do if I want to use fetch size functionality.

Thanks

[manodwhb]

@Paresh Pawar​ , Have you checked the Use an existing connection in basic setting of tDBInput? if yes you need to connect the tDBConnection to tDBInput using on subjob ok. and One mor thing that there is a warning sign in to most right side of the component in tDBInput what was that? I feel you have not configured tDBInput properly.

[paresh1]

@Manohar B​  Thanks for your quick response.

Have you checked the Use an existing connection in basic setting of tDBInput? ----Yes I have selected Component list using existing connection.

I tried with subjob ok still same error.

The warning sign is for date pattern values. Even if I specify the date pattern values it is still throwing same error.