I am getting this error when using the Query Database Smart Service (also see at

maheshp460

Certified Associate Developer

over 9 years ago

I am getting this error when using the Query Database Smart Service (also see attached)

The database returned ARV's that may not be supported. Message: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name \\'PROJ_TCKT_DATA_VIEW\\'.

This is simple query on a view in the DB2 database: Select ID_PROJ_TCKT from PROJ_TCKT_DATA_VIEW
What am I doing wrong?

Discussion posts and replies are publicly visible

0 pavithrac over 9 years ago

Hi maheshp, refer this post...it is based on ARV's that may not be supported error
forum.appian.com/.../e-193045
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavithrac over 9 years ago

Another post related to similar error
forum.appian.com/.../f-179450
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 maheshp460
Certified Associate Developer
over 9 years ago

Hello pavithrac, I will have alias defined for the view and try again. Thanks for your input.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 9 years ago

Hi Mahesh, could you please try to fully qualify your table or check if your Appian user has privileges on the object.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 maheshp460
Certified Associate Developer
over 9 years ago

Fully qualifying the view name helped. Thanks for the help folks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel