topic Re: SQLite_Implicit_context_Problem in Talend Studio

SQLite_Implicit_context_Problem

olni — Sat, 16 Nov 2024 01:01:25 GMT

Hi,

i have a strange behavior of TOS-7.3.1.

I want to use a sqlite database to implicit load my context variables - i made for testing:

SalesforceURL -> for the Salesforce endpoint eg. sandbox/production

SalesforceUser and

SalesforcePassToken

I created a sqlite3 database with the common key/value pair and in metadata i created a connection (path2file) to the db

In Extra of the job Component i can connect:

everything seems fine.

I made a SFInput test job to see if it works. Inside the Component i use my context variables which i want to filled by the database values.

But when i run the job i get the error:

I read that the strange "out of memory error" is thrown when the db is not found - but i have a successful connection.

Has anyone an idea what i've done wrong?

Thx a lot

Olli

Re: SQLite_Implicit_context_Problem

Anonymous — Wed, 02 Dec 2020 06:12:49 GMT

Hello,

We are supposing you have already checked online documentation about: TalendHelpCenter: Using the Implicit Context Load feature

Did you configure the Implicit Context Load feature in Project Settings or in the Job view for your current Job?

Is it working when you are using a relational database management system (RDBMS)?

Please try to

Best regards

Sabrina

Re: SQLite_Implicit_context_Problem

olni — Wed, 02 Dec 2020 11:22:01 GMT

1) Hi xdshi, yes i read that documentation, but this article describes a mysql connection over the net which i don't want because of the hassle to install a complete mysql infrastructure.

..i tried both - the same error happens.

I tried in Project like this:

..and in the job settings as well:

The Context_vars inside the job looks like this:

I did'nt test a "real" DB via tcp - the idea is to drop the db as a file on the target maschine with all the tables/context i need so that i only have to select the correct table and every variable is then implicit filled by the values of the sqlite db.

Is that possible?

Thanx for your help.

Olli

Re: SQLite_Implicit_context_Problem

Anonymous — Fri, 04 Dec 2020 04:21:27 GMT

Hello,

Are you able to extract data from 'SANDBOX' table in sqlite database? Does this table contain only two columns: key and value, both of type VARCHAR?

Best regards

Sabrina

Re: SQLite_Implicit_context_Problem

olni — Fri, 04 Dec 2020 13:41:14 GMT

..hi, yes i'am able to get the data and yes the datatype is VARCHAR.

Datatype:What else could be wrong?

Regards,

Olli

Re: SQLite_Implicit_context_Problem

Anonymous — Fri, 04 Dec 2020 14:09:23 GMT

Hello,

Please test retrieving the schema from the SQLite database by right-clicking the SQLite connection in Metadata, and selecting Retrieve Schema to open the schema window to see if this SQLite database is working well in talend.

Or you can drag and drop the SQLite connection from Metadata onto the designer workspace of your Job. When the Components window opens, select the tSQLiteInput and then add a tLogRow component to the Job. Please link the tSQLiteInput to the tLogRow to display data in the console.

Best regards

Sabrina

Re: SQLite_Implicit_context_Problem

olni — Fri, 04 Dec 2020 14:24:14 GMT

..this is the output:

Regards

Olli

Re: SQLite_Implicit_context_Problem

Anonymous — Mon, 07 Dec 2020 05:39:26 GMT

Hello,

This issue is probable from DB side.

Would you mind keeping your connection parameters(SalesforceURL, SalesforceUser and SalesforcePassToken ) in a file and trying to set implicite tContextload from file instead of Database to see if it works?

Best regards

Sabrina

Re: SQLite_Implicit_context_Problem

olni — Mon, 07 Dec 2020 07:53:14 GMT

..i already did that and it works when using a file instead of a sqlite-db. Best Regards Olli Am 7. Dezember 2020 06:39:32 MEZ schrieb Talend :