Devart Forums

Posted: **Fri 19 Nov 2021 17:45**

Same error I posted before..

Errors:

    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..

Posted: **Sat 20 Nov 2021 19:25**

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..

Posted: **Sun 21 Nov 2021 21:03**

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"

Posted: **Mon 29 Nov 2021 16:50**

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

Posted: **Mon 29 Nov 2021 18:22**

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

Posted: **Wed 01 Dec 2021 12:49**

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

Devart Forums

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

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

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

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

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

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

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