Re: Corrupted index that won't fix

[Kirk Brooks via 4D_Tech]

Tim and all,
Good suggestions. I'm working on something else at the moment and actually
try any of these yet. I did run the standard repair on the data as well.
The issues seems to have to do with the composite index made up of the
record id and table name.

As I think about it I decided using table names was a bad idea because they
can be so easily changed and would corrupt exactly that sort of thing. I
changed it to table number. The fact the error log shows the old name might
be clue.

I'll report back once I can get into it again.

On Sun, May 21, 2017 at 1:00 PM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> On May 21, 2017, at 9:00 PM, Kirk Brooks wrote:
>
> > Checking index pages on Cluster Index 167 on DOX_ATTACH._data ,
> > DOX_ATTACH.record_id (tableName_recordId) [200 errors]
> >
> > I'm not sure what else to do besides dropping the index. I'm assuming,
> > perhaps incorrectly, that if the data are good the index should be able
> to
> > write itself correctly.
> >
> > I'm hoping one of you can give me some insight into how to correct this.
> > The server is running 15.3 on Win 7.
>
> I had a situation with a damaged index and trashed the .4dindx file to
> rebuild all indexes. I ran MSC again and the index damage was still there.
> I did an MSC data file repair and that fixed the problem.
>
> I had the same idea as you Kirk that index damage could be fixed with just
> an index rebuild but in this situation it required a data file repair.
>
> Curious what kind of index damage you had. Mine mentioned something about
> "null clusters" if I remember correctly.
>
> Tim
> Sent from my iPad
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Corrupted index that won't fix

[Tim Nevels via 4D_Tech]

On May 21, 2017, at 9:00 PM, Kirk Brooks wrote:

> Checking index pages on Cluster Index 167 on DOX_ATTACH._data ,
> DOX_ATTACH.record_id (tableName_recordId) [200 errors]
> 
> I'm not sure what else to do besides dropping the index. I'm assuming,
> perhaps incorrectly, that if the data are good the index should be able to
> write itself correctly.
> 
> I'm hoping one of you can give me some insight into how to correct this.
> The server is running 15.3 on Win 7.

I had a situation with a damaged index and trashed the .4dindx file to rebuild 
all indexes. I ran MSC again and the index damage was still there. I did an MSC 
data file repair and that fixed the problem. 

I had the same idea as you Kirk that index damage could be fixed with just an 
index rebuild but in this situation it required a data file repair. 

Curious what kind of index damage you had. Mine mentioned something about "null 
clusters" if I remember correctly. 

Tim
Sent from my iPad
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[info--- via 4D_Tech]

> Does anybody now if it is possible to put an oObject in a dynamic form
> variable?
>
> I want to reuse the contents of a local oObject outside of the scope of the
> method that created it.

yes, works just fine
- name the object whatever you want
- type as object in properties and your are done
very helpful, doing house keeping for subform-widgets: setting and getting



Grüße/regards
Ortwin Zillgen
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Douglas von Roeder via 4D_Tech]

I was working in 15.2 at the time.


On Sun, May 21, 2017 at 11:51 AM Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 21 mai 2017 à 20:46, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > Thanks to both of you... I should have known...
>
> PS after reading Douglas
>
> in v14R5.
>
> --
> Arnaud
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
--
Douglas von Roeder
949-336-2902
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Arnaud de Montard via 4D_Tech]

> Le 21 mai 2017 à 20:46, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Thanks to both of you... I should have known...

PS after reading Douglas

in v14R5. 

-- 
Arnaud 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Jim Dorrance via 4D_Tech]

Thanks to both of you... I should have known...


On Sun, May 21, 2017 at 8:22 PM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 21 mai 2017 à 19:51, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > Merci As a longint?
>
> No, I've just drawn a variable rect, and in properties named="object",
> type=none.
> Then I use it like this:
>   (object get pointer (named object;"object"))->:=$someObject_o  //write
>   $someObject_o:=object get pointer (named object;"object")->  //read
> In the display, I don't see nothing but it works.
>
> I must mention this app is not compiled, so in this context I'd add this
> on load:
>   $obj_p:=object get pointer (named object;"object")->
>   c_pointer($obj_p->)
>
> If all above fails, stringify into a text variable instead.
>
> --
> Arnaud de Montard
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Arnaud de Montard via 4D_Tech]

> Le 21 mai 2017 à 19:51, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Merci As a longint?

No, I've just drawn a variable rect, and in properties named="object", 
type=none. 
Then I use it like this:
  (object get pointer (named object;"object"))->:=$someObject_o  //write
  $someObject_o:=object get pointer (named object;"object")->  //read
In the display, I don't see nothing but it works.

I must mention this app is not compiled, so in this context I'd add this on 
load:
  $obj_p:=object get pointer (named object;"object")->
  c_pointer($obj_p->)

If all above fails, stringify into a text variable instead. 

-- 
Arnaud de Montard 



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Douglas von Roeder via 4D_Tech]

Jim:

Yes.

The newest (or one of the newest) versions supports that. For older
versions, create a text dynamic variable and populate it with the
stringified version.


On Sun, May 21, 2017 at 10:07 AM Jim Dorrance via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hello,
>
> Does anybody now if it is possible to put an oObject in a dynamic form
> variable?
>
> I want to reuse the contents of a local oObject outside of the scope of the
> method that created it.
>
> Thanks,
>
> --
> Jim Dorrance
> jim.dorra...@gmail.com
> 4...@dorrance.eu
> www.4d.dorrance.eu
>
> PS: If you know of anyone that needs an experienced 4D programmer to add
> energy and experience to their team, please let me know. I have
> experience in many areas. Reasonable rates. Remote or Paris only.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
--
Douglas von Roeder
949-336-2902
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Jim Dorrance via 4D_Tech]

Merci As a longint?

On Sun, May 21, 2017 at 7:26 PM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 21 mai 2017 à 19:07, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > Hello,
> >
> > Does anybody now if it is possible to put an oObject in a dynamic form
> > variable?
>
> Yes, I remember I did it recently.
>
> --
> Arnaud de Montard
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Corrupted index that won't fix

[Alan Chan via 4D_Tech]

If you have removed a table or field, then add new table or field, it might 
cause problem if the old data is still there.

Repair it might help. It won't harm if it doesn't.

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>I verified a data file and MSC reported the data were fine but the indexes
>had some errors. No problem, I think, I'll just trash the index files,
>restart and let them rebuild. After doing this twice the indexes are still
>showing as :
>
>Cluster Index 167 on DOX_ATTACH._data , DOX_ATTACH.record_id
>(tableName_recordId) [OK]
>Checking index Cluster Index 167 on DOX_ATTACH._data , DOX_ATTACH.record_id
>(tableName_recordId) [OK]
>Checking index page addresses on Cluster Index 167 on DOX_ATTACH._data ,
>DOX_ATTACH.record_id (tableName_recordId) [OK]
>Checking clusters on Cluster Index 167 on DOX_ATTACH._data ,
>DOX_ATTACH.record_id (tableName_recordId) [OK]
>Checking list of deleted clusters on Cluster Index 167 on DOX_ATTACH._data
>, DOX_ATTACH.record_id (tableName_recordId) [OK]
>Checking index pages on Cluster Index 167 on DOX_ATTACH._data ,
>DOX_ATTACH.record_id (tableName_recordId) [200 errors]
>
>I'm not sure what else to do besides dropping the index. I'm assuming,
>perhaps incorrectly, that if the data are good the index should be able to
>write itself correctly.
>
>I'm hoping one of you can give me some insight into how to correct this.
>The server is running 15.3 on Win 7.
>
>

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: oObject and dynamic form variable

[Arnaud de Montard via 4D_Tech]

> Le 21 mai 2017 à 19:07, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hello,
> 
> Does anybody now if it is possible to put an oObject in a dynamic form
> variable?

Yes, I remember I did it recently. 

-- 
Arnaud de Montard 



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

oObject and dynamic form variable

[Jim Dorrance via 4D_Tech]

Hello,

Does anybody now if it is possible to put an oObject in a dynamic form
variable?

I want to reuse the contents of a local oObject outside of the scope of the
method that created it.

Thanks,

-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Corrupted index that won't fix

[Arnaud de Montard via 4D_Tech]

> Le 21 mai 2017 à 04:15, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I verified a data file and MSC reported the data were fine but the indexes
> had some errors. No problem, I think, I'll just trash the index files,
> restart and let them rebuild. After doing this twice the indexes are still
> showing as :
> 
> Cluster Index 167 on DOX_ATTACH._data , DOX_ATTACH.record_id
> (tableName_recordId) [OK]
> [...]
> Checking index pages on Cluster Index 167 on DOX_ATTACH._data ,
> DOX_ATTACH.record_id (tableName_recordId) [200 errors]

Entering the voodoo zone. 

I'm wondering about the index… What are the types of fields DOX_ATTACH._data, 
DOX_ATTACH.record_id? Could you explain?

Or a problem in the data… I'd try a "touch all" on table [DOX_ATTACH]. Some 
code here:


-- 
Arnaud de Montard




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**