Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbmlsrv9 -m Error?

5 posts in iAnywhere General Discussion (Chinese) Last posting was on 2006-05-07 14:11:29.0Z
cwf Posted on 2006-04-15 04:26:02.0Z
From: "cwf" <cwfok@sina.com>
Newsgroups: ianywhere.public.chinese.general
Subject: dbmlsrv9 -m Error?
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 219.140.221.251
X-Original-NNTP-Posting-Host: 219.140.221.251
Message-ID: <444075da@forums-1-dub>
Date: 14 Apr 2006 21:26:02 -0700
X-Trace: forums-1-dub 1145075162 219.140.221.251 (14 Apr 2006 21:26:02 -0700)
X-Original-Trace: 14 Apr 2006 21:26:02 -0700, 219.140.221.251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:497
Article PK: 376

When i start MobiLink server by dbmlsrv9.exe ,using '-m' option,i get these
errors,Why?


E. 04/03 22:46:52. ´íÎó: [QA] Statement SQLState is 42000
E. 04/03 22:46:52. ´íÎó: [QA] java.sql.SQLException: [Microsoft][ODBC SQL
Server Driver][SQL Server]µÚ 1 ÐÐ: '|' ¸½½üÓÐÓï·¨´íÎó¡£
E. 04/03 22:46:52. ´íÎó: [QA] Problem evaluating transmission rules for user
User1: Problem getting objects from repository using condition "select *
from ml_qa_repository mr where uploaded = 0 and status = 'pending' and
destination like 'Q' || ? || '\%' and ((select count(*) from
ml_qa_repository_props p where p.msgid = mr.msgid) = 0 )":
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]µÚ 1
ÐÐ: '|' ¸½½üÓÐÓï·¨´íÎó¡£
E. 04/03 22:46:52. ´íÎó: ianywhere.objrepos.ObjectRepositoryException:
Problem getting objects from repository using condition "select * from
ml_qa_repository mr where uploaded = 0 and status = 'pending' and
destination like 'Q' || ? || '\%' and ((select count(*) from
ml_qa_repository_props p where p.msgid = mr.msgid) = 0 )":
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]µÚ 1
ÐÐ: '|' ¸½½üÓÐÓï·¨´íÎó¡£
E. 04/03 22:46:52. ´íÎó: at
ianywhere.objrepos.db.BasicObjectRepositoryDB.getByParams(BasicObjectRepositoryDB.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.objrepos.db.BasicObjectRepositoryDB.getByCondition(BasicObjectRepositoryDB.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.repository.MessageBeanRepositoryBean.getByCondition(MessageBeanRepositoryBean.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.ReplicationSQLRuleEngine.populateMessagePropertiesRepository(ReplicationSQLRuleEngine.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.ReplicationSQLRuleEngine.lowLevelEvaluateRuleGroup(ReplicationSQLRuleEngine.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.NotifierSQLRuleEngine.evaluateRuleGroup(NotifierSQLRuleEngine.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.RuleManagerImpl.evaluateRules(RuleManagerImpl.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.RuleManagerImpl.evaluateRules(RuleManagerImpl.java)
E. 04/03 22:46:52. ´íÎó: at
ianywhere.message.rules.NotifierManagerImpl$1.run(NotifierManagerImpl.java)
E. 04/03 22:46:52. ´íÎó: at java.util.TimerThread.mainLoop(Unknown Source)
E. 04/03 22:46:52. ´íÎó: at java.util.TimerThread.run(Unknown Source)

--chenwf


Raymond.Kwong Posted on 2006-04-20 02:37:31.0Z
MIME-Version: 1.0
X-MIMETrack: Serialize by Notes Client on Raymond Kwong/SYBASE(Release 6.5|September 26, 2003) at 04/19/2006 09:16:18 PM, Serialize complete at 04/19/2006 09:16:18 PM, Serialize by Notes Client on Raymond Kwong/SYBASE(Release 6.5|September 26, 2003) at 04/19/2006 09:21:36 PM, Serialize complete at 04/19/2006 09:21:36 PM
From: Raymond.Kwong@sybase.com
Subject: Re: dbmlsrv9 -m Error?
Newsgroups: ianywhere.public.chinese.general
References: <444075da@forums-1-dub>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
Content-Type: multipart/alternative; boundary="=_alternative 000778C485257156_="
X-Original-NNTP-Posting-Host: rkwong-xp.sybase.com
Message-ID: <4446e348$1@forums-2-dub>
X-Original-Trace: 19 Apr 2006 18:26:32 -0700, rkwong-xp.sybase.com
Lines: 44
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Apr 2006 18:26:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Apr 2006 19:37:31 -0700
X-Trace: forums-1-dub 1145500651 10.22.108.75 (19 Apr 2006 19:37:31 -0700)
X-Original-Trace: 19 Apr 2006 19:37:31 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:501
Article PK: 3963


QAnywhere 按道理是应该能探测到微软SQL Server作出适当调整(例如以+代||)的!

然而这是可以纠正的。你可以创建一个包含下列数行的QAnywhere设定值档 (姑且叫它做qanyserv.props吧):



ianywhere.qa.db.pstmtCacheSize=-1
ianywhere.qa.db.blobThreshold=1000
ianywhere.qa.db.concatenationOperator=+
ianywhere.qa.db.currentTimestampFunction=getdate()
ianywhere.qa.db.deleteCorrNameVariation=SS
ianywhere.qa.db.procNameLengths=short
ianywhere.qa.db.procNameOwner=????
ianywhere.qa.db.supportsSelectFirst=TOP

上述的???? , 应是连接数据库时用的 UID 值。

然後像下列方法还行QAnywhere:

dbmlsrv9 -m qanyserv.props ........


cwf Posted on 2006-04-23 12:19:50.0Z
From: "cwf" <cwfok@sina.com>
Newsgroups: ianywhere.public.chinese.general
References: <444075da@forums-1-dub> <4446e348$1@forums-2-dub>
Subject: Re: dbmlsrv9 -m Error?
Lines: 141
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C66709.0E705FD0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 219.140.220.127
X-Original-NNTP-Posting-Host: 219.140.220.127
Message-ID: <444b70e6@forums-1-dub>
Date: 23 Apr 2006 05:19:50 -0700
X-Trace: forums-1-dub 1145794790 219.140.220.127 (23 Apr 2006 05:19:50 -0700)
X-Original-Trace: 23 Apr 2006 05:19:50 -0700, 219.140.220.127
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:503
Article PK: 17303

Raymond.Kwong,
  你总能给我带来惊喜!非常感谢你.
  按照你的方法,已经能使用-m选项进行SqlServer中的qanywhere系统表和客户端QanyWhere系统表之间这复制,我想关键是用了你回复中的'ianywhere.qa.db.concatenationOperator=+' 选项.
  在这里还想请问一下,这些配置还没有公开的吗?我怎么找了很多文档都找不到这些参数设置的说明,如果不麻烦的话,能否说明一下这方面的配置信息.
<Raymond.Kwong@sybase.com> 写入消息新闻:4446e348$1@forums-2-dub...

QAnywhere 按道理是应该能探测到微软SQL Server作出适当调整(例如以+代||)的!

然而这是可以纠正的。你可以创建一个包含下列数行的QAnywhere设定值档(姑且叫它做qanyserv.props吧):



ianywhere.qa.db.pstmtCacheSize=-1
ianywhere.qa.db.blobThreshold=1000
ianywhere.qa.db.concatenationOperator=+
ianywhere.qa.db.currentTimestampFunction=getdate()
ianywhere.qa.db.deleteCorrNameVariation=SS
ianywhere.qa.db.procNameLengths=short
ianywhere.qa.db.procNameOwner=????
ianywhere.qa.db.supportsSelectFirst=TOP

上述的???? , 应是连接数据库时用的 UID 值。

然後像下列方法还行QAnywhere:

dbmlsrv9 -m qanyserv.props ........


Raymond.Kwong Posted on 2006-05-02 23:21:34.0Z
MIME-Version: 1.0
X-MIMETrack: Serialize by Notes Client on Raymond Kwong/SYBASE(Release 6.5|September 26, 2003) at 05/02/2006 07:15:22 PM, Serialize complete at 05/02/2006 07:15:22 PM, Serialize by Notes Client on Raymond Kwong/SYBASE(Release 6.5|September 26, 2003) at 05/02/2006 07:21:31 PM, Serialize complete at 05/02/2006 07:21:31 PM
From: Raymond.Kwong@sybase.com
Subject: Re: dbmlsrv9 -m Error?
Newsgroups: ianywhere.public.chinese.general
References: <444075da@forums-1-dub> <4446e348$1@forums-2-dub> <444b70e6@forums-1-dub>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
Content-Type: multipart/alternative; boundary="=_alternative 0080505685257162_="
NNTP-Posting-Host: rkwong-xp.sybase.com
X-Original-NNTP-Posting-Host: rkwong-xp.sybase.com
Message-ID: <4457e97e@forums-1-dub>
Date: 2 May 2006 16:21:34 -0700
X-Trace: forums-1-dub 1146612094 10.25.98.158 (2 May 2006 16:21:34 -0700)
X-Original-Trace: 2 May 2006 16:21:34 -0700, rkwong-xp.sybase.com
Lines: 38
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:506
Article PK: 533


不可不提,看来阁下安装了9.0.2版 但仍有 9.0.1 版的 qaconnector.jar.  如果你是事用9.0.1版,这些资料是写在readme里的。

在9.0.2 版,QAnywhere设计上是自动辩识ODBC驱动器,并自动作出调校的。在9.0.2 版中我们应避免更该设定,故此并没有把这些加入。

在 9.0.2 版里 META-INF/MANIFEST.MF 档会说明QAnywhere 的版数.  请阁下检查 qaconnector.jar 里有没有该档,及里面说的版数正确。若阁下使用  Sun 的工具,可用下列办法提取该档检阅:

jar xf qaconnector.jar META-INF/MANIFEST.MF

此META-INF/MANIFEST.MF 档应有下列两行:

Implementation-Version: 9.0.2.????
Implementation-Vendor: Sybase, Inc.


cwf Posted on 2006-05-07 14:11:29.0Z
From: "cwf" <cwfok@sina.com>
Newsgroups: ianywhere.public.chinese.general
References: <444075da@forums-1-dub> <4446e348$1@forums-2-dub> <444b70e6@forums-1-dub> <4457e97e@forums-1-dub>
Subject: Re: dbmlsrv9 -m Error?
Lines: 122
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_005C_01C67223.2746A1C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Original-NNTP-Posting-Host: 221.232.211.185
Message-ID: <445e000e@forums-2-dub>
X-Original-Trace: 7 May 2006 07:11:26 -0700, 221.232.211.185
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 May 2006 07:11:29 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 May 2006 07:11:29 -0700
X-Trace: forums-1-dub 1147011089 10.22.108.75 (7 May 2006 07:11:29 -0700)
X-Original-Trace: 7 May 2006 07:11:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:509
Article PK: 17309

Raymond.Kwong:
      我检查了qaconnector.jar/META-INF/MANIFEST.MF,发现其内容和你介绍的不一样,我的ASA9是安装了9.01版本后再下载补丁到9.0.1.2085 ,文件的内容如下:
 
Manifest-Version: 1.0
Created-By: 1.4.2_06 (Sun Microsystems Inc.)
 
 
<Raymond.Kwong@sybase.com> 写入消息新闻:4457e97e@forums-1-dub...

不可不提,看来阁下安装了9.0.2版但仍有 9.0.1 版的 qaconnector.jar.  如果你是事用9.0.1版,这些资料是写在readme里的。

在9.0.2 版,QAnywhere设计上是自动辩识ODBC驱动器,并自动作出调校的。在9.0.2 版中我们应避免更该设定,故此并没有把这些加入。

在 9.0.2 版里 META-INF/MANIFEST.MF 档会说明QAnywhere 的版数.  请阁下检查 qaconnector.jar 里有没有该档,及里面说的版数正确。若阁下使用  Sun 的工具,可用下列办法提取该档检阅:

jar xf qaconnector.jar META-INF/MANIFEST.MF

此META-INF/MANIFEST.MF 档应有下列两行:

Implementation-Version: 9.0.2.????
Implementation-Vendor: Sybase, Inc.