Have a look at your client log and you'll see an error for when this occurred. There should be a query there that was executed and errored. That may give you some insight.
Thank you, Lee.
I don't have much experience in troubleshooting - the error (please see below) doesn't tell me much - any idea what the problem is?
Error running query in SpDbOdbc
Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
========= LAST COMMAND ========
If (object_id(N'tempdb..#ApiBatchCfgs') Is Not Null) Truncate Table #ApiBatchCfgs Else Create Table #ApiBatchCfgs (DocID Int, Cfg nvarchar(255) collate database_default)
SET NOCOUNT ON
Exec ApiBatchUpdate 2, 2, N'e4bc2c7f-3f1e-4d4a-bfeb-df05baf10ae7'
Based on the line "conversion of a nvarchar data type to a datetime data type"; is there something funny about the date format in a variable you are using or copying during the conversion? A blank space can be enough to throw the script off.
I'm not sure but check these; Permissions (user/groups, folders and workflow), which PC runs the task, or settings on Task in administrator tool....
on the Task Pdf creator menu there is a time to set and repeat if fails looks like that might be it.
I think the timing of the host computer is taking a while sometimes increase the time.
Also make sure the host PC is a dedicated license of SolidWorks if its flexlm that might be it too.
I had similar problems when I setup a users PC to run the task on a machine that was in the UK behind VPN the timing would only work half the time.
There is an SPR for this; 735708. I am not sure if there is a workaround besides changing the vault date format setting to 1999-12-31 (yyyy-mm-dd)
Thank you, Lee. Changing the date format made the task work for Office to PDF conversion. Just wondering, why the date format is not an issue for conversion of SolidWorks files to PDF?