Problems porting Spectra Access db's to Oracle

[Miranda, Esther]

Hi,

I'm trying to install Spectra 1.5.3 on a clean system (windows 2003
server).
I want to use Oracle (9.2.0.5.0) instead of the provided access
databases, and am trying to port the blank databases (allaire.zip) as
described in the Spectra 1.5.3. releasenotes.
I'm using the Oracle Migration Workbench to create the Oracle model,
however I'm running into several errors :
        failed to map table :
cfapplicationdb.cfapplicationdb.rs_lastcommit;oracle.mtg.migration.Migra
tionSQLException: Failed to map table column:origin_qid:Failed to map
table column:origin_qid

The table rs_lastcommit contains the datatype 'Binary' which the Oracle
Migration Tool does not seem to recognize (When checking the Data Type
Mappings there's no entry for 'Binary', only 'LongBinary').
I've tried changing the access type to 'Long Binary' in the xml file,
which get translated to BLOB in Oracle, but then I get other errors
(ORA-02262: ORA-932 occurs while type-checking column default value
expression). Changing the BLOB to LONG RAW does not help, as you can
only have 1 LONG RAW type column per table (and cfaapplicationdb
contains 2 binary columns)

Anybody have any idea what I can try next, or have experience with
running Spectra on Oracle ?

Thanx in advance,
Esther

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Simon Slooten]

Hi,

We run Spectra 1.5.3 on Win2003 with Oracle 9 databases for one of our
customers.
We used Access to Oracle (http://www.soft32.com/download_76142.html) to
migrate the db's.

We have had this config up and running since early this year without
problems.

Cheers,
Simon Slooten
Prisma IT



-----Original Message-----
From: Miranda, Esther [mailto:esther.miranda@...]
Sent: donderdag 3 november 2005 14:38
To: Spectra-Talk
Subject: Problems porting Spectra Access db's to Oracle

Hi,

I'm trying to install Spectra 1.5.3 on a clean system (windows 2003
server).
I want to use Oracle (9.2.0.5.0) instead of the provided access
databases, and am trying to port the blank databases (allaire.zip) as
described in the Spectra 1.5.3. releasenotes.
I'm using the Oracle Migration Workbench to create the Oracle model,
however I'm running into several errors :
        failed to map table :
cfapplicationdb.cfapplicationdb.rs_lastcommit;oracle.mtg.migration.Migra
tionSQLException: Failed to map table column:origin_qid:Failed to map
table column:origin_qid

The table rs_lastcommit contains the datatype 'Binary' which the Oracle
Migration Tool does not seem to recognize (When checking the Data Type
Mappings there's no entry for 'Binary', only 'LongBinary').
I've tried changing the access type to 'Long Binary' in the xml file,
which get translated to BLOB in Oracle, but then I get other errors
(ORA-02262: ORA-932 occurs while type-checking column default value
expression). Changing the BLOB to LONG RAW does not help, as you can
only have 1 LONG RAW type column per table (and cfaapplicationdb
contains 2 binary columns)

Anybody have any idea what I can try next, or have experience with
running Spectra on Oracle ?

Thanx in advance,
Esther



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5684
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Miranda, Esther]

Hi Simon,

The tool works like a charm, thanx for the tip ;-)

Esther

> -----Original Message-----
> From: Simon Slooten [mailto:Slooten@...]
> Sent: donderdag 3 november 2005 15:30
> To: Spectra-Talk
> Subject: RE: Problems porting Spectra Access db's to Oracle
>
> Hi,
>
> We run Spectra 1.5.3 on Win2003 with Oracle 9 databases for
> one of our customers.
> We used Access to Oracle
> (http://www.soft32.com/download_76142.html) to migrate the db's.
>
> We have had this config up and running since early this year
> without problems.
>
> Cheers,
> Simon Slooten
> Prisma IT
>
>
>
> -----Original Message-----
> From: Miranda, Esther [mailto:esther.miranda@...]
> Sent: donderdag 3 november 2005 14:38
> To: Spectra-Talk
> Subject: Problems porting Spectra Access db's to Oracle
>
> Hi,
>
> I'm trying to install Spectra 1.5.3 on a clean system
> (windows 2003 server).
> I want to use Oracle (9.2.0.5.0) instead of the provided
> access databases, and am trying to port the blank databases
> (allaire.zip) as described in the Spectra 1.5.3. releasenotes.
> I'm using the Oracle Migration Workbench to create the Oracle
> model, however I'm running into several errors :
> failed to map table :
> cfapplicationdb.cfapplicationdb.rs_lastcommit;oracle.mtg.migra
> tion.Migra
> tionSQLException: Failed to map table
> column:origin_qid:Failed to map table column:origin_qid
>
> The table rs_lastcommit contains the datatype 'Binary' which
> the Oracle Migration Tool does not seem to recognize (When
> checking the Data Type Mappings there's no entry for
> 'Binary', only 'LongBinary').
> I've tried changing the access type to 'Long Binary' in the
> xml file, which get translated to BLOB in Oracle, but then I
> get other errors
> (ORA-02262: ORA-932 occurs while type-checking column default
> value expression). Changing the BLOB to LONG RAW does not
> help, as you can only have 1 LONG RAW type column per table
> (and cfaapplicationdb contains 2 binary columns)
>
> Anybody have any idea what I can try next, or have experience
> with running Spectra on Oracle ?
>
> Thanx in advance,
> Esther
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5685
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54