UCCE 8.5.4 - DB node failing - Script table not available

[cherilynn1030]

Good afternoon all.

UCCE 8.5.4 w/ CVP.  Micro-apps only.

What we are trying to accomplish is a DB dip for callers we wish to block from getting through to the client.  (obscene callers, predictive dialers, fax machines, etc.)   The list is about 300 numbers long, so we are making a DB on another server.  I'm currently testing the DB dip by making a table on the HDS right now, just to do a proof of concept.  However, the node is failing, stating in call tracer - script table not available.

I have done the following troubleshooting:

DBworker process is running and connecting. 

on Routers, the username and password has been added to the registry.

I have set up the table name TempAniBlock, column name Phone (as the primary key) using VarChar(50) as the type.

I can't figure out what else to do to make this connect.

Has anyone successfully done this on the HDS?  or any other server?

Many thanks in advance!

[jpsweeney77]

Does the user account you specified in the registry have at least read access to the new lookup table you created?

[cherilynn1030]

Yes it does.

[jpsweeney77]

Are you seeing activity in the dbworker log when you run call tracer? Any additional info there?

[cherilynn1030]

I am not.  the only thing I see is the following:

msgGetUpdateCCLockReply received.

that's repeated.

[jpsweeney77]

Can you upload a screenshot the following?

* db lookup in config (script table)

* registry entry for sql login (blackout password)

* contents of db lookup node in script

* screenshot of table contents in DB. Just enough to see the structure and at least one row

* screenshot of table definition

* confirm that named pipes is enabled although since it's an HDS it would have to be.

Note: Define all integer fields in tables accessed by a DBLookup node as NOT NULL.

Only the following data types are supported for SQL databases: SQLINT1 (tinyint),

SQLINT2 (smallint), SQLINT4 (int), SQLCHAR (char), SQLVARCHAR (varchar),

SQLFLT4DBFLT4 (real), SQLFLT8DBFLT8 (float), and SQLDATETIME (datetime).

All fields except SQLDATETIME, SQLVARCHAR, and SQLCHAR must be defined as

NOT NULL fields. These three fields can be defined as NULL.

[cherilynn1030]

okay, I'm a little farther.   Got my username corrected, as that wasn't quite right.

but here's where I'm at.  from the DBW log:

20:42:05:592 ra-dbw Trace: Action=4 type=0 count=0
20:42:05:593 ra-dbw Trace: Action=3 type=126 count=1
20:42:05:593 ra-dbw Trace: Action=5 type=0 count=0
20:42:05:593 ra-dbw Trace: Transaction complete.
20:42:05:593 ra-dbw Update of ScriptTable complete. TempAniBlock (5000).
20:42:05:593 ra-dbw Trace: Invalid pathname for TempAniBlock: usmav-icmhdsa
20:42:05:593 ra-dbw Trace: Handling delete for ScriptTable 5000 (ScriptTableInfo::QueueUpdate (BadPath))
20:42:05:593 ra-dbw Trace: ScriptTable tempCheri.dbo.TempAniBlock (ID 5000) disconnected.

from the registry:

\\usmav-icmhdsa\testCheri=(ANIBLOCK,xxxxxx)

[jpsweeney77 · Accepted solution]

Config Manager is the first problem (maybe only problem).. format should be as follows.

\\server\database.tablename

Assuming the following

Server = usmav-icmhdsa

Database = xxxx_hds

Table = testCheri

UserName = ANIBLOCK

your SideA and SideB definition should be

\\usmav-icmhdsa\xxxx_hds.testCheri

Substitute your instance name for xxxx on the HDS db name.

[jpsweeney77]

And assuming assumptions above are correct your registry should be

\\usmav-icmhdsa\xxx_hds=(ANIBLOCK,xxxxxx)

\\server\database=(sql login/sql password)

[cherilynn1030]

YOU ROCK!  

this worked.    thank you SO very much!