{"action":"created","issue":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/933","repository_url":"https://api.github.com/repos/ArctosDB/arctos","labels_url":"https://api.github.com/repos/ArctosDB/arctos/issues/933/labels{/name}","comments_url":"https://api.github.com/repos/ArctosDB/arctos/issues/933/comments","events_url":"https://api.github.com/repos/ArctosDB/arctos/issues/933/events","html_url":"https://github.com/ArctosDB/arctos/issues/933","id":178778164,"node_id":"MDU6SXNzdWUxNzg3NzgxNjQ=","number":933,"title":"constraint on positions problems","user":{"login":"campmlc","id":14808196,"node_id":"MDQ6VXNlcjE0ODA4MTk2","avatar_url":"https://avatars0.githubusercontent.com/u/14808196?v=4","gravatar_id":"","url":"https://api.github.com/users/campmlc","html_url":"https://github.com/campmlc","followers_url":"https://api.github.com/users/campmlc/followers","following_url":"https://api.github.com/users/campmlc/following{/other_user}","gists_url":"https://api.github.com/users/campmlc/gists{/gist_id}","starred_url":"https://api.github.com/users/campmlc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/campmlc/subscriptions","organizations_url":"https://api.github.com/users/campmlc/orgs","repos_url":"https://api.github.com/users/campmlc/repos","events_url":"https://api.github.com/users/campmlc/events{/privacy}","received_events_url":"https://api.github.com/users/campmlc/received_events","type":"User","site_admin":false},"labels":[{"id":417784823,"node_id":"MDU6TGFiZWw0MTc3ODQ4MjM=","url":"https://api.github.com/repos/ArctosDB/arctos/labels/Blocked:%20Needs%20Discussion","name":"Blocked: Needs Discussion","color":"0052cc","default":false},{"id":329285206,"node_id":"MDU6TGFiZWwzMjkyODUyMDY=","url":"https://api.github.com/repos/ArctosDB/arctos/labels/Function-ContainerOrBarcode","name":"Function-ContainerOrBarcode","color":"fef2c0","default":false},{"id":252228770,"node_id":"MDU6TGFiZWwyNTIyMjg3NzA=","url":"https://api.github.com/repos/ArctosDB/arctos/labels/Priority-High","name":"Priority-High","color":"eb6420","default":false}],"state":"closed","locked":false,"assignee":{"login":"dustymc","id":5720791,"node_id":"MDQ6VXNlcjU3MjA3OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/5720791?v=4","gravatar_id":"","url":"https://api.github.com/users/dustymc","html_url":"https://github.com/dustymc","followers_url":"https://api.github.com/users/dustymc/followers","following_url":"https://api.github.com/users/dustymc/following{/other_user}","gists_url":"https://api.github.com/users/dustymc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustymc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustymc/subscriptions","organizations_url":"https://api.github.com/users/dustymc/orgs","repos_url":"https://api.github.com/users/dustymc/repos","events_url":"https://api.github.com/users/dustymc/events{/privacy}","received_events_url":"https://api.github.com/users/dustymc/received_events","type":"User","site_admin":false},"assignees":[{"login":"dustymc","id":5720791,"node_id":"MDQ6VXNlcjU3MjA3OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/5720791?v=4","gravatar_id":"","url":"https://api.github.com/users/dustymc","html_url":"https://github.com/dustymc","followers_url":"https://api.github.com/users/dustymc/followers","following_url":"https://api.github.com/users/dustymc/following{/other_user}","gists_url":"https://api.github.com/users/dustymc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustymc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustymc/subscriptions","organizations_url":"https://api.github.com/users/dustymc/orgs","repos_url":"https://api.github.com/users/dustymc/repos","events_url":"https://api.github.com/users/dustymc/events{/privacy}","received_events_url":"https://api.github.com/users/dustymc/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/ArctosDB/arctos/milestones/3","html_url":"https://github.com/ArctosDB/arctos/milestone/3","labels_url":"https://api.github.com/repos/ArctosDB/arctos/milestones/3/labels","id":1276690,"node_id":"MDk6TWlsZXN0b25lMTI3NjY5MA==","number":3,"title":"Needs Discussion","description":"The path to implementation is unclear and requires discussion by involved parties, the Advisory Committee, and/or the Arctos Group.","creator":{"login":"dustymc","id":5720791,"node_id":"MDQ6VXNlcjU3MjA3OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/5720791?v=4","gravatar_id":"","url":"https://api.github.com/users/dustymc","html_url":"https://github.com/dustymc","followers_url":"https://api.github.com/users/dustymc/followers","following_url":"https://api.github.com/users/dustymc/following{/other_user}","gists_url":"https://api.github.com/users/dustymc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustymc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustymc/subscriptions","organizations_url":"https://api.github.com/users/dustymc/orgs","repos_url":"https://api.github.com/users/dustymc/repos","events_url":"https://api.github.com/users/dustymc/events{/privacy}","received_events_url":"https://api.github.com/users/dustymc/received_events","type":"User","site_admin":false},"open_issues":191,"closed_issues":82,"state":"open","created_at":"2015-08-27T22:05:58Z","updated_at":"2018-11-14T17:11:34Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-09-23T03:49:02Z","updated_at":"2018-11-14T17:11:34Z","closed_at":"2018-11-14T17:11:34Z","author_association":"NONE","body":"I am having a lot of difficulty with the constraint on altering positions because of  the existence of legacy object tracking from before this constraint was put into place. For example, I have shelves or freezer racks that have jars or freezer boxes scanned directly to the shelf or rack, and later positions were added, which makes it impossible to do any further editing to anything.  I get  the following oracle error:\nAn error occurred while processing this page! \nError Executing Database Query. \n[Macromedia][Oracle JDBC Driver][Oracle]ORA-20000: FAIL: Parent contains positions and cannot contain not-position containers ORA-06512: at \"UAM.BULKUPDATECONTAINER\", line 79 ORA-06512: at line 1\n\nBUT: I can't find out where the parent is that is causing the problem.  If I am trying to bulkload to Bulk Edit Container, there is no way for me to find out which parent has both containers and positions via the error info.  I am unable to figure out where the problem lies in order to find the problem and fix it.  PLEASE HELP.\n\nHere is the file I've been trying to load this evening - these are Rausch legacy jars that need label information in order to sort them out for cataloging. This process has already taken two years. I would really like to get it done and not keep fighting this battle over and over.\n\n[jar label upload final 9-22-16.xlsx](https://github.com/ArctosDB/arctos/files/488829/jar.label.upload.final.9-22-16.xlsx)\n"},"comment":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/comments/438741461","html_url":"https://github.com/ArctosDB/arctos/issues/933#issuecomment-438741461","issue_url":"https://api.github.com/repos/ArctosDB/arctos/issues/933","id":438741461,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODc0MTQ2MQ==","user":{"login":"dustymc","id":5720791,"node_id":"MDQ6VXNlcjU3MjA3OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/5720791?v=4","gravatar_id":"","url":"https://api.github.com/users/dustymc","html_url":"https://github.com/dustymc","followers_url":"https://api.github.com/users/dustymc/followers","following_url":"https://api.github.com/users/dustymc/following{/other_user}","gists_url":"https://api.github.com/users/dustymc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustymc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustymc/subscriptions","organizations_url":"https://api.github.com/users/dustymc/orgs","repos_url":"https://api.github.com/users/dustymc/repos","events_url":"https://api.github.com/users/dustymc/events{/privacy}","received_events_url":"https://api.github.com/users/dustymc/received_events","type":"User","site_admin":false},"created_at":"2018-11-14T17:11:34Z","updated_at":"2018-11-14T17:11:34Z","author_association":"CONTRIBUTOR","body":"https://github.com/ArctosDB/arctos/issues/1743 separates actual positions and random non-position things that have been called position."}}
{"actor":{"display_login":"dustymc"}}