topic migration from mysql to couchbase using talend in Talend Studio

migration from mysql to couchbase using talend

Anonymous — Wed, 08 Nov 2017 09:38:01 GMT

hi,

i am migrating data from mysql to couchbase database using talend open studio. following are the details :

mysql version : 5.6.37

couchbase server : 4.6.3

talend version : 6.4.1

couchbase-client (jar) : 1.4.13

following is the error log:

Starting job test1 at 08:44 08/11/2017.

[statistics] connecting to socket on port 3436
[statistics] connected
Exception in component tCouchbaseOutput_1_In (test1)
java.lang.NullPointerException
at project1.test1_0_1.test1.tMysqlInput_1Process(test1.java:1309)
at project1.test1_0_1.test1.runJobInTOS(test1.java:2602)
at project1.test1_0_1.test1.main(test1.java:2451)
[statistics] disconnected
Job test1 ended at 08:44 08/11/2017. [exit code=1]

i have verified the fields and their null-able properties and seems they are fine.

please suggest

Re: migration from mysql to couchbase using talend

Anonymous — Thu, 09 Nov 2017 07:24:43 GMT

Hello,

Are you using any t<DB>Connection component in your work flow? Your job design screenshot will be helpful for us to address your issue quickly.

Best regards

Sabrina

Re: migration from mysql to couchbase using talend

Anonymous — Mon, 11 Dec 2017 09:57:53 GMT

I am still getting this error

Re: migration from mysql to couchbase using talend

Anonymous — Thu, 14 Dec 2017 03:21:06 GMT

Hello

Please post your job design screenshots on forum which will be helpful for us to address your issue.

Best regards

Sabrina

Re: migration from mysql to couchbase using talend

Anonymous — Thu, 14 Dec 2017 13:56:13 GMT

For MySql my config is:

localhost:3306

username: root

password:

For couchbase my config is:

base url: 127.0.0.1

portal username: Administrator

portal password: administrator

bucket username: alfy

bucket password: thisistheadmin

I have attached the screenshots

couchbase.PNG
job screen.PNG
mysqlscreen.PNG