Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to load data to DVCS trial instance using Data Sync

Question
22
Views
0
Comments
Bhuvaneswari Duraiswamy
Bhuvaneswari Duraiswamy Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

Unable to load data to DVCS trial instance using Data Sync

Content

Hi,

I am a newbie to DVCS. I am trying to load on-premise data to Oracle DVCS trial Instance using Data Sync. The data load job failed with the following error description:

Screenshot_15.png

Here is the log description:

23  GLOBAL  2017-10-19 17:10:21.839 IST  Oracle Business Intelligence Cloud Service Data Sync (2.3), build: BICS-2.3.20170510.1832

24  GLOBAL  2017-10-19 17:10:21.842 IST  The System properties are: GLOBAL_LOG_FILE_DIRECTORY_FOR_THIS_RUN    C:\BICSDataSync_V2_3\log\dvcs_new-Job1.25140221

java.runtime.name    Java(TM) SE Runtime Environment

sun.boot.library.path    C:\Program Files\Java\jdk1.8.0_131\jre\bin

java.vm.version    25.131-b11

java.vm.vendor    Oracle Corporation

java.vendor.url    http://java.oracle.com/

path.separator    ;

ETL_EXECUTION_MODE    ETL_SERVER

java.vm.name    Java HotSpot(TM) 64-Bit Server VM

file.encoding.pkg    sun.io

user.country    US

user.script  

sun.java.launcher    SUN_STANDARD

sun.os.patch.level  

java.vm.specification.name    Java Virtual Machine Specification

user.dir    C:\BICSDataSync_V2_3

java.runtime.version    1.8.0_131-b11

java.awt.graphicsenv    sun.awt.Win32GraphicsEnvironment

java.endorsed.dirs    C:\Program Files\Java\jdk1.8.0_131\jre\lib\endorsed

os.arch    amd64

java.io.tmpdir    C:\Users\Admin\AppData\Local\Temp\

line.separator  

java.vm.specification.vendor    Oracle Corporation

user.variant  

os.name    Windows 10

sun.jnu.encoding    Cp1252

java.library.path    C:\Program Files\Java\jdk1.8.0_131\jre\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre1.8.0_131\bin\server;C:\Program Files\Java\jdk1.8.0_131\bin;C:\Program Files\Java\jre1.8.0_131\bin;C:\Program Files\Java\jre7\bin\server;C:\Program Files\Java\jdk1.7.0_79\bin;C:\Program Files\Java\jre7\bin;C:\ProgramData\Oracle\Java\javapath;C:\oraclexe\app\oracle\product\11.2.0\server\bin;C:\Program Files\Dell\DW WLAN Card;C:\DevSuiteHome_2\jdk\jre\bin\classic;C:\DevSuiteHome_2\jdk\jre\bin;C:\DevSuiteHome_2\jdk\jre\bin\client;C:\DevSuiteHome_2\jlib;C:\DevSuiteHome_2\bin;C:\DevSuiteHome_2\jre\1.4.2\bin\client;C:\DevSuiteHome_2\jre\1.4.2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\CrSSL\bin;C:\Users\Admin\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\CrSSL\bin;.

java.specification.name    Java Platform API Specification

java.class.version    52.0

sun.management.compiler    HotSpot 64-Bit Tiered Compilers

os.version    10.0

user.home    C:\Users\Admin

user.timezone    Asia/Calcutta

java.awt.printerjob    sun.awt.windows.WPrinterJob

file.encoding    Cp1252

java.specification.version    1.8

java.class.path    .\dacx.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derby.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyclient.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_cs.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_de_DE.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_es.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_fr.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_hu.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_it.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_ja_JP.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_ko_KR.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_pl.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_pt_BR.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_ru.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_zh_CN.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyLocale_zh_TW.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbynet.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyoptionaltools.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbyrun.jar;C:\Program Files\Java\jdk1.8.0_131\db\lib\derbytools.jar;

user.name    Admin

java.vm.specification.version    1.8

sun.java.command    com.siebel.analytics.etl.concurrentetl.ETLProcess EXECUTION_PLAN_NAME=dvcs new-Job1 ETL_PROCESS_ID=25140221 LAST_RUN_STATUS=Completed HONOR_TIME_LAGS=false ORIGIN_OF_REQUEST=null

java.home    C:\Program Files\Java\jdk1.8.0_131\jre

sun.arch.data.model    64

user.language    en

java.specification.vendor    Oracle Corporation

oracle.security.jps.config    C:\BICSDataSync_V2_3\conf\security/jps-config-jse.xml

awt.toolkit    sun.awt.windows.WToolkit

java.vm.info    mixed mode

java.version    1.8.0_131

java.ext.dirs    C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext

sun.boot.class.path    C:\Program Files\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_131\jre\classes

java.vendor    Oracle Corporation

file.separator    \

java.vendor.url.bug    http://bugreport.sun.com/bugreport/

sun.io.unicode.encoding    UnicodeLittle

sun.cpu.endian    little

sun.desktop    windows

sun.cpu.isalist    amd64

25  GLOBAL  2017-10-19 17:10:21.844 IST  Logging Started

26  GLOBAL  2017-10-19 17:10:21.847 IST  -Xmx value: -Xmx2048m

Max heap memory in MBs: 2048

29  SEVERE  2017-10-19 17:10:28.223 IST  Credentials don't exist: map=oracle.dac.mail key=userCredEnc.

30  SEVERE  2017-10-19 17:10:28.229 IST  Cannot get Email Password. Run the ServerSetup again!Credentials don't exist!

Make sure the properly configured cwallet file is used.

31  GLOBAL  2017-10-19 17:10:32.662 IST

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

START OF JOB

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

32  SEVERE  2017-10-19 17:10:40.219 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

33  SEVERE  2017-10-19 17:10:51.302 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

34  SEVERE  2017-10-19 17:11:02.426 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

35  SEVERE  2017-10-19 17:11:13.515 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

36  SEVERE  2017-10-19 17:11:24.658 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

37  SEVERE  2017-10-19 17:11:35.763 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

38  SEVERE  2017-10-19 17:11:46.931 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

39  SEVERE  2017-10-19 17:11:58.033 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

40  SEVERE  2017-10-19 17:12:09.123 IST  Error sending request "read index definition GL_LEDGERS_SYS" to https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/, will try again.

Error code 404

GET https://dvcs-in1globetrial.dataviz.us.oraclecloud.com/dataload/v1/tables/GL_LEDGERS/indexes/GL_LEDGERS_SYS returned a response status of 404 Not Found

41  SEVERE  2017-10-19 17:12:20.866 IST  C:\BICSDataSync_V2_3\CustomSQLs\ChangeCaptureFilter.xml (The system cannot find the file specified)

43  GLOBAL  2017-10-19 17:12:20.872 IST  Starting ETL Process.

44  SEVERE  2017-10-19 17:12:21.039 IST  MESSAGE:::This connection does not support relational tables.

EXCEPTION CLASS::: com.siebel.etl.gui.core.MetaDataIllegalStateException

com.siebel.etl.engine.core.Session.createOrAlterTables(Session.java:2195)

com.siebel.etl.engine.core.Session.executeTasks(Session.java:744)

com.siebel.etl.engine.core.Session.run(Session.java:876)

java.lang.Thread.run(Thread.java:748)

45  GLOBAL  2017-10-19 17:12:21.073 IST  Finishing ETL Process.

46  SEVERE  2017-10-19 17:12:21.075 IST  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(Thread.java:748)

47  SEVERE  2017-10-19 17:12:21.105 IST  Number of incomplete tasks whose status got updated to stopped :0

Number of incomplete task details whose status got updated to stopped :5

49  GLOBAL  2017-10-19 17:12:21.518 IST

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

END OF JOB

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

Could someone help me with this?

Thanks,

Bhuvana.