Messages

1

Bugs and Issues / Re: Microsoft Cursor Engine on Apply

« on: May 14, 2015, 02:56:40 am »

Perfect, thanks!
And the option is under Cursors/Results -> "Return matched rows instead of affected rows"

2

Bugs and Issues / Microsoft Cursor Engine on Apply

« on: May 14, 2015, 01:32:18 am »

I'm trying to create a new Model Document in one of my packages. After just creating it, I'm getting the error, ":Microsoft Cursor Engine [-2147217864] Row cannot be located for updating. Some values may have been changed since it was last read."

I have:

• Deleted and re-created the Model Document
• Deleted and re-created the containing package, then re-created the Model Document
• Deleted and re-created the grandparent package, parent, and the Model Document

Any suggestions for what I can start looking into?
We're using a MariaDB backend to store the data.

Thanks!
Tom

-- Edit, been doing some more debugging, getting some SQL logs. The following two lines return all nulls when executed manually.
SELECT * from t_operation where  ( Object_ID IN (5862) )  Order by Object_ID, Pos DESC , Scope, Name DESC

SELECT * from t_attribute where  ( Object_ID IN (5862) )  Order by Object_ID, Pos, Scope, Name

select Alias, t_object.Object_ID as Classifier from t_object, t_attribute where t_attribute.Classifier <> '0' and t_attribute.Classifier = t_object.Object_ID and  ( t_attribute.Object_ID IN (5862) ) union all

select Alias, t_object.Object_ID as Classifier from t_object, t_operation where t_operation.Classifier <> '0' and t_operation.Classifier = t_object.Object_ID and  ( t_operation.Object_ID IN (5862) ) union all

select Alias, t_object.Object_ID as Classifier from t_object, t_operation, t_operationparams where t_operationparams.Classifier <> '0' and t_operationparams.Classifier = t_object.Object_ID and t_operation.OperationID = t_operationparams.OperationID and  ( t_operation.Object_ID IN (5862) )

select t1.Name, t1.ea_guid from t_object t1, t_object t2 where t1.ea_guid = t2.PDATA1 and  ( t2.Object_ID IN (5862) )

select t1.Object_ID, t1.Object_Type, t1.Name, t1.Alias, t1.IsActive, t1.ea_guid from t_object t1, t_object t2 where t1.Object_ID = t2.Classifier and  ( t2.Object_ID IN (5862) )

Select UserID, GroupID, EntityID from t_seclocks, t_object WHERE  ( t_object.Object_ID IN (5862) )  AND EntityID = t_object.ea_guid

SELECT t_operationparams.* FROM t_operationparams,t_operation WHERE t_operationparams.OperationID = t_operation.OperationID and  ( t_operation.Object_ID IN (5862) )  order by t_operation.OperationID, t_operationparams.Pos

Select t_operationparams.OperationID from t_connector, t_connectortag, t_operationtag, t_operationparams where t_connector.Connector_ID=t_connectortag.ElementID  and t_operationparams.OperationID=t_operationtag.ElementID and t_connectortag.Property='operation_guid' and t_connectortag.`VALUE`= t_operationtag.`VALUE` and t_operationtag.Property='ea_guid' and t_operationparams.Classifier='5862' UNION  Select t_operation.OperationID from t_connector, t_connectortag, t_operationtag, t_operation where t_connector.Connector_ID=t_connectortag.ElementID  and t_connectortag.Property='operation_guid' and t_connectortag.`VALUE`= t_operationtag.`VALUE` and t_operationtag.Property='ea_guid' and t_operationtag.ElementID=t_operation.OperationID and t_operation.Classifier='5862'

3

Automation Interface, Add-Ins and Tools / Re: Cloud Services over SSL / HTTPS

« on: June 01, 2015, 11:41:43 pm »

Simon M:
Thanks! That did the trick.

Tom

4

Automation Interface, Add-Ins and Tools / Re: Cloud Services over SSL / HTTPS

« on: May 29, 2015, 11:58:42 pm »

Still running into problems getting the SSL to work. I know nothing else is listening on the port - restarting the service with the not-secure listening on port 805 works.
I reverted to the original cacert.pem file provided with the cloud installation.
It isn't a missing file because the logs will indicate when a file is missing.

I performed the following to generate the server.pem - do I need to follow  a different procedure to generate it?

1)    openssl req -out ca.pem -new -x509
2)    openssl genrsa -out server.key 1024
3)    openssl req -key server.key -new -out server.req
4)    openssl x509 -req -in server.req -CA CA.pem -CAkey privkey.pem -CAserial file.srl -out server.pem
5)    openssl genrsa -out client.key 1024
6)    openssl req -key client.key -new -out client.req
7)    openssl x509 -req -in client.req -CA CA.pem -CAkey privkey.pem

What is the PDF that Dermot referenced?

Thanks again,
Tom

5

Automation Interface, Add-Ins and Tools / Re: Cloud Services over SSL / HTTPS

« on: May 28, 2015, 11:48:22 pm »

Client side, I'm getting "Unable to connect to service: HTTP status: 500\nThe operation timed out"

Server side, I'm getting "[WARNING]: Unable to create secure server on port 805."

I must have missed the PDF instructions. I'll see if I can find those, and update if I'm still unable to make everything play nice.

Thanks!

6

Automation Interface, Add-Ins and Tools / Cloud Services over SSL / HTTPS

« on: May 28, 2015, 05:57:53 am »

I'm trying to set up the Could Services over SSL, and keep running into a problem. I'm not 100% certain where I'm running into it. I know the service is running because access over unsecure HTTP (okay within the office) works. If I visit localhost:804 in a web browser, I get the "Sparx Systems Cloud Server" page.
However, I'm unable to get anything if I visit https://localhost:805
I've tried generating a server.pem using the instructions at http://dst.lbl.gov/~boverhof/openssl_certs.html, replacing the provided cacert.pem with the generated ca.pem
I'm running on a Windows 2012 server, with IIS 8 (don't think that is relevant, but it might be?). I have verified that port 805 is open.
Has anyone managed to get this to work and kept notes as to what you did?