+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Oracle Error: ORA-01460

Oracle Error: ORA-01460

6 posts, 0 answered
  1. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    29 Jul 2010
    Link to this post
    Hi,

    We've got a new error coming up in the Event Logs associated with Sitefinity:

    ORA-01460: unimplemented or unreasonable conversion requested

    This message is so obscure, but we do see it coming from the media section.

    Anyone seen this before?

    Regards,
    Jacques
  2. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    03 Aug 2010
    Link to this post
    Hello J.Hoventer,

    Thank you for posting this issue in our forums. 
    Do you have long descriptions of the items in the Media section? I guess these are the items from the Images and Documents module. Anyway, this is just a warning and nothing critical, but we'll have to find what is causing it. Can you please check the Sitefinity log, it may also contain some information?

    Thank you in advance for your cooperation.

    Greetings,
    Georgi
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    04 Aug 2010
    Link to this post
    Here is what I found in the Sitefinity Log:

    8/3/2010 11:07:39 PM [UNKNOWN]
    ************************************************************************************
    ID: 19aa24e5-6f54-433e-9ef5-2de9b819f224; Code: 3005; Occurrence: 1; Sequence: 409
    ------------------------------------------------------------------------------------

    Application information:
        Machine name: PD1
        OS Version: Microsoft Windows NT 5.2.3790 Service Pack 2
        Product Version: 3.7.2096.2
        Application Path: D:\ProductionSites\CompanyX\
        Debug: True

    Process information:
        Process ID: 1228
        Process Name: w3wp

    Request information:
        Request URL: /mediacentre/mediadetail/10-07-14/The_CompanyX_At_Your_Service_-_Assisting_Those_Affected_by_the_Calgary_and_Area_Hail_Storm_on_July_12_2010.aspx
        Rewrite URL: http://www.CompanyX.ca/mediacentre/mediadetail/10-07-14/The_CompanyX_At_Your_Service_-_Assisting_Those_Affected_by_the_Calgary_and_Area_Hail_Storm_on_July_12_2010.aspx
        Url Referrer: http://www.google.com/search?client=safari&rls=en&q=Hailstorm+Calgary+Canada+July+12th+2010&ie=UTF-8&oe=UTF-8
        Is Authenticated: False
        Authentication Type:     User:     User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.16 (KHTML, like Gecko) Version/5.0 Safari/533.16
        User Address: 172.16.1.195

    Variables:
        RadControlRandomNumber: 0
        CmsHttpRequest: /mediacentre/mediadetail/10-07-14/The_CompanyX_At_Your_Service_-_Assisting_Those_Affected_by_the_Calgary_and_Area_Hail_Storm_on_July_12_2010.aspx

    - L0 -------------------------------------------------------------------------------

    Exception Type: System.Data.OracleClient.OracleException

    Message: ORA-01460: unimplemented or unreasonable conversion requested


    Source: System.Data.OracleClient

    Stack Trace:
       at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row)
       at Nolics.ORMapper.DataProviders.SQLBlockBuilder.EmitQuery(StmtContext context, DataRow queryData, Int32 maxRows, String groupName)
       at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteQuery(StmtContext context, DataRow queryData, Int32 maxRows, String group)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.ExecQuery(DataSet queries)
       at Nolics.ORMapper.Base.QueryBase`1.LoadQuery(Int32 maxElements, Int32 fromElement)
       at Nolics.ORMapper.Base.QueryBase`1.LoadAll()
       at Telerik.Cms.Data.DefaultProvider.GetPageByAdditionalUrl(String url)
       at Telerik.Cms.Web.CmsSiteMapProvider.GetUrlContext(String url, Boolean skipSvcs, Boolean skipMappingService)
       at Telerik.Cms.Web.CmsSiteMapProvider.GetUrlContext(String url, Boolean skipSvcs)
       at Telerik.Cms.Web.CmsHttpModule.BeginRequest(Object sender, EventArgs e)
       at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    ------------------------------------------------------------------------------------
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    10 Aug 2010
    Link to this post
    Hi J.Hoventer,

    Thank you for the errors log file. 
    We have scheduled some tests with Oracle about this. Once we are ready. It's good though that there is no error to the user, but just in the records.

    Sincerely yours,
    Georgi
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    11 Oct 2010
    Link to this post
    Hi Georgi,

    Any news on this error? We're still getting it.

    Regards,
    Jacques
  6. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    14 Oct 2010
    Link to this post
    Hello J.Hoventer,

    Unfortunately  we were not able to reproduce it - neither with Sp3 and Sp4. Do you have any additional information in what scenarios this appears? I see that there are some additional urls for pages on which the errors occur. Do you get the error when a page is not accessed through an additional url?

    Sincerely yours,
    Georgi
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
6 posts, 0 answered