Has anyone else experience this problem? We're moving a Spectra Application from a SQL server over to Oracle, and are plagued by "two-task conversion routine: integer overflow" errors, and "XML parsing error: no element found (error code 3, line 1, column 0, buffer offset -1)" Heres the full story. Has anyone else encountered this? Any known workarounds? ========================== After the upsize of SPectra Objectstore from SQL server to Oracle, we started getting the following error. When we tried to fix this by 'enabling long text retrieval setting' in CF Administrator we get a different error which is attached below the first error. Error 1: We do know that this 'integer overflow error' is linked to a database field type 'CLOB'. and in regular select or update statement any reference to a field with 'CLOB' datatype throws the error. ******************* Error 1 ******************* -------------------------------------------- Error Diagnostic Information ODBC Error Code = S1000 (General error) [Oracle][ODBC][Ora]ORA-03120: two-task conversion routine: integer overflow SQL = "select * from wddxdata where plpinstanceid = ?" Query Parameter Value(s) - Parameter #1 = F2CD8665-6F8A-11D4-9AE500508BC5C2C4 Data Source = "SPECTRA_OBJECTSTORE" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:98) in the template file C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDSELECT_BP.CFM. Date/Time: 08/11/00 09:56:41 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 208.178.133.5 HTTP Referer: /allaire/spectra/webtop/systemdesign/plpdesigner/index" EUDORA="AUTOURL"http://<myserver>/allaire/spectra/webtop/systemdesign/plpdesigner/index. cfm Query String: plp=BD2A9C39-6F8E-11D4-9AE500508BC5C2C4&killplp=yes -------------------------------------------------------------------- Execution Time 734 milliseconds 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\PLP\CFA_PLPGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\PLP\CFA_PLPINSTANCEGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_DEEPCOPY.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_ENTITYCONSTANTS.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_GENERATEDCONTENTCACH E.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDSELECT.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_SERVERSETTINGSGET.CF M 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_STRUCTGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_CACHEREAD.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_DBTABLEDICTIONARY.CFM 172 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDSELECT_BP.CFM 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\BROWSER\CFA_BROWSER.CFM 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTG ET.CFM 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\PLP\CFA_PLP.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_AUTHENTICATE.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_SECURE.CFM 94 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERDIRECTORYGET. CFM 250 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERDIRECTORYGETM ULTIPLE.CFM 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERPROFILEGET.CF M 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSION.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSIONISDEFIN ED.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSIONSTATUSG ET.CFM 31 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\APPLICATION\CFA_APPLICATIONINI TIALIZE.CFM 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\SITEMODELING\CFA_PAGE.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\UI\CFA_CONTROLHANDLER.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\UI\_SELFPOSTFORMATTER.CFM 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\UTILS\CFA_GLOBALSETTINGS.CFM 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\WEBTOP\CFA_WEBTOPAPP.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\WEBTOP\CFA_WEBTOPHELP.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\WEBTOP\LEFT.CFM 32 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\WEBTOP\TOP.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\PAGETEMPLATES\WEBTOP\COLORSWITCH.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\PAGETEMPLATES\WEBTOP\STYLESWITCH.CFM 0 ms D:\INETPUB\WWWROOT\ALLAIRE\SPECTRA\WEBTOP\APPLICATION.CFM 16 ms D:\INETPUB\WWWROOT\ALLAIRE\SPECTRA\WEBTOP\SYSTEMDESIGN\PLPDESIGNER\PLPCREATE .CFM 0 ms STARTUP, PARSING, & SHUTDOWN ************************* Error 2 ************************* Error Diagnostic Information XML parsing error: no element found (error code 3, line 1, column 0, buffer offset -1) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (221:3) to (221:75) in the template file C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\OBJECTSTORE\CFA_OBJECTTYPEGETM ULTIPLE.CFM. Date/Time: 08/18/00 13:04:51 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: <myserver> HTTP Referer: /allaire/spectra/webtop/" EUDORA="AUTOURL"http://<myserver>/allaire/spectra/webtop/ ---------------------------------------------------------------------------- ---- Execution Time 3875 milliseconds 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\OBJECTSTORE\CFA_OBJECTTYPEGET. CFM 141 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\OBJECTSTORE\CFA_OBJECTTYPEGETM ULTIPLE.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_DEEPCOPY.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_ENTITYCONSTANTS.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_HANDLER.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDSELECT.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_SERVERSETTINGSGET.CF M 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_STRUCTGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_DBTABLEDICTIONARY.CFM 2421 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDSELECT_BP.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECT. CFM 31 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTG ET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTI NVOKEMETHOD.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_AUTHENTICATE.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_SECURE.CFM 78 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERDIRECTORYGET. CFM 203 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERDIRECTORYGETM ULTIPLE.CFM 391 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERGET.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SECURITY\CFA_USERPROFILEGET.CF M 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSION.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSIONCREATE. CFM 16 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SESSIONMGMT\CFA_SESSIONISDEFIN ED.CFM 15 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\APPLICATION\CFA_APPLICATIONINI TIALIZE.CFM 188 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\SITEMODELING\CFA_REFRESHPAGEMO DEL.CFM 172 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\SITEMODELING\CFA_REFRESHSECTIO NMODEL.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\SITEMODELING\CFA_REFRESHSITEMO DEL.CFM 203 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER1\UTILS\CFA_GLOBALSETTINGS.CFM 0 ms C:\PROGRAM FILES\ALLAIRE\SPECTRA\HANDLERS\SYSTEM\APPLICATION\INITIALIZE.CFM 0 ms D:\INETPUB\WWWROOT\ALLAIRE\SPECTRA\WEBTOP\APPLICATION.CFM 0 ms STARTUP, PARSING, & SHUTDOWN ================================================== Jeff Tapper [EMAIL PROTECTED] Team Manager / Lead Applications Architect http://www.gtriad.com G. Triad ================================================== ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.