Home > Cannot Perform > Cannot Perform This Operation On A Closed Dataset Saleslogix

Cannot Perform This Operation On A Closed Dataset Saleslogix

if not that It is this : When I have restored a database to a new server, I have encountered issues where sysdba is not recognized. Privacy Policy Site Map Support Terms of Use Brent Wills Provant Top For discussions on SalesLogix please visit the CRM – General Discussions group. Has anyone come across such a problem and any resolutions?? Check This Out

I am assuming something has changed in the SalesLogix v8.0.0 executables that no longer likes this particular combination, but I can't explain why one would work in their current installation and share|improve this answer answered Jul 21 '11 at 11:16 Johan 49.2k16108204 Apparently the OP is doing it's stuff from the BDE Administrator control panel applet: no dataset Opened or Yes that's right. I found bugreport for this : http://zeosbugs.firmos.at/view.php?id=206 Any progress ? http://crm.ittoolbox.com/groups/technical-functional/saleslogix-l/cannot-perform-this-operation-on-a-closed-dataset-456362

To me, this is a bit more troubling as 'Delte' is the proper Cascade type. Unusual Errors? First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Closed Data Set?

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. You're now being signed in. Lazarus 1.1, FPC 2.6.0, Zeos svn Testng (also Trunc) latest, Firebird 2.5 ...

Both had tables created outside of SalesLogix that were NOT enabled, but did have Global joins created to them. King regards, MichaelYou want to help? There are basically two ways to resolve the issue, either from your client you need to use .NextRecordset or .NextResult or whatever equivalent method is available in your client. navigate to these guys So anytime you start the saleslogix application, it appears to skip all the pre-login process and attempts to continue from where it left out!

Top EgonHugeist Zeos Dev Team Posts: 1700 Joined: 31.03.2011, 22:38 Quote Postby EgonHugeist » 04.09.2012, 20:29 patyit, ok this a sloution and an example to check the issue. Oh the pain For discussions on SalesLogix please visit the CRM – General Discussions group. At delivery time, client criticises the lack of some features that weren't written on my quote. As we all know, you can create tables outside of SalesLogix.

Thus, the error in your case meant not that you forgot to open it, but that your app cannot open the corrupt .dbf file. http://microsoft.public.sqlserver.clients.narkive.com/J7sbbxDs/error-message-cannot-perform-this-operation-on-a-closed-dataset Join them; it only takes a minute: Sign up How do I solve the “Cannot perform this operation on a closed dataset” with Borland Database Engine and a Delphi application? [closed] We are connecting fromWindows 2000, and XP clients running the SQL Server 2000client.On all but one of the systems, we can access the databasegreat. http://sourceforge.net/p/zeoslib/tickets/ Top patyit Junior Boarder Posts: 37 Joined: 10.02.2012, 18:39 Quote Postby patyit » 20.09.2012, 23:02 Hi EgonHugeist !

In file '/home/patyi/lazarus-svn/zeos7_test/src/component/ZAbstractDataset.pas' at line 641: CachedResultSet.DisposeCachedUpdates; I'm developing an ERP like (big) application and this code construction is very important ! his comment is here Or you change the stored procedure that you are calling and add "SET NOCOUNT OFF" before the code that is executed in the SP. did you try opening the dataset if the operation cannot be performed on a closed dataset? –Cosmin Prund Jul 21 '11 at 10:31 How do I open it? I have deleted and recreated the SYSDBA user in the database but that has still not solved the problem.

MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... mei replied Nov 22, 2005 Hi, We have moved our database to a new server=2E The approach we used was to backup from the current server, then moved the backup database es/testing as well as with the latest version of http://svn.code.sf.net/p/zeoslib/code-0/trunk on Delphi XE2 and Firebird 2.1. this contact form On the last one, we keep getting the error "cannotperform this operation on a closed dataset" when tryingstart the applicaiton.Any ideas?

How do I handle this? I clicked Open in BDE, but nothing changed. Click the arrow button .

This site, and all contents herein, are Copyright © 2016 Customer FX Corporation.The information and opinions expressed here are not endorsed by Sage Software.

When it's time to use the dataset you will get this error because the dataset is closed. User155260 replied Jul 9, 2002 If moving a backup of a DB to another server, the SID for the sysdba user is different and needs to be dropped and readded with The SalesLogix group is no longer active. Sites: Disneyland vs Disneyworld Can I hint the optimizer by giving the range of an integer?

No one can now log into the system and this is the error message when we try to login. "A database error occurred: Cannot perform this operation on a closed dataset". except Database.Rollback; ... // error handling an back to edit data Exit; end; QPrometz.CommitUpdates; QPromett.CommitUpdates; QPromet.CommitUpdates; ... The biggest difference is that had to be some changes in the logic in the executables in v8.0.0 that no longer handles them gracefully and causes problems. navigate here I have seen the following issue with 5.2 .But when you attach /detach the db and restart the server , this error was gone.

Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM Allan Mitchell 2003-10-20 06:24:39 UTC PermalinkRaw Message It looks as though the application closed the dataset or did not set it toeditableHave a look at these posts from people with the User89481 replied Apr 23, 2004 Hi, Finally, I have got to the bottom of the problem. How to react?

If you have a complex stored procedure which performs more than a single select, you may get more than one dataset result returned. Lazarus 1.0.8 fpc 2.6.0 Top ism Zeos Test Team Posts: 202 Joined: 02.10.2010, 20:48 Quote Postby ism » 18.08.2012, 17:27 Try last rev from http://svn.code.sf.net/p/zeoslib/code-0 ... Where are you clicking Open? –Cosmin Prund Jul 21 '11 at 10:53 2 I suspect your DBF file was corrupted by OpenOffice. We were in the midst of client testing on a SalesLogix v7.5.1 to v8.0.0 LAN upgraded database when we got the following error message when trying to delete a Contact:

Jim PembertonVice President of EngineeringSimplesoft Solutions, IncAward Winning Infor CRM Business Partner Report Inappropriate Content Message 1 of 5 (886 Views) Reply 0 Kudos MikeSpragg Silver Super Contributor Posts: 801 Registered: More CRM Groups Your account is ready. Jim PembertonVice President of EngineeringSimplesoft Solutions, IncAward Winning Infor CRM Business Partner Report Inappropriate Content Message 3 of 5 (875 Views) Reply 1 Kudo RJLedger Gold Super Contributor Posts: 3,087 Registered: So now I don't need to call CommitUpdates after Commit ?

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. With the first, after so many investigations and trials, I am not sure whether that was what happened.