DSXchange

I just had the same error. In the oracle database and in the application metadata a field had differing types between the source and target databases. In Oracle in the source it was a VARCHAR2 but a NUMBER in the target. Once the table metadata was remigrated into the warehouse it solved the problem.

Support told us to reinstall Oracle... We moved to implement the native drivers and now we are up and running with this workaround.

You misread the initial post- we do not have the Oracle client installed on the server, which is also per policy. I think its great that you all have not had problems, unfortunately we have.

So far nothing from Oracle support except they are requesting drivers, which I am skeptical will resolve- or maybe it will and in 15 days the same thing will happen...

Thanks for the reply, Ray and Vince. The directory only has one .LIC file in it and thats IVVM.LIC and nothing had been removed or modified. We use a PSFT OEM version of DS so I dont know if that changes the mix of .LIC files that would be present. Checked the backup of the intial install and IVVM.L...

Error Message: ---------------------------------- J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]File not found 'IVVM.LIC'. J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]You are not...