10-09-2014 07:08 AM
I am uploading some data using Multiload= option in SAS to upload the data to Teradata library.
But receiving the error ..that it cannot create ML_Log tables in SAS installation directory..
Is there a way to change the ML_LOG location so that insufficient permission can be removed..??
10-09-2014 10:22 PM
Please find the code as below:
prov append data=work.Test
base=Tera.final (Multiload=yes ML_LOG=err1);
Error: insufficient authorization to access the /sas93conf/Lev1/......./BL_1234.dat
can anybody help in removing the above error..??
Tera is Teradata library...
i am trying to upload work dataset test to Teradata table final...
pleae help in resolving the above error..Please help
10-10-2014 02:34 AM
Ask you platform admin to correct to current directory setting.
SAS made a failure with that. 50345 - Changing the current working directory for the SAS® Workspace Server
There are several approaches with Teradata not the same as you are used to common DBMS systems.
With loading data TD can create error notification files for dropped failed records and proceed continuing with all following. A classic DBMS would return an error and stop, not TD.
This is part of thinking in big-data processing. Better missing some records and having all others than having nothing.
(cannot find that refrence as quickly)
If the work table or error table names are not specified, Teradata MultiLoad creates them using the target table or view names with a three-character prefix of WT_, ET_, or UV_, as in:
• WT_tname1 for the tname2 work tables
• ET_tname1 for the tname3 error tables
• UT_tname1 for the tname4 error tables
Your ML_log is just a naming convention not a location. Better to switch to a location supporting sufficient storage.