There could be many causes - search MOS for "java.sql.SQLException: Exhausted Resultset publisher" and you will find some hits - see if any of them are applicable
i located the problem but i couldn't correct it, i followed a note (Doc ID 740529.1), i found the hostname different from the name recuperated in the opp
OPP Host addr: ERP_1
Please how can i correct the problem?
my problem is not resolved, please how can i change the configuration of opp hostname adress to erp1 not ERP_1
Login with SYSTEM ADMINISTRATOR Responsibility.
Navigate to Concurrent > Manager > Define
Query for OPP and remove the Node Entry and Save.
Navigate to Concurrent > Manager > Administer
Click on Verify Button.
when i navigated to Navigate to Concurrent > Manager > Define and query for opp i found the server erp1 i didn't know where it gets ERP_1? i searched on the internet and i found its related to the configuration of the network (the value returned by InetAddress.getLocalHost().getHostName().toUpperCase(); ) where should i exactly do the modification to correct the name returned by InetAddress.getLocalHost().getHostName().toUpperCase();?
check your /etc/hosts file.
i think that the value mentionned in file /etc/hosts is returned by hostname no? i search to change the adress returned by InetAddress.getLocalHost().getHostName().toUpperCase(); i didn't know where can i change it?
please share the contents of following files
1 person found this helpful
in hosts, i have:
10.10.10.112 erp_1 erp1.ommp.nat.tn 10.10.10.113 erp_2 erp2 10.10.10.118 db_ports_1 10.10.10.119 db_ports_2 10.10.10.131 prod1 10.10.10.132
in resolve.conf, i have:
nameserver 192.168.1.2 nameserver 192.168.1.4
when i tried to change the erp_1 to erp1 and excuted the java function, it returns erp1 but when i tried to connect to the oracle EBS, i have an error :
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, email@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
should i make changes in other files?
Shutdown all your Application Services.
Change the values in /ets/hosts file like
10.10.10.112 erp1.ommp.nat.tn erp1
188.8.131.52 localhost.localdomain localhost
Execute AutoConfig on APPS Tier
start the Application Services.
thanks a lot, the problem is resolved
Please mark your problem as Answered and Helpful.