Validation error still in Overnight build 9.0.1 (19-Nov-2021)

[FredS]

Same error I posted before..

Errors:

Code: Select all

    PA.exe raised exception class EUniError with message 'validation error for column "TRUSTEDDOMAINS"."DSDOMAINKINDS", value "4294967330"'.

    PA.exe raised exception class EIBCError with message 'validation error for column "TRUSTEDDOMAINS"."TRUSTTYPE", value "4294967298"

Input:

Code: Select all

    ASql    'insert into trusteddomains (netbiosname, domainid, dnsdomainname, domainsid, dc, dsdomainkinds, trusttype) values (:netbiosname, :domainid, :dnsdomainname, :domainsid, :dc, :dsdomainkinds, :trusttype)'
    AParams    (
    'SMB03', 1, 'smb03.local',
    'S-1-5-21-3188387342-845300696-3033364349',
    'Offline or Unavailable', 34, 2)

Monitor:

Code: Select all

    SQL Execute: insert into trusteddomains (netbiosname, domainid, dnsdomainname, domainsid, dc, dsdomainkinds, trusttype) values (:netbiosname, :domainid, :dnsdomainname, :domainsid, :dc, :dsdomainkinds, :trusttype)
    :netbiosname(WideString[4])='EMCO'
    :domainid(LargeInt)=1
    :dnsdomainname(WideString[10])='emco.local'
    :domainsid(WideString[41])='S-1-5-21-2788477859-2423432321-3061298541'
    :dc(WideString[22])='Offline or Unavailable'
    :dsdomainkinds(LongWord)=34
    :trusttype(LongWord)=2
    Pending

So let's be clear, this error is new in v9:

• occurs only in Win32 not Win64 against the same db..

• occurs in a thread, but I haven't and wont' bother to test outside of a thread since a NON parameterized Insert works

• error is in both FBv3 and FBv4

Code: Select all

CREATE DOMAIN DWORD AS
BIGINT
check ( value between 0 and 4294967295 );

Everything else is as vanilla as it gets..

[FredS]

Today I made these changes:

Code: Select all

              LMyUInt64 := ar[i].DsDomainKinds.ToCard;
              FCon.SQL.Params[5].Value := LMyUInt64;// ar[i].DsDomainKinds.ToCard;
              LMyUInt64 := ar[i].TrustType;
              FCon.SQL.Params[6].Value := LMyUInt64;// ar[i].TrustType;

this changes the monitor output and works:

11/20/2021 11:03:03 AM 0.000 SQL Execute: insert into trusteddomains...

Code: Select all

..
:dsdomainkinds(Unknown)=34 
:trusttype(Unknown)=2 Complete

11/20/2021 11:03:03 AM 0.000 SQL Execute: insert into trusteddomains..

Code: Select all

..
:dsdomainkinds(Unknown)=34 
:trusttype(Unknown)=2 Complete

reverting returns to this:

11/20/2021 11:08:02 AM 0.032 SQL Execute: insert into trusteddomains..

Code: Select all

..
:dsdomainkinds(LongWord)=34 
:trusttype(LongWord)=2 Complete

11/20/2021 11:08:02 AM 0.062 SQL Execute: insert into trusteddomains..

Code: Select all

..
:dsdomainkinds(LongWord)=34 
:trusttype(LongWord)=2 Error: validation error for column "TRUSTEDDOMAINS"."DSDOMAINKINDS", value "4294967330"

As the Monitor log shows all entries are legit up to where you have a complete SQL Statement and pass it to the Monitor..

[FredS]

Not the constraint, fbtrace.log:

Code: Select all

Statement 607:
-------------------------------------------------------------------------------
insert into trusteddomains (netbiosname, domainid, dnsdomainname, domainsid, dc, dsdomainkinds, trusttype) values (?, ?, ?, ?, ?, ?, ?)

param0 = varchar(320), "SMB03"
param1 = bigint, "1"
param2 = varchar(480), "smb03.local"
param3 = varchar(800), "S-1-5-21-3188387342-845300696-3033364349"
param4 = varchar(320), "VMSMB03"
param5 = bigint, "34"
param6 = bigint, "4294967298"

[ViktorV]

We answered you on the forum viewtopic.php?f=28&t=48136

[FredS]

Assume I won't have to ask for another nightly build?

[ViktorV]

Hi Fred, as soon as we get all required information (like indicated in the previous post) from you - we will immediately create and send you back a nightly buid which you may use further.

Best regards,
Viktor