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!
|
|
Problem merging duplicate accounts
Posted: 19 Mar 06 12:04 PM
|
viagra prodej cena viagra cena heureka
---------------------------
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.
|
|
|
|
Re: Problem merging duplicate accounts
Posted: 19 Mar 06 12:25 PM
|
fiogf49gjkf0d 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.
 |
|
|
|
Re: Problem merging duplicate accounts
Posted: 20 Mar 06 1:23 AM
|
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!!) |
|
|
| |
|
Re: Problem merging duplicate accounts
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.
|
|
|
| |
|