+1
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.
+15
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) > 30I 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.
+20
Hi
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.