Tag Archives: JSP Check

Insufficient privileges for cloning

Problem:

When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:

You have insufficient privileges for the current operation. Please contact your System Administrator.

Solution:

Used URL:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.

In Metalink, searched for error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Checked document: Subject:  Troubleshooting Login (Doc ID:  Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”

In SQL*Plus, executed the following code:

select SESSION_COOKIE_DOMAIN from icx_parameters;

update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;

commit;

select SESSION_COOKIE_DOMAIN from icx_parameters;

Tested logon on ebusinesstest, working now.

Reference:

Subject:  Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID:  Note:177095.1)

Recreating DBC file

Problem: While installing vision instance, the post-install check “JSP Check” fails with the message “DBC file may be invalid”.

Solution: Recreate DBC file.

Note: Run these commands from $FND_TOP/secure. Also, source environment file first.

To create a DBC file and server ID:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=vis SECURE_PATH=%FND_TOP%secure GUEST_USER_PWD=guest/guest APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=eam.clientnetwork.com DB_PORT=1522

To check status:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis STATUS DB_HOST=eam.clientnetwork.com DB_PORT=1522

To delete DBC file:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis DELETE DB_HOST=eam.clientnetwork.com DB_PORT=1522

Also, you can run adgendbc.sh, located in $COMMON_TOP/admin/install/

For Database Connectivity problems, ensure that the hosts file is set up properly:

127.0.0.1 localhost.localdomain localhost
hostname.domainname hostname

On Windows, use java. On Linux/Unix, use JRE.

Reference:
Metalink Doc ID: 108865.1 (How To Create a Database Connection(DBC) File and Troubleshooting Common Problems)