DSXchange

I used Connector Migration tool in 11.5 version, migrated the server jobs having ORA OCI stages to Oracle Connector stage.

Before migration server job ORA OCI stages property " Prefetch memory setting" value as 5000, but after migration setting in Oracle connector "Prefetch Buffer Size " value became 5000000. This is happening for all jobs where ever we defined Prefetch memory setting. because of this we couldn't compile jobs and error saying buffer size can't be more than 100240.

Please let me know how to resolve this.

Since the utility is supported, you should really report this defect to Support and request a fix. They will most likely provide you with a patch, or at least with detailed instructions to follow to fix it manually. Good luck!

I contacted IBM support, they suggested to install patch JR56834.

Patch resolved issue.

I know what you guys think and tell others is very helpful.