DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
deesh
Participant



Joined: 08 Oct 2007
Posts: 193

Points: 1950

Post Posted: Sat Sep 21, 2019 11:16 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi

We are loading the data from netezza to yellowbricks but getting below error.

ODBC_Connector_15,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3452617: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequence for encoding "UTF8": 0x00()
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3624914: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 730)

source column is not null column and target also not null column, but loading data from netezza to netezza but not loading netezza to yellow bricks while using datastage.

while doing analysis showing blank in unix for the particular column, please help me out how to resolve the issue.

and the default value for the column is space ' '.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Sat Sep 21, 2019 9:33 pm Reply with quote    Back to top    

Okay... you've mentioned nulls and "showing blank" in the same post. Does blank mean a space or does it mean null or? They are not the same thing so need clarification. What exactly are you trying to do... send a null in Netezza as a space in Yellowbrick? Something else? Confused

Also, if Yellowbrick works anything like other databases I've used, the "default" value for a column comes into play when it is not included in an insert so probably not relevant here.

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise
Rate this response:  
Not yet rated
deesh
Participant



Joined: 08 Oct 2007
Posts: 193

Points: 1950

Post Posted: Fri Sep 27, 2019 4:17 pm Reply with quote    Back to top    

Hi,

The defualt value coming from netezza, but unidentified what it is and some times will come blank(null) and some times come withe data like '1/100 ??'.
but i need data cleanse in datastage, i used pad string and convert functions.
But unable to remove that kind of data and yellowbricks not accepting.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Sat Sep 28, 2019 6:27 am Reply with quote    Back to top    

The lack of details here isn't helping get you to a solution. My biggest question right now is what is your target (datatype, precision, etc.)? Knowing that might get us closer to helping getting it "cleansed" and avoiding that "invalid byte sequence" error. If you're feeling really generous, share with us details of your pad string and convert functions.

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours