【第22期】观点:IT 行业加班,到底有没有价值?

SAP DS mysql数据源配置

原创 2015年07月08日 11:56:22

DS完成mysql-oracle之间的ETL。DS连接oracle没有问题,现在要连接Mysql。已经配置好mysql odbc(http://blog.csdn.net/u010587433/article/details/46799037

接下来配置DS数据源。

其实需求来源于应用在完成DS配置后,开启job的时候总报错,如下:


DS上使用的oracle用户。

su - oracle
export DISPLAY=192.168.1.2:0.0
cd $LINK_DIR/bin
./DSConnectionManager.sh

ADD添加


点击OK


测试



配置完成,并成功连接。

mysql-oracle是没有问题的,但是oracle-mysql失败。即,mysql可读,不可写。问题还没有解决,客户端报错如图。如有知道的大侠还望告知。谢谢!


DS服务器端后台日志没有信息,只在$LIND_DIR/log/stack_trace.txt中生成信息如下:

=== Start Stack Trace dump. Signal: 6 PID: 15058===

Thread 6 (Thread 0x7f0f2845a700 (LWP 15060)):
#0  0x000000315ac0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f0f34bd9c7e in RWCondition::wait(unsigned long) () from /home/oracle/BOD/dataservices/bin/libsync3012d.so
#2  0x0000000001760939 in CTimer::main() ()
#3  0x0000000001760fec in RWTFunctor0MImp<CTimer, void>::run() const ()
#4  0x00007f0f34e38933 in RWThreadFunctionImp::run() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#5  0x00007f0f34e19818 in RWRunnableImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#6  0x00007f0f34e3988c in RWThreadImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#7  0x00007f0f34e39929 in RWThreadImp_entry () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#8  0x000000315ac07851 in start_thread () from /lib64/libpthread.so.0
#9  0x000000315a8e890d in clone () from /lib64/libc.so.6
Thread 5 (Thread 0x7f0f18782700 (LWP 15329)):
#0  0x000000315ac0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f0f34bd9c7e in RWCondition::wait(unsigned long) () from /home/oracle/BOD/dataservices/bin/libsync3012d.so
#2  0x000000000174354b in memoryMonitor::main() ()
#3  0x000000000174399e in RWTFunctor0MImp<memoryMonitor, void>::run() const ()
#4  0x00007f0f34e38933 in RWThreadFunctionImp::run() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#5  0x00007f0f34e19818 in RWRunnableImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#6  0x00007f0f34e3988c in RWThreadImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#7  0x00007f0f34e39929 in RWThreadImp_entry () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#8  0x000000315ac07851 in start_thread () from /lib64/libpthread.so.0
"stack_trace.txt" 17425L, 1270541C                                                                                                                   17239,0-1     99%
#3  0x000000000176799c in ActaHandler(int) ()
#4  <signal handler called>
#5  0x000000315a8328a5 in raise () from /lib64/libc.so.6
#6  0x000000315a834085 in abort () from /lib64/libc.so.6
#7  0x000000315a82ba1e in __assert_fail_base () from /lib64/libc.so.6
#8  0x000000315a82bae0 in __assert_fail () from /lib64/libc.so.6
#9  0x00007f0b3a577d50 in mysql_table_status () from /usr/local/lib/libmyodbc5.so
#10 0x00007f0b3a57b425 in mysql_columns () from /usr/local/lib/libmyodbc5.so
#11 0x00007f0b3a576df3 in i_s_columns () from /usr/local/lib/libmyodbc5.so
#12 0x00007f0b3a576f2c in MySQLColumns () from /usr/local/lib/libmyodbc5.so
#13 0x00007f0b3a58c028 in SQLColumnsW () from /usr/local/lib/libmyodbc5.so
#14 0x0000000000de1d3e in ConnODBC::SQLColumns(void*, unsigned short*, short, unsigned short*, short, unsigned short*, short, unsigned short*, short) ()
#15 0x000000000100f13a in OdbcDB::fixupColumnType(DIUString, DIUString, Elem_vect*, unsigned int) ()
#16 0x00000000018dcb6d in LoadDB::fixupVarcharForCharColType(Loader_runtime*) ()
#17 0x00000000018dd3c2 in LoadDB::setUpConnectionItemVectors(Loader_runtime*, bool) ()
#18 0x00000000018f0cf4 in LoadDB::execute(XTran_desc&) ()
#19 0x0000000000d07ff1 in XTran_desc::execute() ()
#20 0x00000000007c89e6 in Rww_thread::main() ()
#21 0x00000000007c958e in RWTFunctor0MImp<Rww_thread, void>::run() const ()
#22 0x00007f0b53561933 in RWThreadFunctionImp::run() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#23 0x00007f0b53542818 in RWRunnableImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#24 0x00007f0b5356288c in RWThreadImp::exec() () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#25 0x00007f0b53562929 in RWThreadImp_entry () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#26 0x000000315ac07851 in start_thread () from /lib64/libpthread.so.0
#27 0x000000315a8e890d in clone () from /lib64/libc.so.6
Thread 1 (Thread 0x7f0b4caa7720 (LWP 15405)):
#0  0x000000315ac0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f0b53302c7e in RWCondition::wait(unsigned long) () from /home/oracle/BOD/dataservices/bin/libsync3012d.so
#2  0x00007f0b5354c358 in RWTPCValBufferBase<RWRunnableExecutionStatePair>::read(RWRunnableExecutionStatePair&, unsigned long) () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#3  0x00007f0b5354b747 in RWRunnableTrapImp::getNext(RWRunnable&, unsigned long) () from /home/oracle/BOD/dataservices/bin/libthread3012d.so
#4  0x00000000007c5e62 in Rww_runnabletrap::get(Rww_runnable&, unsigned long) ()
#5  0x0000000000ce392e in XProc_children::wait4threads() ()
#6  0x0000000000ceaa87 in XDataflow_desc::executeInline() ()
#7  0x0000000000cb43d0 in XDataflow_info::execute(XDataflow_desc&) ()
#8  0x0000000000cf90e7 in XDataflow_desc::execute() ()
#9  0x0000000000caf7a8 in XDataflow_info::compute(XCall_desc*, XExec_flag, int&, DIUString&, DIUString&, DIUString&) ()
#10 0x0000000000cab02c in XDataflow_info::compute(XCall_desc*, XExec_flag) ()
#11 0x0000000001d2e56d in AE_Main_Process_Options(int, unsigned short**, unsigned long, unsigned long, unsigned int&) ()
#12 0x0000000001d3fb5e in AE_Main ()
#13 0x0000000001ce7dad in exec_command_file(int, char**, char*, int, bool) ()
#14 0x0000000001ce8c1a in main ()

=== End Stack Trace dump. PID: 15405 ===



版权声明: 举报

相关文章推荐

[Oracle, MySQL] Oracle通过dblink连接MySQL

业务上有这么一个需求,需要把Oracle的一些数据同步到MySQL,如果每次都是手动同步的话,实在太麻烦,因此花了点时间研究了下Oracle直连MySQL的方式。 参考文档:Detailed Over...

linux下mysql odbc配置

公司内部用的SAP data service(linux,IP:136)作为DS服务器,使用ODBC连接另外一台mysql数据库服务器(linux IP:129)。所以在136上安装mysql odb...

使用事务码DBCO实现SAP链接外部数据库以及读取例程

使用事务码DBCO实现SAP链接外部数据库以及读取例程

细说SAP Sybase ASE数据库中的ODBC驱动(Windows ODBC篇)

SAP Sybase ASE数据库自从12.5到15.0,再到15.5,再到15.7,这几个阶段,ODBC驱动也发生了一些变化,具体变化涉及到一些内部细节,就不公开了.这里主要介绍一下这些驱动的注册方...
  • iihero
  • iihero
  • 2013-12-06 20:49
  • 9742

各种数据库的jdbc驱动下载及连接方式

http://www.cnblogs.com/netshuai/archive/2009/07/11/1521705.html 各种数据库驱动 数据库名称 下载地址 说...

各种数据库的jdbc驱动下载及连接方式

各种数据库驱动 数据库名称 下载地址 说明 Mysql ...

SAP xi/pi连接access数据库

In case you are facing issue connecting MS Access with SAP PI, this document might be useful to you....

SAP lumira建立数据源集合

SAP lumira配置数据集合报错Java Classnot found in classpath: com.mysql.jdbc.Driver,如下所示:E:\u\sap\pic\lurima00...
  • mchdba
  • mchdba
  • 2016-10-28 20:44
  • 1268

mysql数据源配置

mysql数据源配置 1.进入 http://localhost:8080/admin/conf文件夹下的tomcat-users.xml   有管理员的用户名密码等信息。   选择Resources...
  • laiahu
  • laiahu
  • 2007-03-23 23:11
  • 10475
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)