cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

1318
Views
0
Helpful
9
Replies
Highlighted
Beginner

UCCE 8.5.4 - DB node failing - Script table not available

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Enthusiast

Re: UCCE 8.5.4 - DB node failing - Script table not available

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.

View solution in original post

9 REPLIES 9
Enthusiast

UCCE 8.5.4 - DB node failing - Script table not available

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

Beginner

UCCE 8.5.4 - DB node failing - Script table not available

Yes it does.

Enthusiast

UCCE 8.5.4 - DB node failing - Script table not available

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

Beginner

UCCE 8.5.4 - DB node failing - Script table not available

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

msgGetUpdateCCLockReply received.

that's repeated.

Enthusiast

UCCE 8.5.4 - DB node failing - Script table not available

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.

Beginner

UCCE 8.5.4 - DB node failing - Script table not available

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)

Enthusiast

Re: UCCE 8.5.4 - DB node failing - Script table not available

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.

View solution in original post

Enthusiast

Re: UCCE 8.5.4 - DB node failing - Script table not available

And assuming assumptions above are correct your registry should be

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

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

Beginner

UCCE 8.5.4 - DB node failing - Script table not available

YOU ROCK!  

this worked.    thank you SO very much!

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here