+9Hi Community,
I face below error while searching in a window in test environment, please help how to resolve this.
Things I have done:
details of error message:
Thanks in advance.
Best answer by Imal Thiunuwan
Hello
If this is APPS10, could you please try below steps?
a. Log into the “IFS Middleware Server Admin Console” as “ifs” user.
b. Then navigate into Main Cluster -> Data Sources -> Control
C. Click on the ‘Plsql-Access’ row and click ‘Restart’
d. After that, restart the application. and check if the issue is still available.
In Apps9, you need to follow the same steps for the data source value.
Cheers!
+16Hello
If this is APPS10, could you please try below steps?
a. Log into the “IFS Middleware Server Admin Console” as “ifs” user.
b. Then navigate into Main Cluster -> Data Sources -> Control
C. Click on the ‘Plsql-Access’ row and click ‘Restart’
d. After that, restart the application. and check if the issue is still available.
In Apps9, you need to follow the same steps for the data source value.
Cheers!
+9Hello
If this is APPS10, could you please try below steps?
a. Log into the “IFS Middleware Server Admin Console” as “ifs” user.
b. Then navigate into Main Cluster -> Data Sources -> Control
C. Click on the ‘Plsql-Access’ row and click ‘Restart’
d. After that, restart the application.
In Apps9, you need to follow the same steps for the data source value.
Cheers!
Hi Imal,
thank you for this new method to me.
Current issue is in app 9.
I have resolved it by giving access user to the view..
Suggest whether is this ok nor not..?
now it is working fine
+16Hello
Glad to hear that the issue has been resolved. Since the issue was resolved after providing required permissions, I think that is not related to a data source issue (user sessions issue) 
If you get such issue in future, kindly try the steps that I mentioned above as well (If you cannot figure out the exact error). Those steps can be used if there are no known errors with user sessions in the Database end but in the IEE.
Hope this is clear with you :)
Cheers!
+9Hello
Glad to hear that the issue has been resolved. Since the issue was resolved after providing required permissions, I think that is not related to a data source issue (user sessions issue) If you get such issue in future, kindly try the steps that I mentioned above as well (If you cannot figure out the exact error). Those steps can be used if there are no known errors with user sessions in the Database end but in the IEE.
Hope this is clear with you :)
Cheers!
Sure Imal,
Thank you so much for the help
Regards,
Hari
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.