Skip to main content
Solved

DOCUMENT MANAGEMENT ERROR WHILE UPLOADING IFS10

  • April 17, 2024
  • 2 replies
  • 135 views

zuhaib
Sidekick (Customer)
Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 76 replies

UPLOAD DOCUMENT IN DOCUMENT REVISION WINDOW ERROR IS SHOW SCREENSHOT IS ATTACHED THANKS IN ADVANCE.

 

 

Best answer by Sahan Udana

@zuhaib 

Based on the error I suspect this is occurring due to tablespace IFSAPP_LOB does not have enough space in the database.

Please try the below query in the database and see if you have enough storage.

select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files 
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments 
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name

If not enough space there. Please try according to the below post to resolve the issue

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+14
  • Superhero (Employee)
  • 169 replies
  • Answer
  • April 17, 2024

@zuhaib 

Based on the error I suspect this is occurring due to tablespace IFSAPP_LOB does not have enough space in the database.

Please try the below query in the database and see if you have enough storage.

select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files 
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments 
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name

If not enough space there. Please try according to the below post to resolve the issue

 


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2824 replies
  • April 17, 2024

SAHAN IS ASKING POLITELY, I WILL NOT 🙂 THE LOB TABLE SPACE IS OUT OF SPACE/DISK/STORAGE AND NEEDS TO BE EXTENDED.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings