Found it!! Please run this and you should be fine. The SPROCS had INT on FileSize.
IF EXISTS (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DMX_AddEntry') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE {databaseOwner}{objectQualifier}DMX_AddEntry
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}DMX_AddEntry
@Author NVARCHAR(500),
@CollectionId Int,
@Created DateTime,
@Deleted Bit,
@Entry NVARCHAR(2000),
@EntryType NVARCHAR(150),
@FileSize BIGINT,
@InheritAttributes Bit,
@IsApproved Bit,
@Keywords NVARCHAR(255),
@LastVersionId Int,
@LockedBy Int,
@LockedUntil DateTime,
@LockKey uniqueidentifier,
@MD5Hash NVARCHAR(50),
@OriginalFileName NVARCHAR(255),
@Owner Int,
@Path NVARCHAR(4000),
@PermissionsOnlyByAdmin Bit,
@PortalId Int,
@State NVARCHAR(50),
@StorageProviderID INT,
@Version Int,
@VersionsToKeep Int,
@WorkflowId NVARCHAR(50)
AS
INSERT INTO {databaseOwner}{objectQualifier}DMX_Entries (
[Author],
[CollectionId],
[Created],
[Deleted],
[Entry],
[EntryType],
[FileSize],
[InheritAttributes],
[IsApproved],
[Keywords],
[LastVersionId],
[LockedBy],
[LockedUntil],
[LockKey],
[MD5Hash],
[OriginalFileName],
[Owner],
[Path],
[PermissionsOnlyByAdmin],
[PortalId],
[State],
[StorageProviderID],
[Version],
[VersionsToKeep],
[WorkflowId]
) VALUES (
@Author,
@CollectionId,
@Created,
@Deleted,
@Entry,
@EntryType,
@FileSize,
@InheritAttributes,
@IsApproved,
@Keywords,
@LastVersionId,
@LockedBy,
@LockedUntil,
@LockKey,
@MD5Hash,
@OriginalFileName,
@Owner,
@Path,
@PermissionsOnlyByAdmin,
@PortalId,
@State,
@StorageProviderID,
@Version,
@VersionsToKeep,
@WorkflowId
)
select SCOPE_IDENTITY()
GO
IF EXISTS (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DMX_UpdateEntry') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE {databaseOwner}{objectQualifier}DMX_UpdateEntry
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}DMX_UpdateEntry
@EntryId Int,
@BypassTriggers BIT,
@Author NVARCHAR(500),
@CollectionId Int,
@Created DateTime,
@Deleted Bit,
@Entry NVARCHAR(2000),
@EntryType NVARCHAR(150),
@FileSize BIGINT,
@InheritAttributes Bit,
@IsApproved Bit,
@Keywords NVARCHAR(255),
@LastVersionId Int,
@LockedBy Int,
@LockedUntil DateTime,
@LockKey uniqueidentifier,
@MD5Hash NVARCHAR(50),
@OriginalFileName NVARCHAR(255),
@Owner Int,
@Path NVARCHAR(4000),
@PermissionsOnlyByAdmin Bit,
@PortalId Int,
@State NVARCHAR(50),
@StorageProviderID INT,
@Version Int,
@VersionsToKeep Int,
@WorkflowId NVARCHAR(50)
AS
IF @BypassTriggers=1
DISABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
UPDATE {databaseOwner}{objectQualifier}DMX_Entries SET
[Author] = @Author,
[CollectionId] = @CollectionId,
[Created] = @Created,
[Deleted] = @Deleted,
[Entry] = @Entry,
[EntryType] = @EntryType,
[FileSize] = @FileSize,
[InheritAttributes] = @InheritAttributes,
[IsApproved] = @IsApproved,
[Keywords] = @Keywords,
[LastVersionId] = @LastVersionId,
[LockedBy] = @LockedBy,
[LockedUntil] = @LockedUntil,
[LockKey] = @LockKey,
[MD5Hash] = @MD5Hash,
[OriginalFileName] = @OriginalFileName,
[Owner] = @Owner,
[Path] = @Path,
[PermissionsOnlyByAdmin] = @PermissionsOnlyByAdmin,
[PortalId] = @PortalId,
[State] = @State,
[StorageProviderID]=@StorageProviderID,
[Version] = @Version,
[VersionsToKeep] = @VersionsToKeep,
[WorkflowId] = @WorkflowId
WHERE
[EntryId] = @EntryId;
IF @BypassTriggers=1
ENABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
GO
|