Skip to main content

Hello IFS Community!

A script to enable History Logging on just about every table has been executed in an IFS Cloud 24R1 SU9 environment per the request of the business. I’ve been collecting table exceptions to disable for general system processing purposes, but I've encountered one that has me stumped currently.

When on a form that presents a List element, normally users have the option to export the data from that List element to Excel. Currently, this History Logging is preventing users from successfully exporting this data. My question to the Community is what table is this data being (presumably) temporarily being inserted to before the data is aggregated into an Excel format and being passed back to the client machine?

Here’s the error message stack and some screen captures illustrating the issue.

Any help or guidance would be greatly appreciate.

Regards,

Randy

Error Message:

IFS Web Version: 24.1.14.20250702093228.0
Date: 2025-08-13T15:02:55.485Z

---------------------------------------------------------------------------

Customers/List (server error)
An internal server error occurred. Contact administrator.
Error details: l{"message":"Failed to add parameters"},{"code":20124,"message":"ORA-20124: Error.NULLVALUE: Field eUSERNAME] is mandatory for History Log and requires a value."}]

Request Id: 7d08ca8f-7e1c-4ed8-a87a-6d437a537958
Url: https://xxx.xxxx.com/main/ifsapplications/extensions/exportxlsx/v1

---------------------------------------------------------------------------
 

 

Hi

 

Already reported to IFS via CS0423121 ticket

Hi Piotr, thank you for providing the case number. When I try to search for it in the Service Center, I don’t get any results back. Would you be so kind as to copy the contents of the case notes and paste them here as a reply, please?

You should see the number of hits but with empty list of tickets because of its unavailability to You.

My ticket has priority 2 so I expect to be rosolved with upcomming SU.

Ah OK, so this is a known issue that you are tracking with a case currently that has not been published to the public, I presume then. I do indeed see an empty list with a hit-count of 1 when looking on the Service Center.

Well thank you again Piotr, best of luck with IFS support in resolving it.

Regards,

Randy

Hello!

I was able to identify the table after (temporarily) modifying some database source code in the HISTORY_LOG_API. The offending table in this instance was EXCEL_PARAMETER_CACHE_TAB. Disabling History Logging for it allowed the exporting of data to Excel from List elements in IFS to proceed.

​@knepiosko - you might look and see if that table has History Logging enabled and see if disabling it helps out with your issue.

Regards,

Randy

Reply


Terms & ConditionsCookie settings