Hi. This is the error when i try to install formspider. Thanks in advance

1- ORA-04063: package body "FORMSPIDER.BDF_SUPPORT" has errors ORA-06508: PL/SQL: could not find program unit being called: "FORMSPIDER.BDF_SUPPORT" ORA-06512: at "FORMSPIDER.BDF_USER_API", line 37 ORA-06512: at line 3

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726) oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696) com.bui.installer.util.SQLScriptRunner.executeLine(SQLScriptRunner.java:136) com.bui.installer.util.SQLScriptRunner.execute(SQLScriptRunner.java:71) com.bui.installer.tasks.EngineInstallTask.handlePostInstallation(EngineInstallTask.java:221) com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:163) com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:76) com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194) org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276) java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) java.util.concurrent.FutureTask.run(FutureTask.java:166) org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) java.lang.Thread.run(Thread.java:722)

asked 22 Aug '12, 09:47

carriagada's gravatar image

carriagada
7235
accept rate: 0%


Formspider installer assumes that execution privilege of DBMS_RANDOM package is granted to public. According to the installer logs, I think execution privilege of DBMS_RANDOM package is not granted to public in your Database.

We will add the privilege to the installer for the next release. So, installer will not fail.

In order to install Formspider in your Database now, I recommend you below steps:

  1. Grant execute on DBMS_RANDOM to public
  2. Install Formspider
  3. Grant execute on DBMS_RANDOM to Formspider
  4. Revoke execute on DBMS_RANDOM from public
link

answered 23 Aug '12, 23:39

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

Hi,

Could you please send the instalation log file to contact(AT)theformspider.com? You can find it in "Formspider Installation Logs" folder under OS user directory.

link

answered 22 Aug '12, 11:49

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

Hi. I have sent you a copy of the log. Thanks.

link

answered 23 Aug '12, 04:48

carriagada's gravatar image

carriagada
7235
accept rate: 0%

Hi Ugur. The installation process has finished ok now. The problem was with the privileges, as you say. Thanks very much for your assistance. Best regards.

Claudio Arriagada.

link

answered 24 Aug '12, 06:14

carriagada's gravatar image

carriagada
7235
accept rate: 0%

Hi,

after getting the error mentioned above (ORA-04063) I gave the grant for 'execute' of dbms_random to public and tried to reinstall, but I got the same error. How to deal with it. (I have sent the report about the error).

Best regards Hans Danzl

link

answered 04 Dec '12, 02:33

hda's gravatar image

hda
111
accept rate: 0%

Hi Hans,

Can you please send the new log file to contact(AT)theformspider.com ?

(04 Dec '12, 08:47) Ugur Kocak ♦

Hi Hans,

We could not find the report in our case management system. It is possible that it got filtered by gmail's spam filter by mistake. Could you please send the report about the error to contact@theformspider.com

Kind Regards, Yalim

(04 Dec '12, 08:50) Yalim K. Gerger ♦♦

Many thanks to the formspider team: For a successfull installation I had to - create a public synonym for package htp - grant execute on htp to public. Kind Regards Hans

(10 Dec '12, 23:55) hda
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×43

Asked: 22 Aug '12, 09:47

Seen: 1,931 times

Last updated: 10 Dec '12, 23:55


© Copyright Gerger 2017