All forum activity

#DateUserForumTypeThreadPost
2839121 Nov 2012 @ 09:46 PSTAmarnathGToolsReplyMload table locks cannot be released because NUSI exists Hi feinholz, Thanks a lot for the post!! Could you please explain what are the possible "internal inconsistencies between the primary and its non-unique secondary indexes". I am a ...
2839021 Nov 2012 @ 09:37 PSTAshishPatilToolsReplyTeradata PT 12.0 error output schema does not matchThanks feinholz, :)   I moved ahead but now i am getting different error stating its not able to load shared library libodbcop.so. I checked whether this file exists or not, but its there o...
2838921 Nov 2012 @ 07:47 PSTsanjeevsDatabaseReplyAdding Compression to existing tableAnd if you want to add more values to the existing Compression List, you can do it as under :     ALTER TABLE DBA_TEST_DB.TEST_COMPRESSION ADD  column_b DECIMAL(15,2) ...
2838821 Nov 2012 @ 06:05 PSTJoshCrosbyGeneralReplyAdvice for a SQL Server Guy getting started in TeradataSorry to raise an old issue, and appreciate the advise you listed here TDMerie. Are there any resources or test databases to work through, somewhat like Adventure Works samples, data warehousing, e...
2838721 Nov 2012 @ 06:03 PSTricky_ruDatabaseReplyCaculate how many bytes of stringThanks Carlos. For the second question, I agree with you that the collations control the ordering. But how could i know the setting in current session. For example, If the encoding is ASCII, ...
2838621 Nov 2012 @ 04:36 PSTwallaceToolsTopicTPT installation guideI would like to install TPT client on one of my linux server. May I ask what software do I need to download and where can I find installation document?   Linux  2.6.18-238.12.1.el5 #1 ...
2838521 Nov 2012 @ 04:23 PSTfeinholzToolsReplyWhy I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?Looks like someone may have copied library files around, or you are pointing to the wrong directories. Script-based TPT is a 32-bit application. However, we also provide 64-bit versions of some o...
2838421 Nov 2012 @ 04:04 PSTwallaceToolsReplyWhy I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?Hi, Feinholz, Thanks a lot, I have one more question. I am running my tpt script and get the following error.      tbuild -f job1A.tpt -v myDesktop.var  Teradat...
2838321 Nov 2012 @ 01:30 PSTasad6020DatabaseTopicOld data access for DBC.ResSpsViewHi I am using view (i.e DBC.ResSpsView), but the problm is that the view reffers to "DBC.ResUsageSPS" table and this "DBC.ResUsageSPS" contains one day data only, so I can't...
2838221 Nov 2012 @ 10:49 PSTfeinholzToolsReplyMload table locks cannot be released because NUSI existsAccording to the DBS engineer: Here is the explanation of error 7446. We process the primary data, the fallback data, and the NUSI data separately in the application phase. If there is an abort du...
2838121 Nov 2012 @ 10:49 PSTJim ChapmanAnalyticsReplyFailure 2805 Maximum row length exceeded in table in abc in BTEQ when using SET operator.It's probably the length of the sort key that pushes the result spool row length over the limit. UNION ALL works because it doesn't require a sort to remove duplicates.  
2838021 Nov 2012 @ 10:36 PSTQaisar KianiDatabaseReplySpool ReleaseSpool falls into three categories: VOLATILE SPOOL - content is retained until * Transaction completes (unless the table was created with  ON COMMIT PRESERVE ROW) * Table is dropped manual...
2837921 Nov 2012 @ 10:21 PSTQaisar KianiDatabaseReplyprimary index hash value SELECT HASHROW(<<COLUMNLIST>>), COUNT(*) FROM <<TABLENAME>>
2837821 Nov 2012 @ 10:10 PSTQaisar KianiDatabaseReplyNeed help to avoid spool space errorExplain plan of the query and DDL / Indexes of the table referenced will help in understanding what could be going wrong...
2837721 Nov 2012 @ 10:04 PSTQaisar KianiAnalyticsReplySQL works fine in Teradata SQL assistant getting error when trying to execute in Tableau custom SQL connectionTry assigning alias names to the first column in your SELECT statement... SEL EXTRACT(MONTH FROM b.date_application_received) || '_' || EXTRACT(YEAR FROM b.date_application_received)...
2837621 Nov 2012 @ 09:09 PSTsteverViewpointReplyvp:tableWidget with higher height gets Exception in thread "Timer-2" java.lang.OutOfMemoryError: PermGen spaceIt appears your local Tomcat is running out of PermGen space.  This is the space that is used to load classes in the JVM.  This is fairly common in servlet containers when you redeploy we...
2837521 Nov 2012 @ 09:07 PSTfeinholzToolsReplyTeradata PT 12.0 error output schema does not matchYou only have an APPLY statement with no accompanying SELECT. You have only defined a consumer operator but no producer operator.
2837421 Nov 2012 @ 08:57 PSTciw916DatabaseTopicNeed help to avoid spool space errorI have a query that I am trying to run against teradata.  I received an email stating that my query was using too much of the CPU resources and to please modify before proceeding.   ...
2837321 Nov 2012 @ 08:52 PSTrajeev saravananDatabaseTopicSpool ReleaseHi, If a query is utilizing many spools are they released only when the query ends? for example if my query is using till spool20 then the sum of all the 20 spools is utilized till the query exec...
2837221 Nov 2012 @ 08:48 PSTCarlosALDatabaseReplyReturning Values from Procedures>>"Is it possible to return values using Stored Procedures in Teradata?" Yes, with OUT IN/OUT parameters. HTH. Cheers. Carlos.
2837121 Nov 2012 @ 08:47 PSTCarlosALDatabaseReplyCaculate how many bytes of stringRicky:   1. OCTET_LENGTH():  BTEQ -- Enter your SQL request or BTEQ command: SELECT OCTET_LENGTH('En un lugar de La Mancha...') LENGTH_DEFAULT,     &nbs...
2837021 Nov 2012 @ 08:46 PSTTerrorDaterThird Party SoftwareTopicSSRS - querying TD using a VB expression via ODBCSQL Server 2008 R2 - Reporting Services - Windows Server 2003 sp2   I am using BETWEEN in my WHERE clause as part of a VB expression, to power a SSRS report: "...WH...
2836921 Nov 2012 @ 08:02 PSTAmarnathGToolsTopicMload table locks cannot be released because NUSI exists Hi All, I had  a problem when i executed mload script. My table has NUPI on some coloumns. The mload script has got failed  and When i try to release the lock on mload target tab...
2836821 Nov 2012 @ 07:40 PSTAmarnathGToolsReplyHow to Find Database name using Proxyid/Service idi All, Any replies...Thanks
2836721 Nov 2012 @ 07:21 PSTplentyfishDatabaseTopicAltering a table to extend partition range fails with error 3732Hi, I'm getting following error when I run alter table statement to add/extend partition range: 3732: The facility of altering the partitioning of a non-empty table by adding/droppin...

Pages