Schema Modeler ignores user defined datatypes

Data Abstract
1

Hi,

I have some stored procedures that have input parameters with user defined datatypes. The Schema Modeler ignores any parameters with user defined datatypes, but includes all parameters with native, SQL datatypes. Is this by design or is it a bug that may be resolved?

Thanks,

David

2

Hello

Could you provide some more details, ie database used and examples of a custom type definition and stored procedure it use. We need this to determine is this really a Schema Modeler or Data Abstract bug in parameters detection or something else (f.e. ADO.NET driver that ignores custom-type parameters).

TIA

3

Hi,

I am using MS SQL Server 2012 Express Edition, with Native Client installed.

Connection Type: MSSQL2005
Connection String: MSSQL2005.NET?Server=192.168.2.100\SQLEXPRESS;Database=EasyROI_Live;Integrated Security=SSPI;Pooling=false

CREATE TYPE udd_BOOL FROM BIT NOT NULL
GO
CREATE PROCEDURE roi.sp_JUNK (@TestParam udd_BOOL) AS
PRINT 'HI’
GO

On a side not, if I don’t specify a schema, the stored procedure does not appear the database, object browser, with the Schema Modeler.

I dragged and dropped the stored procedure from the database objects into my application’s schema, all within Schema Modeler. It is created without any parameters. Under Commands, roi.sp_JUNK, Parameters, I click Recreate Parameters. It creates RETURN_VALUE, but not @TestParam, which uses my user defined datatype.

Even with other stored procedures that use native datatypes, I have noticed that when I drag stored procedures into the schema, RETURN_VALUE is never created, and some other parameters may not be created. Clicking Recreate Parameters creates all of the missing parameters that use native datatypes, but not the user defined datatypes.

As a secondary question, in Relativity Server Admin, when I click “Open in Schema Modeler,” I have to specify the AES password. In earlier versions, I did not have to do this. Since I can simply copy the password from Network Settings, it does not appear to add any security. Is it possible to have Relativity Server automatically include the AES password?

Thanks,

David