For more information about troubleshooting failed stored procedures, see Stored Procedure Diagnostics.
We recommend consulting the trace log for details. The trace log is normally located at <drive>:\ Server Files\TraceLogs\SiteName and view the SPFServerTraceRolling.log.
Use the table below to determine which site's trace log to review:
When the error occurs |
Site on which to review the trace file |
---|---|
In job creation |
Staging site |
During initial stage of export |
Target system site |
During job deletion |
Stage and target system sites |
During completion of the job |
Stage and target system sites |
The above table is relevant when staging and target systems are in different systems.
Below is a sample of the content you will find in the trace file:
Error^Loader^ProcessID:2496^ThreadID:5636^BaseVTLProcessStep^Execute^ 2018/09/19 14:25:44^SPF.Server.SPFException: Failed to Execute Stored Procedure ---> Oracle.DataAccess.Client.OracleException: ORA-00959: tablespace 'VTL_DATASPACEEEEEE' does not exist
ORA-06512: at "VTL_DATA.VCT", line 12
ORA-06512: at line 1
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at SPF.Common.DataAccessLayer.ProviderClasses.OracleDBProvider.ExecuteStoredProcedure(String pstrStoredProcName, IEnumerable`1 pcolParameters) in C:\Products\SPF40\Source\Common Projects\DataAccessLayer\SPF\Common\DataAccessLayer\ProviderClasses\Instance\OracleDBProvider.vb:line 110
--- End of inner exception stack trace ---
at SPF.Common.DataAccessLayer.ProviderClasses.OracleDBProvider.ExecuteStoredProcedure(String pstrStoredProcName, IEnumerable`1 pcolParameters) in C:\Products\SPF40\Source\Common Projects\DataAccessLayer\SPF\Common\DataAccessLayer\ProviderClasses\Instance\OracleDBProvider.vb:line 123 at Intergraph.VTL.Server.Services.Import.Classes.Classes.Database.StoredProcedureExecution.CreateTablesForImport(IDBProvider pobjIDBProvider, IJob pobjJob, Int32 lobjTotalRowsToBeProcessed)
at Intergraph.VTL.Server.Services.Import.Classes.Classes.Import.VTLJobImportProcessor.ProcessImportJob(IJob pobjJob)
at Intergraph.VTL.Server.Services.Import.Classes.Classes.Import.VTLJobImportProcessor.ProcessImportJob(IVTLJob pobjJob)
at Intergraph.VTL.Server.Services.Import.Classes.Classes.Import.VTLImport.Execute(IVTLJob pobjVTLJob, ISPFRequestContextService pobjRequestContext)
at SPF.Server.Components.Workflow.ProcessSteps.Import.StepExecution()
at BaseVTLProcessStep.Execute()