Upgrade Issue With Attachments on Service Calls

Description:

After upgrading multiple versions of Signature (2018 to current) and MobileTech was at the current version, when attempting to add an attachment to a service call, the following error message was displayed: MobileTech will attempt to attach the file to the call. The document was saved to the WSDOCS table, but was not written to the WSDOCAPPT table.

Resolution:

Create a new non-clustered index on the WSDOCS table in SQL Server. In SQL Server Management Studio, copy and paste the following query script and run it against your company database.

CREATE NONCLUSTERED INDEX [DocID_NonClusteredIndex] ON [dbo].[WSDOCS]
(
[Document_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO