63 | 30 Aug 2016 @ 11:04 PDT | Tools | Reply | FastExport Remove Binary/Indicator Values in Outmod | Hi,
There are some sample OUTMOD routines in Teradata FastExport manual(B035-2410) Appendix C.
Thanks!
|
62 | 30 Aug 2016 @ 10:47 PDT | Tools | Reply | Error Table Mload | Hi,
Here is related information on 2665:
2665 Invalid date.
Explanation: This error occurs when date arithmetic is attempted on an invalid date.
Generated By: AMP Steps.
For Whom: End User.... |
61 | 29 Aug 2016 @ 08:42 PDT | Tools | Reply | Error Table Mload | Hi,
1. Can you let us know the error code recorded in the error table?
If it is in the Application Error Table, the column name is DBCErrorCode;
If it is in the Acquisition Error Table, the colu... |
60 | 29 Aug 2016 @ 03:47 PDT | Tools | Reply | MULTILOAD BUFFER ERROR!!! urgent | Hi,
1. Can you let us know the MultiLoad version and the Teradata Data Connector version? The Data Connector version could be obtained by issuing a ".version;" command using MultiLoad.
... |
59 | 11 Aug 2016 @ 01:35 PDT | Tools | Reply | Fastload error: I/O Error on File Open 34 | Hi,
Glad to know that it worked after correcting the syntax error. It would be nice for FastLoad not to issue the misleading message which leads to a Teradata DataConnector related error. Teradata... |
58 | 04 Aug 2016 @ 02:40 PDT | Tools | Reply | Record count from worktable in mload | Hi,
Here is Locking summary during a MultiLoad job:
- Begin MLOAD Step
. Target table
- write lock
. Work table
&... |
57 | 21 Jul 2016 @ 03:22 PDT | Tools | Reply | Float data type export using Fast Export | Hi,
This is not related to FastExport utility. We can see this using BTEQ too.
Is it Okay to use some other data types like decimal?
Here is an example:
BTEQ -- Enter your SQL request or ... |
56 | 13 Jul 2016 @ 10:36 PDT | Tools | Reply | Fastload - Error on piom GET ROW: 64 | Hi,
There was a similar issue and it is fixed in Dataconnector 15.00.00.003 and above. Please try to use 15.00.00.003 and above versions of Dataconnector and let us know if there is still issues.
... |
55 | 12 Jul 2016 @ 03:00 PDT | Tools | Reply | Fastload - Error on piom GET ROW: 64 | Hi,
1. Can you let us know the Teradata Data Connector version? This could be obtained by issuing a ".show version;" command using FastLoad.
The version will be followed "Teradata ... |
54 | 28 Jun 2016 @ 11:34 PDT | Tools | Reply | FastExport : SET SESSION SEARCHUIFDBPATH | Hi,
You can send the SQL after the LOGON statement and before .BEGIN EXPORT statement. Here is an example:
.LOGTABLE fexplog;
.LOGON <the tdpid>/<the user id>, <the user password&... |
53 | 11 May 2016 @ 05:08 PDT | Tools | Reply | Multi Load UTY0006 Input error in the FIELD command | Hi,
Please share with me the FastExport script and target table definition. I will take a further look. Thanks!
For the time being, you can try to change the line to:
.field IBNRSkadeestim... |
52 | 04 May 2016 @ 11:42 PDT | Tools | Reply | Issues in Multiload, Insert and Update for Multiple tables | Hi,
Can you please provide the MultiLoad job output?
If possible, can you share with me your target table definiation and the MultiLoad script/data file?
Thanks!
|
51 | 21 Mar 2016 @ 01:13 PDT | Tools | Reply | Very large table loading fails with Fastload, what are other possible solutions? | Here is the link to the patch server:
http://tssprod.teradata.com:8080/TSFS/
|
50 | 08 Mar 2016 @ 12:15 PST | Tools | Reply | Mload failing when trying to load file with þ (thorn) as delimiter | BTW,
there is an additional blank space in-between field6" and the þ in your data file. The result could be a sightly different from non-addtional blank space.
"field6" &thor... |
49 | 08 Mar 2016 @ 12:03 PST | Tools | Reply | Mload failing when trying to load file with þ (thorn) as delimiter | Hi tonez01,
I copied your 'þ' character and put the in mload script as the delimiter, and just used the ASCII session character set,
format vartext&nb... |
48 | 08 Mar 2016 @ 11:25 PST | Tools | Reply | how to load different files using multiload into different tables. | Hi Deepak,
Yes, those 5 IMPORTs are processed sequentially.
The MultiLoad job will terminate if loading one of the tables fails due to certain errors, the MultiLoad job could be re-submitted
aft... |
47 | 15 Feb 2016 @ 01:27 PST | Tools | Reply | Very large table loading fails with Fastload, what are other possible solutions? | Hi,
Please install DataConnector 15.00.00.02 or 14.10.00.08 Efixes or later versions to resolve "empty file on read open" error for large files on Windows platform.
Thanks!
|
46 | 02 Feb 2016 @ 04:45 PST | Tools | Reply | Multiload failure | Hi,
Regarding
**** 07:06:54 UTY0805 RDBMS failure, 3807: Object 'BKP.customers1' does not exist.
You need create the table first for MultiLoading.
--Ivy.
|
45 | 27 Jan 2016 @ 01:52 PST | Tools | Reply | Multiload + LDAP | Hi Tushar,
The screen shot only has the MLOAD error and from this screen shot alone we don’t know what is going on. The LDAP mechanism all happens on the server side and minimally we need th... |
44 | 10 Sep 2015 @ 10:07 PDT | Tools | Reply | Delete MLoad is giving errors - bad internal status - Delete Mload Started while Import Mload suspended | Hi,
It looks to me there is a prior MultiLoad job was suspended before you started the delete mload.
You can try completing the prior MultiLoad job and then sunbmit the delete mload.
If you stil... |
43 | 04 Sep 2015 @ 09:54 PDT | Tools | Reply | how to load different files using multiload into different tables. | Hi,
MLOAD could load up to 5 target tables, here is a pseudo MLOAD script to load data to 5 target tables using 5 data files:
.BEGIN IMPORT MLOAD TABLES <target table 1>,<target table... |
42 | 26 Aug 2015 @ 12:10 PDT | Tools | Reply | mload error - glibc detected *** mload: free(): invalid next size (fast): 0x08171308 | Hi,
In "/xx/xxx/bteq_logon.txt", there should be the LOGON statement and probably a LOGTABLE statement,
Can you check if the LOGON statement ends with a semicolon, like,
.LOGON <tdp... |
41 | 26 Aug 2015 @ 11:58 PDT | Tools | Reply | fastload error "not enough fields in vartext data record number". | Hi,
I could succesfully execute the same flod script using the same data file from my side, please find the out listed below.
Please double check if there are some extra characters in the data fi... |
40 | 15 Jul 2015 @ 01:55 PDT | Tools | Reply | fast export and mload with unicode column type and value | Hi,
Since UTF8 is used, please double check if the size of the unicode column is tripled in the mload script.
For example, if "Column3 char(10)" is specified in the target table, in mlo... |
39 | 04 Jun 2015 @ 03:18 PDT | Tools | Reply | 2573 Invalid match tag found | Hi,
2573 error will be returned if the match tag in the current parcel cannot be found.
Can he try to do some clean up and run mload freshly(new logtable and new target table) to see if this erro... |