今天重新安装了SCE CM3.1.6解决了sybdata目录占用空间十分大的问题，原来是在安装过程中一个参数设置问题，如下：
Waiting for Sybase to come up... (1 of 60)
calling configuration sequence...Starting Sybase configuration sequence
Waiting for Sybase to come up... (0 of 60)
Please enter SIZE in 2K blocks of file to be used for the "data[maximum is 41661909; minimum is 5242798]" device.
NOTE - the actual size required will include a 1.05 overhead on the amount you specify.
SIZE in 2K blocks: 15728394
Do you want to input the values again? (yes/no): no
在前面安装过程中，一直设置为最大41661909，使硬盘占用达到80G左右，同时安装速度也很慢。后来计算了下设置成15723894，即最小5242798的3倍。
安装完成后，测试OK
-bash-3.00$ ./alive.sh
STATUS OK
-bash-3.00$ ./on-boot.py
sybase: on
cm: on
-bash-3.00$
可是在准备用SCA BB Console查看流量监控图像时，发现“Window －> Preferences -> Reporter -> Templates -> IP of SCE for policy data ”下拉框中无可选的SCE IP。 查看SCA BB Console日志部分信息如下：
!ENTRY com.cisco.p3.apps.reporter 4 4 2008-10-03 13:51:02.437
!MESSAGE VelocityTools::sqlToNestedMaps - error executing sql
!STACK 0
com.sybase.jdbc2.jdbc.SybSQLException: INI_VALUES not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2884)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2206)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1766)
at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758)
at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:815)
at com.cisco.p3.apps.reporter.db.Query.execute(Query.java:110)
at com.cisco.p3.apps.reporter.velocity.VelocityTools.sqlToNestedMaps(VelocityTools.java:152)
at com.cisco.p3.apps.reporter.velocity.VelocityTools.sqlToNestedMaps(VelocityTools.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:51)
at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:95)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:316)
at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:210)
at com.cisco.p3.apps.reporter.velocity.VelocityParser.parse(VelocityParser.java:67)
at com.cisco.p3.apps.reporter.templates.repository.FileTemplateRepository.initializeStatic(FileTemplateRepository.java:261)
at com.cisco.p3.apps.reporter.templates.repository.FileTemplateRepository$1.run(FileTemplateRepository.java:231)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)
!ENTRY com.cisco.p3.apps.reporter 4 4 2008-10-03 13:51:02.468
!MESSAGE VelocityTools::sqlToNestedMaps - error executing sql
利用condition testing结果如下：
SCA BB Templates:
[PASS] A database connection is defined and available.
[FAIL] Not all mandatory prederences are set (IP of SCE for policy data).
[SKIP] Policy string translations in CM DB.
[SKIP] Timezone information in CM DB.
由上可以看出问题集中在IP of SCE，但查了许久也没找到问题所在。