Menu
▾
▴
Re: FW: [Ebxmlrr-tech] Oracle Erorr - ORA-00972: identifier is too long
|
From: Diego B. <die...@di...> - 2004-12-22 10:54:33
|
Solved:
> I have rectified the problem. I deleted rdbold directory which was
> created from "Build clean" process and recompile it again. Then it
> compiled without any problems.
Diego
Manjith wrote:
> Dear Diego,
>
> I am having an urgent problem in my ebXMLRR version 2.1. Please help me
> to fix is. It was okay so far and my research work was based on it.
> Suddenly it got crashed since I tried to compile source code again. My
> presentation is tomorrow at 1.00p.m. and I am panic on setting up it.
>
> This is the error I got when I compiled:
> =====================
> compile:
> [javac] Since fork is true, ignoring compiler setting.
> [javac] Compiling 146 source files to
> D:\ebxmllr_v2.1\ebxmlrr-server\ebxmlrr\build\lib\classes
> [javac] Since fork is true, ignoring compiler setting.
> [javac]
> D:\ebxmllr_v2.1\ebxmlrr-server\ebxmlrr\src\share\com\sun\ebxml\registry\
> persistence\rdbold\AssociationDAO.java:35:
> [javac] public class AssociationDAO extends RegistryObjectDAO {
> [javac] ^
>
>
> =================
>
> regards
>
> Manjith
>
>
> -----Original Message-----
> From: Diego Ballve [mailto:die...@di...]
> Sent: 22 December 2004 13:28
> To: Manjith
> Cc: ebx...@li...
> Subject: Re: FW: [Ebxmlrr-tech] Oracle Erorr - ORA-00972: identifier is
> too long
>
> Hello Manjith,
>
> Your log shows: "executing query: 'SELECT * FROM Association WHERE lid =
> 'urn:uuid:d4001de8-7fe1-433d-9ca3-acba17200ece'"
> Then: "table or view does not exist"
>
> This could be because you have not created the database tables (with
> createMinDB target).
>
> Diego
>
> Manjith wrote:
>
>>
>>Dear all,
>>
>>Still I haven't received any response from exbmlrr registry group
>
> about
>
>>solution to following problem.
>>
>>Regards
>>
>>Manjith
>>
>>
>>-----Original Message-----
>>From: ebx...@li...
>>[mailto:ebx...@li...] On Behalf Of Manjith
>>Sent: 17 December 2004 15:06
>>To: 'Manjith'; 'Farrukh Najmi'
>>Cc: Ebx...@li...
>>Subject: RE: [Ebxmlrr-tech] Oracle Erorr - ORA-00972: identifier is
>
> too
>
>>long
>>
>>Dear All,
>>
>>I rectified this problem by commenting "create index id_event_id .."
>>Statement in the database.sql and database.sql.template files.
>>
>>Now I am getting different error which is listed below. It says some
>>tables are missing.
>>
>>=============
>>004-12-17 14:57:46,723 INFO
>>
>
> org.freebxml.omar.server.query.sql.SQLQueryProcessor[http-8080-Processor
>
>>24] - executing query: 'SELECT * FROM Association WHERE lid =
>>'urn:uuid:d4001de8-7fe1-433d-9ca3-acba17200ece'')
>>2004-12-17 14:57:46,786 ERROR
>>net.sf.hibernate.util.JDBCExceptionReporter[http-8080-Processor24] -
>>ORA-00942: table or view does not exist
>>
>>2004-12-17 14:57:46,786 ERROR
>>net.sf.hibernate.util.JDBCExceptionReporter[http-8080-Processor24] -
>>ORA-00942: table or view does not exist
>>
>>2004-12-17 14:57:46,786 ERROR
>>net.sf.hibernate.util.JDBCExceptionReporter[http-8080-Processor24] -
>>Could not execute query
>>java.sql.SQLException: ORA-00942: table or view does not exist
>>
>> at
>>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
>> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
>>
>>
>>
>>I was wondering some sort of a wrong code is gone to latest CVS of
>
> OMAR
>
>>directory. I downloaded latest CVS bit from there on 15th Dec. 2004.
>>
>>Please check the code in OMAR folder especially sqls are work in the
>>Oracle database.
>>
>>Regards
>>
>>Manjith
>>
>>
>>
>>-----Original Message-----
>>From: ebx...@li...
>>[mailto:ebx...@li...] On Behalf Of Manjith
>>Sent: 17 December 2004 13:39
>>To: 'Farrukh Najmi'
>>Cc: Ebx...@li...
>>Subject: RE: [Ebxmlrr-tech] Oracle Erorr - ORA-00972: identifier is
>
> too
>
>>long
>>
>>Dear Farrukh,
>>
>>I am using latest version of Oracle 9i (9.2.0.4.0) and I have not
>
> touch
>
>>any of ebXMLRR scripts.
>>
>>This is the place error is popping up.
>>
>
> ------------------------------------------------------------------------
>
>>
>>[sql] Failed to execute: CREATE INDEX id_eventId_AffectedObject_index
>>ON
>>AffectedObject(id, eventId)
>>
>>BUILD FAILED
>>D:\ebXMLRR\omar\build-setup.xml:162: The following error occurred
>
> while
>
>>executing this line:
>>D:\ebXMLRR\omar\build-setup.xml:155: java.sql.SQLException: ORA-00972:
>>identifier is too long
>>
>>
>>It clearly show id_eventID_AffectedObject_index is more than 30
>>characters long. In Oracle you cannot create identifiers more than 30
>>characters. How should I change this so that it will create index. I
>
> was
>
>>wonder why others did not get this error.
>>
>>Amazing why others not get ....
>>
>>
>>
>>Regards
>>
>>Manjith
>>
>>
>>
>>-----Original Message-----
>>From: ebx...@li...
>>[mailto:ebx...@li...] On Behalf Of Farrukh
>>Najmi
>>Sent: 17 December 2004 10:20
>>To: Manjith
>>Cc: Ebx...@li...
>>Subject: Re: [Ebxmlrr-tech] Oracle Erorr - ORA-00972: identifier is
>
> too
>
>>long
>>
>>Manjith wrote:
>>
>>
>>
>>>Dear friends,
>>>
>>>
>>>
>>>I am getting following Oracle error when I am creating Demo Database.
>>>I have downloaded latest CVS and I was wondering why this error is
>>>popping up.
>>>
>>>
>>>
>>>
>>>
>>>BUILD FAILED
>>>
>>>D:\ebXMLRR\omar\build-setup.xml:162: The following error occurred
>>>while executing this line:
>>>
>>>D:\ebXMLRR\omar\build-setup.xml:155: java.sql.SQLException: ORA-00972:
>>
>>
>>>identifier is too long
>>>
>>>
>>>
>>>
>>>
>>>Regards
>>>
>>>
>>>
>>>Manjith
>>>
>>
>>A quick google search on "ORA-00972: identifier is too long" showed
>
> the
>
>>following:
>>
>> http://dbforums.com/t582336.html
>>
>>What version of Oracle are you using? We have had no issues with
>
> Oracle
>
>>9i like this.
>>Are you using a different version? Did you modify any of the files we
>>provide for the createdb target?
>>
>>If you somehow resolved the problem please share what was the issue
>
> and
>
>>how you resolved it.
>>Thanks.
>>
>
>
>
--
Diego Ballve
Digital Artefacts Europe
http://www.digital-artefacts.fi
|