Return
-
Title
Stat HF-i Script STAT-5713, failed with error ORA-38824 -
Description
Applying stat Hotfix I - Running script STAT5713ORA.SQL produces error:
* Data - STAT_DBSCRIPT_TBL Start * Stat database version check 6.3.0
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.
Rollback complete.
-
Cause
DB edition. -
Resolution
Solution:1. Connect to Stat DB, with the user Stat and run the following instruction:CREATE OR REPLACE FORCE NONEDITIONABLE VIEW "STAT"."BUS_RULES_CSR_PARAMS_VW1"("SD_CD", "CSR_ID", "SERVICE_DOMAIN", "TITLE", "CUSTOMER_LAST_NAME", "CUSTOMER_FIRST_NAME", "APPLICATION_CODE", "APPLICATION", "ENVIRONMENT_CODE", "ENVIRONMENT", "CSR_TYPE_CODE", "CSR_TYPE", "PRIORITY_CODE", "PRIORITY", "CUST_PRIORITY_CODE", "CUST_PRIORITY", "PROJECT_CODE", "PROJECT", "WORKFLOW_ID", "WORKFLOW", "STATUS_CODE", "STATUS", "DEPARTMENT", "IS_CLOSED", "TRACKING_NUMBER", "OPEN_DATE", "CLOSE_DATE", "UPDATE_DATE", "LAST_UPDATE_DATE", "CREATED_USER_ID", "UPDATED_USER_ID", "ASSIGNED_USER_ID", "QUEUE_ID", "QUEUE", "HAS_BEEN_READ_FLAG") ASSELECT A.SD_CD, A.CSR_ID, B.DESCR, A.DESCR_SHORT, C.LAST_NAME, C.FIRST_NAME, D.APPL_CD, D.DESCR, E.APPL_ENV_CD, E.DESCR, F.CSR_TYPE_CD, F.DESCR, G.PRIORITY_CD, G.DESCR, H.PRIORITY_CUST, H.DESCR, I.PROJ_CD, J.DESCR, K.WRKFLW_ID, K.WRKFLW_NAME, L.CSR_STATUS_CD, L.DESCR, M.DESCR, N.CLOSED_STATUS_FLAG, A.TRACKING_NUMBER, N.OPEN_DT, N.CLOSE_DT, A.UPDATE_DT, CLU.UPDATE_DT, -- added for STAT-5713N.OPEN_USERID, N.UPDATE_USERID, N.ASSIGNED_USERID, QU.QUEUE_ID, QU.DESCR, N.HAS_BEEN_READ_FLAGFROM STAT.CSR_MASTER_TBL AJOIN STAT.SERVICE_DOMAIN B ON B.SD_CD = A.SD_CDJOIN STAT.CUSTOMERS C ON C.CUST_ID = A.CUST_IDJOIN STAT.DEPARTMENT M ON M.DEPT_ID = C.DEPARTMENTJOIN STAT.APPL_TYPE D ON D.SD_CD = A.SD_CD AND D.APPL_CD = A.APPL_CDLEFT JOIN STAT.APPL_ENV E ON E.SD_CD = A.SD_CD AND E.APPL_CD = A.APPL_CD AND E.APPL_ENV_CD = A.APPL_ENV_CDJOIN STAT.CSR_TYPE_CD F ON F.SD_CD = A.SD_CD AND F.CSR_TYPE_CD = A.CSR_TYPEJOIN STAT.CSR_STATUS N ON N.SD_CD = A.SD_CD AND N.CSR_ID = A.CSR_IDJOIN STAT.PRIORITY G ON G.PRIORITY_CD = N.PRIORITY_CD AND G.SD_CD = N.SD_CDLEFT JOIN STAT.CUSTOMER_PRIORITY H ON H.SD_CD = N.SD_CD AND H.PRIORITY_CUST = N.PRIORITY_CUSTJOIN STAT.CSR_STATUS_CD L ON L.SD_CD = N.SD_CD AND L.CSR_STATUS_CD = N.CSR_STATUS_CD AND L.CSR_TYPE_CD = A.CSR_TYPELEFT JOIN STAT.PROJ_CSRS I ON I.SD_CD = A.SD_CD AND I.CSR_ID = A.CSR_IDLEFT JOIN STAT.PROJ_DEFN J ON J.PROJ_CD = I.PROJ_CDLEFT JOIN STAT.CSR_WRKFLW_DEFN K ON K.SD_CD = A.SD_CD AND K.CSR_ID = A.CSR_IDJOIN STAT.QUEUE QU ON QU.SD_CD = N.SD_CD AND QU.QUEUE_ID = N.QUEUE_IDJOIN STAT.CSR_LAST_UPDATE CLU ON CLU.SD_CD = A.SD_CD AND CLU.CSR_ID = A.CSR_ID;2. If you still get the error ORA-38824, try to run the same statement deleting the word "NONEDITIONABLE" from the script.3. If the first 2 step doesn't work, connect to the Stat database as SYSTEM and run the following statement:ALTER STAT.BUS_RULES_CSR_PARAMS_VW1 ENABLE EDITIONS, then run the original script again.