Qury Entity Error

jayashrib223 over 8 years ago

Hi,

We are getting error "Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data." when we have text input in query filter of length more than 20 as below:

filters: {
a!queryFilter(
field: "Abc",
operator: "=",
value:
"173501735017350173501"
),
}

When we query database directly( not through Appian) with the same value of length more than 20, it works fine.

Any help appreciated!

Thanks,
Jayashri

Discussion posts and replies are publicly visible

0 chetany
A Score Level 1
over 8 years ago

Is the field "Abc" text or integer in CDT?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abhinavg712
Certified Lead Developer
over 8 years ago

Server logs will give more details on why it failed to retrieve the data.Please check the logs once.
Does the "columnDefinition" for ABC field is similar as per the DB mappings
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jayashrib223 over 8 years ago

Field "Abc" is "Text" in CDT and 'VARCHAR' in DB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bhanuprakashm over 8 years ago

Hi jayasrib,
Can you please check cdt datatype size. I think u mentioned the size lessthan 20 characters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jayashrib223 over 8 years ago

in CDT it's type="xsd:string" - no size limitation
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abhinavg712
Certified Lead Developer
over 8 years ago

Any luck with logs as there you will the details error description
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chetany
A Score Level 1
over 8 years ago

As mentioned by abhinavg712, the logs may give a clue to the exact issue. I would also like to point out that if you have just specified xsd:string and did not give any JPA annotation for column size, then by default it is considered as varchar(255)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Omkar K over 8 years ago

Can you try using tostring( "173501735017350173501") for value parameter in a!queryFilter? Also, please check the JPA notation as mentioned by chetany.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rama Thummala
Certified Lead Developer
over 8 years ago

@jayashrib
might be the problem with filed size in xsd.Can you try by adding the size in xsd for the column?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jayashrib223 over 8 years ago

Thanks All! I tried adding tostring(), xsd size but still getting same issue. I will try to find the error in logs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel