Skip to Main Content

DAC Repository importing issues in DAC 10.1.3.4.1 version.

720272Nov 25 2009
Dear All,

I had just installed DAC 10.1.3.4.1 and had finished doing the repository import.

Now i am facing an error while doing the metadata import. I have OBIA 7.9.6.1 version installed in my system. So, i have used the metadata files from that.

I had selected 2 applications for import namely 'Universal' and 'Siebel 8.1.1'

After doing the import i got an error stating "5 errors in import.log file". And in the LOG file, the following errors are mentioned:

---------------------------------------------------------------------------------------------------------------------------

::: CAUSE :::
MESSAGE:::ORA-00001: unique constraint (OBAW.W_ETL_SYSPROP_U1) violated

EXCEPTION CLASS::: java.sql.SQLException

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:672)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:598)

---------------------------------------------------------------------------------------------------------------------------------------

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
java.lang.Thread.run(Thread.java:619)
2235 SEVERE Tue Nov 24 19:57:13 IST 2009 Could not write bean to database
2236 SEVERE Tue Nov 24 19:57:13 IST 2009 Bean classcom.siebel.analytics.etl.databean.SystemPropertyBean
2237 SEVERE Tue Nov 24 19:57:13 IST 2009 Bean Id: No Run
2238 SEVERE Tue Nov 24 19:57:13 IST 2009
ANOMALY INFO::: Could not write bean to database
MESSAGE:::com.siebel.etl.database.IllegalSQLQueryException: null:INSERT INTO W_ETL_SYSPROP
(ROW_WID, VERSION_ID, LAST_UPD, NAME, VALUE, COMMENTS, DEFAULT_VALUE) VALUES (?, ?, ?, ?, ?, ?, ?)
Values :
KEY : 3
VALUE : 2008-11-15 02:47:48.0
KEY : 4
VALUE : No Run
KEY : 5
VALUE : false
KEY : 6
VALUE :
When set to true, this property will run the execution plan for just generating the tasks and their details.
None of the tasks will be executed, and the refresh dates will not be updated. Use this only to debug.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Can these 5 errors be ignored even for the Siebel 8.1.1 Applications metadata import, or is it Application specific?

Kindly help me out regarding these 5 errors.

Thanks in advance.

Regards,
Samdev.
Comments
Post Details
Added on Nov 25 2009
0 comments
1,139 views