关闭

SAP DS mysql数据源配置

标签: SAP data servicemysql odbcDS数据源配置
1406人阅读 评论(2) 收藏 举报
分类:

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



0
0
查看评论

hybris 使用MySQL数据库

参考:https://wiki.hybris.com/display/pqn/MySQL+database+configuration+on+Windows大致过程:下载安装
  • berryreload
  • berryreload
  • 2014-10-30 12:59
  • 4431

SAP Data Services如何链接MYSQL

  • 2013-11-04 09:42
  • 1.43MB
  • 下载

abap直连第三方数据库(sqlserver,oracle)

1.工作环境需求 A. The operating system user <sid>adm must be able to log on to the secondary database. B. The R/3 table DBCON must be mainta...
  • champaignwolf
  • champaignwolf
  • 2015-05-18 21:34
  • 3482

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

SAP Data Services简称DS,可以手动/ 定时同步数据库A到数据库B。
  • berryreload
  • berryreload
  • 2014-06-28 06:05
  • 2578

SAP DS mysql数据源配置

DS完成mysql-oracle之间的ETL。DS连接oracle没有问题,现在要连接Mysql。已经配置好mysql odbc(http://blog.csdn.net/u010587433/article/details/46799037) 接下来配置DS数据源。 其实需求来源于应用在完成DS配...
  • u010587433
  • u010587433
  • 2015-07-08 11:56
  • 1406

关于Universe和IDT链接数据库的JDBC配置

情况一:Universe链接Oracle(选择客户端链接方式)   开发端:客户端装的BO Client Tool 4.0版本要和Oracle Client要一致,即同为32位或64位 运行时:由于BOE 4.0为64位,所以在BOE调相应驱动时会调用:C:\Progra...
  • Liu_Fengming
  • Liu_Fengming
  • 2014-07-03 15:07
  • 827

BMP图像的选择与显示

void CMFCTestDlg::OnBnClickedButton1() { // TODO: 在此添加控件通知处理程序代码 UpdateData(TRUE); CFileDialog file_open_dlg(TRUE,NULL,NULL,OFN_HIDEREADONLY,("...
  • hhys08120
  • hhys08120
  • 2013-12-28 10:59
  • 627

sap 数据库表

  • 2017-09-07 11:21
  • 642KB
  • 下载

SAP Download Manager

  • 2013-05-15 14:02
  • 12.78MB
  • 下载
    个人资料
    • 访问:188996次
    • 积分:3438
    • 等级:
    • 排名:第11563名
    • 原创:151篇
    • 转载:28篇
    • 译文:2篇
    • 评论:24条
    文章分类
    最新评论