#DateForumTypeThreadPost
98423 Oct 2015 @ 09:24 PDTToolsReplyLoad fileMike,   What version of the DataConnector are you using (the FastLoad output will show it if you "show versions" in the script).   This issue has been fixed in:   Dat...
98321 Oct 2015 @ 11:48 PDTToolsReplyLoad fileI checked with the FastLoad developer and he claims that FastLoad can load a file that exceeds 2GB on 32-bit Windows platforms.  
98220 Oct 2015 @ 04:16 PDTToolsReplyFastLoad UTF8 charset issue - for special charactersBob has an access module that is used (by PS folks I believe) in the field. We do not (to the best of my knowledge) actually ship it to customers. It is not an official product.   Tak develo...
98120 Oct 2015 @ 03:47 PDTToolsReplyLoad fileYeah, we noticed that documentation error, but after the 15.0 docs went out the door. The doc is fixed in the 15.10 Reference Manual and says:   'Y[es]' = indicator mode data. This ...
98012 Oct 2015 @ 09:53 PDTToolsReplyOMD API errorFred is correct. I just want to emphasize that the message is a WARNING and not an error. (If it was an error, the job would have terminated.)    
97901 Oct 2015 @ 10:09 PDTToolsReplyOracle Decimal to Teradata integer in TPT scriptThe documentation states that TPT is only certified with the ODBC drivers from DataDirect. We bundle the drivers with TPT starting in 15.0 (although the user must obtain license files from Teradat...
97830 Sep 2015 @ 10:55 PDTToolsReplyTPT - MULTIPLE OUTPUT FILES DINAMICALLY ?"Derived" file names is not currently supported in TPT. The file writer operator has no knowledge of where the data came from. It just receives rows of data from the operator that is pu...
97729 Sep 2015 @ 11:47 PDTToolsReplyTPT Template operators with LDAP authenticationThat patch has been out on the patch server for quite a while now. Always download the latest, though.
97629 Sep 2015 @ 05:30 PDTToolsReplyTPT Load Operator Error: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size You need to contact our Product Management team. The contact person right now is Jefferson Uy.
97529 Sep 2015 @ 04:30 PDTToolsReplyTPT Template operators with LDAP authenticationIt was fixed in 15.00.00.01.  
97428 Sep 2015 @ 05:15 PDTToolsReplyTPT Load Operator Error: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size Thanks for the feedback. We will improve the docs.
97328 Sep 2015 @ 02:44 PDTToolsReplyOracle Decimal to Teradata integer in TPT scriptThis is a known issue when moving data from non-Teradata databases to Teradata. Especially Oracle. In general, the ODBC operator does not perform data conversions, or data type conversions. The ...
97228 Sep 2015 @ 09:46 PDTToolsReplyTPT Load Operator Error: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size I am not sure I should bring this up and pursue it, since you seem to have "fixed" the problem. But a CLI302 error in the Load operator cannot be caused by the ODBC operator, or the versi...
97125 Sep 2015 @ 09:10 PDTToolsReplyCLI Error 527: CLI2: ICULOADLIBERR(527): Error loadi ng ICU librariesThis seems to be an install issue. Try re-installing ICU (if you are given an option to just install that component; I am not familiar with the entire install process).  
97024 Sep 2015 @ 12:22 PDTToolsReplyTPT - Casting VARCHAR to TIMESTAMP issueI would have to see more of the script to tell, but there is probably another single quote that needs to be escaped somewhere.
96918 Sep 2015 @ 06:21 PDTToolsReplyunloaded Date value issue by tpt scriptCan you please run the tbuild command with the -P command line option? In the current working directory you should find some trace files and the expanded script that is generated under the covers....
96817 Sep 2015 @ 01:09 PDTToolsReplyunloaded Date value issue by tpt scriptI will need more information that this. I will need the script, version of TPT, exact error message, etc.  
96703 Sep 2015 @ 04:01 PDTToolsReplyTPT Script - Not all records loaded from a file with SkipRowsEveryFile optionWe have fixed the bug. The fix will be available in the next set of 14.10, 15.0 and 15.10 efixes. Dates for those releases have not yet been announced.  
96601 Sep 2015 @ 05:41 PDTToolsReplyErrortables creation for Update operator in TPTThis was asked already in another thread, and answered:   The DELETE task in the Update operator is an Application Phase operation only. And thus, only the UV error table is needed. On a...
96501 Sep 2015 @ 02:15 PDTToolsReplyfastload error "not enough fields in vartext data record number".There must be some garbage characters in your data file somewhere after the 2nd record that makes FastLoad think there is a 3rd record to read, and that garbage (possibly unprintable characters) is...
96401 Sep 2015 @ 02:13 PDTToolsReplyTPT10508: RDBMS error 3707: expected some thing bet 'UDFCALLNAME' keyword between the 'USING' keyword and the 'DELETE' keyword.The DELETE task in the Update operator is an Application Phase operation only. And thus, only the UV error table is needed. On a regular import task, 2 error tables are needed (one for the Acquis...
96331 Aug 2015 @ 01:58 PDTToolsReplyfastload error "not enough fields in vartext data record number".Does record number 2 have a proper end-of-record marker at the end? And then is there a proper end-of-file after that? If there happens to have a garbage character on the 3rd line/record, that mi...
96225 Aug 2015 @ 06:52 PDTToolsReplyTPT NPAM reading named pipe ,not ending. Please help urg!!Is the data coming through the pipe in the proper format? If so, then the pipe will remain open until there is an end-of-file type of condition on the pipe. Without that, the named pipe access mo...
96125 Aug 2015 @ 06:50 PDTToolsReplyTPT Load errors, exit codeCurrently, TPT cannot return a non-0 return code if there are rows in one of the error tables. But we are considering an attribute to the operator in which the user could tell us that they would l...
96024 Aug 2015 @ 04:45 PDTToolsReplyTPT Script - Not all records loaded from a file with SkipRowsEveryFile optionWe have located the source of the bug and will fix in the near future. The workaround (as you well know), if you only have a single file, then do not set SkipRowsEveryFile to 'Y'.

Pages