#DateForumTypeThreadPost
20316 Oct 2014 @ 09:00 PDTTeradata StudioReplyTeradata Load ErrorsAndrew, We found a bug regarding the handling of parenthesis that was fixed in Studio 15.00 version. Is it possible for you to upgrade to Studio 15.00 and try your Teradata Load. Upgrading Studio w...
20215 Oct 2014 @ 05:25 PDTTeradata StudioReplyTeradata Load ErrorsAndrew, Thanks. We will take a look at this.
20115 Oct 2014 @ 11:19 PDTTeradata StudioReplyTeradata Load ErrorsAndrew, We have tested with our 14.10 version and do not see a problem with what you described. Can you attach a sample of the rows that fail?
20015 Oct 2014 @ 10:13 PDTTeradata StudioReplyTeradata Load ErrorsAndrew, What version of Studio are you running?
19915 Oct 2014 @ 10:00 PDTTeradata StudioReplyTeradata Load ErrorsAndrew, Studio's Teradata Load feature allows for tab delimited columns and parenthesis within the column data. The 'Unexpected number of parameters' error means that the row contains m...
19809 Oct 2014 @ 03:44 PDTTeradata StudioReplyData Source Explorer DB ListTodd, By default, Studio uses the 'V' Views (DBC.DatabasesV) to gather the Data Dictionary information. You can set a preference to use the 'VX' views (thus DBC.DatabasesVX'). G...
19707 Oct 2014 @ 12:59 PDTTeradata StudioReplycan't see tables in data source explorerRonak, To see the list of tables, you need to locate the database or user they are in, and since Teradata Databases or Users can be nested, you may need to locate ancestors first. If you're not...
19630 Sep 2014 @ 01:22 PDTTeradata StudioTopicWorkaround for Problem Occurred during Data Labs Smart LoaderIf you are getting a 'Problem Occurred Error: An internal error occurred during: "Load DataXXX"', resulting in a Null Pointer Exception when running Smart Loader via the Data Lab ...
19530 Sep 2014 @ 08:20 PDTTeradata StudioReplyHow Do You Create A Teradata Database?Please post this question to the Database Forum.
19428 Sep 2014 @ 07:09 PDTTeradata StudioReplyHow Do You Create A Teradata Database?The steps are described in the Studio Express article , http://developer.teradata.com/tools/articles/teradata-studio-express. Let us know if you are still having problems. 
19323 Sep 2014 @ 01:22 PDTTeradata StudioReplyLoading text file to Teradata Table in Teradata StudioSibhi, Switch to the Data Transfer Perspective then locate the table in the Data Sourec Explorer that you want to load into. Right click on the table and choose Data>Load Data... menu option. Th...
19218 Sep 2014 @ 09:18 PDTTeradata StudioReplyAdd New Database in Teradata Studio ExpressJamuna, Studio Express provides the Data Source Explorer, lefthand side, to connect and browse your database objects. You need to create a Connection Profile to the Teradata database you want ...
19109 Sep 2014 @ 03:20 PDTToolsReplyInstalling TD 15.0David, It depends which OS version are you running? Also, if Windows, is it 32-bit or 64-bit? 
19005 Sep 2014 @ 06:23 PDTTeradata StudioReplyError while trying for data movement between Teradata and Hadoop using TDCH installed on Teradata StudioSwati, For command line usage of TDCH, please post issues to the Extensibility Forum (http://forums.teradata.com/forum/extensibility) or comment on the article (http://developer.teradata.com/connec...
18904 Sep 2014 @ 10:45 PDTTeradata StudioReplySQL Editor has No Profiles after creating new profile for MS SQL databaseBob, You need to use the SQL File Editor and not the Teradata SQL Editor with MS SQL Server. The Teradata SQL Editor only supports Teradata and Aster connection profiles. To open with the SQL File ...
18803 Sep 2014 @ 09:11 PDTTeradata StudioReplyError while trying for data movement between Teradata and Hadoop using TDCH installed on Teradata StudioSwati, Please follow the instructions in the Readme on our Teradata Studio download page. As for moving files from Windows machine to Hadoop, you can use PUTTY or WinSCP.
18731 Aug 2014 @ 03:17 PDTTeradata StudioReplyUnable to launch Teradata Studio ExpressAnkit, Just to recap what is the environment, are you running Teradata Studio Express inside a Teradata Express VM or outside, on your desktop? Is there an error message displayed? Is there a .log ...
18617 Aug 2014 @ 09:25 PDTTeradata StudioReplyTeradata Studio 15.0 connecting to Hadoop fails with Oozie connectivity failureRupert, Can you verify that you are running Studio version 15.00.01. It is the latest release available on the download page. Also, if you are running the Hadoop sandbox, you may be hitting the fo...
18515 Aug 2014 @ 09:36 PDTTeradata StudioReplyTeradata Studio 15.0 connecting to Hadoop using JDBC failsPaolo, I’m guessing you are running into the classic Hadoop sandbox problem. You need to edit your client host file to include the IP of the sandbox and sandbox.hortonworks.com. The Windows ...
18412 Aug 2014 @ 02:43 PDTTeradata StudioReplyunable to import flatfileAndre, We think the problem is that you are trying to load a file that was created on Windows and contains the Windows line separator (CR/LF). Studio Load feature uses the Operating System line sep...
18312 Aug 2014 @ 01:11 PDTTeradata StudioReplyunable to import flatfileAndre, Can you display the job details text? It is an option in the Transfer Hsitory view toolbar.
18212 Aug 2014 @ 08:54 PDTTeradata StudioReplyunable to import flatfileAndre, With Teraedata Studio Express 15.00, the data load job status is stored in the Transfer History Viewer. To open the Transfer History View, go to Window>Show View and select the Transfer H...
18107 Aug 2014 @ 01:28 PDTTeradata StudioReplyError while trying for data movement between Teradata and Hadoop using TDCH installed on Teradata StudioAastha, load_from_hcatalog() and load_to_hcatalog() are SQL-H functions. From Teradata Studio, you can open a SQL Editor window and execute SQL commands that call database functions. These com...
18007 Aug 2014 @ 10:43 PDTTeradata StudioReplyError while trying for data movement between Teradata and Hadoop using TDCH installed on Teradata StudioAastha, You are confusing two different products. Teradata Studio does not use SQL-H when transfering data between Teradata and Hadoop. If you want to transfer data between Teradata and Hadoop with...
17905 Aug 2014 @ 11:45 PDTTeradata StudioReplyTeradata Studio 15.0 connecting to Hadoop using JDBC failsIf you are connecting to HDP 2.1 you must use the latest Studio release, 15.00.01. Refer to the download page Readme as this also requires a new version of the TDCH, 1.3.1. Also if you already have...

Pages