entering Work Items

If you are having a problem using Vault, post a message here.
Post Reply
tficken2
Posts: 62
Joined: Wed Mar 15, 2017 1:39 pm

entering Work Items

Post by tficken2 » Fri Jan 19, 2018 2:52 pm

Hello again,

1) So we discovered that Vault doesn't allow certain (valid) characters in file names. Thus far we've discovered + and & are not allowed. Is there a complete list of disallowed characters anywhere for our reference?

2) I think we've uncovered a maximum attachment file size of 10 meg. Where can we expand that limit?

(We poked around in admin options and found something where a limit could be adjusted, but our options were "100 meg" or "unlimited". Since we're being blocked at around 10 meg, I'm guessing that's NOT the correct setting to tweak.)

3) I've set up a query for "All Issues" in the web client. I think it's telling me that there are 16684 work items in the db. How do I see them? I thought perhaps it was loading 100 at a time for performance reasons, but I have no option to scroll down to load more. Thoughts?

Thanks!

Tara

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Fri Jan 19, 2018 4:58 pm

1) Do you mean for attachments to the work items? I just attached some with a + and a & using our Vault Pro Demo server in this work item: http://vaultprodemo.sourcegear.com/Vaul ... &itemid=42. If you are using XML for manipulating data, then the name could be being translated to something else.

2) Checking this out.

3) There should be a small error pointing to the right to go to the next page.
Beth Kieler
SourceGear Technical Support

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Fri Jan 19, 2018 5:41 pm

I reproduced item 2, and ASP.NET throws a "Maximum request length exceeded" error in the Event Viewer Windows logs. Try first the number 1048576 in the IIS upload limit, and perform an iisreset (run iisreset at an administrator command prompt).

If that doesn't fix it, try changing the MaxRequestLength in your web.config file directly:
https://stackoverflow.com/questions/385 ... h-exceeded.
Beth Kieler
SourceGear Technical Support

tficken2
Posts: 62
Joined: Wed Mar 15, 2017 1:39 pm

Re: entering Work Items

Post by tficken2 » Mon Jan 22, 2018 9:10 am

1) The web client will allow attachments with the "invalid" characters. The desktop client will not. It replaces the characters it doesn't like with spaces.

2) We did as suggested. Now when adding a ~200 meg attachment we get an error. The log file shows:

2018-01-22 09:59:13.857 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ModifyItem The UPDATE statement conflicted with the FOREIGN KEY constraint "fk_items_platforms". The conflict occurred in database "sgdragnet", table "dbo.platforms", column 'platformid'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at MantisSQLService.MantisSQLService.ModifyItem(MantisSqlConn conn, Int32 nAuthUID, MantisItem& mItem, Boolean bDescriptionChange, Boolean bDetailsChange, String strXmlKeywords, String strCommentXmlKeywords, Boolean bTagsChange, String strXmlTags, Int32 nAttDBBufSize, MantisItemFullDetail& mi) at MantisServiceAPI.MantisServiceAPI.ModifyItem(Int32 nAuthUID, String strUserLogin, MantisItem mItem, Int32 nAttDBBufSize) at MantisServiceLib.Helpers.ModifyItem(HttpSessionState session, MantisItem mItem)

3) Yes, I tried that on Friday, but it didn't actually do anything. I will try again. Thanks!

Tara

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Mon Jan 22, 2018 9:30 am

2) Check the allowable entries for the platform field. It looks like that item has a platform that isn't listed in the field options.

I'll post back about #1 in a bit.
Beth Kieler
SourceGear Technical Support

tficken2
Posts: 62
Joined: Wed Mar 15, 2017 1:39 pm

Re: entering Work Items

Post by tficken2 » Mon Jan 22, 2018 11:22 am

2) Eh...the Platform field is inserting its own defaults on Add of a work item. And if that were the issue, I would expect small attachments to fail also with the same Platform value. I think it's time to blow away the work item DB, start fresh, and treat it more gently based upon what we've learned about configuring it.

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Mon Jan 22, 2018 1:34 pm

Are you importing into our default platform field or one that you made? Ours is a drop-down field, which limits entries only to those that exist.
Beth Kieler
SourceGear Technical Support

tficken2
Posts: 62
Joined: Wed Mar 15, 2017 1:39 pm

Re: entering Work Items

Post by tficken2 » Mon Jan 22, 2018 2:03 pm

We WERE going to import into the default platform field. We changed its name and default table values. Then we realized that the name change doesn't bubble out through the system. So...we renamed it back to Platform, left its table values alone (as we had already populated work items using the platform field) and abandoned it. (So existing work item data that has the platform column populated should be OK.)

The original error about the foreign key constraint went away. Now we get THIS when we fail when attempting to manually add a work item with a large (~200 meg) attachment:

# SourceGear Vault Professional Server
2018-01-22 14:44:37.501 piaws359.rs.com (192.168.44.194)-skatsumata : Helpers::ListItemStatusValues
2018-01-22 14:49:58.984 Receiving an uploaded file.
2018-01-22 14:50:02.948 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUsers - pid=100
2018-01-22 14:50:02.948 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeUnitVals
2018-01-22 14:50:02.948 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeLogEntryTypeVals
2018-01-22 14:50:02.949 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemDetails - id=48799
2018-01-22 14:50:02.954 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:02.956 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:02.956 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::GetAttachmentHeaders
2018-01-22 14:50:02.958 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:02.958 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:02.959 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:02.960 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:02.960 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:02.960 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSavedQueries
2018-01-22 14:50:02.966 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:02.967 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:02.970 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListVaultRepositories
2018-01-22 14:50:11.897 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::DeleteAttachment - nMsgID=-2147434841, nAttID=-2147448893
2018-01-22 14:50:11.903 Calling plugin at location : https://vault.piacton.com/VaultNotifySe ... rvice.asmx
2018-01-22 14:50:11.908 Successfully called plugin at location : https://vault.piacton.com/VaultNotifySe ... rvice.asmx
2018-01-22 14:50:11.908 Exiting plugin thread for : https://vault.piacton.com/VaultNotifySe ... rvice.asmx
2018-01-22 14:50:11.913 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUsers - pid=100
2018-01-22 14:50:11.913 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeUnitVals
2018-01-22 14:50:11.913 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeLogEntryTypeVals
2018-01-22 14:50:11.913 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemDetails - id=48799
2018-01-22 14:50:11.916 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:11.917 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:11.917 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::GetAttachmentHeaders
2018-01-22 14:50:11.920 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:11.920 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:11.921 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:11.922 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:11.922 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:11.922 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSavedQueries
2018-01-22 14:50:11.925 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:11.925 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:11.925 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:11.926 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:11.926 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:11.926 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:11.926 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:11.929 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListVaultRepositories
2018-01-22 14:50:24.105 Receiving an uploaded file.
2018-01-22 14:50:24.519 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUsers - pid=100
2018-01-22 14:50:24.519 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeUnitVals
2018-01-22 14:50:24.519 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListTimeLogEntryTypeVals
2018-01-22 14:50:24.520 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemDetails - id=48799
2018-01-22 14:50:24.523 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:24.525 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:24.525 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::GetAttachmentHeaders
2018-01-22 14:50:24.527 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:24.527 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:24.528 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:24.528 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:24.529 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:24.529 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSavedQueries
2018-01-22 14:50:24.532 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListUserPermissions
2018-01-22 14:50:24.532 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListSystemFieldDetails
2018-01-22 14:50:24.532 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListItemStatusValues
2018-01-22 14:50:24.532 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:24.533 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:24.533 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:24.533 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListCustomFieldDetails
2018-01-22 14:50:24.535 piaws070.rs.com (192.168.44.132)-hgrannis : Helpers::ListVaultRepositories

tficken2
Posts: 62
Joined: Wed Mar 15, 2017 1:39 pm

Re: entering Work Items

Post by tficken2 » Mon Jan 22, 2018 2:21 pm

OK, false alarm! We verified that the IT guy didn't set the correct settings to increase the maximum allowed attachment size. We got those set correctly. We were then able to successfully add a file with a 200 meg attachment.

We're going to verify our import one last time, then backup the vault db, then blow away the dragnet db and reinstall Vault so as to recreate the dragnet db fresh. Then I will re-customize the db, and populate the necessary tables. Then we will wave some sage in the server room, say a prayer, and run the import for real.

Thanks for all your help!

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Mon Jan 22, 2018 2:29 pm

Another option you have with system fields is you can remove them from the form and not use them if you want to use your own custom one instead.
Beth Kieler
SourceGear Technical Support

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: entering Work Items

Post by Beth » Mon Jan 22, 2018 3:18 pm

I tried a bunch and only came up with + and & as well.

I have logged a bug on this.

F: 19928
Beth Kieler
SourceGear Technical Support

Post Reply