Good afternoon -
When using the native Oracle Connector we are seeing "TTC Error" Reference but not the detailed ORA error code.
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/JDBC-error-messages.html
The interesting part is that it only happens on some tables, not others. As an example 1 table only has 62 rows and 9 columns whereas a different one has millions of rows
Example: SELECT * FROM SYSADM.PS_COMBO_RULE_TBL
Any thoughts on how to mitigate that error or how to do a deeper dive on troubleshooting?
Error: TTC Error
Source: action "Import from database", table "Imported table 1"
Hello @adambeltz,
Which Oracle and EasyMorph versions are you using? And which connector type?
Can you please try to run the query that gives you that error, but make it return zero rows. Something like this:
SELECT * FROM SYSADM.PS_COMBO_RULE_TBL WHERE 1=0
Will it give you the same error?
Hi Andrew -
Sorry for the delay. Running the following does not error but returns no results as you mentioned
SELECT * FROM SYSADM.PS_COMBO_RULE_TBL WHERE 1=0
EM: 5.8.0.10
Connector Type: Oracle
Oracle Version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
Hi Adam,
If that query succeeds, then the source of the error is data-related.
Does the table have CLOB, BLOB, or LONG columns? If so, does the query succeed when you import all the columns except those? If it does, please try to pinpoint the exact columns that can't be imported.
Also, I would like to mention that support for your Oracle version ended a long time ago. It's possible that some features of that version are no longer supported by the ODP.NET driver, used internally by EasyMorph.
