|28391||21 Nov 2012 @ 09:46 PST||AmarnathG||Tools||Reply||Mload table locks cannot be released because NUSI exists||
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 ... |
|28390||21 Nov 2012 @ 09:37 PST||AshishPatil||Tools||Reply||Teradata PT 12.0 error output schema does not match||Thanks 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... |
|28389||21 Nov 2012 @ 07:47 PST||sanjeevs||Database||Reply||Adding Compression to existing table||And 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) ... |
|28388||21 Nov 2012 @ 06:05 PST||JoshCrosby||General||Reply||Advice for a SQL Server Guy getting started in Teradata||Sorry 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... |
|28387||21 Nov 2012 @ 06:03 PST||ricky_ru||Database||Reply||Caculate how many bytes of string||Thanks 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, ... |
|28386||21 Nov 2012 @ 04:36 PST||wallace||Tools||Topic||TPT installation guide||I 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 ... |
|28385||21 Nov 2012 @ 04:23 PST||feinholz||Tools||Reply||Why 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... |
|28384||21 Nov 2012 @ 04:04 PST||wallace||Tools||Reply||Why 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
|28383||21 Nov 2012 @ 01:30 PST||asad6020||Database||Topic||Old data access for DBC.ResSpsView||Hi 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... |
|28382||21 Nov 2012 @ 10:49 PST||feinholz||Tools||Reply||Mload table locks cannot be released because NUSI exists||According 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... |
|28381||21 Nov 2012 @ 10:49 PST||Jim Chapman||Analytics||Reply||Failure 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.
|28380||21 Nov 2012 @ 10:36 PST||Qaisar Kiani||Database||Reply||Spool Release||Spool 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... |
|28379||21 Nov 2012 @ 10:21 PST||Qaisar Kiani||Database||Reply||primary index hash value||
SELECT HASHROW(<<COLUMNLIST>>), COUNT(*)
|28378||21 Nov 2012 @ 10:10 PST||Qaisar Kiani||Database||Reply||Need help to avoid spool space error||Explain plan of the query and DDL / Indexes of the table referenced will help in understanding what could be going wrong...
|28377||21 Nov 2012 @ 10:04 PST||Qaisar Kiani||Analytics||Reply||SQL works fine in Teradata SQL assistant getting error when trying to execute in Tableau custom SQL connection||Try assigning alias names to the first column in your SELECT statement...
EXTRACT(MONTH FROM b.date_application_received) || '_' || EXTRACT(YEAR FROM b.date_application_received)... |
|28376||21 Nov 2012 @ 09:09 PST||stever||Viewpoint||Reply||vp:tableWidget with higher height gets Exception in thread "Timer-2" java.lang.OutOfMemoryError: PermGen space||It 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... |
|28375||21 Nov 2012 @ 09:07 PST||feinholz||Tools||Reply||Teradata PT 12.0 error output schema does not match||You only have an APPLY statement with no accompanying SELECT. You have only defined a consumer operator but no producer operator.
|28374||21 Nov 2012 @ 08:57 PST||ciw916||Database||Topic||Need help to avoid spool space error||I 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.
|28373||21 Nov 2012 @ 08:52 PST||rajeev saravanan||Database||Topic||Spool Release||Hi,
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... |
|28372||21 Nov 2012 @ 08:48 PST||CarlosAL||Database||Reply||Returning Values from Procedures||>>"Is it possible to return values using Stored Procedures in Teradata?"
Yes, with OUT IN/OUT parameters.
|28371||21 Nov 2012 @ 08:47 PST||CarlosAL||Database||Reply||Caculate how many bytes of string||Ricky:
BTEQ -- Enter your SQL request or BTEQ command:
SELECT OCTET_LENGTH('En un lugar de La Mancha...') LENGTH_DEFAULT,
|28370||21 Nov 2012 @ 08:46 PST||TerrorDater||Third Party Software||Topic||SSRS - querying TD using a VB expression via ODBC||SQL 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:
|28369||21 Nov 2012 @ 08:02 PST||AmarnathG||Tools||Topic||Mload table locks cannot be released because NUSI exists||
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... |
|28368||21 Nov 2012 @ 07:40 PST||AmarnathG||Tools||Reply||How to Find Database name using Proxyid/Service id||i All,
|28367||21 Nov 2012 @ 07:21 PST||plentyfish||Database||Topic||Altering a table to extend partition range fails with error 3732||Hi, 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... |