cancel
Showing results for 
Search instead for 
Did you mean: 

Data Store connection issues in the workbench

venkataramana_paidi
Contributor
0 Kudos

Hi ,

I am trying to connect oracle database using workbench. Connection test succeeded but I am getting the error like Cannot retrieve children nodes - browse remote error: Oracle <orcl> error message for operation <OCIStmtFetch>: <ORA-24338: statement handle not executed.

I have tried with designer, I can import table by table but I cannot browse all the metadata.

Please find the screenshots for reference

Please help me how to resolve this issues.

Thanks & Regards,

Ramana.

Accepted Solutions (0)

Answers (1)

Answers (1)

DayaJha
Active Contributor
0 Kudos

Hi Ramana,

Same Issue i faced in BODS 4.1, Please do the below activity.

I have seen these Oracle messages when the database runs out of sessions or processes. Ask your DBA to execute the following commands:

  • alter system set processes=400 scope=spfile;
  • alter system set sessions=800 scope=spfile;

And then restart the database to take effect. If your DBA does not know what that is, forget it, it is just another optimization with its own pros and cons.

Regards,

Daya Jha

venkataramana_paidi
Contributor
0 Kudos

Hi Daya,

Thanks for your response. I have tried already with above options but  I am facing the same issue. I changed the parameters values and I restarted the oracle services.

I am not only facing the issue for workbench. If I click on the oracle data store also  I am getting the below error.

Thanks & Regards,

Ramana.