#DateForumTypeThreadPost
2308 Nov 2015 @ 08:36 PSTDatabaseReplySELECT Failed. [7548] Insufficient memory to complete the XML operationGetting same error message on Teradata 15.00
2202 Nov 2015 @ 02:43 PSTDatabaseTopicSELECT Failed. [7548] Insufficient memory to complete the XML operation- version Teradata 14.10 - stored a 6Mb .xml file to a XML column (XML_col) on a row - dbc control:  284.  MaxXML_MemoryLimit = 128 MB (4 - 128, Default 32) - SELECT XML_col.EXISTSNODE...
2121 Oct 2015 @ 04:15 PDTDatabaseReplyRow not returned when percentile_cont() only sees null values, even when other columns would have dataThanks.  Ticket opened.
2017 Sep 2015 @ 04:47 PDTDatabaseTopicRow not returned when percentile_cont() only sees null values, even when other columns would have dataAny ideas why percentile_cont() will prevent a row from returning when the source rows (the 'group') all contain null values?  I expect to see the row with perhaps NULL in that column....
1928 Mar 2015 @ 09:12 PDTDatabaseTopicIntentionally Stale Bookend Statistics to get past inconsistent right-side stats extrapolation by query optimizerHere's a clever way to force the query optimizer to follow the same *stable* plan for a query regardless of the data set it runs against.  Useful when the data set cardinalities and row co...
1822 Jan 2015 @ 06:26 PSTToolsReplyNumber of Utility Load SlotsUpdate: Teradata has told us there is a hard limit of 30 utility aka load slots, and that it is difficult if not impossible to configure systems in such a way that all 30 are usable.
1715 Jan 2015 @ 06:31 PSTToolsReplyNumber of Utility Load SlotsIdeally there would be a spreadsheet model that would come up with the max load slots that would not impact the other work being done on the system.  Any ideas?
1612 Jan 2015 @ 03:19 PSTToolsTopicNumber of Utility Load SlotsHi,  Some utility load slot questions... 1.  Are there any guidelines for the number of utility load slots a Teradata system can have?  Is there a limit?  How is it deter...
1524 Oct 2014 @ 08:25 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingResolution:  this is fixed in DR 171445 fix in TDBMS_14.10.2.9_GCA. There is no workaround [for earlier 14.10 releases]  
1422 Oct 2014 @ 11:29 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingThanks Dieter
1322 Oct 2014 @ 08:03 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingAny ideas on how to get TD_UNPIVOT to work?  It doesn't appear to be a permissions problem, right?
1221 Oct 2014 @ 03:15 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingDieter, The function shows up in... TD_SYSFNLIB Prefacing the function with the databasename still returns the error: "SELECT Failed.  [9134] TD_UNPIVOT_CONTRACT" SELECT TOP 100...
1121 Oct 2014 @ 12:43 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingWhat's the next step?  Does this indicate a problem with the upgrade from V13 we did back in May?   
1021 Oct 2014 @ 06:23 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingYes, I got the release and version from querying dbc.dbcinfo in the same session.  
920 Oct 2014 @ 09:16 PDTDatabaseTopicTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusing    The 14.10 help for TD_UNPIVOT has two examples, one with SELECT... FROM UNPIVOT, and another with SELECT... FROM TD_UNPIVOT.  Neither are working. The UNPIVOT variation fails ...
819 Jun 2014 @ 01:24 PDTToolsReplyRunning multiple concurrent TPT INSERTER jobs on one server - seeing long wind-down-->  I would need to see the script(s), and the command lines. listings at bottom -->  Are you running 12 different TPT scripts? 16 scripts, one per target table.  S...
718 Jun 2014 @ 02:45 PDTToolsTopicRunning multiple concurrent TPT INSERTER jobs on one server - seeing long wind-downWe're trying to find the upper limit to how many concurrent INSERTER operators we can run on our application server.  After a certain number, we are seeing a long delay after the INSE...
616 Jun 2014 @ 11:35 PDTToolsReplyWill TPT INSERTER operator lock the target table if an INSERT step fails?From extensive tests we have not seen the INSERTER operator leave a table locked.  So far, so good.
512 Jun 2014 @ 03:07 PDTToolsTopicWill TPT INSERTER operator lock the target table if an INSERT step fails?We sometimes see the LOAD operator leave a table in a locked state if the TPT job fails at certain places in the script.  The only solution that works for us is to drop and recreate the t...
403 Jun 2014 @ 12:42 PDTDatabaseReplySQL statements in UNION executes serial or parallelHere's a variation where it would be great all if the select's of a union all executed in parallel and the resulting spools were combined sequentially at the end...    ...
310 Oct 2013 @ 08:32 PDTToolsTopicVigilMaxFiles doesn't seem to work without specifiying VigilWaitTimeWith TPT v 13 we are seeing data connector producer's read more than the VigilMaxFiles that we specify - unless we also specify VigilWaitTime.  Is this by design?
209 Sep 2013 @ 01:13 PDTToolsReplyError: It is not possible to call DisableCheckPoint at this pointAny ideas about why this is happening?   One more detail: the TPT utilities are V 14 but the database is still V 13... VERSION 13.10.06.07 RELEASE 13.10.06.06  
106 Sep 2013 @ 11:14 PDTToolsTopicError: It is not possible to call DisableCheckPoint at this pointHi, we are getting this error in TPT V 14 scripts... TPT_INFRA: TPT02510: Error: It is not possible to call DisableCheckPoint at this point Environment: Windows 2008 server Teradata Parall...