This has been discussed in a previous thread here: http://groups.google.com/group/farcry-dev/browse_thread/thread/3b095f9927a50b7/f5f86ac80a93ec59?lnk=gst&q=ruleRichText+#f5f86ac80a93ec59
The cause is a table name > 30 characters. Tomek On Wed, Apr 22, 2009 at 10:09 AM, nicholas sollecito <[email protected]> wrote: > > So, I decided to start over with a fresh install on Oracle and during > the process the step "RULES): Creating ruleRichText table." fails with > the following error: > > "[Macromedia][Oracle JDBC Driver][Oracle]ORA-00972: identifier is > too long" > > struct > COLUMN 0 > ID CFQUERY > LINE 168 > RAW_TRACE at > cfOracleGateway2ecfc1451488126$funcDEPLOYARRAYTABLE.runFunction(/var/ > www/html/farcry/core/packages/fourq/gateway/OracleGateway.cfc:168) > TEMPLATE /var/www/html/farcry/core/packages/fourq/gateway/ > OracleGateway.cfc > TYPE CFML > > Digging through to try and find the cause of the error > > > On Apr 21, 2009, at 3:29 PM, Nick S. wrote: > >> >> I recently migrated a FarCry MySQL database to Oracle 10g. I updated >> the dbtype variable (to "ora") in project_folder/ >> farCryConstructor.cfm. After changing the DSN and restarting CF, I >> can't seem to get my site to work. >> The database was migrated using the migration tools built-in to >> SQLDeveloper. >> >> I am able to log in to the webtop, but some sections don't work and I >> can't get to the actual public site any longer. (results in a redirect >> loop). A couple of the problems I'm seeing: >> >> - Under the "Site" tab, where the site tree should be on the left, I >> get the following: >> "The OBJECTID argument passed to the getAncestors function is not of >> type UUID." >> >> I can't load any of the "Types" or "Rules" under Admin > Developer >> Utilities; Every class shows a conflict with a message next to each >> property that says: >> "TYPE CONFLICT EXISTS: Choose repair type below " >> >> If I choose to Repair, I get the following error: "Variable >> ORIGINALDATATYPE is undefined." >> >> Any ideas? Do I need to wipe out the database and reinstall? >> > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
