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
Netezza Enterprise Configuration Issue
Moderators: chulett, rschirm, roy
Netezza Enterprise Configuration Issue
Thanx........
CTCT
CTCT
Resolution:
Add a new parameter in the Administrator or the Job
$APT_NZ_ERRORS_ALLOWED = 100
Update LIBPATH
NZ_HOME path should precede Oracle_HOME path.
For Example..here is our LIBPATH
/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/aix-all-ppc_64:/usr/nps/kit/lib64:/usr/oracle/product/10.2.0/db/lib
It worked fine....
Add a new parameter in the Administrator or the Job
$APT_NZ_ERRORS_ALLOWED = 100
Update LIBPATH
NZ_HOME path should precede Oracle_HOME path.
For Example..here is our LIBPATH
/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/aix-all-ppc_64:/usr/nps/kit/lib64:/usr/oracle/product/10.2.0/db/lib
It worked fine....
Thanx........
CTCT
CTCT