#DateForumTypeThreadPost
30913 Jul 2012 @ 09:41 PDTToolsReplyfastload issue with inmod path Ok. We already have JIRA issues opened for these but we will just eventually close the one you opened as a duplicate. Thanks!  
30812 Jul 2012 @ 03:35 PDTToolsReplyTPT: AcceptExcessColumns with strange behaviour in FILE_READER #2 and #3 are bugs we are currently fixing. For #1, the AcceptExcessColumns was originally only intended for the "delimited" data. We will not be supporting that feature for th...
30711 Jul 2012 @ 11:49 PDTToolsReplyfastload issue with inmod path Try this: INMOD="c:\Progra~1\MySoftware\MyInmod.dll"; while I investigate whether spaces are supported.  
30602 Jul 2012 @ 08:09 PDTToolsReplyRequest size exceeds maximum. I have seen this error when incompatible versions of different TTU software components are installed, especially CLI. Please install (or-reinstall) the latest and greatest patches of CLI. ...
30528 Jun 2012 @ 07:59 PDTToolsReplyFastload Logtable error This error is usually due to the Teradata Database telling FastLoad that the job is a restart, but there is no information in the FastLoad restart log table (SYSADMIN.FASTLOG) for that table. ...
30427 Jun 2012 @ 10:43 PDTToolsReplyBeginner TPT According to the documentation for UPSERT: When using the upsert feature: • There must be exactly two DML statements in the DML group. • The first DML statement must be an UPDA...
30321 Jun 2012 @ 07:53 PDTToolsReplyRDBMS error 2633 Too many load/unload task running I am not sure what you are asking for here. The number of load/unload tasks has nothing to do with the number of sessions being used by each job. Each TPTEXP job will utilize one load/un...
30220 Jun 2012 @ 11:03 PDTToolsReplyBeginner TPT We have never seen this issue before. Might be a problem with the installation. Try to install again, and please go to the patch server and download the latest and greatest patches to TP...
30115 Jun 2012 @ 10:09 PDTToolsReplyBeginner TPT Can you please provide the command you gave to tlogview? This error:   TPT_INFRA: TPT01514: Error: Unable to Open File. Error code 2, Reason code 530, Class code 501 No such...
30015 Jun 2012 @ 09:57 PDTToolsReplyBeginner TPT Yes, it might be an issue with the installation. Can you post the contents of the directory pointed to by the $TWB_ROOT environment variable? And make sure you have the proper access rig...
29915 Jun 2012 @ 09:30 PDTToolsReplyLoading using Teradata Parallel Transporter Load utility. No, the WildcardInsert feature is only for the Load operator (which only uses a single DML statement). The documentation (13.10 version I just looked at) seemed pretty clear to me that it is...
29814 Jun 2012 @ 10:24 PDTToolsReplyFastexport ASCII character removal Yep, I missed the "FORMAT TEXT" part. I am trying to get people to use "TEXT" in the proper way. In fact, I think we have made changes over the years as to how we handle ...
29713 Jun 2012 @ 12:07 PDTToolsReplyFastexport ASCII character removal Actually, those are not ASCII characters. The 2 bytes are the record length. Declaring the output as CHAR will not change that. FastExport always exports the data with the 2-byte record ...
29613 Jun 2012 @ 12:00 PDTToolsReplyBeginner TPT First of all, you should always upgrade to the latest and greatest patches. Next, you need to provide the contents of TPT_STATS_CLIENTE00.sh. The .out file is in the directory pointed to...
29512 Jun 2012 @ 11:15 PDTToolsReplyTPT Crashed Open an incident with the GSC. There is not enough information in the post to identify the exact problem. The other thing you should do (first) is to upgrade to the latest and greatest patch...
29411 Jun 2012 @ 11:43 PDTToolsReplyTPT log file not printing the update row count Without seeing the entire script, it is hard to tell what you are actually trying to do. The console output (you are showing the console output, not the contents of the log) shows what was actua...
29307 Jun 2012 @ 11:12 PDTToolsReplyFastexport - how to export without beginning two bytes ? Try: APPLY INTO OPERATOR instead of LOAD INTO OPERATOR  
29206 Jun 2012 @ 02:48 PDTToolsReplyTPT unknown load error Ok, well I would like to say "that could never happen" and "we only process what is in the script". But clearly you are seeing different behavior than what "should&q...
29101 Jun 2012 @ 10:02 PDTToolsReplyLoading using Teradata Parallel Transporter Load utility. If you look in the TPT 13.10 User Guide, page 446, there is an example script for what you want to do. When using the SQL Selector operator, you need to specify:    TYPE SELECT...
29030 May 2012 @ 05:02 PDTToolsReplyLoading XML file into empty terdata table using TPT Please show me what your data looks like. Your schema has a "varchar(100)". Are you sure that your field is preceded by the required 2-byte field length?
28924 May 2012 @ 03:28 PDTToolsReplyTPT10505 Error when fastloading with Data Services The error cannot be informational because the job cannot continue. TPT10505 is a run-terminating error. The user specified the minimum number of sessions necessary to run the job and tha...
28822 May 2012 @ 10:37 PDTToolsReplyLoading using Teradata Parallel Transporter Load utility. Have you experimented? Job variables can be used anywhere. So, just like how you can use it for UserName, you can use it for the INCLUDE statement.      INCLUDE @my_f...
28717 May 2012 @ 03:14 PDTToolsReplyTELAPI Initialize error on Linux64 TPT API 13.10 "[CLI2: BUFOVFLOW(308): Parcel data too large for receiving buffer.]" Can you please tell me at which customer site you are working? At the site with which we were working, the problem was an incompatibility between the TPTAPI infrastructure and the Export ope...
28617 May 2012 @ 03:11 PDTToolsReplyTPT10505 Error when fastloading with Data Services A TPT error is not the same as a Teradata Database error (different products, which is why we prepend "TPT" to the beginning of our errors). The error message is very clear: TP...
28517 May 2012 @ 03:08 PDTToolsReplyTeradata PT API Error - Row length exceeds maximum defined by the table schema TPTAPI does not care about the data in the file, because TPTAPI does not have the ability to read from a file. You application must read the data from the file and provide the data to the TPT Lo...

Pages