In current version, you can't do it from UI, just from the DB as you did.
However, you need to be aware that changing that in the DB is not supported and you may have issues when working with FDMEE as some tables have data based on LOADID column.
I'm going to conduct maintenance tasks which will clear FDMEE DB and directories and next to change process id.
Because I'm running batch every 5 minutes and Process ID is very high.
Okay, I get it. Just so you know, I've never encountered an issue where the Process ID reached some sort of limit. So, while you see tons of process detail entries for your batches (whether there are files or not for a given batch), you should be okay just leaving things as is.
A couple of other things to consider and I'll get off my soapbox. If you reset the process ID value, won't that cause some discrepancies with the process detail logs associated with IDs you've cleared out? You also have other tables that reference the PROCESS_ID field, e.g. AIF_PROCESSES, AIF_PROCESS_DETAILS, and AIF_BATCH_LOAD_AUDIT. If you reset the counter you may also have to clear out the corresponding info in other tables otherwise you may encounter problems.
Okay, I'm done with my rant.
Good luck! Let us know how it goes.
What version of Hyperion including patch level) are you on?
What errors are you seeing that require you to take such actions?
Had you sought to open an Oracle SR and Oracle gave you such advice...?
If it maintenance procedures, then in the later version (220.127.116.11.2XX)of the software Oracle did provide certain scripts to allow for such.
As others have mentioned/cautioned you certainly want to be careful of just going about and deleting items from your tables as you run the risk of corrupting your model.
>I've never encountered an issue where the Process ID reached some sort of limit
How high value reached process id, do you remember?
Regarding other tables using process id, the Administrator's Guide Release 18.104.22.168.200, chapter or appendix 'H Purge Scripts' describes System Maintenance Tasks scripts which maintain tables and directories.
I've tested on the TEST env and I haven't noticed any problems.
- Running script (via UI) from System Maintenance Tasks generate new process id
- Maintain Application Folder script can not delete own process id log , in my opinion better way to backup / remove etc. is robocopy command
Are you scheduling an open batch?
Scheduling with high frequency is not recommended until Oracle adds a more intelligent way of managing open batch when there are no source files.
The best approach would be to create an external batch file which seeks for files and run the openbatch with runbatch.bat/sh utility when files are found.
>The best approach would be to create an external batch file which seeks for files and run the openbatch with runbatch.bat/sh utility when files are found.
I went above described way + windows scheduler.
Why? Because, the highest frequency accessible in FDMEE UI is 30 or 15 minutes (I don't remember)