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 -~----------~----~----~----~------~----~------~--~---
