Hi Ste Frdric,
Can you share the profile or mapping log where the filter or filter transformation respectively does not work?
The log can have errors which might shed some light on what is happening.
I wish I could share it. I am new here and due to policy, I cannot share company info( just took a class(smile). Maybe I can look at the log, (if i can get access) and it will give me some insight. Thank you very much, for the suggestion..
Thank you for your reply on this. Since you can not share the logs, can you try to share the screenshot of the successful test and failure test case.
Since this works in one environment database, would it be possible to connect to the same database from the other environment to test it?
If that works, the data seems to be causing an issue to me.
You may enable "Verbose Data" logging to compare the working and non-wroking scenario. The verbose log might also help you with the bad characters if any.
Hope this helps.
I have been here less than 4 months and we take these classes , orientation, etc... and i cannot take screen shots.. either.. etc..
Thanks for your assistance
thank you very much.. I will see if I can get access to the log... .. i showed it to my boss, he wasn't sure either... but what you are saying about the data..... they are both in the same enironment, same database, but different tables in the database.... , dates defined the same way... could that still cause a problem?
Thank you very much
That makes things clear.
At times there are special characters that are not directly visible. You can possibly take a dump of the data in the database and check if that is correct.
There could be other possibilities as well which would be possible to review once you get the verbose log.