Skip to main content
Solved

DOCUMENT MANAGEMENT ERROR WHILE UPLOADING IFS10

  • April 17, 2024
  • 2 replies
  • 183 views

zuhaib
Sidekick (Customer)
Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 78 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

 

2 replies

Forum|alt.badge.img+15
  • Superhero (Employee)
  • 180 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)
  • 2903 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.