Dynamics Community Forum Thread Details

Dynamics GP Older Conversion Stored Procedure Errors

We have an older Dynamics GP user who had an employee make some changes to the stored procedures and now getting litany of issues when trying to run the conversion. Would anybody know what the following errors would point to?

Event Type: Error

Event Source: SQLISPackage100

Event Category: None

Event ID: 12550

Date: 7/31/2015

Time: 10:54:21 AM

User: NT AUTHORITY\SYSTEM

Computer: ABRAHAM

Description:

Event Name: OnError

Message: The StoredProcedure '[dbo].[eConnectOutCreate]' cannot be scripted as its data is not accessible.

StackTrace: at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects)

at Microsoft.SqlServer.Management.Smo.Scripter.EnumScriptWithList(SqlSmoObject[] objects)

at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(SqlSmoObject[] objects)

at Microsoft.SqlServer.Management.Smo.Transfer.Microsoft.SqlServer.Management.Common.ITransferMetadataProvider.SaveMetadata()

at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.Configure(ITransferMetadataProvider metadataProvider)

at Microsoft.SqlServer.Management.Smo.Transfer.GetTransferProvider()

at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()

at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()

InnerException-->Property TextHeader is not available for StoredProcedure '[dbo].[eConnectOutCreate]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.

StackTrace: at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextProperty(String requestingProperty, ScriptingOptions so, Boolean bThrowIfCreating)

at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.BuildText(ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextForScript(ScriptingOptions so, Boolean forCreate, String[] expectedObjectTypes, Boolean forceCheckNameAndManipulateIfRequired)

at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptInternal(StringCollection queries, ScriptingOptions so, Boolean bForCreate)

at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptSP(StringCollection queries, ScriptingOptions so, Boolean bForCreate)

at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreate(StringCollection queries, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects)

at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects)

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)