We are on SCM 5.0, with Oracle database and Linux OS.
We extract the data out of Planning area for releasing the forecast to a diff system. So we have a program which extract the data out of LC and puts in Appln server. So far it has been fine running this batch job (few years). Now i am running into this errors.
I know this is a BASIS issue. But our Basis suggests to me to decrease the data volume. Which is not possible as per business needs. We get this error even in the pl books, if we drill down by 2 chars.. I believe we have 10 or 11 GB LC memory. I am also confused this with LC memory or OS memory this error pertaining to ?
What exactly needs to be done ? Is it profile parameters adjustment / increasing the memory/ OS adjustments / Internal tables/ increasing the memory cap for user sessions ?
Can anyone help me if one faced this similar situation ? Pls don't tell me to talk to our BASIS. He is out of ideas, i guess.