What are the challenges you face when working across database platforms? Take the survey
Options

Cannot create project

opcampbellopcampbell Posts: 3
edited March 10, 2016 5:15AM in Source Control for Oracle
I've just downloaded Source Control for Oracle and I can't create a project. Every time I try, it reaches 'registering database' and then fails. The following appears in the log:
11:53:16.259|Debug  |Object Model        |60 |-- Executing query

WITH m_owners AS
(
    SELECT 'AGR55' as owner from dual

)
SELECT
u.username as OWNER,
o.NAME as TABLE_NAME,
c.NAME as COLUMN_NAME,
c.property, --TO_CHAR (c.property,'XXXXXXXXXXXXXXXXXX') AS property,
decode(bitand(c.property, 137438953472 + 274877906944), 137438953472, 'YES', 274877906944, 'YES', 'NO') AS IDENTITY_COLUMN,
decode(bitand(c.property, 68719476736), 68719476736, 'YES','NO') AS IDENTITY_ONNULL,
decode(bitand(c.property, 137438953472), 137438953472, 'YES','NO') AS IDENTITY_ALWAYS,
decode(bitand(c.property, 274877906944), 274877906944, 'YES', 'NO') AS IDENTITY_DEFAULT
FROM sys.col$ c,sys.tab$ t,sys.obj$ o, all_users u, m_owners
WHERE c.obj# = t.obj#
AND t.obj# = o.obj#
AND o.owner# = u.user_id
AND u.username = m_owners.owner
AND decode(bitand(c.property, 137438953472 + 274877906944), 137438953472, 'YES', 274877906944, 'YES', 'NO') = 'YES';
11:53:16.267|Error  |Object Model        |60 |Failed to execute reader
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist

I'm using 3.0.5.1416 and the database is Oracle 12c Enterprise Edition Release 12.1.0.2.0

Comments

Sign In or Register to comment.