Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

UCCX 7.0 SQL Query: Rows Returned = 0

Hello,

I haven't done a db dip in UCCX for a while. I've the following setup for initial testing and I'm getting:

Number of rows returned: 0 [from the DB Read step Test Button]

When I look at this table via Microsoft Ent Manager there's plenty of rows in the table. When I fire the reactive debugger up the script drops down to the SQL Error from the DB Read Step.

Datasource Name: dsn_cra

User Name: CRSAdministrator

General:

DB Resource Name: getAreaCode

Data Source Name: dsn_cra

Timeout: 7

Field Selection:

SELECT *

FROM AgentConnectionDetail

Any help appreciated.

2 REPLIES
New Member

Re: UCCX 7.0 SQL Query: Rows Returned = 0

Hello micandre:

I have the same problem than you, the ODBC connection is configured ok, from the SQL Query Analyzer y get plenty of rows, but from the script i get Number of rows returned: 0.

Did you solve the problem? how? could you post it?

Thank you, Best Regards.

New Member

Re: UCCX 7.0 SQL Query: Rows Returned = 0

The UCCX 7 SQL DB is in windows only authentication mode by default. If you are using a local SQL user you have to enable mixed mode authentication by right clicking on the server in enterprise manager and going to properties, then the security tab. Cisco does not recommend this however, it should let your query go through. Otherwise use a windows user in the dsn to access the info.

482
Views
0
Helpful
2
Replies
CreatePlease to create content