03-03-2017 11:30 AM - edited 03-03-2017 11:34 AM
I went into the "manage dabase drivers" opion in RapidMiner Studio and I created an entry for Teradata. I then went into "manage database connections" and I created an entry to connect to a Teradata database. I tested by pressing the "Test" button and it told me "Connection OK". I then went into the repository tab and I tried to expand my teradata connection, but all I get is a "Pending..." under the connection tree item. Any ideas on how to troubleshoot this? My connection string looks like this: jdbc:teradata://MY_SERVER/LOGMECH=LDAP. See attachment for what I mean by "Pending".
Solved! Go to Solution.
03-03-2017 11:52 AM
It might trying to fetch the metadata of all the tables. It could take a bit.
03-03-2017 12:36 PM
I just turned off "Evaluate SQL meta data" in "settings / preferences / user interface / miscellaneous": see attachment. Still have the same problem.
03-03-2017 12:38 PM
OK, now I get a message in the log. It states:
Mar 3, 2017 11:37:08 AM SEVERE: could not create repository action: class com.rapidminer.repository.gui.actions.StoreProcessAction
I'm not sure if this is in response to my attempt to connect to Teradata.
03-05-2017 08:05 PM
Were you trying to write something the Teradata database?
03-07-2017 12:11 PM
OK, after waiting a long time, the oracle connection worked, but it gave me several messages such as:
Mar 7, 2017 10:57:01 AM WARNING: Failed to fetch column meta data for table <SCHEMA.TABLE_NAME goes here>: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
Someone earlier in this thread suggested that I turn off meta data fetching. Can someone tell me where exactly that is done? I attached an image where I think it should be done.