GeoMedia Discussions

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Posts: 10
Registered: ‎06-26-2016
Accepted Solution

connection to oracle

Why there is no Warehouse connection to oracle database in geomedia ?
Is it required to install Oracle to activate connection option ?

Highlighted
Technical Evangelist
Posts: 557
Registered: ‎09-11-2015

Re: connection to oracle

Oracle Client 32bit must be installed on the machine with GeoMedia. If you install the client after GeoMedia has been installed, you should run GeoMedia Configuration Wizard again to get the Oracle components registered properly.

 

Pavel

Highlighted
Occasional Contributor
Posts: 13
Registered: ‎10-16-2016

Re: connection to oracle

I've followed this step but still not work. Geomedia desktop still cannot connect with oracle database. The popup displayed "Unable to connect to the database. Please verify that your warehouse-connection parameters are correct and try again". However, database utilities also used the same database configuration but can connect. 

Highlighted
Technical Evangelist
Posts: 557
Registered: ‎09-11-2015

Re: connection to oracle

What version of Oracle client did you install? The easiest is to install "Administrator".

 

Pavel

Highlighted
Occasional Contributor
Posts: 13
Registered: ‎10-16-2016

Re: connection to oracle

i have installed Oracle Database 12c Release 2 Client (12.2.0.1.0) as an administrator.

I'm also used SQL*Plus command an successfully connected.

 

SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 11 10:51:45 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Tue Aug 11 2020 10:50:37 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

 

Still cannot connect with oracle database in Geomedia 

Highlighted
Occasional Contributor
Posts: 13
Registered: ‎10-16-2016

Re: connection to oracle

I have enable goracle.log and this is the output

 

2020-08-11 10:50:37.1244 ********** BEGIN NEW ORACLE CONNECTION ***********
2020-08-11 10:50:37.1245 Entering GODatabase::Initialize
2020-08-11 10:50:37.1290 Exiting GODatabase::Initialize, hr = 0
2020-08-11 10:50:37.1290 Entering GODatabase:Smiley SurprisedpenDatabase
2020-08-11 10:50:37.1291 Entering GMDatabase::Connect
2020-08-11 10:50:37.1291 username = <GOMPB>
2020-08-11 10:50:37.1291 service name = <pujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com>
2020-08-11 10:50:37.1291 Entering GMDatabase::Initialize
2020-08-11 10:50:37.1315 Exiting GMDatabase::Initialize, hr = 0
2020-08-11 10:50:37.2262 ExecuteForDefinition (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) SQL text: select owner, table_name, column_name, data_type from all_tab_columns
2020-08-11 10:50:37.2279 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 1.099ms, SQL text: select sdo_version from dual
2020-08-11 10:50:37.2279 Exiting GMDatabase::Connect, hr = 0
2020-08-11 10:50:37.2283 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.321ms, SQL text: select count(1) from GDOSYS.GALIASTABLE
2020-08-11 10:50:37.2286 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.238ms, SQL text: select count(1) from GDOSYS.GALIASTABLE
2020-08-11 10:50:37.2291 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.441ms, SQL text: select TABLETYPE, TABLENAME from GDOSYS.GALIASTABLE
2020-08-11 10:50:37.2299 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.449ms, SQL text: select count(1) from GDOSYS.GPARAMETERS
2020-08-11 10:50:37.2303 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.341ms, SQL text: select GPARAMETER, GVALUE from GDOSYS.GPARAMETERS
2020-08-11 10:50:37.2314 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.578ms, SQL text: select count(1) from GDOSYS.GFIELDMAPPING
2020-08-11 10:50:37.2322 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.464ms, SQL text: select OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_SUBTYPE, CSGUID, SEQUENCE_OWNER, SEQUENCE_NAME from GDOSYS.GFIELDMAPPING
2020-08-11 10:50:37.2361 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.398ms, SQL text: select count(1) from GDOSYS.GEXCLUSIONS
2020-08-11 10:50:37.2364 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 0.313ms, SQL text: select OWNER, EXTYPE from GDOSYS.GEXCLUSIONS
2020-08-11 10:50:37.5986 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 361.755ms, SQL text: SELECT COUNT(*) FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P'
2020-08-11 10:50:37.6612 ExecuteStatement (GOMPBSmiley Tongueujprd-oradb-scan.jpphvis.com/NVISPROD.jpphvis.com) Elapsed time: 62.513ms, SQL text: SELECT OWNER, TABLE_NAME, CONSTRAINT_NAME FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P'
2020-08-11 10:50:37.6747 Database Error Number: 1406
2020-08-11 10:50:37.6747 Database Error Message: ORA-01406: fetched column value was truncated

2020-08-11 10:50:37.6751 Exiting GODatabase:Smiley SurprisedpenDatabase, hr = -2147219601

 

It's show fetched column value was truncated. Any suggestion that I can easily trace which column is truncate 

 

 

Highlighted
Technical Evangelist
Posts: 557
Registered: ‎09-11-2015

Re: connection to oracle

Do you try to connect as a superuser (sys, system)?

Highlighted
Technical Evangelist
Posts: 207
Registered: ‎02-02-2016

Re: connection to oracle

An Oracle connection failure will occur with the entries shown in the posted GOracle.log file of:

 

"...SQL text: SELECT OWNER, TABLE_NAME, CONSTRAINT_NAME FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P'
2020-08-11 10:50:37.6747 Database Error Number: 1406
2020-08-11 10:50:37.6747 Database Error Message: ORA-01406: fetched column value was truncated
2020-08-11 10:50:37.6751 Exiting GODatabaseSmiley Frustratedmiley SurprisedpenDatabase, hr = -2147219601"

 

...if you have created an object name in Oracle with more than 30 characters (e.g. a table name, etc) and you are using a version of GeoMedia prior to GeoMedia Desktop 2020 Update 1 (16.6.0.1200).

 

A fix/enhancement has been made to support long Oracle object names with GeoMedia Desktop 2020 Update 1, so once you upgrade to that version the connection should succeed.

 

If you are unable to upgrade to GeoMedia Desktop 2020 Update 1 at this time, you will need to edit the database objects names that are greater than 30 characters and change them to values that do not exceed 30 characters. The constraint names are often the culprit, so you may want to check those first.

 

Thanks.