DataServices常见问题处理

Data Services常见问题处理

1.登录Data Services Designer失败

错误现象：Addition Information：< Session: SDK failure >，具体如下图所示

错误原因：在Designer所在主机上缺少Data Services服务器主机信息
解决方法：修改登录主机的hosts文件（文件位置：C:\Windows\System32\drivers\etc），增加Data Services服务器主机IP及主机名，保存之后再次使用Data Services Designer登录成功

2.登录CMC失败报错

2.1 FWM20030错误

错误原因1：ips服务问题
解决方法1：重启ips服务

错误原因2：未启动相关服务
解决方法2：启动相关服务（安装IPS时有指定安装路径）

$ cd <IPS Install Path>/sap_bobj
$ ./startservers

2.2 FWM20031错误

错误原因1：IPS安装时端口重复
安装IPS时端口重复并未出现相关报错信息，而是在安装Data Services时，会出现如下报错信息：

Error
An error has occurred.
Press Enter to continue.
Invalid CMS Connection Information.

Please check the CMS connection information, 
make sure they are correct and the CMS is up and running, then try again.

解决方法1：执行IPS安装程序，对IPS进行卸载后重新进行安装

错误原因2：相关服务问题
解决方法2：重启相关服务后，重新登录CMC

$ cd <IPS Install Path>/sap_bobj/tomcat/bin
$ ./shutdown.sh
$ cd <IPS Install Path>/sap_bobj
$ ./sqlanywhere_shutdown.sh
$ ./stopservers

$ cd <IPS Install Path>/sap_bobj
$ ./sqlanywhere_startup.sh
$ cd <IPS Install Path>/sap_bobj/tomcat/bin
$./startup.sh
$ cd <IPS Install Path>/sap_bobj
$ ./startservers

3.创建Job Server失败

错误现象1：svrcfg创建Job Server时出现如下错误信息：

S#  Job Server Name  TCP    Repository Information        
                     Port                                 
--  ---------------  ----   ---------------------         

1   Server1          3500   dba@ds_repo__dba              

Is this information correct [Y/N]?  [Y]: Y
Error occurs while Connecting to repository. Error: (14.2) 04-10-20 21:42:12 (R) (30583:2104112928) CON-120302: Initialization
ODBC call <SQLConnect> for data source <ds_repo> failed: <[Sybase][ODBC Driver][SQL Anywhere]Database server not found>. Notify
Customer Support.
(14.2) 04-10-20 21:42:12 (E) (30583:2104112928) CON-120302: Initialization
ODBC call <SQLConnect> for data source <ds_repo> failed: <*****>. Notify Customer Support. This message contains some internal
system details which have been hidden for security. If you need to see the full contents of the original message, ask your
administrator to assign additional privileges to your account.

Continue to Add/Modify/Delete Job Servers[Y/N]: N

错误原因：
1.在ODBCINI路径（< IPS Install Path >/sap_bobj/enterprise_xi40）下缺失odbc.ini配置文件
2.在ODBCINI路径下的odbc.ini文件无对应的db条目
3.未执行$ODBCINI环境变量

错误现象2：svrcfg创建Job Server时出现如下错误信息：

S#  Job Server Name  TCP    Repository Information        
                     Port                                 
--  ---------------  ----   ---------------------         

1   Server1          3500   dba@ds_repo__dba              

Is this information correct [Y/N]?  [Y]: Y

Updating the repository <dba@ds_repo__dba>.  Please wait...

UNABLE to Update the repository <dba@ds_repo__dba>. Error: terminate called after throwing an instance of 'RWInternalErr'



Continue to Add/Modify/Delete Job Servers[Y/N]: N

解决方法：
1.参考处理：
链接：How to Add Local Repo with Data Services Job Server in LINUX | SAP Blogs https://blogs.sap.com/2014/02/05/how-to-add-local-repo-with-data-services-job-server-in-linux/
步骤：

See SAP Note 2880394:

cp $LINK_DIR/bin/CreateDemoCerts.sh
$LINK_DIR/bin/CreateDemoCerts_bkup.sh
vi $LINK_DIR/bin/CreateDemoCerts_bkup.sh
change entry: export VALIDITY_DAYS= change from 10950 to 9125
cp -rf $LINK_DIR/ssl $LINK_DIR/ssl.bkup
rm -rf $LINK_DIR/ssl/server/*
$LINK_DIR/bin/CreateDemoCerts.sh

2.处理步骤：

--配置环境变量
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<IPS Install Path>/dataservices/bin
export BOE_REGISTRYHOME=<IPS Install Path>/sap_bobj/data/.bobj/registry
export LINK_DIR=<IPS Install Path>/dataservices
export ODBCINI=<IPS Install Path>/sap_bobj/enterprise_xi40/odbc.ini

--备份相关文件
cp $LINK_DIR/bin/CreateDemoCerts.sh $LINK_DIR/bin/CreateDemoCerts.sh.bak 
mkdir $LINK_DIR/ssl.bak
cp -a $LINK_DIR/ssl/* $LINK_DIR/ssl.bak/

--修改脚本，将VALIDITY_DAYS由默认的10950改为9125
vi $LINK_DIR/bin/CreateDemoCerts.sh
change entry: export VALIDITY_DAYS= change from 10950 to 9125

--删除文件并重新执行脚本
rm -rf $LINK_DIR/ssl/server/*
$LINK_DIR/bin/CreateDemoCerts.sh

执行完上述操作后，重新创建Job Server，问题解决。