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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Problem merging duplicate accounts

Steven Bair
Posts: 14

Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 06 12:04 PM

viagra prodej cena

viagra cena heureka

When I try to merge two (seemingly) normal account records, I get the following message...

---------------------------
Function had an error...
---------------------------
An unusual error has occurred when executing MainView:DupMerge.
Contact your system administrator. 0x1 @0: Function MainView:DupMerge
Exception: Cannot perform this operation on a closed dataset
---------------------------
OK
---------------------------

I have run integrity checker and the database now has no integrity issues. I have checked joins. I'm not sure what the error means by "close dataset." Is this a dataset that has been closed in code? or a dataset that has no members? or a dataset that has been shut down by the appropriate governmental agency?

Does anyone have any thoughts about what might be going on?

TIA.

[Reply][Quote]

Steven Bair
Posts: 14

Re: Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 06 12:25 PM

zantac

just ran slx profiler. log shows an error which reads "invalid table name".. however, there is no indication of what table name is invalid. the last statement on the log tab is for a table which IS valid.

i don't see an icon for pulling out what hair i have left.

[Reply][Quote]

Peter H
Posts: 17

Re: Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 06 1:23 AM

naltrexone and naloxone

naloxone vs naltrexone

Check (should not exist - but check anyway) that there are no table names that contain a space in the name.
this is very unlikely, but I have seen it once before (who knws what had been done to that database!!)

[Reply][Quote]

Steven Bair
Posts: 14

Re: Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Mar 06 12:05 PM

nope -- no table names with spaces. no circular joins.

any other thoughts?

[Reply][Quote]

Steven Bair
Posts: 14

Re: Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Mar 06 2:31 PM

Peter H kindly offered to look at my sql profiler log and see if he could find the problem. His offer prompted me to run the MS profiler (I had previously run the one from slx). To my surprise, I found that slx was choking on the absence of a table called DELETE_THIS. Just last week, I had deleted it.

Seems like a poor choice of names. Maybe should have been DONT_DELETE_THIS.

Don't delete it. Everything breaks.

[Reply][Quote]

Luke Russell
Posts: 5

Re: Problem merging duplicate accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Mar 06 8:32 AM

the abortion pill Philippines

the abortion pill philippines

OK, I'm laughing. Sounds like something they would do.

[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): 5/3/2024 4:24:51 AM