Hello,
Thank you for your previews help with connection.
Now when I tried to make Reverse Engineer only for one table, I received this message from ODI:
om.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (DEV2_ODI_REPO.AK_REV_COL) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3898)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:367)
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:194)
at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)
at com.sun.proxy.$Proxy34.executeUpdate(Unknown Source)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:689)
at com.sunopsis.dwg.dbobj.generated.GeneratedSnpRevCol.insertAction(GeneratedSnpRevCol.java:1199)
at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3650)
at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3680)
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:2266)
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:2330)
at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$10.doLongOperation(EditFrameSnpModel.java:2782)
at oracle.cef.ui.Framework$5.doInBackground(Framework.java:726)
at oracle.cef.ui.Framework$5.doInBackground(Framework.java:718)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 1, Position : 0, Sql = insert into SNP_REV_COL (BYTES,CHECK_FLOW,CHECK_STAT,COL_DEC_SEP,COL_DESC,COL_DESC_C,COL_FORMAT,COL_HEADING,COL_MANDATORY,COL_NAME,COL_NULL_IF_ERR,DATA_FORMAT,DEF_VALUE,DT_DRIVER,FILE_POS,HIVE_SORTBY_POS,IND_HIVE_CLUSTER,IND_HIVE_PARTITION,IND_WRITE,IND_WS_INSERT,IND_WS_SELECT,IND_WS_UPDATE,I_MOD,I_TXT_COL_DESC,LONGC,MOD_GUID,POS,REC_CODE_LIST,SCALEC,SCD_COL_TYPE,TABLE_NAME) values (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ,:30 ,:31 ), OriginalSql = insert into SNP_REV_COL (BYTES,CHECK_FLOW,CHECK_STAT,COL_DEC_SEP,COL_DESC,COL_DESC_C,COL_FORMAT,COL_HEADING,COL_MANDATORY,COL_NAME,COL_NULL_IF_ERR,DATA_FORMAT,DEF_VALUE,DT_DRIVER,FILE_POS,HIVE_SORTBY_POS,IND_HIVE_CLUSTER,IND_HIVE_PARTITION,IND_WRITE,IND_WS_INSERT,IND_WS_SELECT,IND_WS_UPDATE,I_MOD,I_TXT_COL_DESC,LONGC,MOD_GUID,POS,REC_CODE_LIST,SCALEC,SCD_COL_TYPE,TABLE_NAME) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), Error Msg = ORA-00001: unique constraint (DEV2_ODI_REPO.AK_REV_COL) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 40 more
It is maybe that the JDBC driver mean that first row is Headers of column.
So I tried to put the properties into the JDBC URL:
jdbc:Excel:////u01/data/BID.xlsm?FirstRowHasNames=false
But the result is the same.
Can you help me with this, please?
Thank you
Jan
|
Hello to Support,
Please, may I have other questions?
1. Pseudo Column is, when I add into attributes in Datastore, the Column with name _rowid_?
2. How ca I use Clausule WHERE in ODI for the Excel sheet. For example I need to filter only 1-st row.
I tried to add filter into Mapping, but still I have problem see error message:
The physical node FILTER_ROW_1 cannot be supported by technology Microsoft Excel on execution unit HXTT_Excel_Default_Logical_UNIT of mapping TEST.
|
Main
webmaster@hxtt.com