51Testing软件测试论坛

标题: Clearquest数据库导入时报错求助 [打印本页]

---

作者: yuqiong    时间: 2006-7-7 16:28
标题: Clearquest数据库导入时报错求助
IMP-00017: 由于 ORACLE 错误6550，以下的语句失败
"BEGIN  "
"ctxsys.driimp.create_index('MLTEXT_DOC','MULTILINE_TEXT',USER,"
"'','1','DATA','8',"
"'0','13209','8130','14546',"
"NULL, NULL, NULL, 0);"
""
""
"ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);"
""
"ctxsys.driimp.set_object('DATATYPE','LONG_DATATYPE',0);"
""
"ctxsys.driimp.set_object('DATAX','SYNCH_DATAX',0);"
""
"ctxsys.driimp.set_object('FILTER','NULL_FILTER',0);"
""
"ctxsys.driimp.set_object('SECTION_GROUP','NULL_SECTION_GROUP',0);"
""
"ctxsys.driimp.set_object('LEXER','CHINESE_VGRAM_LEXER',0);"
""
"ctxsys.driimp.set_object('WORDLIST','BASIC_WORDLIST',2);"
"ctxsys.driimp.set_value('STEMMER','1');"
"ctxsys.driimp.set_value('FUZZY_MATCH','1');"
""
"ctxsys.driimp.set_object('STOPLIST','BASIC_STOPLIST',76);"
"ctxsys.driimp.set_value('STOP_WORD','Corp');"
"ctxsys.driimp.set_value('STOP_WORD','Mr');"
"ctxsys.driimp.set_value('STOP_WORD','Mrs');"
"ctxsys.driimp.set_value('STOP_WORD','Ms');"
"ctxsys.driimp.set_value('STOP_WORD','Mz');"
"ctxsys.driimp.set_value('STOP_WORD','a');"
"ctxsys.driimp.set_value('STOP_WORD','about');"
"ctxsys.driimp.set_value('STOP_WORD','after');"
"ctxsys.driimp.set_value('STOP_WORD','all');"
"ctxsys.driimp.set_value('STOP_WORD','also');"
"ctxsys.driimp.set_value('STOP_WORD','an');"
"ctxsys.driimp.set_value('STOP_WORD','and');"
"ctxsys.driimp.set_value('STOP_WORD','any');"
"ctxsys.driimp.set_value('STOP_WORD','are');"
"ctxsys.driimp.set_value('STOP_WORD','as');"
"ctxsys.driimp.set_value('STOP_WORD','at');"
"ctxsys.driimp.set_value('STOP_WORD','be');"
"ctxsys.driimp.set_value('STOP_WORD','because');"
"ctxsys.driimp.set_value('STOP_WORD','been');"
"ctxsys.driimp.set_value('STOP_WORD','but');"
"ctxsys.driimp.set_value('STOP_WORD','by');"
"ctxsys.driimp.set_value('STOP_WORD','can');"
"ctxsys.driimp.set_value('STOP_WORD','co');"
"ctxsys.driimp.set_value('STOP_WORD','could');"
"ctxsys.driimp.set_value('STOP_WORD','for');"
"ctxsys.driimp.set_value('STOP_WORD','from');"
"ctxsys.driimp.set_value('STOP_WORD','had');"
"ctxsys.driimp.set_value('STOP_WORD','has');"
"ctxsys.driimp.set_value('STOP_WORD','have');"
"ctxsys.driimp.set_value('STOP_WORD','he');"
"ctxsys.driimp.set_value('STOP_WORD','her');"
"ctxsys.driimp.set_value('STOP_WORD','his');"
"ctxsys.driimp.set_value('STOP_WORD','if');"
"ctxsys.driimp.set_value('STOP_WORD','in');"
"ctxsys.driimp.set_value('STOP_WORD','inc');"
"ctxsys.driimp.set_value('STOP_WORD','into');"
"ctxsys.driimp.set_value('STOP_WORD','is');"
"ctxsys.driimp.set_value('STOP_WORD','it');"
"ctxsys.driimp.set_value('STOP_WORD','its');"
"ctxsys.driimp.set_value('STOP_WORD','last');"
"ctxsys.driimp.set_value('STOP_WORD','more');"
"ctxsys.driimp.set_value('STOP_WORD','most');"
"ctxsys.driimp.set_value('STOP_WORD','no');"
"ctxsys.driimp.set_value('STOP_WORD','not');"
"ctxsys.driimp.set_value('STOP_WORD','of');"
"ctxsys.driimp.set_value('STOP_WORD','on');"
"ctxsys.driimp.set_value('STOP_WORD','one');"
"ctxsys.driimp.set_value('STOP_WORD','only');"
"ctxsys.driimp.set_value('STOP_WORD','or');"
"ctxsys.driimp.set_value('STOP_WORD','other');"
"ctxsys.driimp.set_value('STOP_WORD','out');"
"ctxsys.driimp.set_value('STOP_WORD','over');"
"ctxsys.driimp.set_value('STOP_WORD','s');"
"ctxsys.driimp.set_value('STOP_WORD','says');"
"ctxsys.driimp.set_value('STOP_WORD','she');"
"ctxsys.driimp.set_value('STOP_WORD','so');"
"ctxsys.driimp.set_value('STOP_WORD','some');"
"ctxsys.driimp.set_value('STOP_WORD','such');"
"ctxsys.driimp.set_value('STOP_WORD','than');"
"ctxsys.driimp.set_value('STOP_WORD','that');"
"ctxsys.driimp.set_value('STOP_WORD','the');"
"ctxsys.driimp.set_value('STOP_WORD','their');"
"ctxsys.driimp.set_value('STOP_WORD','there');"
"ctxsys.driimp.set_value('STOP_WORD','they');"
""
"ctxsys.driimp.set_value('STOP_WORD','this');"
"ctxsys.driimp.set_value('STOP_WORD','to');"
"ctxsys.driimp.set_value('STOP_WORD','up');"
"ctxsys.driimp.set_value('STOP_WORD','was');"
"ctxsys.driimp.set_value('STOP_WORD','we');"
"ctxsys.driimp.set_value('STOP_WORD','were');"
"ctxsys.driimp.set_value('STOP_WORD','when');"
"ctxsys.driimp.set_value('STOP_WORD','which');"
"ctxsys.driimp.set_value('STOP_WORD','who');"
"ctxsys.driimp.set_value('STOP_WORD','will');"
"ctxsys.driimp.set_value('STOP_WORD','with');"
"ctxsys.driimp.set_value('STOP_WORD','would');"
""
"ctxsys.driimp.set_object('STORAGE','BASIC_STORAGE',2);"
"ctxsys.driimp.set_value('R_TABLE_CLAUSE','lob (data) store as (cache)');"
"ctxsys.driimp.set_value('I_INDEX_CLAUSE','compress 2');"
""
"commit;"
"COMMIT; END;"
IMP-00003: ORACLE 错误6550出现
ORA-06550: 第 2 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 8 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 8 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 10 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 10 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 12 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 12 行, 第 1 列:
PL/SQL: Statement ign
IMP-00088: 导入索引MLTEXT_DOC的元数据时出现错误，将跳过索引创建
准备启用约束条件...
成功终止导入，但出现警告。

登陆Clearquest客户端（win），双击Public Queries列表中已建立的项目文件夹下的Query目录，报错：
sdlkfj2ERROR！Multiline text search is currently disabled.You must remove the text filter from the query before running it.Contact your dba to resolve this problem. Possible causes are:
1.ConText/InterMedia Text server is not running.
2.Required index and/or policy is not properly created in the database.
   Refer to 'setup_cq_ora_user.sql'and'setup_cq_intermedia.sql'for Oracle 8i or'setup_cq_ctx_policy.sql'for 7.3 and 8.0 in ClearQuest install directory.

以前用同样的方法导入数据库一直没有出现过这个问题，但最近试了几次都报这样的错误，请高手指点迷津，先在这里谢过了。

---

作者: will_suto    时间: 2006-7-10 14:54
You might need start ctxsrv!

----------------------------------
http://www.websina.com/cn/

---

作者: yuqiong    时间: 2006-7-18 21:32
start ctxsrv!
不好意思，能不能说的再具体些，本人乃入门级菜鸟，请多包涵！sdlkfj5

---

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)

Powered by Discuz! X3.2