majorbyte さんのグループアクティビティ

Force user to delete their browser cache?

AngelaIp — Wed, 22 Nov 2017 03:36:31 GMT

Hi, When adding new features to an Aras instance, it is sometimes necessary for users to clear their browser cache. What is the best way to force users to delete their browser cache? I don´t think it´s technically possible to do this automatically, is it? How do other users deal with it? Are their any best practice tips (except sending a notification message)? Thanks!!

Purge and float

majorbyte — Thu, 15 Feb 2018 04:39:18 GMT

Hi, I create Itemtype A and B, both are version controlled and A has B as an item property defined as float. I create an instance of both and relate instance B to instance A. I modify both multiple times so they both go up several generations. When I purge instance A it goes to the previous generation with still referencing the latest generation of instance B. When I purge instance B I get an error instead stating that that specific generation of instance B is still referenced by instance A. 1. what is the Aras standard way of dealing with this situation? 2. what is the Aras standard way of dealing with a similar situation, but instead applied on relationship itemtypes? I'm having a hard time finding information on how to deal with the above 2 situations. Regards, /MB

ODATA RESTful API

majorbyte — Mon, 12 Feb 2018 08:46:13 GMT

Hi, I'm currently reading RESTful API document and I'm getting stuck rather quick. host:port/.../Products That's the example used in the document. But if I install a clean aras 11 SP12, what would the url be, because there's no *.svc file located in any folder of the installation. Also, the documentation mentions: http://host/odata/Part but so far I only get IIS errors, what does host stand for, localhost/InnovatorServer, localhost/InnovatorServer/Server, I can't seem to find the correct one. Also, how would I go about logging in with a user, that part seems to be missing as well. I can see an OAuthServer running in IIS, but I can't find anything about that in the documentation. regards, MB

Vault user vadmin password expired?

majorbyte — Fri, 12 Jan 2018 09:55:20 GMT

So we ran into an issue with our Vault server and the tp_Image item type All of the sudden SVG images were not display correctly, better yet not displayed at all. But this occurred only after a approximately 10 minutes, and after uploading a new image to the vault it would display the SVG's correct again. From Chrome's developer tools we could see that after 10 minutes, the vault server started return images with the mimetype octet-stream instead of the appropriate mimetype for the images (svg+xml for SVG). While octet-stream works for PNG/JPEG, it does not work for SVG. Also, if you had an admin logged in with another browser and let admin perform a search for tp_images it would work, and it would subsequently work for the normal user, but again for only 10 minutes. Turning debugging in InnovatorServerConfig.xml showed that when admin searches, the following aml was sent:

<Item type='FileType' action='get' orderBy='priority'> <OR> <extension condition='eq'><![CDATA[svg]]></extension> <extension condition='like'><![CDATA[svg,%]]></extension> <extension condition='like'><![CDATA[%,svg]]></extension> <extension condition='like'><![CDATA[%,svg,%]]></extension> </OR> </Item>

But, that aml was never sent when a normal user searched after 10 minutes. Trying to replicate this issue in a clean, newly installed Aras environment was unsuccessful, meaning everything works fine. This let us to believe that something was amiss with the Vault Server, but what was it sending? We installed Burp Proxy and set up a proxy forward for localhost and configured the Vault Server to send its Aras requests to the proxy address instead. These are the request headers for a normal user in our environment that had the issue at hand:

POST /InnovatorServer/Server/InnovatorServer.aspx HTTP/1.1 Content-Type: text/xml SOAPACTION: GetItem AUTHUSER: vadmin AUTHPASSWORD: C264E88F8ED2BAFBBC5EC79197FF2CCB DATABASE: 12.3 LIKEVALIDATEUSER: 1 VAULTTOKEN: B8j09Gbpng0SyruLPbppSq3K5azYsEtFuMiq04PjvAKqAhFYvlnVSA2 Host: localhost:8080 Cookie: ASP.NET_SessionId=tosjxk13jwrwfcrf4h23ytbm Content-Length: 347 Expect: 100-continue Connection: close

and this is the request's payload:

<?xml version='1.0' encoding='utf-8' ?><Item type='FileType' action='get' orderBy='priority'> <OR> <extension condition='eq'><![CDATA[svg]]></extension> <extension condition='like'><![CDATA[svg,%]]></extension> <extension condition='like'><![CDATA[%,svg]]></extension> <extension condition='like'><![CDATA[%,svg,%]]></extension> </OR></Item>

The response we got was:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Password is expired]]></faultstring><detail><af:legacy_detail><![CDATA[Password is expired]]></af:legacy_detail><af:exception message="Password is expired" type="Aras.Server.Core.PasswordExpiredException" /><message key="password_validation_info" value="<Item type="Variable" id="A4EFCB3197604DDAAF0E7CAA2BED9738"><name>User_pwd_symbols_min_number</name><value>-1</value></Item><Item type="Variable" id="188B86F49F8B4D6FB31FBEF8F606BD8E"><name>User_pwd_digits_min_number</name><value>-1</value></Item><Item type="Method" id="71C5E99F04F9413FBB3F89F9C910B640"><name>User_pwd_checkPolicy</name><method_code>//function User_pwd_checkPolicy(plainPwd, variablesXML[optional])

return standardCheckPlainPwdPolicy(plainPwd, variablesXML);

function standardCheckPlainPwdPolicy(plainPwd, variablesXML) {
	var varMinNumberNm = 'User_pwd_symbols_min_number';
	var varMinDigitsNm = 'User_pwd_digits_min_number';
	var failedSymbolTests = {};
	var failedDigitsTests = {};
	var valuesHash = {};
	var resXml;
	var wrongSymbolsVar = false;
	var wrongDigitsVar = false;

	if (variablesXML === undefined) {
		var conditionStr = '\'' + varMinNumberNm + '\',\'' + varMinDigitsNm + '\'';
		var aml = '&lt;Item type=\'Variable\' action=\'get\' select=\'name,value\'&gt;&lt;name condition=\'in\'&gt;' + conditionStr + '&lt;/name&gt;&lt;/Item&gt;';
		var res = aras.soapSend('ApplyItem', aml);
		if (res.getFaultCode() !== 0) {
			return res.getFaultString();
		}
		resXml = res.getResultsBody();
	} else {
		resXml = variablesXML;
	}

	if (resXml.indexOf('&lt;Result') &lt; 0) {
		resXml = '&lt;Result&gt;' + resXml + '&lt;/Result&gt;';
	}

	var d = aras.createXMLDocument();
	d.loadXML(resXml);

	var nd = d.selectSingleNode('//Item[name=\'' + varMinNumberNm + '\']/value');
	var val = (nd) ? parseInt(nd.text) : '';
	valuesHash[varMinNumberNm] = val;
	if (val &amp;&amp; (!plainPwd || plainPwd.length &lt; val)) {
		failedSymbolTests[varMinNumberNm] = true;
	} else {
		wrongSymbolsVar = true;
	}

	nd = d.selectSingleNode('//Item[name=\'' + varMinDigitsNm + '\']/value');
	val = (nd) ? parseInt(nd.text) : '';
	valuesHash[varMinDigitsNm] = val;
	if (val &amp;&amp; val &gt; 0) {
		failedDigitsTests[varMinDigitsNm] = testStr(plainPwd, /[0-9]{1}/g, val);
	} else {
		wrongDigitsVar = true;
	}

	var retVal = '';
	var k;
	for (k in failedDigitsTests) {
		if (failedDigitsTests[k]) {
			if (!wrongSymbolsVar) {
				retVal = aras.getResource('', 'imports_core.password_policy_requirements_missed', valuesHash[varMinNumberNm], valuesHash[varMinDigitsNm]);
				return retVal;
			} else {
				retVal = aras.getResource('', 'imports_core.password_policy_requirements_missed2', valuesHash[varMinDigitsNm]);
				return retVal;
			}
		}
	}

	for (k in failedSymbolTests) {
		if (failedSymbolTests[k]) {
			if (!wrongDigitsVar) {
				retVal = aras.getResource('', 'imports_core.password_policy_requirements_missed', valuesHash[varMinNumberNm], valuesHash[varMinDigitsNm]);
				return retVal;
			} else {
				retVal = aras.getResource('', 'imports_core.password_policy_requirements_missed2', valuesHash[varMinNumberNm]);
				return retVal;
			}
		}
	}
	return retVal;

	function testStr(s, re4s, cnts) {
		var retVal = false;
		var arr = s.match(re4s);
		var i = 0;

		while (arr &amp;&amp; arr[i] &amp;&amp; cnts &gt; 0) {
			i++;
			cnts--;
		}

		if (cnts &gt; 0) {
			retVal = true;
		}

		return retVal;
	}
}
</method_code></Item>" /></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

This request never got logged when debugging was on, presumably because it never got past checking the password. So our first question: why was the password expired? We confirmed that everything started working as normal again in our environment after we changed the password for vadmin, but why did we need to change its password? It has no maximum password age, it has no password history length configured, and bot User_pwd_symbols_min_number and User_pwd_digits_min_number are set to -1. The second question we have: We noticed that when admin performs a search on tp_Image, the Vault Server sets/sends a different header:

AUTHUSERTOKEN: XeiVKxP9ywNWqL1SKrtVjD6PgWOSeLs2_3hvl1AfmzmGZqYstlzpqaK4WRA9qHwPcVkgr3COGXpf_1-f6d0GexVDyaZrtgOmO2GdhC5vE9utA0PtBrfBbvWYufTRD9euDt9nUqKbMeC77VIraYCWa0iv_wYPwF7DbErEtlTUAmGf8nm9aEdEx5jD8cJh9D5CN9mCh373BAYGZVP2WcyQ_Tg3w70FFiuiKFwthjDpVIlOGxRm4QJqto2r0GkqdTja0

Instead of the AUTHUSER / AUTHPASSWORD combination, which makes us wonder, have we configured the Vault Server correct?

Technical Publication - additional xsd

majorbyte — Wed, 17 May 2017 07:52:22 GMT

I have several schema's (tp_xmlschema) which are all quite similar. Basically this is to control what elements you can add in different types of publication. There's one tree of xs:element's in all these schema's that's exactly the same. Now when I have to change it, I have to make the same change to all schema's. What I'm interested in is defining that tree in it's own xsd in Client/Modules/aras.innovator.TDF/Schemes and import that xsd into my schema's, just like: <xs:schema xmlns="">www.aras.com/TechDocExample" targetNamespace="">www.aras.com/TechDocExample" xmlns:aras="">http://aras.com/ArasTechDoc" xmlns:graphics="">mynamespace.com/Graphics" xmlns:xs="">www.w3.org/.../XMLSchema" elementFormDefault="qualified"> <xs:import namespace="">www.w3.org/.../> <xs:import namespace="">aras.com/.../> <xs:import namespace="">mynamespace.com/.../> But doing so gives the following error in the client: The 'mynamespace.com/Graphics:Graphic-List' element is not declared.. I assume this is because nowhere I have defined that it should load Client/Modules/aras.innovator.TDF/Schemes/graphics.xsd. I haven't been able to find where it might load the XSD's from that folder. Am I trying to achieve something that's just not possible, or am I missing something? I hope someone can help me out

AML throws Aras.Server.Core.AmbiguousCriteriaException

majorbyte — Fri, 25 Nov 2016 10:48:02 GMT

I'm trying to update the datasource of a property to the correct datasource in our test and production environments, but without the use of ID's because that's what caused the problem I'm trying to correct in the first place, the id's for (for instance) properties in test and production don't always match the id's in our development environment. So, I wrote this AML:

<Item action="edit" type="Property" where="[Property].keyed_name = 'era_locked_by'">
  <data_source keyed_name="locked_by_id">
    <Item type="Property" action="get" select="id" where="[property].keyed_name = 'locked_by_id' and [property].source_id in (select it.ID from innovator.ITEMTYPE it where it.name = 'DOCUMENT')" />
  </data_source>
</Item>

but when I run in Innovator Admin for instance, it returns

<af:exception message="Aras.Server.Core.AmbiguousCriteriaException" type="Aras.Server.Core.AmbiguousCriteriaException" />

This is probably because of the nested Properties where statement, but is there any to make this work, without using actual id's?