DSXchange

BTW - You need to figure out how you managed to get a DATE in a NUMBER field, we can't. As noted earlier, check to see how many times the key combination of the problematic record(s) occurs in your input data set.[/quote] I have used hash file stage to capture rejected records and viewed the data.. ...

chulett wrote:ps. You should have done a CLEAR.FILE on your log file name as noted in the error, not the completely unrelated "phantom" directory. ...

how to find the log file name for the particular Job?

please give the full syntax for using CLEAR.FILE

Doing a "CLEAR.FILE &PH&" has nothing to do with your issue. The "&PH&" hashed file (actually stored as a project subdirectory) contains only Tee'd output from background processes. I ... Thanks for your information andrew my concern is to avoid the warnings and ...

Your log file is corrupted and the quickest way to get back up and running is to use the Director and clear all log file entries; this triggers a TCL command of "CLEAR.FILE" which will reset the log f ... I had used CLEAR.FILE &PH& but in vain, Its ok i have copied in to new job a...

I meant the "update and insert" dml not the source query, I thought that was your "custom" one. And your phantom is strictly from blowing the logs over 2GB in size just as it states, probably by runni ... There is no custom query for update and insert on the target ODBC stage. y...

I would suspect it's an issue with your 'custom query', that and loading multiple records with the same keys in a run. Why custom rather than generated? Care to post it? ... SELECT TBL1.COL1,TBL1.COL2,TBL1.COL3,TBL2.COL4,TBL2.COL5, TBL2.COL6,TBL2.COL7,TBL2.COL8 FROM TBL1,TBL2 WHERE TBL1.COL1=TBL2.C...

Hi all, I am wondering how the warnings are thrown, while inserting records. there are two behaviours one is, while running the job for custom query with update and insert login on target table, some records are rejected with the warnings "ORA-00932: inconsistent datatypes: expected NUMBER got ...

Moreover, if I want to compile the job it is giving compilation error: Cannot get exclusive acces to job. Job may be monitored When I am facing this error, I had tried to by copying the job and saving it with different name.. it was working... you can try by stopping the DSENGINE and starting it aga...

Hi whenever I was facing this problem i used to compile the job and rerun it. It was working fine. I think this is due to no. of process running at the backend or if the server is busy with the existing processes. I am not sure about what i think, since I am also eager to know why this error is occu...

Could this be a "hard space" character from a Word document or similar? ... I had copied from director logs and pasted, did you mean to say that '?' is present in the source which is not accepted varchar type? when i am searching for 'district centre ? Janakpuri' in the odbc. It is throwi...

The character between Centre and Janakpuri is 0xA0 (Char(160)). Check your source data to determine whether this actually occurs there. And do check the NLS_LANG setting for Oracle. ... I had checked in the source system its proper "Janakpuri" is present, no special character, also i had ...

some spelling mistake in the code

Convert(".", "", Oconv(inputlinkname, "MCP"))

Hi ray & andrew, thanks for your reply, but the field is not a date field. It is Location having value like "Janakpuri" I had used conver(".","",Oconv(inputfieldname,MCP)) and after passing inputfieldname alone without using any conversion and added one reject seque...

Hi all, I am getting following warnings and following that 4 records are not passed to the target. Could any one suggest on, how to avoid the mentioned warnings. below are the warning for one of the record. Transformer_2.DSLink4: DSD.BCIPut call to OCONV failed. Column: PARAMDESC1, NLS mapname: ISO8...

Hi

the mentioned commands were used in AIX server did not noticed the datastage server is installed in windows environment..

any how I would not suggest the same will work in windows environment or not