I am trying to install and configure OBIA 7.9.6.4
I have successfully completed all the steps till installing and setting up DAC
I installed DAC successfully, imported metadata for DAC repository. Selected Universal and Oracle 12.1.1 as source system.
i did all steps,now i'm trying to run my first ETL
the ETL fails with the ِAttached Error
Notes:
* i tried to drop the Datawarehouse tables and re-create them again
i found them under user DAC_REP (it's the table owner) ,but no changes happen to them after dropping or after re-creation
* the database that holds the DAC repository and informatica info and the DataWarehouse is a "relational" database
means: when i created it ,i selected "database" not "Datawarehouse" , is that a problem??
--------------------------------------------
40 GLOBAL Fri Aug 23 14:23:22 GMT 2013 DAC Version: Dac Build AN 11.1.1.6.4.20121119.2022
41 GLOBAL Fri Aug 23 14:23:22 GMT 2013 The System properties are: GLOBAL_LOG_FILE_DIRECTORY_FOR_THIS_RUN C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\dac\log\first_etl.22954464
java.runtime.name Java(TM) SE Runtime Environment
sun.boot.library.path C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\bin
java.vm.version 14.1-b02
java.vm.vendor Sun Microsystems Inc.
java.vendor.url http://java.sun.com/
path.separator ;
ETL_EXECUTION_MODE ETL_SERVER
java.vm.name Java HotSpot(TM) Client VM
file.encoding.pkg sun.io
sun.java.launcher SUN_STANDARD
user.country US
sun.os.patch.level Service Pack 2
java.vm.specification.name Java Virtual Machine Specification
user.dir C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\dac
java.runtime.version 1.6.0_15-b03
java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
java.endorsed.dirs C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\endorsed
os.arch x86
java.io.tmpdir C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\
line.separator
java.vm.specification.vendor Sun Microsystems Inc.
user.variant
os.name Windows 2003
sun.jnu.encoding Cp1252
java.library.path C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;"C:\Informatica\9.1.0"\server\bin;C:\Informatica\9.1.0\java\jre\bin\server;C:\Informatica\9.1.0\tools\datadirect;C:\Informatica\9.1.0\DataTransformation\bin;C:\Informatica\9.1.0\clients\tools\datadirect;C:\Informatica\9.1.0\clients\DeveloperClient\bin;C:\Informatica\9.1.0\clients\java\jre\bin\server;C:\Oracle_DB\product\11.2.0\dbhome_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;c:\Program Files\Amazon\cfn-bootstrap\;C:\OBIEE\Oracle_BI1\bin;C:\OBIEE\Oracle_BI1\opmn\bin;C:\OBIEE\Oracle_BI1\opmn\lib;C:\OBIEE\Oracle_BI1\perl\bin;C:\Informatica\9.1.0\server\bin;C:\Informatica\9.1.0\clients\PowerCenterClient\client\bin
java.specification.name Java Platform API Specification
java.class.version 50.0
sun.management.compiler HotSpot Client Compiler
os.version 5.2
user.home C:\Documents and Settings\Administrator
user.timezone GMT
java.awt.printerjob sun.awt.windows.WPrinterJob
file.encoding Cp1252
java.specification.version 1.6
java.class.path .\lib\msbase.jar;.\lib\mssqlserver.jar;.\.lib\msutil.jar;.\lib\sqljdbc.jar;.\lib\ojdbc6.jar;.\lib\ojdbc5.jar;.\lib\ojdbc14.jar;.\lib\db2java.zip;.\lib\terajdbc4.jar;.\lib\log4j.jar;.\lib\teradata.jar;.\lib\tdgssjava.jar;.\lib\tdgssconfig.jar;.\lib\nzjdbc.jar;.\lib\bijdbc.jar;.\lib\ttjdbc6.jar;.\lib\orai18n.jar;.\lib\timestenjmsxla.jar;.\lib\jms.jar;.\lib\javax.jms.jar;;.\DAWSystem.jar;.\lib\biacm.paramproducer.jar;;.\lib\oracle_common/modules/oracle.pki_11.1.1/oraclepki.jar;.\lib\oracle_common/webservices/wsclient_extended.jar;.\lib\oracle_common/modules/oracle.jmx_11.1.1/jmxspi.jar;.\lib\oracle_common/modules/oracle.odl_11.1.1/ojdl.jar;.\lib\oracle_common/modules/oracle.jps_11.1.1/jps-internal.jar;.\lib\oracle_common/modules/oracle.jps_11.1.1/jps-platform.jar;.\lib\oracle_common/modules/oracle.jps_11.1.1/jps-se.jar;.\lib\oracle_common/modules/oracle.idm_11.1.1/identitystore.jar;.\lib\oracle_common/modules/oracle.jps_11.1.1/jps-az-rt.jar;.\lib\oracle_common/modules/oracle.jps_11.1.1/jacc-spi.jar;.\lib\oracle_common/modules/oracle.iau_11.1.1/fmw_audit.jar;.\lib\oracle_common/modules/oracle.jmx_11.1.1/jmxframework.jar;.\lib\oracle_common/modules/oracle.igf_11.1.1/identitydirectory.jar;;.\lib\oracle_common/jlib/help-share.jar;.\lib\oracle_common/jlib/ohj.jar;.\lib\oracle_common/jlib/jewt4.jar;.\lib\oracle_common/jlib/share.jar;.\lib\oracle_common/jlib/oracle_ice.jar;
user.name Administrator
java.vm.specification.version 1.0
java.home C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre
sun.arch.data.model 32
user.language en
java.specification.vendor Sun Microsystems Inc.
oracle.security.jps.config C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\dac\conf\security/jps-config-jse.xml
awt.toolkit sun.awt.windows.WToolkit
java.vm.info mixed mode
java.version 1.6.0_15
java.ext.dirs C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
sun.boot.class.path C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\resources.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\rt.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\sunrsasign.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\jsse.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\jce.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\lib\charsets.jar;C:\DAC\Oracle Business Intelligence Data Warehouse Administration Console 11g\jre\classes
java.vendor Sun Microsystems Inc.
file.separator \
java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi
sun.io.unicode.encoding UnicodeLittle
sun.cpu.endian little
sun.desktop windows
sun.cpu.isalist pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
44 SEVERE Fri Aug 23 14:23:22 GMT 2013 Incorrectly specified Pre-Etl Script/Executable. The file either does not exist, or is not readable
45 SEVERE Fri Aug 23 14:23:39 GMT 2013 Credentials don't exist: map=oracle.dac.mail key=userCredEnc.
46 SEVERE Fri Aug 23 14:23:39 GMT 2013 Cannot get Email Password. Run the ServerSetup again!Credentials don't exist!
Make sure the properly configured cwallet file is used.
47 GLOBAL Fri Aug 23 14:23:39 GMT 2013
--------------------------------------------
START OF ETL
--------------------------------------------
53 GLOBAL Fri Aug 23 14:25:21 GMT 2013 Starting ETL Process.
54 SEVERE Fri Aug 23 14:25:21 GMT 2013 MESSAGE:::No value for @DAC_SOURCE_PRUNED_REFRESH_TIMESTAMP available!
EXCEPTION CLASS::: com.siebel.analytics.etl.converter.evaluator.EvaluationException
com.siebel.analytics.etl.converter.evaluator.TimestampEvaluator.evaluate(TimestampEvaluator.java:206)
com.siebel.analytics.etl.runtime.RuntimeFunctionHelper.getEvaluatedParameters(RuntimeFunctionHelper.java:269)
com.siebel.etl.engine.custom.TaskParameters.reEvaluateParameters(TaskParameters.java:441)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:569)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
55 SEVERE Fri Aug 23 14:25:21 GMT 2013 MESSAGE:::No value for @DAC_TARGET_PRUNED_REFRESH_TIMESTAMP available!
EXCEPTION CLASS::: com.siebel.analytics.etl.converter.evaluator.EvaluationException
com.siebel.analytics.etl.converter.evaluator.TimestampEvaluator.evaluate(TimestampEvaluator.java:206)
com.siebel.analytics.etl.runtime.RuntimeFunctionHelper.getEvaluatedParameters(RuntimeFunctionHelper.java:269)
com.siebel.etl.engine.custom.TaskParameters.reEvaluateParameters(TaskParameters.java:441)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:569)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
56 SEVERE Fri Aug 23 14:25:21 GMT 2013 MESSAGE:::No value for @DAC_SOURCE_PRUNED_REFRESH_TIMESTAMP available!
EXCEPTION CLASS::: com.siebel.analytics.etl.converter.evaluator.EvaluationException
com.siebel.analytics.etl.converter.evaluator.TimestampEvaluator.evaluate(TimestampEvaluator.java:206)
com.siebel.analytics.etl.runtime.RuntimeFunctionHelper.getEvaluatedParameters(RuntimeFunctionHelper.java:269)
com.siebel.etl.engine.custom.TaskParameters.reEvaluateParameters(TaskParameters.java:441)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:569)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
57 SEVERE Fri Aug 23 14:25:21 GMT 2013 MESSAGE:::No value for @DAC_SOURCE_PRUNED_REFRESH_TIMESTAMP available!
EXCEPTION CLASS::: com.siebel.analytics.etl.converter.evaluator.EvaluationException
com.siebel.analytics.etl.converter.evaluator.TimestampEvaluator.evaluate(TimestampEvaluator.java:206)
com.siebel.analytics.etl.runtime.RuntimeFunctionHelper.getEvaluatedParameters(RuntimeFunctionHelper.java:269)
com.siebel.etl.engine.custom.TaskParameters.reEvaluateParameters(TaskParameters.java:441)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:569)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
58 SEVERE Fri Aug 23 14:25:22 GMT 2013
ANOMALY INFO::: DataWarehouse:TRUNCATE TABLE W_ETL_RUN_S
ORA-00942: table or view does not exist
MESSAGE:::ORA-00942: table or view does not exist
EXCEPTION CLASS::: java.sql.SQLSyntaxErrorException
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
com.siebel.etl.database.cancellable.CancellableStatement.executeUpdate(CancellableStatement.java:171)
com.siebel.etl.database.DBUtils.executeUpdate(DBUtils.java:310)
com.siebel.etl.database.DBUtils.executeUpdate(DBUtils.java:249)
com.siebel.etl.database.DBUtils.operateTable(DBUtils.java:1823)
com.siebel.etl.database.DBUtils.truncateTable(DBUtils.java:1862)
com.siebel.analytics.etl.etltask.TruncateTableTask.doExecute(TruncateTableTask.java:40)
com.siebel.analytics.etl.etltask.TruncateTableTaskWrapper.doExecute(TruncateTableTaskWrapper.java:31)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)
59 SEVERE Fri Aug 23 14:25:22 GMT 2013
ANOMALY INFO::: Error while executing : TRUNCATE TABLE:W_ETL_RUN_S
MESSAGE:::com.siebel.etl.database.IllegalSQLQueryException: DataWarehouse:TRUNCATE TABLE W_ETL_RUN_S
ORA-00942: table or view does not exist
::: CAUSE :::
MESSAGE :::Submitted task failed during execution
EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.FailedTaskException
com.siebel.analytics.etl.etltask.ParallelTaskBatch.submitIncompleteTasks(ParallelTaskBatch.java:478)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:634)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:199)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:600)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:199)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:708)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
62 SEVERE Fri Aug 23 14:25:22 GMT 2013
ANOMALY INFO::: Error while executing task All Task Batches
MESSAGE:::Execution of child batch Truncate Batch failed.
EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.FailedTaskException
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:614)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:199)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:708)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
63 SEVERE Fri Aug 23 14:25:22 GMT 2013
ANOMALY INFO::: Error while executing : com.siebel.analytics.etl.etltask.ParallelTaskBatch:All Task Batches
MESSAGE:::com.siebel.analytics.etl.etltask.FailedTaskException: Execution of child batch Truncate Batch failed.
EXCEPTION CLASS::: java.lang.RuntimeException
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:536)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:708)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
::: CAUSE :::
MESSAGE :::Execution of child batch Truncate Batch failed.
EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.FailedTaskException
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:614)
com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:199)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.etl.engine.core.Session.executeTasks(Session.java:708)
com.siebel.etl.engine.core.Session.run(Session.java:821)
java.lang.Thread.run(Unknown Source)
64 GLOBAL Fri Aug 23 14:25:22 GMT 2013 Finishing ETL Process.
65 SEVERE Fri Aug 23 14:25:22 GMT 2013 MESSAGE:::Some steps failed.
EXCEPTION CLASS::: com.siebel.etl.engine.bore.SomeSessionsFailedException
com.siebel.etl.engine.bore.NewDispatcher.execute(NewDispatcher.java:263)
com.siebel.etl.engine.bore.NewDispatcher.run(NewDispatcher.java:123)
java.lang.Thread.run(Unknown Source)
66 SEVERE Fri Aug 23 14:25:23 GMT 2013 Number of incomplete tasks whose status got updated to stopped
Number of incomplete task details whose status got updated to stopped :3244
68 GLOBAL Fri Aug 23 14:25:23 GMT 2013
--------------------------------------------
END OF ETL
--------------------------------------------