hello ,

i'm trying to install formspider and

i'm getting the below failure error while installing formsspider

  • ORA-00990: missing or invalid privilege

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:743) oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614) oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579) com.bui.installer.tasks.EngineInstallTask.grantPrivsToEngineUser(EngineInstallTask.java:252) com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:101) 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(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source)

kindly advice.

thanks,

asked 09 Nov '11, 16:41

gmajdalani's gravatar image

gmajdalani
111
accept rate: 0%


12next »

Hi,
I am truly sorry that your Formspider installation failed. To guess the reason of the failure, can you plase send us previous part of the installation log.

link

answered 10 Nov '11, 05:09

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

hi thanks for the prompt reply below is the installation log

16:33:06 INFO - ---------------------------------- 16:33:06 INFO - Gathering available tablespace size 16:33:06 INFO - Tablespace name: USERS 16:33:07 INFO - File ID: 4 16:33:07 INFO - Autoextensible: true 16:33:07 INFO - Bytes: 813957120 16:33:07 INFO - Max Bytes: 34359721984 16:33:07 INFO - Blocks: 99360 16:33:07 INFO - Increment_by: 160 16:33:07 INFO - Free Bytes: 49020928 16:33:07 INFO - Available space: 33594785792 16:33:07 INFO - Finished gathering available tablespace size 16:33:07 INFO - ---------------------------------- 16:33:07 INFO - ---------------------------------- 16:33:07 INFO - Gathering available tablespace size 16:33:07 INFO - Tablespace name: SYSTEM 16:33:07 INFO - File ID: 1 16:33:07 INFO - Autoextensible: true 16:33:07 INFO - Bytes: 597688320 16:33:07 INFO - Max Bytes: 34359721984 16:33:07 INFO - Blocks: 72960 16:33:07 INFO - Increment_by: 1280 16:33:07 INFO - Free Bytes: 73007104 16:33:07 INFO - Available space: 33835040768 16:33:07 INFO - Finished gathering available tablespace size 16:33:07 INFO - ---------------------------------- 16:34:02 INFO - *INSTALLATION STARTED* 16:34:02 INFO - ---------------------------------- 16:34:02 INFO - Started Installing Tomcat 16:34:02 INFO - Creating directory: "C:Program FilesGergerFormspider Serverapache-tomcat-6.0.29" 16:34:02 INFO - Extracting Tomcat installation files 16:34:03 INFO - Configuring tomcat-users.xml file. 16:34:04 INFO - Configuring server.xml file 16:34:04 INFO - Tomcat is succesfully installed 16:34:04 INFO - ---------------------------------- 16:34:04 INFO - Started installing engine 16:34:04 INFO - Oracle version: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod 16:34:04 INFO - Creating Engine user 16:34:04 INFO - SQL statement is "create user FORMSPIDER identified by default tablespace USERS" 16:34:04 INFO - Granting priviliges to Engine user 16:34:04 INFO - engine install fail debug 16:34:04 INFO - *INSTALLATION FAILED**** 16:34:04 INFO - Exception stack trace: ORA-00990: missing or invalid privilege

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:743) oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614) oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579) com.bui.installer.tasks.EngineInstallTask.grantPrivsToEngineUser(EngineInstallTask.java:252) com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:101) 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(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source)

16:34:05 INFO - Rolling back changes 16:34:13 INFO - Roll back finished

link

answered 10 Nov '11, 07:36

gmajdalani's gravatar image

gmajdalani
111
accept rate: 0%

It seems your database version is 10.1.0.2.0 and Formspider supports 10.2 and higher versions (Please see "System Requirements" part on download page). I must confess that it should have given a more friendly error message. We will add this validation on next bulits.

link

answered 14 Nov '11, 13:39

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

edited 14 Nov '11, 13:41

Hi.. Is this version of formspider supported with Oracle 11g XE. After the instalation, it fails when i tried to open the IDE. Thanks..

link

answered 15 Nov '11, 05:36

carriagada's gravatar image

carriagada
7238
accept rate: 0%

Hi, Thank you very much for your feed back. Does it give any error message? Can you please add more details about the problem and your enviroment (java version, Operating System)

(15 Nov '11, 05:53) Ugur Kocak ♦

This is the error: ORA-06550: line 1, column 13: PLS-00905: object FORMSPIDER.DS_35 is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored

I can not recompile the object.

OS Version: Windows Seven: DB Version: 11g XE Java Version: JDK 1.7

Thanks..

link

answered 15 Nov '11, 06:06

carriagada's gravatar image

carriagada
7238
accept rate: 0%

Can you please check why FORMSPIDER.DS_35 package is invalid? Is there a missing object? Please send package source if it is not obvious.

link

answered 15 Nov '11, 07:05

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

when i compile it the error is: PLS-00201: identifier 'DSI_35' must be declared

I have not this table in my schemma.

link

answered 15 Nov '11, 07:14

carriagada's gravatar image

carriagada
7238
accept rate: 0%

08:16:50 INFO - ---------------------------------- 08:16:50 INFO - Gathering available tablespace size 08:16:50 INFO - Tablespace name: SYSTEM 08:16:50 INFO - File ID: 1 08:16:50 INFO - Autoextensible: true 08:16:50 INFO - Bytes: 377487360 08:16:50 INFO - Max Bytes: 629145600 08:16:50 INFO - Blocks: 46080 08:16:50 INFO - Increment_by: 1280 08:16:50 INFO - Free Bytes: 9306112 08:16:50 INFO - Available space: 260964352 08:16:50 INFO - Finished gathering available tablespace size 08:16:50 INFO - ---------------------------------- 08:18:59 INFO - *INSTALLATION STARTED* 08:18:59 INFO - ---------------------------------- 08:18:59 INFO - Started Installing Tomcat 08:18:59 INFO - Creating directory: "C:Program FilesGergerFormspider Serverapache-tomcat-6.0.29" 08:18:59 INFO - Extracting Tomcat installation files 08:19:00 INFO - Configuring tomcat-users.xml file. 08:19:01 INFO - Configuring server.xml file 08:19:01 INFO - Tomcat is succesfully installed 08:19:01 INFO - ---------------------------------- 08:19:01 INFO - Started installing engine 08:19:01 INFO - Oracle version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production 08:19:01 INFO - Creating Engine user 08:19:01 INFO - SQL statement is "create user FORMSPIDER identified by *** default tablespace SYSTEM" 08:19:01 INFO - Granting priviliges to Engine user 08:19:01 INFO - Extracting installation scripts 08:19:01 INFO - Executing installation scripts 08:19:01 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbtype.sql 08:19:02 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbtable.sql 08:19:13 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbtable_data.sql 08:19:17 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbref_constraint.sql 08:19:23 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbsequence.sql 08:19:23 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbpackage_spec.sql 08:19:54 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbview.sql 08:19:57 INFO - Schema FORMSPIDER has 70 invalid objects: API_ACCORDIONPANEL API_ALERT API_COLOR API_DATASOURCE API_DIALOG API_FRAME API_LOV API_PANEL API_RECORDLIST API_TABBEDPANEL API_TREE API_TREENODE API_XMLEDITOR BDF_ACCORDIONPANEL_MNG BDF_ACCORDIONPANEL_XML BDF_ALERT_ETL BDF_ALERT_MNG BDF_ALERT_QRY BDF_ALERT_XML BDF_APPLICATION_ETL BDF_APPLICATION_MNG BDF_APPLICATION_QRY BDF_APPLICATION_XML BDF_BUTTONGROUPINS_QRY BDF_BUTTONGROUP_ETL BDF_BUTTONGROUP_MNG BDF_BUTTONGROUP_QRY BDF_BUTTONGROUP_XML BDF_DATASOURCEDEF_QRY BDF_DBOBJECTACCESSINS_QRY BDF_DBOBJECTACCESS_MNG BDF_DBOBJECTACCESS_QRY BDF_DBOBJECTACCESS_XML BDF_DIALOG_MNG BDF_DIALOG_QRY BDF_DIALOG_XML BDF_DOMAIN_XML BDF_EXTERNALMETHOD_MNG BDF_EXTERNALMETHOD_QRY BDF_EXTERNALMETHOD_XML BDF_GRID_MNG BDF_GRID_XML BDF_MAINFRAME_MNG BDF_MAINFRAME_QRY BDF_MAINFRAME_XML BDF_MENUBAR_MNG BDF_MENUBAR_QRY BDF_MENUBAR_XML BDF_MENUITEM_MNG BDF_MENUITEM_QRY BDF_MENUITEM_XML BDF_PANELDTLINS_QRY BDF_PANELDTL_MNG BDF_PANELDTL_QRY BDF_PANELDTL_XML BDF_PANELINS_QRY BDF_PANEL_MNG BDF_PANEL_QRY BDF_PANEL_XML BDF_POPUPMENU_MNG BDF_POPUPMENU_QRY BDF_POPUPMENU_XML BDF_RECORDLISTINS_QRY BDF_RECORDLISTSEARCH_QRY BDF_RECORDLIST_MNG BDF_RECORDLIST_QRY BDF_RECORDLIST_XML BDF_SPLITPANEL_MNG BDF_TABBEDPANEL_MNG BDF_WINDOWINS_QRY

08:19:57 INFO - Recompiling FORMSPIDER 08:20:05 INFO - Recompile completed 08:20:05 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbprocedure.sql 08:20:06 INFO - Schema FORMSPIDER has 1 invalid objects: BDF_DELETE_OLDSESSIONS

08:20:06 INFO - Recompiling FORMSPIDER 08:20:06 INFO - Recompile completed 08:20:06 INFO - C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbpackage_body.sql 08:21:16 INFO - Started registring Xsd 08:22:12 INFO - Finished registring Xsd 08:22:12 INFO - Recompiling FORMSPIDER 08:22:12 INFO - Recompile completed 08:22:12 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpengine_dbpostInstall.sql" 08:22:13 INFO - Engine is successfully installed 08:22:13 INFO - ---------------------------------- 08:22:13 INFO - Installing IDE Server 08:22:13 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbtype.sql" 08:22:13 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbtable.sql" 08:22:14 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbtable_data.sql" 08:22:14 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbsequence.sql" 08:22:14 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbpackage_spec.sql" 08:22:18 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbview.sql" 08:22:21 INFO - Schema FORMSPIDER has 41 invalid objects: BDF_IDE_ALERT_QRY BDF_IDE_APPLICATION_QRY BDF_IDE_ARCHIVE_QRY BDF_IDE_BUTTONGROUP_QRY BDF_IDE_DATASOURCEDEF_QRY BDF_IDE_DATASOURCE_QRY BDF_IDE_EXTERNALMETHOD_QRY BDF_IDE_INTERFACE_PKG BDF_IDE_MENU_QRY BDF_IDE_PANEL_QRY BDF_IDE_RECORDLIST_QRY BDF_IDE_SUPPORT BDF_IDE_TREE_PKG BDF_IDE_USER_QRY BDF_IDE_WINDOW_QRY BDF_IDE_ACTIONUSAGE BDF_IDE_APPLICATION BDF_IDE_APPLICATION_ID BDF_IDE_APPLICATION_II BDF_IDE_APPLICATION_IU BDF_IDE_DATASOURCE BDF_IDE_DATASOURCE_IU BDF_IDE_DATASOURCE_ID BDF_IDE_DATASOURCE_II BDF_IDE_DATASOURCEDEF BDF_IDE_DATASOURCEDEF_U BDF_IDE_DATASOURCEDEF_I BDF_IDE_DATASOURCEDEF_D BDF_IDE_DATASOURCEDEFATRIB_D BDF_IDE_DATASOURCEDEFATRIB_I BDF_IDE_DATASOURCEDEFATRIB_U BDF_IDE_DATASOURCEDEFBINDVAR_D BDF_IDE_DATASOURCEDEFBINDVAR_I BDF_IDE_DATASOURCEDEFBINDVAR_U BDF_IDE_DATASOURCEDEFCOMMIT BDF_IDE_DATASOURCEDEFCOMMIT_II BDF_IDE_DATASOURCEDEFDML_IU BDF_IDE_DATASOURCEDEFPK_IU BDF_IDE_LANGUAGE_D BDF_IDE_LANGUAGE_I BDF_IDE_LANGUAGE_U

08:22:21 INFO - Recompiling FORMSPIDER 08:22:22 INFO - Recompile completed 08:22:22 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbprocedure.sql" 08:22:22 INFO - Recompiling FORMSPIDER 08:22:22 INFO - Recompile completed 08:22:22 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbpackage_body.sql" 08:22:52 INFO - Recompiling FORMSPIDER 08:22:52 INFO - Recompile completed 08:22:52 INFO - Reloading IDE application 08:22:52 INFO - Executed SQL statement is "create table t_temp_application (v_xml_cl clob) " 08:22:52 INFO - Reading "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbFormspider IDE Reload ApplicationFormspider IDE Application.xml" 08:22:56 INFO - Read complete 08:22:56 INFO - Inserting application xml into t_temp_application 08:22:57 INFO - Executing "C:UsersCARRIA~1AppDataLocalTempFormspider8042227657201912377tmpide_dbFormspider IDE Reload ApplicationFormspider IDE Reload Application.sql" 08:23:55 INFO - IDE application is succesfully reloaded 08:23:55 INFO - Schema FORMSPIDER has 40 invalid objects: P_1195 P_1196 P_1199 P_1200 P_1202 P_1205 P_1206 P_1208 P_1209 P_1212 P_1220 P_1226 P_1227 P_1228 P_1243 P_1244 P_1250 P_1251 P_1252 P_1267 P_1276 P_1288 P_1289 P_1291 P_1305 P_1321 DS_31 DS_31 DS_32 DS_32 DS_33 DS_34 DS_35 DS_36 DS_37 DS_38 DS_39 DS_40 DS_41 DS_42

08:23:55 INFO - Recompiling FORMSPIDER 08:23:57 INFO - Recompile completed 08:23:57 INFO - Schema FORMSPIDER has 40 invalid objects: P_1195 P_1196 P_1199 P_1200 P_1202 P_1205 P_1206 P_1208 P_1209 P_1212 P_1220 P_1226 P_1227 P_1228 P_1243 P_1244 P_1250 P_1251 P_1252 P_1267 P_1276 P_1288 P_1289 P_1291 P_1305 P_1321 DS_31 DS_31 DS_32 DS_32 DS_33 DS_34 DS_35 DS_36 DS_37 DS_38 DS_39 DS_40 DS_41 DS_42

08:23:57 INFO - IDE Server is succesfully installed 08:23:57 INFO - ---------------------------------- 08:23:57 INFO - Tomcat Version: 6.0.20 08:23:58 INFO - Extracting Formspider Middletier application 08:24:01 INFO - Configuring context file 08:24:01 INFO - Engine resource name is formspider_ds 08:24:01 INFO - Copying files to Tomcat webapps directory 08:24:01 INFO - ---------------------------------- 08:24:01 INFO - Installing IDE Client 08:24:01 INFO - Executed command is ""C:UserscarriagadaAppDataLocalTempFormspider8042227657201912377tmpide_clientformspider_ide_installer.exe" /application.url=http://127.0.0.1:8081/formspider/ /application.startApplication.name=FormspiderIDE /application.installation.folder=FormspiderIDE" 08:24:16 INFO - IDE Client installation is completed 08:24:16 INFO - ---------------------------------- 08:24:20 INFO - ---------------------------------- 08:24:20 INFO - Starting Tomcat 08:24:21 INFO - Tomcat is succesfully started 08:24:21 INFO - ---------------------------------- 08:24:21 INFO - *INSTALLATION COMPLETED*

link

answered 15 Nov '11, 07:29

carriagada's gravatar image

carriagada
7238
accept rate: 0%

I suspect it is a tablespace issue. Can you run the script below in Formspider schema:

begin
  bdf_datasourcedef_gen.datasettablecreateorreplace(35);
end;

link

answered 15 Nov '11, 07:41

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

Thanks.. I will set automatically extend the tablespace SYSTEM and perform a new clear install.

link

answered 15 Nov '11, 08:15

carriagada's gravatar image

carriagada
7238
accept rate: 0%

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:

×1

Asked: 09 Nov '11, 16:41

Seen: 6,741 times

Last updated: 15 Mar '12, 07:28

Related questions


© Copyright Gerger 2017