Nathan French ComDoc Systems Analyst

Thanks Phil.  
I confirmed the time zone is "(UTC-5) Eastern Time (US & Canada)"

You say "Oh dear" so I'll put in a support ticket after I gather some screenshots before and after 5pm today.

Nate

The previous behaviors from my original post are no longer present:
- dates are not being decremented when they are read from.
- WF_CURRENT_DATE reports 12pm now and not 5pm.

Now I'm seeing some different odd behavior, but it feels very related.  This is Build 7.1.0.15390 (2019-12-09)

Right now, I'm trying to add 7 days to WF_CURRENT_DATE.   

• Before 5pm, it adds 6 days.  (Feb 4 + 7 days = Feb 10)
• After 5pm, it adds 7 days.  (Feb 4 + 7 days = Feb 11)

I'm in EST (UTC-5) so it looks like I'm seeing the same "off by -19 hours" error as I did before. 
24 hours - 5 hours = 19 hours so i'm guessing the UTC-5 offset is involved.

Right now, it's not an actual problem for what I'm doing.  I'll just add 8 days, and it will wind up being 7 days for stuff processed within normal business hours, which is when this scheduled workflow runs.  It's easy enough to envision scenarios where this would cause trouble though.

If this is one of the fixes in 20200107, it's not listed.
 

DocuWare 7.1 - Build: 7.1.0.15287
Windows Server 2012 R2
MS SQL Server 2014
 
BACKGROUND
I noticed this error whenever I would enter the form configuration (picture attached).  It wasn't always like that, and I'm not sure exactly when it began or what brought it on - it could be related to applying a previous minor update which may have been applied prior to this message.

This form has about 65 fields which are indexed and filled in on a merge form.  The merge form itself has all of those plus another 25 fields (hidden on the web form) which are later populated by calculations in workflow. I have not wanted to recreate all of that.

Everything has been fully functional and working properly.  Still though, I am uneasy putting this into production as is. I made some copies of the workflow (all with the same message) and deleted here and there until it didn't error upon opening.

The culprit is the merge form entry itself.  Not any specific areas of it - using a different file, deleting all fill areas, deleting all indexing still gives the same message.  It was something about the mere existence of that merge form entry.

SOLUTION

1. Test everything below with a COPY of the affected form, just to be sure. (My copies were also affected.)
2. Under "Submission," switch from Merge Form to Web Form.
3. Under Output choose a store dialog (I chose the same one the merge form had used - unsure if important)
4. Under Indexing, index something
5. Save the configuration
6. Unsure if important, but it worked consistently:
   1. Go "back" to main Forms configuration
   2. Exit Configurations entirely or reload the page,
   3. Re-enter Forms and re-enter the affected form - NO ERROR
7. Under "Submission" switch from Web Form back to Merge Form
8. Enter merge form configuration - rejoice there is still your old merge form configuration.
9. Within merge form config, verify Designer (fill areas), Output (store dialog), and Indexing are all still okay.
10. Save. Exit merge form, exit whole form, refresh page to main Configurations.
11. Navigate back to the previously affected form configuration and be satisfied to find no error.

Anyway, I hope this will help someone else who's searching for this message and can't figure out where it's coming from. 

Cheers,
- Nate
 

That integration link will only show tasks within that workflow.  I've tried to deconstruct and reform the parameters, but it has not been fruitful. 

Clearly there is a method which is used to access each section fully: Document trays, Search, Lists, Tasks ... this happens when those buttons are clicked, but it appears to be purely javascript. 

My goal is to use the URL redirect after a form submission to take the user to their Tasks.  There, they view the merged data and confirm the document. (Because there's no way to see the document prior to submitting the form.) 

I'm looking for some URL to direct Docuware to take the user directly to their tasks, as opposed to their document tray, a search, or lists?  I have in mind something like http://servername/DocuWare/Platform/WebClient/#My-Tasks (Example is completely made up, and doesn't do anything.)

If there is any sort of link that will take any user directly to their tasks, that's what I'm looking for.  This has to be generic, not directed to one task list or one user.  Also would love to know if there are shortcuts to other areas like document trays, searches, lists, monitor tasks.

Thanks,
-Nate

In the 7.1 version of Workflow Designer there is now a data assignment option for the destination "Fill area on the document" which sounds enticing.  My searching for "fill area" has not turned up any information or even discussions on what this is or how to use it.  It's apparent I need to define a fill area to populate. 

My only guess is this will put information directly onto the document image.  Right now that would be amazing for the project I'm working on, rather than using workflow decision stamps to embed that information.  

EDIT: I didn't realize that my searches excluded help.docuware.com when I was searching in "All" ... I found what I was looking for:
http://help.docuware.com/en/#b57865t64471n88773

This is exactly what I needed!  Hopefully this helps someone else find that page.  

Suggestion:  Have the "All" search at support.docuware.com include the help.docuware.com manual.
 

Oh thank you!  

I named them differently to keep track of what I was seeing.  
Thought I was being clever.

I've created a 32-bit ODBC connection to a SQL Server 2000 database.  I have done this because DocuWare's SQL driver can't apparently connect to the ancient SQL Server 2000 directly.  I can connect to this ODBC source and authenticate using the ODBC driver in DocuWare Administration. 

In Select Lists, the source is available to choose but I cannot see any tables or views when I select it.  It's an empty dropdown.
In Workflow Designer, the source is again available, but choosing it gives the error "The specified DSN contains an architecture mismatch between the Driver and Application"  

I tried also presenting it as a 64-bit ODBC connection, but DocuWare cannot see that one at all.  It must be 32-bit ODBC.  So what is this about the architecture mismatch?

Can someone please advise what I'm missing?
 
Thanks much,
--Nate

EDIT:  I am using:
DocuWare 7.1 On-Premise
Windows Server 2016 1607 (DocuWare Server)
ODBC Data Source Administrator 32-bit
SQL Native Client 10.0 ODBC driver
ODBC Connection to SQL Server 2000
(DocuWare databases themselves are hosted on SQL Server 2014)

I see the current version 7.1 System Requirements document (link above from Tobias).  But I cannot find the corresponding information for 7.0.  The closest I'm finding is this tiny document:

Release Information > What's New in DocuWare Version 7 > Additional New Features and Usability Improvements in Version 7 > Configure and manage DocuWare > Changed System Requirements

Then, when 7.2 comes out, the document for 7.1 will be updated for 7.2. 
Then, the full list of requirements for both 7.0 and 7.1 will not be available.

I suggest this current version System Requirements document be copied over to live with its little brother Changed System Requirements prior to being updated for the next release.  Or they can be combined.

Thanks,
--Nate

EDIT: The document for 7.1, Changed System Requirements and Technical Release Notes, is located in a different position.  I suggest the position within the version's What's New folder should be the same for each version.

I'm noticing in cloud 7.1 systems that the data file used in a file connection can be locked somehow, and therefore cannot be updated.  Here's a transcript of an FTP session (in FileZilla) to the data directory.  The destination directory already contains "File_Connection_1.csv" which now needs to be updated with new information.  (Actual path names are redacted - "unique_directory_characters" replaces the actual string of characters for this cloud system.)
 

Status:      Starting upload of /path/to/document/File_Connection_1.csv
Command:   CWD /unique_directory_characters/data
Response:  250 OK. Current directory is /unique_directory_characters/data
Command:   TYPE I
Response:  200 TYPE is now 8-bit binary
Command:   PASV
Response:  227 Entering Passive Mode (40,122,29,90,157,205)
Command:   STOR File_Connection_1.csv
Response:  553 Can't open that file: Device or resource busy
Error:        Critical file transfer error

I think I locked this file when I was double-checking the columns for the file connection in the Administration tool, but the lock is still in place for quite a long time, it's been more than 4 hours now.  How can I get this lock to be released?  

The only alternative seems to be create a new autoindex job pointing to a new file connection using a renamed copy of this updated file.  I have done this as a workaround in the systems where this is happening, so there is no currently open or waiting issue.

Two questions:
- Is this the expected behavior?
- How long is this file lock supposed to exist?

Thanks,
Nate