{"id":249,"date":"2020-02-16T12:16:45","date_gmt":"2020-02-16T12:16:45","guid":{"rendered":"https:\/\/swiv.com.br\/solved-issue-bug-no-odi-12-2-1-ao-tentar-excluir-cenario\/"},"modified":"2026-05-27T20:02:55","modified_gmt":"2026-05-27T19:02:55","slug":"solved-issue-bug-no-odi-12-2-1-ao-tentar-excluir-cenario","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2020\/02\/16\/solved-issue-bug-no-odi-12-2-1-ao-tentar-excluir-cenario\/","title":{"rendered":"[Solved] Issue: Bug no ODI 12.2.1 ao tentar excluir cen\u00e1rio"},"content":{"rendered":"\n

O Oracle Data Integrator, conhecido pelo acr\u00f4nimo ODI, \u00e9 uma poderosa ferramenta de ETL da Oracle, muito utilizada em ambientes de BI e tamb\u00e9m Analytics. Ela tem capacidade de se conectar em m\u00faltiplas origens (seja banco de dados, planilhas excel, arquivos, e outras fontes de dados) e realizar sua devida transforma\u00e7\u00e3o e carga de acordo com as necessidades do neg\u00f3cio. Tudo isso com uma ferramenta gr\u00e1fica que auxilia muito bem o profissional a desenvolver desde processos simples aos mais complexos.<\/p>\n\n\n\n

Neste artigo, vou explorar um comportamento muito pontual (caracterizado por um bug) do ODI, que eu nunca identifiquei nas vers\u00f5es 11, apenas na 12.<\/p>\n\n\n\n

Vers\u00e3o 12.2.1.0:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Caracter\u00edstica do problema: dentro do ODI, temos um objeto chamado cen\u00e1rio, que encapsula as regras de ETL e possibilita que as cargas sejam feitas. Toda vez que um cen\u00e1rio \u00e9 executado, ele salva v\u00e1rias informa\u00e7\u00f5es no seu respectivo banco de metadados (onde o ODI foi instalado). Quando um cen\u00e1rio \u00e9 executado com uma periodicidade constante (por exemplo, a cada 10 minutos de forma c\u00edclica), obviamente muitos logs ser\u00e3o gerados. <\/p>\n\n\n\n

Nesta vers\u00e3o que usamos como exemplo, o problema ocorre quando, no momento de Deploy, voc\u00ea tenta excluir o cen\u00e1rio atual (com a inten\u00e7\u00e3o de posteriormente importar o novo). Nesta etapa, o ODI realiza um purge interno nos logs associados com o cen\u00e1rio em quest\u00e3o, e acaba explodindo um erro. Vamos simular este caso:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Como este artigo foi originado de uma situa\u00e7\u00e3o real, apagarei quaisquer informa\u00e7\u00f5es de nome de objetos e detalhes, para manter o sigilo do ambiente.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Erro em modo texto:<\/p>\n\n\n

\njava.lang.RuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-02292: restri\u00e7\u00e3o de integridade (XXXXXX.FK_SCEN_REPORT) violada - registro filho localizado\n \n    at com.sunopsis.graphical.core.DwgObjectDeleterService$2.doInTransaction(DwgObjectDeleterService.java:649)\n    at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:100)\n    at com.sunopsis.graphical.core.DwgObjectDeleterService.deleteObject(DwgObjectDeleterService.java:632)\n    at com.sunopsis.graphical.core.DwgObjectDeleterService.access$200(DwgObjectDeleterService.java:120)\n    at com.sunopsis.graphical.core.DwgObjectDeleterService$1.doInBackground(DwgObjectDeleterService.java:329)\n    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)\n    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)\n    at java.lang.Thread.run(Thread.java:748)\nCaused by: com.sunopsis.dwg.SQLWorkReposException: ORA-02292: restri\u00e7\u00e3o de integridade (XXXXXXXXX.FK_SCEN_REPORT) violada - registro filho localizado\n \n    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)\n    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)\n    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)\n    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)\n    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)\n    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)\n    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)\n    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)\n    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)\n    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)\n    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)\n    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)\n    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)\n    at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source)\n    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n    at java.lang.reflect.Method.invoke(Method.java:498)\n    at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:353)\n    at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:178)\n    at com.sun.proxy.$Proxy32.executeUpdate(Unknown Source)\n    at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source)\n    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n    at java.lang.reflect.Method.invoke(Method.java:498)\n    at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)\n    at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)\n    at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:689)\n    at com.sunopsis.dwg.DwgObject.deleteAction(DwgObject.java:1387)\n    at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1548)\n    at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1555)\n    at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:1102)\n    at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:1081)\n    at com.sunopsis.graphical.core.DwgObjectDeleterService$2.doInTransaction(DwgObjectDeleterService.java:643)\n    ... 7 more\n<\/pre><\/div>\n\n\n
Em contato com o fornecedor, nos foi recomendado, devido as circunst\u00e2ncias, aplicar o procedimento seguinte:<\/p>\n\n\n\n
1-Executar um backup do owner XXXX (owner de metadados que abriga as informa\u00e7\u00f5es internas do ODI);
2-Parar todos os processos de carga do ODI caso estejam em execu\u00e7\u00e3o;
3-Executar o comando abaixo no banco de metadados em quest\u00e3o:
ALTER TABLE XXXXXX.SNP_SCEN_REPORT DISABLE CONSTRAINT FK_SCEN_REPORT;
4-Tentar excluir novamente o cen\u00e1rio;
5-Executar o comando abaixo no banco de metadados em quest\u00e3o:
ALTER TABLE XXXXXXX.SNP_SCEN_REPORT ENABLE CONSTRAINT FK_SCEN_REPORT;<\/p>\n\n\n
At\u00e9 para fundamentar a decis\u00e3o de executar esse Workaround, uma situa\u00e7\u00e3o similar j\u00e1 est\u00e1 documentada no Oracle Note ““ORA-02292: integrity constraint (xxxx.FK_SNP_SESSION_SB) violated – child record found” when Running ODIPurgeLog in ODI 12c (Doc ID 2049524.1)<\/strong>“.<\/p>\n\n\n
Realizando o export do owner de reposit\u00f3rio:<\/p>\n\n\n
\n[user@server]$ cat expdp.log\n;;;\nExport: Release 12.1.0.2.0 - Production on Fri Feb 14 15:01:52 2020\n \nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n;;;\nConnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nAdvanced Analytics and Real Application Testing options\nStarting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system\/******** parfile=exp.par\nEstimate in progress using BLOCKS method...\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\nTotal estimation using BLOCKS method: 21.27 GB\nProcessing object type SCHEMA_EXPORT\/USER\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type SCHEMA_EXPORT\/STATISTICS\/MARKER\n. . exported "XXXXXXX"."SNP_STEP_LOG"           488.1 MB 2048203 rows\n. . exported "XXXXXXX"."SNP_STEP_REPORT"        485.0 MB 1777493 rows\n. . exported "XXXXXXX"."SNP_SESS_TASK_LOG"      80.94 MB  527825 rows\n. . exported "XXXXXXX"."SNP_PARAM_SESS"         74.67 MB 2694134 rows\n. . exported "XXXXXXX"."SNP_SESSION"            38.34 MB  717394 rows\n. . exported "XXXXXXX"."SNP_SCEN_REPORT"        19.58 MB  692287 rows\n. . exported "XXXXXXX"."SNP_SESS_TASK_LS"       1.557 MB   69315 rows\n. . exported "XXXXXXX"."SNP_SESS_STEP_LV"       882.2 KB   39242 rows\n. . exported "XXXXXXX"."SNP_SB_TASK"            280.0 KB    2286 rows\n. . exported "XXXXXXX"."SNP_SCEN_TASK"          227.7 KB    1844 rows\n. . exported "XXXXXXX"."SNP_CONV_DT"            855.1 KB   38206 rows\n. . exported "XXXXXXX"."SNP_SB_STEP"            52.44 KB     601 rows\n. . exported "XXXXXXX"."SNP_MTXT"               153.9 KB    3949 rows\n. . exported "XXXXXXX"."SNP_CONNECT"            8.976 KB      11 rows\n. . exported "XXXXXXX"."SNP_LPI_EC_VAR_LOG"         0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_VAR_LOG"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SCEN_STEP"          42.40 KB     406 rows\n. . exported "XXXXXXX"."SNP_SESS_TASK"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_VAR"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_AGENT"                  0 KB       0 rows\n. . exported "XXXXXXX"."SNP_DEPLOYMENT_LOG"         0 KB       0 rows\n. . exported "XXXXXXX"."SNP_EXP_TXT_HEADER"     8.687 KB      86 rows\n. . exported "XXXXXXX"."SNP_FF_VALUEE"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_FF_VALUEM"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_FLEX_FIELD"         8.429 KB      40 rows\n. . exported "XXXXXXX"."SNP_LPI_EXC_LOG"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_RUN"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_STEP"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_STEP_LOG"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LPI_STEP_VAR"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LP_STEP"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LP_STEP_VAR"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LP_VAR"                 0 KB       0 rows\n. . exported "XXXXXXX"."SNP_PARAM_LPI_RUN"          0 KB       0 rows\n. . exported "XXXXXXX"."SNP_PROF_METH"          57.82 KB    2494 rows\n. . exported "XXXXXXX"."SNP_PSCHEMA"            9.203 KB      11 rows\n. . exported "XXXXXXX"."SNP_SB"                 9.421 KB      73 rows\n. . exported "XXXXXXX"."SNP_SEQ_SB"             6.773 KB      24 rows\n. . exported "XXXXXXX"."SNP_SEQ_SCEN"           6.601 KB      19 rows\n. . exported "XXXXXXX"."SNP_SESS_STEP"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_VAR_DATA"           6.070 KB       5 rows\n. . exported "XXXXXXX"."SNP_VAR_PLAN_AGENT"         0 KB       0 rows\n. . exported "XXXXXXX"."SNP_VAR_SB"             7.984 KB      75 rows\n. . exported "XXXXXXX"."SNP_VAR_SCEN"           7.523 KB      49 rows\n. . exported "XXXXXXX"."SNP_VAR_SESS"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LE_TECHNO"          71.10 KB    2341 rows\n. . exported "XXXXXXX"."SNP_DT"                 40.00 KB     896 rows\n. . exported "XXXXXXX"."SNP_FIELD"              59.42 KB    1290 rows\n. . exported "XXXXXXX"."SNP_LANG_ELT"           53.18 KB    1308 rows\n. . exported "XXXXXXX"."SNP_METHOD"             36.07 KB     863 rows\n. . exported "XXXXXXX"."OGG_METADATA"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_ACTION"             7.851 KB      58 rows\n. . exported "XXXXXXX"."SNP_AGENT_PROP"             0 KB       0 rows\n. . exported "XXXXXXX"."SNP_AGENT_PROP_LST"     5.484 KB       6 rows\n. . exported "XXXXXXX"."SNP_ALLOC_AGENT"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_CEC_LP"                 0 KB       0 rows\n. . exported "XXXXXXX"."SNP_CEC_SCEN"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_CONNECT_PROP"       5.882 KB      20 rows\n. . exported "XXXXXXX"."SNP_CONTEXT"            5.781 KB       1 rows\n. . exported "XXXXXXX"."SNP_DATA"                   0 KB       0 rows\n. . exported "XXXXXXX"."SNP_DATASOURCE"             0 KB       0 rows\n. . exported "XXXXXXX"."SNP_DIM_PATTERN"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_ENTITY"             11.91 KB     103 rows\n. . exported "XXXXXXX"."SNP_ENT_ID"             5.484 KB      35 rows\n. . exported "XXXXXXX"."SNP_ENT_PRINCIPAL"          0 KB       0 rows\n. . exported "XXXXXXX"."SNP_ESS"                    0 KB       0 rows\n. . exported "XXXXXXX"."SNP_FIELD_LOOKUP"       21.89 KB     568 rows\n. . exported "XXXXXXX"."SNP_GRP_ACTION"          6.25 KB      10 rows\n. . exported "XXXXXXX"."SNP_HIST_VERSION"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_HOST"               5.625 KB       8 rows\n. . exported "XXXXXXX"."SNP_HOST_MOD"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_ID"                 5.148 KB       5 rows\n. . exported "XXXXXXX"."SNP_IMPORT_REP"             0 KB       0 rows\n. . exported "XXXXXXX"."SNP_INDEX_TYPE"          8.25 KB      66 rows\n. . exported "XXXXXXX"."SNP_INST_OBJ"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LAGENT"                 0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LANG"               6.296 KB       8 rows\n. . exported "XXXXXXX"."SNP_LANG_TECHNO"        7.195 KB      54 rows\n. . exported "XXXXXXX"."SNP_LB_AGENT"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LINE_ACTION"        8.679 KB      78 rows\n. . exported "XXXXXXX"."SNP_LINK"               12.53 KB     220 rows\n. . exported "XXXXXXX"."SNP_LOAD_PLAN"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LOCK"                   0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LOCKED_OBJECT"          0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LOC_REP"            7.046 KB       1 rows\n. . exported "XXXXXXX"."SNP_LOC_REPW"           6.429 KB       1 rows\n. . exported "XXXXXXX"."SNP_LOOKUP"                 0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LOOKUP_VALUE"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LP_INST"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_LSCHEMA"            6.445 KB      12 rows\n. . exported "XXXXXXX"."SNP_MERGE"                  0 KB       0 rows\n. . exported "XXXXXXX"."SNP_MERGE_OBJECT"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_MODULE"             5.531 KB       5 rows\n. . exported "XXXXXXX"."SNP_M_IMPORT_REP"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_OBJECT"             10.64 KB     115 rows\n. . exported "XXXXXXX"."SNP_OPEN_TOOL"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_PLAN_AGENT"             0 KB       0 rows\n. . exported "XXXXXXX"."SNP_PROFILE"            6.195 KB      15 rows\n. . exported "XXXXXXX"."SNP_PSCHEMA_CONT"       5.992 KB      10 rows\n. . exported "XXXXXXX"."SNP_PWD_POLICY"          5.25 KB       1 rows\n. . exported "XXXXXXX"."SNP_PWD_RULE"           5.476 KB       4 rows\n. . exported "XXXXXXX"."SNP_REM_REP"            5.687 KB       1 rows\n. . exported "XXXXXXX"."SNP_ROLE_ENT_PRP"           0 KB       0 rows\n. . exported "XXXXXXX"."SNP_RT_BRP"                 0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SCEN"               9.796 KB      60 rows\n. . exported "XXXXXXX"."SNP_SCEN_BRP"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SCEN_FOLDER"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SCHEDULE_EXEC"          0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SEQ_DATA"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SESSION_DBG"        5.789 KB      10 rows\n. . exported "XXXXXXX"."SNP_SESS_FOLDER"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SOLUTION"               0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SOL_ELT"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_SUB_LANG"           7.539 KB      51 rows\n. . exported "XXXXXXX"."SNP_TECHNO"             17.35 KB      62 rows\n. . exported "XXXXXXX"."SNP_USER"               6.492 KB       4 rows\n. . exported "XXXXXXX"."SNP_USER_CONNECTED"     17.36 KB     373 rows\n. . exported "XXXXXXX"."SNP_USER_METH"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_USER_OBJ_METH"          0 KB       0 rows\n. . exported "XXXXXXX"."SNP_USER_PREF"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_USER_PROF"          5.531 KB       3 rows\n. . exported "XXXXXXX"."SNP_USR_PREFERENCE"     5.164 KB       2 rows\n. . exported "XXXXXXX"."SNP_U_O_M_REP"              0 KB       0 rows\n. . exported "XXXXXXX"."SNP_VCS_VERSION"            0 KB       0 rows\n. . exported "XXXXXXX"."SNP_VERSION"                0 KB       0 rows\n. . exported "XXXXXXX"."SNP_WS_POLICY"              0 KB       0 rows\nMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n  \/xxxx\/BKP.dmp\nJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Feb 14 16:12:41 2020 elapsed 0 00:30:44\n<\/pre><\/div>\n\n\n
Rodar comando abaixo no banco de Metadados:<\/p>\n\n\n
\nALTER TABLE XXXXXXX.SNP_SCEN_REPORT DISABLE CONSTRAINT FK_SCEN_REPORT;\n \nTable XXXXXXX.SNP_SCEN_REPORT altered.\n<\/pre><\/div>\n\n\n
Tentando deletar o cen\u00e1rio novamente:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Cen\u00e1rio exclu\u00eddo com sucesso.<\/p>\n\n\n\n
Depois disso, e necess\u00e1rio rodar o comando abaixo no banco de metadados:<\/p>\n\n\n
\nALTER TABLE XXXXXXX.SNP_SCEN_REPORT ENABLE CONSTRAINT FK_SCEN_REPORT;\n \nTable XXXXXXX.SNP_SCEN_REPORT altered.\n<\/pre><\/div>\n\n
Obviamente, o procedimento acima \u00e9 uma solu\u00e7\u00e3o paliativa do bug documentado, de modo que para san\u00e1-lo de forma definitiva, \u00e9 recomendado aplicar o Patch abaixo, ou at\u00e9 subir o ambiente para a vers\u00e3o mais recente, que contempla o ajuste: (ODI 12.2.1.x: Delete Mapping Error “ORA-02292: integrity constraint (WORKREPO.FK_MAP_CONN_MAP) violated \u2013 child record found” (Doc ID 2329587.1)<\/strong>).<\/p>","protected":false},"excerpt":{"rendered":"
O Oracle Data Integrator, conhecido pelo acr\u00f4nimo ODI, \u00e9 uma poderosa ferramenta de ETL da Oracle, muito utilizada em ambientes de BI e tamb\u00e9m Analytics. Ela tem capacidade de se conectar em m\u00faltiplas origens (seja banco de dados, planilhas excel, arquivos, e outras fontes de dados) e realizar sua devida transforma\u00e7\u00e3o e carga de acordo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":9317,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions\/9317"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}