Hi All,
We have upgraded from 7.0.0 to 7.0.1 after the upgrade the user have lost their admin access and they are not having the full access now.And also I am seeing the Aveksa Entitlement Collector is getting failed with the below mentioned admin error.
Is is because of the Aveksa EDC collection failed the users have lost their admin access ?.If any one have faced the same issue please let me know the resolution to resolve this.
Many thanks !
Regards,
Sabthami Subramanian
Yes. It's possible that the issue is because of the Aveksa edc failure.
Have to looked to see why Aveksa Edc is failing? What's the error you are seeing on the run and in the logs?
Hi Venkata,
I think the warning in the below screenshot taken from aveksaserver.log looks like something related to Aveksa EDC.Any
Idea ??
Regards,
Sabthami Subramanian
Venkata - I have uploaded the aveksaserver.log,workpoint.log and Details for Aveksa EDC run for you reference on the main post.
Regards,
Sabthami Subramanian
I see below error in the logs.. You need to compile the package Common_Exploder.pkb and see what errors it is throwing... This package having errors will fail most collections.
12/06/2016 04:25:57.052 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=259560 RunID=150428 Source=338 Type=DataObjectProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-04063: package body "AVUSER.COMMON_EXPLODER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_EXPLODER"
ORA-06512: at "AVUSER.EDC_DATA_COLLECTOR", line 265
ORA-06512: at "AVUSER.EDC_DATA_COLLECTOR", line 325
Hi Venkata,
Thanks for that.I have compiled the package on Toad now and I have attached the below screenshot for your reference.Any Idea how we can get this resolved now ?
Even I tried restarting the Database and application server which dint work.
Regards,
Sabthami S
Please run below statement, recompile the package and let know if there are other errors... Are there any other packages with errors.?
alter table GTT_CE_AFFECTED_PARENTS add(CE_EXPLODED_PATH varchar2(4000))
Hi Venkata,
Many thanks for you reply !
After running the above statement I have recompiled the COMMON_EXPLODER package and now i can see no errors for that package.Still I can see the below mentioned packages have error.I have provided the relavent screenshot below for the same.
Could you please let me know what we can do to sort out the compilation issue for the below mentioned packages?
Do I need to restart the Database or server after which I can run the Aveksa EDC collector? or can I run the Aveksa EDC now and check ?
1.DAG_UPDATE_MASTER_TABLES
2.RESOLUTION_PKG
3.ROLE_MANAGEMENT_PKG
4.UNAUTH_CHANGE_DETECTION_RULE
DAG_UPDATE_MASTER_TABLES
RESOLUTION_PKG
ROLE_MANAGEMENT_PKG
UNAUTH_CHANGE_DETECTION_RULE
Many thanks for your help ! Much appreciated !
Regards,
Sabthami S
There seem to be issues with migrating from 7.0.0 to 7.0.1 GA. These are resolved in 7.0.1 P01. Once all packages compile properly, you can run the collections and there is no need to restart server or database.
The below SQL's might need to be run based on an internal ticket that i see. Compile the packages after running these and check if that helps.
CREATE GLOBAL TEMPORARY TABLE GTT_DC_PRE_SUGG_RES_OWN
(APPLICATION_REF VARCHAR2(256),
FULLY_QUALIFIED_NAME VARCHAR2(256),
C2 VARCHAR2(256),
OWNER_NAME VARCHAR2(256),
OWNER_REASON VARCHAR2(256),
OWNER_RANK VARCHAR2(50),
DC_ID NUMBER NOT NULL,
RUN_ID NUMBER NOT NULL,
SRCID NUMBER NOT NULL,
OP_TYPE CHAR(1) NOT NULL,
APPLICATION_ID NUMBER,
ID NUMBER,
IS_DELETED VARCHAR2(5),
OPTED_OUT VARCHAR2(5),
OWNER_DISPLAY_NAME VARCHAR2(512),
OWNER_ID NUMBER,
RANK NUMBER,
RESOURCE_ID NUMBER,
CHECK (op_type in ('I','U','D','J'))
) ON COMMIT PRESERVE ROWS;
CREATE GLOBAL TEMPORARY TABLE GTT_DC_SUGG_RES_OWN
(APPLICATION_REF VARCHAR2(256),
FULLY_QUALIFIED_NAME VARCHAR2(256),
C2 VARCHAR2(256),
OWNER_NAME VARCHAR2(256),
OWNER_REASON VARCHAR2(256),
OWNER_RANK VARCHAR2(50),
DC_ID NUMBER NOT NULL,
RUN_ID NUMBER NOT NULL,
SRCID NUMBER NOT NULL,
OP_TYPE CHAR(1) NOT NULL,
APPLICATION_ID NUMBER,
ID NUMBER,
IS_DELETED VARCHAR2(5),
OPTED_OUT VARCHAR2(5),
OWNER_DISPLAY_NAME VARCHAR2(512),
OWNER_ID NUMBER,
RANK NUMBER,
RESOURCE_ID NUMBER,
CHECK (op_type in ('I','U','D','J'))
) ON COMMIT PRESERVE ROWS;
CREATE GLOBAL TEMPORARY TABLE GTT_CONSTRAINT_METRIC_ROLES
(
ID NUMBER,
ROLE_TYPEID VARCHAR2(50)
)
ON COMMIT PRESERVE ROWS;
CREATE GLOBAL TEMPORARY TABLE GTT_UCD_PREPROC (
SOURCE_ID NUMBER NOT NULL,
DC_ID NUMBER NOT NULL,
APPLICATION_ID NUMBER NOT NULL,
ENTITY_TO_APPLY_ID NUMBER NOT NULL,
ENTITY_TO_APPLY_TYPE VARCHAR2(30) NOT NULL,
TARGET_ENTITY_ID NUMBER NOT NULL,
TARGET_ENTITY_TYPE VARCHAR2(30) NOT NULL
) ON COMMIT DELETE ROWS;
Hi Venkata,
Many thanks for the reply it worked and got the lost admin access.
Identity Data Collection Failed - Got one more error while running the Identity Collector - See the below screenshot of the error and also I have attached the aveksaserver.log file in the main post for your reference.
Any idea how we can resolve it ??
Regards,
Sabthami Subramanian
Please run below statement, recompile the package and let know if there are other errors... Are there any other packages with errors.?
alter table GTT_CE_AFFECTED_PARENTS add(CE_EXPLODED_PATH varchar2(4000))