I cannot run formspider on my machine.

When i try to open it, i receive the message "Cannot find Application "FormspiderIDE"."

I try stop/start the application on tomcat, but the problem continues.

How can i solve this?



asked 14 Nov '14, 14:55

tgalante's gravatar image

accept rate: 0%

Hi Thiago,

When you run the installer, there is a check box to indicate that you want to install Formspider IDE. Did you uncheck this checkbox by accident?

You can also run the following query in the schema you installed Formspider, to see if the Formspider IDE is installed:

select * t_bdf_application where name_tx='FormspiderIDE'

If this query doesn't return any rows, you are missing the IDE. Please rerun the installer and install only the IDE.

If query returns one row then maybe something went wrong during the installation of the IDE.

Please run

select p.bdf_panel_oid
from t_bdf_panel p, t_bdf_application a
where a.bdf_application_oid=p.bdf_application_oid
and a.name_tx='FormspiderIDE'

This query should give you the list of all the panels in the Formspider IDE. For every bdf_panel_oid value this query returns, there should be a corresponding package named P_||[bdf_panel_oid] in the schema. In other words, in your schema there should be many packages called for example P_85, P_128, P_45365 etc...

If you see all of these packages and you still can't run the application, we have a bigger problem. Let's worry about that after you finish these easy troubleshooting steps.

Hope this helps.

Kind Regards,


answered 15 Nov '14, 03:39

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Hi Yalin, tks for help! :)

In fact, Formspider IDE are not installed. Then when i try install it was given another problem:

Installing IDE Server 17:28:58 INFO - Executing "C:\Users\THIAGO~1.SOU\AppData\Local\Temp\Formspider20141tmp\ide_db\type.sql" 17:28:58 INFO - *INSTALLATION FAILED* 17:28:58 INFO - Exception stack trace: ORA-02303: cannot drop or replace a type with type or table dependents

Should i try manually drop objects?

Kind Regards


(17 Nov '14, 14:36) tgalante

Hi Thiago,

You can certainly manually drop the objects but the thing is there are apparently dependent objects to this type. So if you also drop the dependent objects (or columns) and make sure you recreate them after the Formspider IDE installation is completed, it should all work.

Alternatively, you can simply drop the entire schema and the Tomcat. Then run the installer again (re-download it if you can, your trial will last longer) and make sure that the IDE check box is checked this time. This might be a faster way to get it all working.

Kind Regards, Yalim

(18 Nov '14, 06:30) Yalim ♦♦

Hi Thiago, How did you decide to progress? Were you able to install Formspider successfully?

(19 Nov '14, 09:43) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 14 Nov '14, 14:55

Seen: 2,918 times

Last updated: 19 Nov '14, 09:43

© Copyright Gerger 2017