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 ===



SQL Server与MySQL数据库对比

Microsoft SQL Server 2008作为一个数据库平台在所有重要商业领域都胜过MySQL。它提供了一个大型的资源网络、行业领先的性能和企业级的可扩展性、最高级的安全性、一个广泛的商业智能...
  • madun
  • madun
  • 2014年01月21日 16:57
  • 19306

学习体会:SAP Data Services和SAP Replication Server的区别

SAP Data Services简称DS,可以手动/ 定时同步数据库A到数据库B。

Delphi7高级应用开发随书源码

  • 2003年04月30日 00:00
  • 676KB
  • 下载

websphere8.5 mysql数据源配置

  • 2017年11月07日 15:38
  • 3.46MB
  • 下载

基于jboss-as-web-7.0.2.Final的mysql数据源配置

近日装了jboss-as-web-7.0.2.Final,现将配置mysql数据源过程记录如下:      一、加入Mysql驱动文件      将mysql的驱动文件mysql-conn...
  • lc_qxr
  • lc_qxr
  • 2011年12月11日 16:01
  • 256

ejb3.0数据源配置文件mysql-ds.xml oracle-ds.xml persistence.xml sqlserver-ds.xml

ejb3.0数据源配置文件,直接COPY后将数据库名、用户名、密码改成你自己的,就能使用了。具体如下: mysql-ds.xml : http://www.mysql.com/down...
  • vebasan
  • vebasan
  • 2012年05月30日 10:51
  • 1992

tomcat5中配置mysql数据源

  • 2007年06月28日 17:59
  • 38KB
  • 下载

磕磕绊绊,Spring+Mybatis多数据源配置mysql+oracle

由于项目需要,需要为我的springMCV项目配置mysql+oracle两种数据源,运行时进行切换。由于技术水平有限,断断续续用了一周时间解决了这个小问题(比较懒),特来发篇博客,为以后需要的朋友提...

Spring配置MySQL数据源

  • 2015年09月15日 21:53
  • 3KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:SAP DS mysql数据源配置
举报原因:
原因补充:

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