I created new user through ACCCM. The system said “Operation completed successfully” but behind I found the error message:
24/07/2015 19:34:55 NAV360_AIC.AICObjects.AICSQLServer.getLastEmployeePKeyByLoginId -> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I have corrected your ACCCM CFG > AIC, I think DB name should be Oracle Instance name (which both development and production are using the same name “AVIC”) but not Oracle TNS name.
After that I got error ORA-00942, the connection is now establish but cannot get Pkey from AIC.
24/07/2015 20:32:32 NAV360_AIC.AICObjects.AICSQLServer.getLastEmployeePKeyByLoginId -> ORA-00942: table or view does not exist
In Oracle, must have schema name (“repository”) in front of table in SQL statement but I tried “create synonym” as follow:
Connect AIC Oracle database using dcobridge2 as normal (not SYSDBA):
create or replace synonym employee for repository.employee;
create or replace synonym workgroup for repository.workgroup;
create or replace synonym groupmember for repository.groupmember;
create or replace synonym site for repository.site;
create or replace synonym skill for repository.skill;
create or replace synonym skillset for repository.skillset;
And now, AIC information can be displayed on ACCCM correctly.
