Hello, We are running Spectra 1.5.1 with the latest patches on a win2000 machine with cf5.0. The database server is Oracle 8.1.6 on a Sun solaris machine. I connect through a Oracle ODBC driver version 8.1.7 (the latest from ORACLE). When editing a container the following error occurs after a random period of time (1 hour - 2 days):
ODBC Error Code = S1010 (Function sequence error) [Microsoft][ODBC Driver Manager] Function sequence error SQL = "delete from sharedobjectsynchronization where originalobjectid = ?" Query Parameter Value(s) - Parameter #1 = 418B359E-CC17-4FBC-8FA68A828AA72A80 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (64:1) to (64:67) in the template file D:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDDELETE.CFM. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (123:3) to (123:13) in the template file D:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDDELETE.CFM. Note: the table 'sharedobjectsynchronization' is empty and the error occurs while deleting or editing a container from designmode. The solution seems to restart the cf server or release cached datasources. We do not want to switch over to the MERANT drivers. I've contacted Oracle support, their comments are included below. I there a solution for this or is this a known problem regarding Cold Fusion? Regards, Johan Coens S1010 is a generic error for ODBC 3.x standards. It says SQLExecute is called before calling SQLPrepare. I would hardly say this is an Oracle problem. I think it could happen despite what driver is used. It looks more like a coding problem. E.g a situation occurs when some sort of exception would occur and it does not. So the question is. Does this occur every time you try to delete a row from an empty table. Is this problem known to the people that developed the application ? == The thing here is the error code S1010 is NOT specific to oracle implementation of ODBC it is a generic standard implementation of all ODBC 3.x standards and just means that the order of the code executed is wrong. E.g we try to execute a sql statement that has not been prepared or parsed yet or whos state is incorrect. To be able to pin point this you will need to provide some sort of reproducer. E.g some one needs to start debug the code that lies behind the delete statement. If any proofs of Oracle involvment then we will be happy to help since we then have something to reproduce and report to our development. == What i'm saying that for the moment i do not see the connection to Oracle. This could be a "bug" in the code that executes thru the ODBC driver. == Next Contact: Customer What: In this stage we have no proof that there is a ODBC bug. The problem states we have a sequence error in the code where we try to execute a statement that has not been prepared,parsed yet. Is there anyway Customer can provide a simplified testcase including our ODBC driver but without all the other stuff ? ========= Johan Coens Senior ColdFusion Developer <theFactor.e> Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com> Premium Partner for Macromedia "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein ========= Disclaimer: Dit e-mailbericht, waaronder begrepen eventuele ingesloten bestanden, is uitsluitend bestemd voor de geadresseerde en de inhoud ervan is strikt vertrouwelijk. Indien u dit e-mailbericht ontvangt, terwijl dat niet voor u bestemd is, of indien de inhoud van het e-mailbericht onduidelijk is, gelieve u direct contact op te nemen met de afzender. <theFactor.e> noch de afzender aanvaardt enige aansprakelijkheid voor de gevolgen van een verminkte weergave c.q. vertraagde of gebrekkige overbrenging c.q. ongeautoriseerd gebruik van het e-mailbericht. <theFactor.e> neemt redelijke maatregelen om te voorkomen dat middels dit e-mailbericht virussen worden overgebracht, maar is niet aansprakelijk in het geval dit toch voorvalt. Alle werkzaamheden worden verricht uit hoofde van een overeenkomst van opdracht met de <theFactor.e> bv, waarop van toepassing zijn onze algemene voorwaarden, gedeponeerd bij de griffie van de Arrondissementsrechtbank te Groningen, waarin onder meer een aansprakelijkheidsbeperking is opgenomen. This e-mail message is intended for the addressee only and its contents are confidential. If you have received this message, while not being the addressee, or if you have received this message in error, please notify the sender immediately. <theFactor.e> nor the sender shall be liable for the consequenses of mutilations and/or delayed or faulty transmision and/or unauthorised use of this e-mail message. <theFactor.e> takes reasonable precautions to prevent that together with this e-mail message any viruses are transmitted, but shall not be liable in case this might happen anyway. All activities shall be carried out under an assignment agreement with the <theFactor.e> bv, to which our general terms and conditions - including a liability limitation - as filed at the Office of the District Court at Groningen, shall apply. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
