Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Getting "Table or View does not exist" with Oracle Blob

I am using the version 5.3.1 of Enterprise Data Integration. My job simply moves data from one Oracle 11g database to another Oracle 11g database based upon a date comparison. Many of the rows fail with "Table or view does not exist", but not all rows are failing. In Oracle, the field is defined as BLOB. In the Talend schema it is defined as Object with a length of 32767. In the Java code I see this declaration which appears incorrect.
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append(super.toString());
sb.append("");
return sb.toString();
}
Is it possible that this is the cause of the issue? Obviously the table exists if it reads all data and writes some data. The amount of error messages is the same as the amount of records not written.
Thank you
0683p000009MDVw.png 0683p000009MDRb.png 0683p000009MDW1.png
Labels (3)
11 Replies
Anonymous
Not applicable
Author

Sorry, my PC java version is 7, but the Enterprise server is 6. Both provide the same results.
Anonymous
Not applicable
Author

I have confirmed the same behavior with Open Studio 5.4.0