This content has been marked as final. Show 3 replies
Hi - Here are couple of things we can check.
1. Check if the Import Format of the location and Load File are synch.
2. Can you tell us what is the adaptor that you are using? You can also try downloading the new adaptor and copy the content of Load Action and paste into your current adaptor.
Unfortunately I do not agree with the statement made by SatyaK. Importing of data into FDM has nothing to do with the adapter and the Load actions.
What I would suggest to do is the following:
1. Clear the User Error Log (Tools -> Clear Error Log)
2. Reproduce the issue.
3. View the User Error Log (Tools -> View Error Log)
The reason is that it is sometimes 'filled' with information that might not be relevant, and you might not be looking at the very first error in the workflow. So therefore you could be looking at something totally irrelevant.
Secondly .... I would suggest to do this as well.... review the Import Log
1. Import Fish (should be white)
2. View Options Tab
3. View Log button
As you go through the log, it will tell you how many records it found, how many it was told to skip, etc. Sometimes when this error occurs it is because the total number of 'valid' records, was zero. Therefore there was nothing to insert into the database. If this is the case, then you will need to update your import format accordingly.
Thanks for the help, the problem is resolved. In our case there were 2
oracle homes and our application server Oracleias was pointing to a
oracle home where sqlldr was not installed. We changed this and that
resolved the issue.