Sorry, should have mentioned this.
No security has yet been set. All spectra users have access to all areas of
spectra.
As a thought, would creating a new cfaobjects DB on the NT box and pointing
the Solaris Spectra at it instead of the current one fix this?
Regards
Darren Tracey
Webmaster
Thiess
Australia
> -----Original Message-----
> From: Jared Clinton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 9 April 2001 4:21 PM
> To: Spectra-Talk
> Subject: RE: Spectra webtop login problems
>
>
> Darren,
>
> This sounds so much like a permissions problem, does the
> login you are using
> have access?
> To make sure , try using the super user..
>
> Good luck, Jared Clinton.
>
> > -----Original Message-----
> > From: Darren Tracey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, 9 April 2001 16:17
> > To: Spectra-Talk
> > Subject: FW: Spectra webtop login problems
> >
> >
> > We have:
> > Allaire Spectra 1.5 for Solaris
> > ColdFusion Enterprise server 4.5.1 SP2 for Solaris
> > (All hotfixes up to 6th April 2001 have been installed,
> > including 'duplicate' fix)
> > Oracle 8i database (version 8.1.6)
> > Sun Sparc box running solaris 7 with all recommended patches.
> >
> > HISTORY:
> > Spectra is a fresh install, finished last Thursday.
> > The default cfaobject database has not been upsized. The
> > application CODB was planned to be migrated in from a db used
> > on a backup NT server.
> > While trying to create the first application, the migrate
> > function gave an error and stopped half way through. The
> > error had not only caused the new destination to be unusable
> > (as expected), but the source Content Object Datastore was
> > also erased.
> > The database was left in this empty state, while
> > reconstruction was done on the backup NT server.
> > The database used for the application was moved to a new copy
> > of itself on the Oracle server and CF admin repointed to it.
> >
> > THE CURRENT PROBLEM:
> > Upon login to Spectra, you are asked for a username and
> > password. After entering these, you see the screen with the
> > Spectra splash screen and the words 'Establishing data
> > connections and loading system objects' and after only a
> > second or two the browser logo that animates to show that
> > loading is underway has stopped. The screen can be left like
> > this for hours and nothing further happens.
> > There are many entries in the CF error log file like this:
> > "Error","TID=11","04/09/01","15:55:24","Oracle Error Code =
> > 942<P>ORA-00942:
> > table or view does not exist <P> <P> SQL = "select objectid,
> > typeid, label,
> > attribs, datetimecreated,
> > datetimelastupdated, createdby, lastupdatedby,
> > lockedby, published, archived, active, objectdata
> > from objects where
> > objectid = '088E7FE8-2AA3-11D3-AD400060B0EB2994'" "
> >
> > We have tried replacing, removing and renaming the
> > datasources used by Spectra.
> > Spectra seems to be completely unusable.
> >
> > Are we looking down the barrel of a re-install?
> >
> > Regards
> >
> > Darren Tracey
> > Webmaster
> > Thiess
> > Australia
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
