Skip to main content

IFS Apps 10 Update 15 LIVE Database. 

 

We are running backgrounds Jobs - and one of the jobs is showing a Warning. This jobs is for Heavy Clean up - and error is showing has failed due to Value too large for Column IFSAPP. (Please see attached image) 

 

Would this be slowing down the performance of  IFS. Is there anything we can do to clear this warning. 

 

@Sarfraz Hussain it seems your DB version supports table names which are 30 bytes → 30 characters.

Somehow you have a table in the DB that is 31 characters long. Would this be due to some modification/customization?

 

If you have db access you could check what that table is by querying security_sys_privs_tab

select *
from security_sys_privs_tab
where length(table_name) > 30

I just checked in an IFS Cloud DB and there doesn’t seem to be anything with length > 30. So I guess in your case it must come from some CRIM.

 

Hi @Sarfraz Hussain 

IFS has a limitation where the object names should be less to 30 characters. In the IFS development tools, this is safeguarded via the developer studio where you can’t mention a Entity name longer than 26 characters.

 

Check your database to see what table is causing this

select * from ALL_TABLES
where owner = 'IFSAPP' --or APPOWNER if it differes from IFSAPP
AND length(TABLE_NAME) > 30
AND TABLE_NAME LIKE '%TAB'

 

Then you could find which table causing this.

 

Hope it helps!

Damith

Reply


Terms & ConditionsCookie settings