Profile

Abhishek Sawant

Boku Network Services In Private Limited

Contact Details

Boku Network Services In Private Limited

My Content

1 to 13 of 13 total

What is the best way to read mysql's UTF-8 blob values from database and insert into another database?

Posted By Abhishek Sawant 02-28-2024 08:55
Found In Egroup: Pentaho \ view thread
Hello, I'm trying to setup and ETL(transformation) where it reads data from source mysql database and write it to another mysql database, but one of the field is blob with UTF-8 values.   I'm using 'Table input' step to read data from source mysql database and using 'Insert/update' step to write it ...

What is the best way to read mysql's UTF-8 blob values from database and insert into another database?

Posted By Abhishek Sawant 02-28-2024 04:12
Found In Library: Pentaho

What is the best way to read mysql's UTF-8 blob values from database and insert into another database?

Posted By Abhishek Sawant 02-28-2024 03:40
Found In Library: Pentaho

What is the best way to read mysql's blob with UTF-8 values from database and insert into another database?

Posted By Abhishek Sawant 02-28-2024 03:39
Found In Community: Pentaho \ view thread
Hello, I'm trying to setup and ETL(transformation)  where it reads data from source mysql database and write it to another mysql database, but one of the field is blob with UTF-8 values.   I'm using 'Table input' step to read data from source mysql database and using 'Insert/update' step to write it ...

S3 CSV Input fails when filename has special char (+) on PDI v9.4

Posted By Abhishek Sawant 02-05-2024 10:21
Found In Library: Pentaho

S3 CSV Input fails when filename has special char (+) on PDI v9.4

Posted By Abhishek Sawant 02-05-2024 10:20
Found In Community: Pentaho \ view thread
We are in process of migrating our existing ETLs from v7.0 to v9.4 I'm getting below error on PDI v9.4 when we read S3 file in S3 CSV Input step having "+" (plus) sign which was working on PDI v7.0: 2024/02/05 12:10:39 - S3 CSV Input GB.0 - com.amazonaws.services.s3.model.AmazonS3Exception: The request ...

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 12-05-2023 10:04
Found In Library: Pentaho

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 12-05-2023 10:04
Found In Community: Pentaho \ view thread
Attaching Screenshot and snippet of logs (updated)

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 12-05-2023 08:59
Found In Library: Pentaho

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 12-05-2023 08:39
Found In Community: Pentaho \ view thread
Thank you, I've tried again with just table input ("select 1;") and UDJC and it worked. Then I tried adding other steps and identified that, the Variables from Job (wrapper job) is not passed in transformation. UDJC error was misleading, attached (word doc) is the actual issue - where the parameter is ...

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 11-23-2023 02:41
Found In Community: Pentaho \ view thread
Attaching full KTR, log output and system info.

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 11-23-2023 02:41
Found In Library: Pentaho

KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Abhishek Sawant 11-21-2023 05:50
Found In Community: Pentaho \ view thread
Hello, We are trying to upgrade PDI CE 7.0 to  PDI CE 9.3, most of the steps (wrapper job/ktr) are working, but the step where er have used User defined Java class is not running (giving error): Logs: 2023/11/09 08:50:31 - Mask MSISDN.0 - distribution activated 2023/11/09 08:50:31 - Mask MSISDN.0 - Starting ...