Netezza Enterprise Configuration Issue
Posted: Fri Jan 22, 2010 10:54 am
Hello ...
I am trying to connect to NZ database(NPS-4.5) using ODBC and NZ Enterprise Stage.
I created a simple job
Job1: Flat file --> Copy Stage --> ODBC Stage
Job2: Flat file --> Copy Stage --> NZ Enterprise Stage
Job1 with ODBC worked fine but Job2 with NZ stage is not working
Here is the error I get when I use NZLOAD method.
Error: Netezza_Enterprise_12,0: Error: ERROR: External Table : count of bad input rows reached maxerrors limit, see nzlog file
Erro [nzetsubop.C:300]
Is there a Environment variable where we can set the max errors?
Here is the error I get when I use ET method
Error: Netezza_Enterprise_12,2: Error: Error occured while opening data file
Error: unable to open '/nz/sys/strings/ldrStrings.C.txt [nzetsubop.C:300]
Do I need any additional permissions on the database to use this method?
I tried the DS_CONNECT and Example script in the branded_odbc folder and it ends up in Core Dump.
Is it necessary that this scirpts shld work? ODBC job works OK with this script failing.
Pls advise.
Thanx
I am trying to connect to NZ database(NPS-4.5) using ODBC and NZ Enterprise Stage.
I created a simple job
Job1: Flat file --> Copy Stage --> ODBC Stage
Job2: Flat file --> Copy Stage --> NZ Enterprise Stage
Job1 with ODBC worked fine but Job2 with NZ stage is not working
Here is the error I get when I use NZLOAD method.
Error: Netezza_Enterprise_12,0: Error: ERROR: External Table : count of bad input rows reached maxerrors limit, see nzlog file
Erro [nzetsubop.C:300]
Is there a Environment variable where we can set the max errors?
Here is the error I get when I use ET method
Error: Netezza_Enterprise_12,2: Error: Error occured while opening data file
Error: unable to open '/nz/sys/strings/ldrStrings.C.txt [nzetsubop.C:300]
Do I need any additional permissions on the database to use this method?
I tried the DS_CONNECT and Example script in the branded_odbc folder and it ends up in Core Dump.
Is it necessary that this scirpts shld work? ODBC job works OK with this script failing.
Pls advise.
Thanx