#DateForumTypeThreadPost
100903 Dec 2015 @ 01:12 PSTToolsReplyTPT Oracle JDBC connectionCould it be that the ODBCINI environment variable is pointing to a valid odbc.ini file, but the contents of the odbc.ini file are actually pointing to non-branded drivers?  
100803 Dec 2015 @ 01:04 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Thank you for all of the information.   I ran the same job on my system with TPT 15.10 and find that both rows end up in the error table. And this is correct in that both rows need to be tre...
100703 Dec 2015 @ 08:51 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesTPT only supports uncompressing files on input. We do not support compressing on output.  
100602 Dec 2015 @ 06:01 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes And at first you said it worked in 14.00.00.08, and then you say it works in 14.10. Does it work in both 14.00 and 14.10, but not in 15.10?
100502 Dec 2015 @ 06:00 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Can you provide me with the table definition and script you are using?
100402 Dec 2015 @ 02:16 PSTToolsReplyTPT Oracle JDBC connectionTPT does not have any integration with JDBC. ODBC is the only solution for connecting to non-Teradata databases.
100302 Dec 2015 @ 10:56 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes On which platform are you running? Have you looked at the error table to see which column is being flagged as the error column? Obviously, it does not make sense (to me) because the data is prett...
100201 Dec 2015 @ 07:42 PSTToolsReplyTPT05015: Error: Cannot open the file '$SCHEMA_GEN_D_TBL001.txt' due to error 13. Permission deniedYes, TPT currently attempts to create the temp files in the current working directory.   We are currently working on a fix that will create the temp files in the same directory as the log fi...
100130 Nov 2015 @ 02:55 PSTToolsReplyTPT05015: Error: Cannot open the file '$SCHEMA_GEN_D_TBL001.txt' due to error 13. Permission deniedWhat are the write permissions on that directory? The failure might be on the creation of the file, not the open to read it.  
100030 Nov 2015 @ 09:26 PSTToolsReplyTPT API Error while using with INFAWe would need more information for this error: [ERROR] Plug-in failed to Initiate Teradata database connection.   Since TPTAPI uses CLIv2, if there was an issue in the connection there shou...
99930 Nov 2015 @ 09:24 PSTToolsReplyFast load IssueI could be wrong but I do not think the RECORD command will work with header rows. FastLoad expects every row to have the same format, so the header rows would have to be in the same format as the...
99816 Nov 2015 @ 04:09 PSTToolsReplyTPT Template operators with LDAP authenticationSet the environment variable COPANOMLOG to a path and file name. CLI will put trace information in that file. Example: COPANOMLOG=/tmp/my_cli_log_file.txt  
99713 Nov 2015 @ 03:16 PSTToolsReplyBTEQ TPTI happen to agree with Todd that sometimes a simple INS-SEL is all that is needed to copy data from one or more source tables to a target table.   And a tool like BTEQ is probably used more ...
99613 Nov 2015 @ 09:34 PSTToolsReplyTPT Template operators with LDAP authenticationPlease generate a COPANOMLOG and send to me. steven.feinholz@teradata.com Thanks!
99512 Nov 2015 @ 12:10 PSTToolsReplyBTEQ TPTOk, let me clarify some of the information provided, some of which is not accurate.   One of the things you need to consider is time. How long (actually, how fast) do you want this to take?...
99411 Nov 2015 @ 03:02 PSTToolsReplyError while loading data from specific row number using MultiloadMultiLoad needs the rows/records to be in the correct format in order to skip them because it parses every row before deciding whether the row is actually thrown away or not.   On the other ...
99311 Nov 2015 @ 02:54 PSTToolsReplyTPT Template operators with LDAP authenticationOk, I have looked at this some more and it looks like either LDAP may not have been set up correctly, or you are not passing the logon credentials correctly.   But still looking into it...
99210 Nov 2015 @ 10:22 PSTToolsReplyTPT Template operators with LDAP authenticationAccording to the Teradata Messages manual:   CLI0235 Connection has not completed   Explanation: A query specified a connection number for a session whose Connection function has not ...
99110 Nov 2015 @ 09:06 PSTToolsReplyTPT Template operators with LDAP authenticationWhat information are you trying to get access to? When you use TraceLevel, it will add a lot of trace information to the regular .out log file.
99005 Nov 2015 @ 01:56 PSTToolsReplyTPT Template operators with LDAP authenticationFor some reason, the TdpId or UserName is not being passed down to TeraGSS for some reason. I am looking into it. One thing just FYI; remove the -C from the command line. That forces round-robin...
98905 Nov 2015 @ 01:32 PSTToolsReplyTPT binary mode exportThe different record formats are documented in the TPT Reference Manual. I guess my first question is, why did you choose "binary" if you were unaware of the record format? I would thin...
98805 Nov 2015 @ 11:03 PSTToolsReplybteq export and import for _ET dataparcelThe tool is called "twbertbl" (the "twb" prefix was to be consistent with "twbstat", "twbkill", "twbrmcp", etc.). It is documented in the TPT Refe...
98728 Oct 2015 @ 01:44 PDTToolsReplyTPT 15.00 For Linux and Informatica ETLNot sure if this is relevant, but in your export of LD_LIBRARY_PATH, I see a space character before "$LD_LIBRARY_PATH". Was that intended? After you have executed the "exports"...
98628 Oct 2015 @ 12:12 PDTToolsReplyTPT - Timestamp format error 6760Please explain what you mean by: "This approach seems to have worked ok with dates previously."   By "previously", do you mean TPT used to work and now does not? BTW, w...
98526 Oct 2015 @ 09:39 PDTToolsReplyTPT sessions are left behind?When the TPTAPI operators issue the "disconnect" (in conn->Terminate), it is an asynchronous process. By that I mean that we issue the disconnect requests but do not wait to find out i...

Pages