cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1349
Views
5
Helpful
7
Replies

DB lookup fails (SQL 2005 and ICM 8.0 version)

Deep46
Beginner
Beginner

Hi all,

I am trying to create a script where i need to do a DB look up . I used Call tracer to validate the script , but I am getting an error " Script table currently not available" . Please let me know what would be the reason for this error.

Regards,

Deepak

7 Replies 7

david.macias
VIP Advocate VIP Advocate
VIP Advocate

Can you post a screen shot of your script, the error, and your db lookup configuration?  I've never heard of the error you're referring.

david

gall00004
Beginner
Beginner

Have you created the DB user with read access on the DB?  Once created there, configure the registry entry:

HKEY_LOCAL_MACHINE/Software/CISCO Systems Inc./ICM//RouterX/Router/CurrentVersion/Configuration/Database

The value should be:
\\servername\database_name=(user, password)

If you've done both of these, cycle the dbworker process and it should be able to connect.

The other thing that just came to mind was to be sure TCP/IP is enabled on your SQL Server.  By default it is disabled.

Hi Nathan,

Thanks for your reply.

The reason was that during set up "Database routing" was not checked(enabled). Then after enabling it , it worked fine.

Thanks,

Deepak

Where did you find the "Database routing" checkbox that showed it was disabled?

In the router setup.

Cycling dbworker process worked for me. Thanks
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: