Jump to content
We've recently updated our Privacy Statement, available here. ×

ERROR: Failed to execute query: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512


Andreia Biancato 5

Recommended Posts

Hello Please can someone tell me how to handle this error in SPOTFIRE 7.11 I need some help urgently. Error message: Could not open information link. ImportException at Spotfire.Dxp.Data: Failed to execute data source query for data source "IL_SP_BI_SHEET_CREATE_NEW18". (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2() at Spotfire.Dxp.Data.DataFlow.Execute() at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.ExecuteQueryCore2() at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2() at Spotfire.Dxp.Data.Producers.SourceColumnProducer.c__DisplayClass2e.b__2b() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, DataPropertyRegistry propertyRegistry, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, PartialDataLoadReport& partialLoadReport) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.GetColumnsAndProperties(DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(SourceColumnProducer producer, DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataItem.Update(SourceColumnProducer producer, DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataPool.d__2.MoveNext() at Spotfire.Dxp.Data.Producers.SourceColumnProducer.OnConfigure() at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node) at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node) at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node) at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass9.b__8(IDocumentNodeChild documentNodeChild) at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation) at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew() at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNodeBase newOwner) at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item) at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass6.b__5() at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException) at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item) at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass37.b__36() at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException) at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable) at Spotfire.Dxp.Data.DataTableCollection.Add(String dataTableName, DataSource dataSource, Boolean autoCreateFilters, Boolean includeInAxisControls) at Spotfire.Dxp.Application.PartiallyOpenedDataSource.d__0.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__34.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__1b.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.ConsumeDataLoadPromptRequests(IEnumerable`1 prompts) at Spotfire.Dxp.Application.AnalysisApplication.Open(DataSource source, DocumentOpenSettings settings) at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSourceWithoutPrompting(DataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider) at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSource(InformationLinkDataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider) at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop() InformationModelException at Spotfire.Dxp.Data: Failed to execute query: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BinaryReader.FillBuffer(Int32 numBytes) at System.IO.BinaryReader.ReadUInt16() at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader) at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType) at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit() at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2() at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2() InformationModelServiceException at Spotfire.Dxp.Services: Failed to execute query: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 (HRESULT: 80131509) Stack Trace: at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod) at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()
Link to comment
Share on other sites

Hello,

This looks like the issue with the way procedure was written. Possible reasons could be comparing string/character type with number type, assigning value of number type to string etc. And make sure input parameters in the procedure element are listed in the order they are defined. Here are some external links.

 

https://stackoverflow.com/questions/9074589/character-to-number-conversi...

https://stackoverflow.com/questions/23545386/ora-06502-pl-sql-numeric-or...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...