I have seen CTX_DDL.SYNC_INDEX ('COMPONENT_CHR_CTX');and ALTER INDEX COMPONENT_CHR_CTX REBUILD parameters ( ''sync'' )suggested on this forum.Is there a difference or preferred method!!Robnull ...
can u please any one tell me what is this error descripe.what is the context policy E ERROR 58005 IBMhttp://DB2.NET SQL0902 An unexpected exception has occurred in Process: 4532 Thread 6 AppDomain: Name:SyncDB2MQ.exeThere are no context policies.Function: DB2DataReader.Read()CallStack: at System.Env ...
The Binary Serializer has support for passing data to the Serialization Context.I am using the DataContract Serializer and I would like to do the same thing.Specifically, I want to be able to pass the path to the file that will be serialized so that I can make other paths relative.How can I do this ...
All the context indexes in the system are failing with below error while syncing.BEGIN ctx_ddl.sync_index('ctx_media_data'); END;"ORA-20000: ORA-20000: Oracle Text error:DRG-11422: linguistic initialization failedDRG-00100: internal error, arguments : [52100],[drxa.c],[359],[gxtopen],[1]DRG-00100: i ...
Hope I chose the correct forum.I have a dataset object with one table that comes to me from a common custom component's GetDS method. I need to pass XML to another process (chunked as byte array). I have it all working but the XML is missing some attributes that the consuming process expects.I use t ...
I'm kind of new in Remoting domain, and I'm facing some problem,I've create a DLL that store a Class that 2 application need,One of them say program "A" register and instantiate the "service" like this RemoteTcpSetting("port") = pServicePortNumberRemoteTcpSetting(" ...
I found that jQuery.active is increased but not decrease in synchronous call;-)-- View this message in context: http://www.nabble.com/Sync-Ajax-bug-in-jQuery-1.0.4-tf2831168.html#a7904229Sent from the JQuery mailing list archive at Nabble.com. ...
Im using sync server 8.1.4 on Palm OS 4.I Can sync All my tables in the SQL server accept one table that seems to be locked some how.After creating the Subscription I can sync the table with the Palm and its OK.After Few other Syncs I get an error on the Palm Of critical Error and the Sync Stops whe ...
In order to keep my context indexes up-to-date, I'm trying to write a trigger calling this PL/SQL procedure on update/insert/delete statement.However, there must be a problem in my trigger definition since it gives compilation errors! I don't see what 's wrong!This is my trigger definition:========= ...
Oracle TextIs there a way to obtain the the last time a CONTEXT/CTXCAT index is updated with ctx_ddl.sync_index? Thanks in advance.I searched in all views in the package ctxsys, but I couldn't find anything.maybe there is some log?Grtz Bart ...
I am hoping someone can help me figure this out. Portable mobilink users are unable to sync information back to database. Using Sybase - SQL iAnywhere DBML_Sync 9.0.2.3320. simulating a server on my test workstation I was able to sync. which leads me to something on my server. Only changes have been ...
I'm trying to create a DataSet in VB.net which accesses a table in a Sybase database. One of the columns is named Timestamp, and trying to select this column is causing problems due to it's being a reserved word...plus the fact that the datatype is a datetime and not a timestamp. Here's the base sel ...
All,I came across very conceptual article about the sybase device io.If you have any questions and suggestions please let me know. Thanks.Source: Sybase Blogs, www, sybooks, sybase white paper for direct io.same thread @ directio,dsync & sync , async IO Sybase BlogASYNCHRONOUS I/O:Asynchronous I ...
With 9.0.1.1.1 Text we use ctx_ddl.sync_index(null) connected as ctxsys to synch all of our Context indexes. We only want it to run out of hours because it is so heavy on CPU i.e. 100% for the whole run. If I set a dbms_job to run it once it will clear some of the records in dr$pending but not all o ...
I used this code to serialize:using System;using System.IO;using System.Runtime.Serialization.Formatters.Binary;[Serializable]public class Car{public string Make;public string Model;public uint Year;public byte Color;}public class Exercise{static void Main(string[] args){Car vehicle = new Car();vehi ...
I am new to .NET and have been unable to get data from a CSV file to a dataset. Most examples are VB and C# which need to be converted. The code below compiles clean but does not fill the dataset. I have been unable to set a watch on the dataset to be sure of this. Any help with eithor problem would ...
I have created a context index and want to optimize it regularly. I issue the following statement:ctx_ddl.optimize_index('MY_INDEX','FAST'); In the Enterprise Manager I can see, that there are a lot of Sort/Merge-operations, but the optimize process doesn't finish.(During optimize there are inserts ...
I've installed the samples on the mobile server and on the palm-emulator and want to sync now.I always get the following error at the server:.....BMS: OWNER IS NOT A CLIENTlog1: log_S11U1BMS: conn user =MOBILEADMIN, e[0]=S11U1BMSlog1: log_S11U1BMS: SELECT "S11U1BMS"."TID$$".NEXTVAL FROM DUALDecremen ...
I've installed the samples on the mobile server and on the palm-emulator and want to sync now.I always get the following error at the server:.....BMS: OWNER IS NOT A CLIENTlog1: log_S11U1BMS: conn user =MOBILEADMIN, e[0]=S11U1BMSlog1: log_S11U1BMS: SELECT "S11U1BMS"."TID$$".NEXTVAL FROM DUALDecremen ...
I am working on Oracle9.2.0.2 database. When I tried to create context index it took a long time.ctx_ddl.optimize_index and ctx_ddl.sync_index are taking more time to process rows.For example: optimize with FAST option has taken 15 minutes to optimize 250 rows.syn_index has taken 25 minutes to proce ...
The sql below synchronizes all the pending context:set echo offset heading offset feedback offset pagesize 50000spool c:\sync.sqlselect distinct 'exec ctx_ddl.sync_index(''' || PND_INDEX_OWNER || '.' || PND_INDEX_NAME || ''')' from ctx_pending;spool off@c:\sync.sql;Would it be possible to transform ...
I have a CTXSYS.CONTEXT index on my table with a multi column datastore. After doing any updates to those columns, how do I get the new data indexed? I don't see any entries in ctx_user_pending so ctx_ddl.SYNC_INDEX doesn't have any effect. However, if I insert new data, ctx_user_pending tracks it p ...
I am trying to create a grade book form using the following class createfileform.csI keep getting the following errors1:The name 'GetTextBoxValues' does not exist in the current context2.Cannot implicitly convert type 'string' into 'int'Here's My Code. // Fig. 18.9: CreateFileForm.cs// Creating a se ...
I'm trying to serialize my java objects by using the gnereated classes from the SOAP *_Ser and *_Deser. The Problem I get is, that in the AngebotsbaumBO there is an array of AngebotsbaumBO and when I say "context.setDoMultiRefs(true)" then it just serialize the root Object and with the childs he jus ...
I am developing a web application, which uses Oracle Text's contains searches. Please find below the scripts I am using and the problem I am facing.create table urlstab(URLID number(22),ID number(22),SUBID number(22),URL varchar2(2000),);beginctx_ddl.create_preference('URL_PREF','URL_DATASTORE');ctx ...
HiI have a table that contains around 5000 documents. Several are added, updated and deleted throughout the day.Yesterday I noticed that I haven't been syncing the indexes as new documents were added, so the new ones weren't searchable. I dropped and re-created my index as the following: create inde ...
Pls see my question below .....CREATE TABLE your_table (id NUMBER PRIMARY KEY, title VARCHAR2(20));drop table your_table;INSERT ALL INTO your_table VALUES (1, 'TEST ITEM 133') INTO your_table VALUES (2, 'TEST ITEM 129') INTO your_table VALUES (3, 'TEST ITEM') INTO your_table VALUES (4, 'TEST ITEM 12 ...
when I attempt to synchronize an Oracle Text CONTEXT index from a button trigger in Oracle forms I get the error: ORA-20000: Oracle Text error:DRG-10017: you must be CTXSYS or RKMS_MGR to do this: SYNCORA-06512: at "CTXSYS.DRUE", line 157ORA-06512: at "CTXSYS.CTX_DDL", line 1328ORA-06512: at line 1I ...
I can't find what view I would query to find the last time a context index was last sync'd - the view for indexes that I've found (ALL_INDEXES) only tells me the last time it was analyzed. Does such a view exist? ...
Sorry if this is a dumb question I am a text newbie. But I have a problem getting a query to use the text index, and I have noticed that there are no CBO statistics created on the text by my stats gathering job. Is this normal (my stats job does cascade to indexes and partitions)? Is there some spec ...
I'm wondering what I can do to speed up the creation of a context index.The target table contains five million rows.This index is using a multi column datastore across three columns, one of which is a CLOB.Tailing the index creation logs, initially each parallel process was indexing 100 documents ev ...
I would like to deactivate or to find a workaround to not use the MINUS function in a search based on the following index :CREATE INDEX DOCUMENT_IDX ON DOCUMENT(BLOB_CONTENT)INDEXTYPE IS CTXSYS.CONTEXTPARAMETERS('FILTER ctxsys.auto_filter SYNC (ON COMMIT)');My table DOCUMENT contains three columns ( ...
If I use the following to create the index:CREATE INDEX files_c1 ON files(location)INDEXTYPE IS CTXSYS.CONTEXTPARAMETERS('DATASTORE ctxsys.file_datastore FILTER CTXSYS.AUTO_FILTER format column format'); If the file content is changed on disk. but the path is the same. e.g. /path/file1.txtdo I need ...
I want to open a specific container on tomcat startup and retrieve XmlManager and XmlContainer from servlet context.To "transport" manager and container into my web application I implemented a ServletContextListener to open and store a container.XmlManager xm = new XmlManager();XmlContainer con = nu ...
If anyone can look at this that would be of great help.The context index creation for a million rows is taking forever. We had let it run for 10 or so hours and it still was not finished so we had to cancel it.We are creating the index as follows:create index content_version_text_idx on content_vers ...
CREATE TABLE "TEST" ( id NUMBER(19) NOT NULL,"TESTDATA" CLOB NOT NULL ENABLE) CREATE INDEX IX_testdata ON test (testdata) INDEXTYPE IS CTXSYS.CONTEXT ONLINEPARAMETERS ('TRANSACTIONAL MEMORY 500M SYNC(ON COMMIT) section group ctxsys.xmlpathgroup') PARALLEL 4 insert into test values (1, '<?xml vers ...
Search performance using context index.We are intending to move our search engine to a new one based on Oracle Text, but we are meeting some bad performance issues when using search.Our application allows the user to search stored documents by name, object identifier and annotations(formerly set on ...
I'm trying to set up my Axim x30 to sync with Evolution in Jaunty. At one point I was able to view the directories on the axim using synce-pls. I've tried so many different things to try and get this to work that I've now messed something up and can no longer get synce-pls to work.I have synce-hal, ...
I have some code which using MAPISession, simply logs into an exchange server using a Profile ( Name set in the MAPISession Control), and using NT Password Authentication (Set in the profile). This works fine when run by the user currently logged into the NT PC, But a requirement is that it runs as ...
Get this in my dmesg...Any ideas how to fix it? Thanks!Below is my dmesg after a suspend-resume cycle:[ 296.388446] sky2 eth0: disabling interface[ 296.392835] bridge-eth0: disabling the bridge[ 296.399436] bridge-eth0: down[ 296.649049] sky2 eth0: enabling interface[ 296.653944] bridge-eth0: enabli ...
I'm new to the forum, and new to VB.NET.I have a simple database application, which displays part of a table in a datagrid. Other related information, from the same table and from others, is displayed on the form in text-boxes and combo-boxes.I would expect the related information to be automaticall ...
I made a webservice that returns back a Class type object to the caller. I called the Class type "CFile". Inside "CFile" there are a number of initializations one in particular has:strucItemDisplayed[] item = new strucItemDisplayed[8];Everything compiles fine in my webservice asm ...
1. Can anyone tell me what exact operation is done on the CONTEXT index when its column is updated and the index is not synchronized? Why don't we get the rows when search with even old values in then column? What operation does a synchronization does on the index, an update or insert after delete?2 ...
I have a question regarding serialization and the constructor calls. I have developed a custom list with events. So, if the object inside the list changes, the list can send an update.When I use serialization to get the list back, I use this functionality:public MyClass(SerializationInfo info, Strea ...
I am trying to use Custom XML Serialization for a variety of purposes. I am getting the following error:Message = "The type MyClass may not be used in this context. To use MyClass as a parameter, return type, or member of a class or struct, the parameter, return type, or member must be declared ...
I just would like to serialize an arraylist of windows forms but I encounter some problems :I have a MainForm class which itself is a form derived class.In this class is a private instance called formList which is of type ArrayList and which contains some other form derived classes which are all mar ...
I am getting some strange results while trying to use the OnDeserialized attribute. I have some classes which contain events, and the events are attached to objects outside the scope of the serialization. So when the objects are deserialized I want to reattach them. The obvious place for this is in ...
My task is to fill a DataSet from a data source and update another data source in C#.For example I have two databases in SQL Server (i.e. db1 and db2).I have table named ProdMkt_Contrib_Link in db1 with following columns:ProdMkt_Contrib_Link--------------------ProdMktContributorID (PK)ProductMarketI ...
I am working on a C# web application (.NET 2.0) which uses remoting to access some interface objects.One remote method returns me a DataSet of product varients. Another method takes a DataSet as an argument.IProduct product = catalog.GetProduct( productName );DataSet varients = product.GetVarients() ...
I want to know abt binding context and its functions.I have two tables. one is the parent table and another is the child table.I have read this tables to a dataset. and create a relation for a column say customer_id (which exissin both tables).Then i have to add two datagrids and bind one datgrid to ...