** T_temp Already Exists Error (132) In Linux And Not In Unix

[Sowmya11]

Hi,

We recently migrated our QAD application from Unix to Linux server. When we try creating a temp table with duplicate records (with same primary unique key fields) we are able to create the temp table successfully in Unix (temp table is created with one unique record and ignores the other duplicate records despite throwing error 132 t_temp already exists). Where as we get the error saying "** t_temp already exists with "7101010" "BUH0RE5 " 1 "4F01AT ". (132)" and the table does not create in Linux.

Does anyone know why this difference between unix and linux? How we can suppress the error in linux and load the data similar to unix?

Thanks!
Sowmya

 

[Cringer]

Was the only thing you changed the OS? This suggests to me that t_temp has a unique index defined that wasn't defined prior to the migration.