Aurelius Operation aborted

BIZ TMS Aurelius
1

Hi,
i am a little bit stuck here, i get the following exception message :

Operation aborted

in method (Unit Aurelius.Comp.Connection)

function TAureliusConnection.CloneAdaptedConnectionWithRtti: TComponent;
var
Rtti: TRttiContext;
Prop: TRttiProperty;
Props: TArray;
ConnectionProp: TRttiProperty;
begin
if AdaptedConnection = nil then Exit(nil);

Rtti := TRttiContext.Create;
try
Result := TComponentClass(AdaptedConnection.ClassType).Create(nil);
try
Props := Rtti.GetType(AdaptedConnection.ClassType).GetProperties;

  // Set events before properties
  for Prop in Props do
    if (Prop.Visibility = mvPublished) and Assigned(Prop.PropertyType) and
      (Prop.PropertyType.TypeKind = tkMethod) and Prop.IsWritable and Prop.IsReadable then
      Prop.SetValue(Result, Prop.GetValue(AdaptedConnection));

  ConnectionProp := nil;
  // Now properties
  for Prop in Props do
    if (Prop.Visibility = mvPublished) and Assigned(Prop.PropertyType) and
      (Prop.PropertyType.TypeKind <> tkMethod) and Prop.IsWritable and Prop.IsReadable then
    begin
      if SameText(Prop.Name, 'Connected') or SameText(Prop.Name, 'Active') then
        ConnectionProp := Prop
      else
      // ugly hack to not clone this property in UniDac
      // Later we should refactor this in a way that each adapter adds specific logic
      // for cloning
      if SameText(Prop.Name, 'DefaultTransaction') and SameText(AdaptedConnection.ClassName, 'TUniConnection') then
        // nothing
      else
        Prop.SetValue(Result, Prop.GetValue(AdaptedConnection));
    end;
  if ConnectionProp <> nil then
    ConnectionProp.SetValue(Result, ConnectionProp.GetValue(AdaptedConnection));
except
  Result.Free;
  raise;
end;

finally
Rtti.Free;
end;
end;

I am tryin to retrive entity data from a MS-SQL Server, using UniDac access components.

Any clue what is going wrong....

br
Michael

2

Update on this topic, i changed my access to the database from UniDac to native driver support, this solves the described error, but now i get this error trying to get data through my Swagger UI :

{
"error": {
"code": "AureliusOdbcException",
"message": "Error -1: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ungültiger Objektname "tblHBM_SIMDATA"."
}
}

confusing :upside_down_face:

3

I can't tell what's going on. Looks like some misconfiguration in your environment at some point, either the ODBC driver, or SQL Server, or the connection settings. The second error simply seems to be a table/object tblHBM_SIMDATA that you are trying to access but doesn't exist in database.

4

Hi Wagner,

no, the table is existing, i can access the table not using Aurelius.
The probplem is, that a dot "." is added to the URL in double quotes.....

The tablename is : tblHBM_SIMDATA and not

tblHBM_SIMDATA"."

The first error is only occuring, when using UniDac as AdapteConnection , if i use FireDac, i don't get the first error !

The UniDac connection is also working fine, without Aurelius.

br
Michael

5

If FireDAC is working, what happens if you try to use FireDAC with Aurelius? You only mentioned to try UniDAC and native connection.

Well, in any case, for us to investigate better, we need to a very small project reproducing the issue. Ideally, with your claimed code that works using no Aurelius, and the one with Aurelius that fails.