Fix (APAR): JR25410 Status: Fix Release: 6.0.1.2 Operating System: AIX,HP-UX,Linux,Solaris,Windows,z/OS Supersedes Fixes: CMVC Defect: JR25410 Byte size of APAR: 142269 Date: 2007-02-28 Abstract: Static relationship cannot be found after reinstalled application on Oracle Description/symptom of problem: JR25410 resolves the following problem: ERROR DESCRIPTION: Static relationship cannot be found after reinstalled application on Oracle. LOCAL FIX: NA PROBLEM SUMMARY USERS AFFECTED: WebSphere Process Server 6.0.1.x users working with Oracle 10.1.0.4 with Static Relationships PROBLEM DESCRIPTION: Static relationship cannot be found after reinstalled application on Oracle RECOMMENDATION: None This issue will occur when we try to install an application on WPS 6.0.1.2 which has static relationships on Oracle 10.1.0.4 with Solaris 9 Operating system. PROBLEM CONCLUSION: This issue will be resolved by applying JR25410 and is integrated in to all the higher versions Directions to apply fix: Before applying the iFix ensure that WebSphere Process Server 6.0.1 is installed on the system. Also download and follow Update Installer installation instructions. The Update Installer can be downloaded from the following link: http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991 1) Copy the pak file to the directory maintenance in the UpdateInstaller directory 2) Shutdown WebSphere Process Server. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix. 3) Run the UpdateInstaller and follow the prompts. 4) Restart WebSphere Directions to remove fix: NOTE: FIXES MUST BE REMOVED IN THE REVERSE ORDER IN WHICH THEY WERE APPLIED. DO NOT REMOVE A FIX UNLESS ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED. YOU MAY REAPPLY ANY REMOVED FIX. Example: If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be removed, fix3 must be removed first, then fix2 may be removed 1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix. 2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix. 3) Restart WebSphere Directions to re-apply fix: 1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix. 2) Run the UpdateInstaller and follow the instructions. The Update Installer can be downloaded from the following link: http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991 3) Restart WebSphere Process Server Additional Information: Sample Error Traces [7/6/06 16:26:53:453 CST] 00000262 SchemaInfoTel 3 com.ibm.wbiserver.relationshipservice.dblayer.SchemaInfoTeller tellLengthQualified source length(255) < target length(256), return false. [7/6/06 16:26:53:558 CST] 00000262 util E com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility createRuntimeSchema(rel_j2ee) CWLAE0005I: RelationshipService encountered the exception: com.ibm.wbiserver.relationshipservice.exceptions.RelationshipServiceException: table ORDE_BOOL_RT_A7ADBB84B22EA02C8 already exist,but the table schema is different from current role defintion at com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreator.createRoleBaseSchema(OracleCreator.java:1270) at com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreator.createRoleRuntimeSchema(OracleCreator.java:615) at com.ibm.wbiserver.relationshipservice.dblayer.SchemaCreator.createRuntimeSchema(SchemaCreator.java:129) at com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility.createRuntimeSchema(ArtifactLoaderUtility.java:438) at com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility.loadAllRelAndRoles(ArtifactLoaderUtility.java:582) at com.ibm.wbiserver.relationshipservice.appinstall.WBIRelationshipsAppTasksImpl.performRelationshipAppTasks(WBIRelationshipsAppTasksImpl.java:120) at com.ibm.wbiserver.relationshipservice.appinstall.WBIRelationshipsAppInstallTask.performTask(WBIRelationshipsAppInstallTask.java:84) at com.ibm.ws.management.application.SchedulerImpl.run(SchedulerImpl.java:253) at java.lang.Thread.run(Thread.java:534) [7/6/06 16:26:53:621 CST] 00000262 SystemErr R com.ibm.wbiserver.relationshipservice.exceptions.RelationshipServiceException: table ORDE_BOOL_RT_A7ADBB84B22EA02C8 already exist,but the table schema is different from current role defintion [7/6/06 16:26:53:628 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreator.createRoleBaseSchema(OracleCreator.java:1270) [7/6/06 16:26:53:634 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreator.createRoleRuntimeSchema(OracleCreator.java:615) [7/6/06 16:26:53:639 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.dblayer.SchemaCreator.createRuntimeSchema(SchemaCreator.java:129) [7/6/06 16:26:53:643 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility.createRuntimeSchema(ArtifactLoaderUtility.java:438) [7/6/06 16:26:53:649 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility.loadAllRelAndRoles(ArtifactLoaderUtility.java:582) [7/6/06 16:26:53:655 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.appinstall.WBIRelationshipsAppTasksImpl.performRelationshipAppTasks(WBIRelationshipsAppTasksImpl.java:120) [7/6/06 16:26:53:659 CST] 00000262 SystemErr R at com.ibm.wbiserver.relationshipservice.appinstall.WBIRelationshipsAppInstallTask.performTask(WBIRelationshipsAppInstallTask.java:84) [7/6/06 16:26:53:664 CST] 00000262 SystemErr R at com.ibm.ws.management.application.SchedulerImpl.run(SchedulerImpl.java:253) [7/6/06 16:26:53:670 CST] 00000262 SystemErr R at java.lang.Thread.run(Thread.java:534) Prerequisite: JR25410 has prereq JR23979. First we have to apply JR23979 and then JR25410.