Skip to main content
  • EN

Hi guys,

I am trying to read a data from oracle and I connected that as reader while checking connection test status is showing successful but while I try to fetch the table it showing "Failed to retrieve feature type".

can anyone suggestion to override this issue?

 

Thank you in advance .

Regards,

Saravanakumar

image 

image

Hello @saravanakumar​, thanks for posting! If you try manually entering the table name, instead of using the Table Selector Tool, are you able to read the data? If manually entering the table name does not work, please try to provide any of the following information:

  • What version of FME are you using?
  • What version of oracle are you reading from? Is it oracle spatial or non-spatial?
  • If you click 'Show Log...' on the feature type pop up error in your screenshot, does it provide any other information? Are you able to share it here?

Also, please consider sharing a copy of your workspace (.fmw file)! Let me know if you have any other questions. Happy to help, Kailin

Hello @saravanakumar​, thanks for posting! If you try manually entering the table name, instead of using the Table Selector Tool, are you able to read the data? If manually entering the table name does not work, please try to provide any of the following information:

  • What version of FME are you using?
  • What version of oracle are you reading from? Is it oracle spatial or non-spatial?
  • If you click 'Show Log...' on the feature type pop up error in your screenshot, does it provide any other information? Are you able to share it here?

Also, please consider sharing a copy of your workspace (.fmw file)! Let me know if you have any other questions. Happy to help, Kailin

Hello @kailinatsafe​ ,

Thank you for the response !

Oracle is worked when I select the table name instead entering manually.

 

Regards,

Saravanakumar

Reply


Community Stats

30,162
Posts
114,487
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.