Products Products
Support & Forums Support & Forums
Compliance Testing Compliance Testing
Labs & Sandboxes Labs & Sandboxes
Program Program
Co-Marketing Co-Marketing
Avaya Experience Platform Avaya Enterprise Cloud Avaya Client SDK Avaya Aura Platform See All Products Find Developer Resources

Avaya Experience Platform

Overview Interfaces Learning Support Options Compliance Testing

Avaya Enterprise Cloud

Overview Interfaces Learning Support Options Compliance Testing

Avaya Client SDK

Overview Programming Docs Developer Downloads Licensing Support & Testing

Avaya Aura Platform

Application Enablement Services Communication Manager Presence Services Snap-in Session Manager System Manager Session Border Controller
About DevConnect Support Submit Support Tickets Support Forums Other Support Options

About DevConnect Support

Support Options Support FAQs Supported Platforms and Interfaces

Submit Support Tickets

Procured System Support
For procurement issues or questions Remote Lab Support
For issues and questions related to DevConnect remote labs Membership & Program Support
For membership and program benefits questions General Support
For general issues not covered by the other support tickets

Support Forums

Avaya Client SDK AEServices DMCC APIs AEServices JTAPI AEServices Web Services Avaya Workspaces Avaya Experience Platform Orchestration Designer All Forums

Other Support Options

Product Notices Non-DevConnect Support Resources

Compliance Testing

About Compliance Testing Compliance Tested Solutions

About Compliance Testing

Compliance Testing Overview Avaya Interfaces Eligible For Testing Compliance Testing FAQs Compliance Testing Guide(s) (PDF)

Compliance Tested Solutions

DevConnect Marketplace Search Applications Notes

Labs & Sandboxes

Remote Labs Procurement Benefits

Remote Labs

Remote Labs Overview Avaya Aura Session Manager Avaya Aura AE Services & Communication Manager Self Services (Experience Portal) Avaya Proactive Outreach Manager Avaya Contact Center Elite

Procurement Benefits

About DevConnect Procurement Access/View Procurement Catalog Procurement FAQs DevConnect Procured System Support

Program

Program Overview Program Benefits Membership Options

Program Overview

DevConnect Membership Levels DevConnect Program Guide (PDF) DevConnect Program FAQs

Program Benefits

Membership Benefits DevConnect Procurement Co-marketing

Membership Options

Manage My Portfolio/Solutions Manage My Profile

Co-Marketing

Co-Marketing Benefits Relationship Benefits

Co-Marketing Benefits

Co-Marketing Overview Logos Marketplace Co-branded Collateral Select Product Program

Relationship Benefits

Social Media 8-and-Out Podcasts Sponsorships Advertising

Author Message
22/04/2021 11:18:12
Subject: Engagement Designer 3.8 - Read From DB issue
#1
MarcusHuang
Joined: Feb 25, 2014
Messages: 157
Offline
Hi,

I am running into an issue where i just want to run a query, select * from dbname.dbtable and i keep getting a warning, "Input Shcema is invalid" If i add a where clause, "where column = ?" i do not get a warning? Is this by design?
PM
03/05/2021 05:57:50
Subject: Re:Engagement Designer 3.8 - Read From DB issue
#2
AnuragAggarwal
Joined: Jun 1, 2014
Messages: 154
Offline
Hi, there seems to be issue using dbname.dbtable

can you please try with just select * from dbtable, and let know if it works or not


we are making a fix for dname.dbtable to work as well for next release of ED
PM
13/05/2021 04:32:16
Subject: Re:Engagement Designer 3.8 - Read From DB issue
#3
AnuragAggarwal
Joined: Jun 1, 2014
Messages: 154
Offline
no, i was incorrect

we tested and seems dbname.dbtable is working as well

we are able to get input schema in designer and are able to run instance as well

Can you please share your ED logs (debug level)

Also can you please confirm that your db is setup correctly with schemas/tables/permissions
PM
Go to:   
Mobile view