3 Replies Latest reply on Mar 21, 2006 7:26 PM by 401827

    Error Code: 17059. any one has solution for this error?

    445511
      hi
      when i search this error code, i got a lot of results, but none of them seems to have a solution. i am using oracle 9.2.0.6.0, and the sql that was generated when i tried to query the object back seemed ok, because i ran it and did get a record back. so, there is no syntax error in the sql from toplink. we are using weblogic 8.1 and running it on windowxp. the jsdk is 1.4.2.x. i included the exception log below.
      thanks.

      ServerSession(29464857)--Connection(12279942)--SELECT LOCATIONMANAGERID, MALL, ADDR_PRIMARY_LN, MESSAGINGCONTRACTTYPEID, BILLTOADDRESS, MMS_STORE_ID, CITYID, OFFICIALLOCATIONID, CSFRIFROM, OPFRIFROM, CSMONTO, OPFRITO, CSSATTO, OPMONFROM, CSSUNTO, OPMONTO, CSTHUTO, OPSATFROM, CSTUETO, OPSATTO, CSWEDTO, OPSUNFROM, EFFECTIVEDATE, OPSUNTO, EXPIRATIONDATE, OPTHUFROM, FAXNUMBER, OPTHUTO, FIDOSTORELOCCOMMENTS, OPTUEFROM, INTERSECTION1, OPTUETO, ISBILLTOADDRESS, OPWEDFROM, ISSHIPTOADDRESS, OPWEDTO, ACTIONTYPEID, PARTNERSSTORENUMBER, CHAINOFSTORESID, POSTALCODE, CSFRITO, PROVINCEID, CSSUNFROM, RECORDTYPEID, CSTUEFROM, RETAILBAN, EDI850STORENUMBER, RMS_LOCATION_ID, EXPIRED, ROGERSOBLIGATIONS, FIDOSTORETYPEID, ROGERSSTORELOCATORID, ISHEADOFFICEADDRESS, SALESCENTRALLOCATIONCODE1, ADDR_SECONDARY_LN, SALESCENTRALLOCATIONCODE2, CSSATFROM, STORENAME, CSWEDFROM, SUPERSYSTEMID, FIDOSTORELOCATORID, SUPERSYSTEMTEAMCODE, LOCATIONID, TELEPHONENUMBER, CSTHUFROM, TITANCUSTOMERNUMBER, INTERSECTION2, VALIDFROM, EMAILADDRESS, VALIDTO, CONTACTPERSONNAME, VENDORID FROM LOCATION WHERE (CHAINOFSTORESID = 1)
      Local Exception Stack:
      Exception [TOPLINK-4002] (OracleAS TopLink - 10g (9.0.4.2) (Build 040311)): oracle.toplink.exceptions.DatabaseException
      Exception Description: java.sql.SQLException: Fail to convert to internal representation
      Internal Exception: java.sql.SQLException: Fail to convert to internal representation
      Error Code: 17059
           at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:226)
           at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java:1066)
           at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(DatabaseAccessor.java:829)
           at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:682)
           at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:506)
           at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:134)
           at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:115)
           at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(CallQueryMechanism.java:197)
           at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(CallQueryMechanism.java:567)
           at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:732)
           at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:707)
           at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:424)
           at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:493)
           at oracle.toplink.queryframework.ReadQuery.execute(ReadQuery.java:111)
           at oracle.toplink.publicinterface.Session.internalExecuteQuery(Session.java:1958)
           at oracle.toplink.threetier.ServerSession.internalExecuteQuery(ServerSession.java:629)
           at oracle.toplink.publicinterface.Session.executeQuery(Session.java:1086)
           at oracle.toplink.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:52)
           at oracle.toplink.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:63)
           at oracle.toplink.internal.indirection.UnitOfWorkQueryValueHolder.getValueFromWrappedValueHolder(UnitOfWorkQueryValueHolder.java:60)
           at oracle.toplink.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:144)
           at oracle.toplink.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:63)
           at com.rogers.taz.model.ChainOfStores.getLocations(ChainOfStores.java:252)
           at com.rogers.taz.util.TazTest.testLoadChainOfStores(TazTest.java:294)