Oracle Connector is not pulling the records !!

[John Daniel]

AND ROWNUM <=10 is given for the testing purpose...

Its pulling the 10 records....but if i gave the full query to pull the entire data its not pulling out......It seems its of Length issue or memory issue....Please advise on this.


Looking for your kind help in this regard.

Thanks,
John

[asorrell]

Have you tried a test where you just pull the single field with the LongNVarChar field? If you suspect that is the issue that may confirm it if it fails.

[John Daniel]

Thanks,

Let me try this option !!

Regards,
John

[John Daniel]

Is there a message handler which is suppressing warnings at all?

How to message handler !! will anyone help me in this.....

[ShaneMuir]

If there was a message handler then you should have an entry in the Director logs to that effect. Something like

Code: Select all

Attached Message Handlers:MH_SHAREreporting

Also look through the Director logs for any hint of the words 'dropped' or 'message handled'.

Not saying this in the answer, but it doesn't hurt to look.