When using the Pentaho PostgreSQL Bulk Loader step, you might come across following error message in the log:INFO 26-08 13:04:07,005 - PostgreSQL Bulk Loader - ERROR {0} ERROR: invalid byte sequence for encoding "UTF8": 0xf6 0x73 0x63 0x68INFO 26-08 13:04:07,005 - PostgreSQL Bulk Loader - ERROR {0} CONTEXT: COPY subscriber, line 2Now this is not a problem with Pentaho Kettle, but quite likely with the default encoding used in your Unix/Linux environment. To check which encoding is currently the default one, execute the following:$...
Tuesday, 27 August 2013
Sunday, 25 August 2013
Part one provided an introduction to Pentaho Kettle routing. This follow-up article will take a look at an additional example, which will retrieve an input value for the condition from a database. This input value could be in example the result of a query which checks in a database logging table if a certain job has been executed successfully: The usage of the Evaluate rows number in a table job entry is a bit of a hack here: Our query will always...
Saturday, 10 August 2013
Going Agile: Sqitch Database Change ManagementYou have your database scripts under a dedicated version control and change management system, right? If not, I recommend doing this now.While there have been handful of open source projects around which focus on DB script versioning and change management control, none has really gained a big momentum and a lot of them are dormant. But there is a new player on the ground! A light at the end of the db...
Subscribe to:
Posts (Atom)
