slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Problem With a Custom Table

Wiston
Posts: 6

Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Nov 06 3:07 PM

Hi EveryBody.
I Have SLX 6.1, My problem is as Follow:
I have a Custom table C_Table1 , But when I try to add a new field, the menu option ( Create New Field) Does not appear (it appear Disable). This table in a few days ago was modified using the Enterprise manager (sql server 2000). Anyone Have any Idea how to fix this problem.
I'll Appreciate any kind of help

Thanks In Advance

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Nov 06 3:22 PM

If the table was just added I would delete it then recreate it using SLX DBManager.

If fields were added... delete them in enterprise manage then readd them using the SLX DBManager.

It sounds like the metadata (stored in sectabledefs and resynctabledefs tables) is messed up. Probable the USERDEF value in the sectabledefs table. Compare the metadata for a table that works with the table that does not work.

[Reply][Quote]

Wiston
Posts: 6

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Nov 06 8:51 AM

Thanks A Lot Frank, This Works Fine.
Thanks So Much.:

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Nov 06 7:50 AM

Quote:

Originally posted by Wiston

Hi EveryBody.
.... This table in a few days ago was modified using the Enterprise manager (sql server 2000). Anyone Have any Idea how to fix this problem.
I'll Appreciate any kind of help

Thanks In Advance

Golden Rule:
NEVER Create/Modify Tables in SalesLogix except via the SalesLogix DB Manager or you break things.
There is a "bunch od MeteData" in the SalesLogix DB that only teh SalesLogix DBmanager knows how to handle (Create/Modify) (Slight exception... tables/fields that are brought in via a SalesLogix "bundle file".) External Tools like EM have no knowledge of this...
SalesLogix 101.
--
rjl

[Reply][Quote]

Wiston
Posts: 6

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Nov 06 5:35 PM

Thanks Bob. I'll have present this suggestion.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Nov 06 10:18 PM

Quote:

Originally posted by Frank Chaffin

If the table was just added I would delete it then recreate it using SLX DBManager.

If fields were added... delete them in enterprise manage then readd them using the SLX DBManager.

It sounds like the metadata (stored in sectabledefs and resynctabledefs tables) is messed up. Probable the USERDEF value in the sectabledefs table. Compare the metadata for a table that works with the table that does not work.

You cannot copy the ResyncTableDefs/SectableDefs "Metadata" from one SalesLogix db to another. You will still have a mess. There's also teh data blobs in every SecProfile record that must match up. Hint: The FieldIndex is a "pointer" to an Encoded blob in every sSecProfile record.
--
rjl

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Nov 06 11:57 PM

Bob,

I did not suggest that he copy the metadata only the he compare a table that work to one that did not so he could get a sense of the metadata that the DBManager generates.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Problem With a Custom Table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Nov 06 10:34 AM

I understand. However just looking at it will not giveone a full sense of the metadata. Unfortunately there's a set of complicated "business rules" that govern the relationship between the records in ResyncTableDefs, SectableDefs, and Secprofile(s). It goes down to the field level (values) to include blob data in SecProfiles.

This relationship info is not available in "public published" documents and AFAIK is not taught in any SLX development classes. It is subject to change and has changed in various versions (as well as SP's and HF's over time) In fact, there are "new rules" about one of the columns/fields in v7.

Some partners have a a detailed understanding, many do not. I believe I've only met one or two customers who have an idea of what is there. As soon as they start to realize "nasty" it is (as well as how it impacts sync operations , they always pass it of to us to fix.

I'd suggest that anyone who suspects they have problems in this area:
A - Contact their BP
B - Contact Tech support
It's not something for the faint-of-heart to mess with.
--
rjl

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 10:47:18 PM