oracle.jdbc.driver.LogicalConnection@67149d
java.sql.SQLException: ORA-01653: unable to extend table FORMSPIDER.T_BDF_WEBSESSIONLOG by 128 in tablespace USERS
ORA-06512: at "FORMSPIDER.BDF_WEBSESSIONLOG_API", line 22
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2046
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2242
ORA-01653: unable to extend table FORMSPIDER.T_BDF_WEBSESSIONLOG by 128 in table space USERS
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2359
ORA-06512: at line 1

These are the errors that my tomcat command line states. I cannot use shutdown.bat, it won't work. I have to close it manually. Formspider IDE gives me a popup message that says "An error occurred. Please contact your system administrator." I can open the API doc just fine.
Could you please help me?

asked 25 Jan '14, 06:12

Mazzel's gravatar image

Mazzel
31215
accept rate: 0%

edited 25 Jan '14, 06:13


Hi Mazzel,

It seems like your USERS tablespace is full, you should resize its datafile or add a new datafile for this tablespace. You can find more details about how to do this in the following documentation:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423

The t_bdf_websessionlog is a table holding all requests made to Formspider for a limited time period specified in bdf_setup table, you can check this value using this following query:

select value_tx from bdf_setup where var_cd = 'WebSessionLogDuration'

Note that the returned value is day based. For instance, if this value is 1, Formspider clears all logs belonging to closed apps after 1 day of their creation. You can always disable this logging mechanism by setting 0 as the WebSessionLogDuration value in bdf_setup table.

Hope this helps,
Ibrahim

link

answered 25 Jan '14, 07:00

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Alright, thanks! I will check on this on Wednesday as my work mate will be back by then. I don't have the credentials to connect to the right db schema.

(25 Jan '14, 08:14) Mazzel
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:

×44
×9
×2
×1

Asked: 25 Jan '14, 06:12

Seen: 2,679 times

Last updated: 25 Jan '14, 08:14


© Copyright Gerger 2017