Skip to main content
Solved

Business Reporter error related to Zoom In

  • November 14, 2021
  • 1 reply
  • 241 views

Forum|alt.badge.img+10

Hi,

Did anyone face such error when performing Zoom In function in a BR report?

The Oracle error "-1691" occurred when inserting report data into the report table - " unable to extend lob segment IFSAPP.SYS_LOB0000070775C00005$$ by 1024 in tablespace IFSAPP_LOB"
 

That’s a quite simple report that queries the GL Project Transaction aggregating values by Code C for a specific project and specific period. If i try to zoom in it generally produce this errors, however it actually worked a few times with some lines. It seems that it works if only very few data are within the Zoom In (= only few lines).

Best answer by ludovic.rougean

Ok solved.

Actually it was a real Oracle server problem as the message suggests. The tablespace IFSAPP_LOB was full. IT department emptied it and “added a datafile on the tablespace”. Not sure what it means, but it’s now working fine.

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 61 replies
  • Answer
  • November 16, 2021

Ok solved.

Actually it was a real Oracle server problem as the message suggests. The tablespace IFSAPP_LOB was full. IT department emptied it and “added a datafile on the tablespace”. Not sure what it means, but it’s now working fine.