Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 6.0.061
  HXTT Cobol 3.0.061
  HXTT DBF 6.0.064
  HXTT Excel 5.0.064
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox 6.0.061
  HXTT Text(CSV) 6.0.062
  HXTT XML 2.0.061
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Beijing City (abbr, HXTT)

HXTT Excel
Problem with Reverse Engeneer in ODI 12c 12.2.1.3
Jan Havranek
2017-11-20 04:24:20.0
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
Re:Problem with Reverse Engeneer in ODI 12c 12.2.1.3
HXTT Support
2017-11-20 05:14:29.0
>unique constraint (DEV2_ODI_REPO.AK_REV_COL) violated
It seems that AK_REV_COL is not a unique column. You can use Pseudo Column

_rowid_, is a pseudo column as primary key. A _rowid_ identifies a row in a table.

Re:Re:Problem with Reverse Engeneer in ODI 12c 12.2.1.3
Jan Havranek
2017-11-20 12:53:38.0
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.
Re:Re:Re:Problem with Reverse Engeneer in ODI 12c 12.2.1.3
HXTT Support
2017-11-21 02:00:01.0
>1. Pseudo Column is, when I add into attributes in Datastore, the Column with name _rowid_?
Yeah.

>2. How ca I use Clausule WHERE in ODI for the Excel sheet. For example I need to filter only 1-st row.
where _rowid_>1; or where recno()>1;


Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 1999-2017 Heng Xing Tian Tai Lab of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap