Hi All
I have one job that insere 3 rows into a oracle table. In development this job works very well. In production it execute with sucess but not insere the rows. The log show me only 3 lines like this:
Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1.
Do you have any idea about this problem?
the table's structure and user permissions is the same (production and development)
Tks
Parallel - Insert into oracle table
Moderators: chulett, rschirm, roy
Parallel - Insert into oracle table
Armatos Consultoria em Informática
Alcides Roberto de Matos
Alcides Roberto de Matos
Add a reject link to your oracle write stage and put that into a peek statement, then examine the SQL code to find out why the rows are being rejected.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Only for explain the solution:
in Development the parameter APT_STRING_PADCHAR = 0x00 and in the Production enviroment the parameter APT_STRING_PADCHAR = 0x20. So the Data Stage expects a Null character at the end of string in Production.
thanks for all
in Development the parameter APT_STRING_PADCHAR = 0x00 and in the Production enviroment the parameter APT_STRING_PADCHAR = 0x20. So the Data Stage expects a Null character at the end of string in Production.
thanks for all
Diogo de Oliveira Vasconcellos
diogo.cwb@gmail.com
diogo.cwb@gmail.com
Re: Parallel - Insert into oracle table
Thank you very much!
Thus was possible to see the error (ora-1480) and to find the solution of this problem.
Thanks
Alcides
Thus was possible to see the error (ora-1480) and to find the solution of this problem.
Thanks
Alcides
Armatos Consultoria em Informática
Alcides Roberto de Matos
Alcides Roberto de Matos