DB lookup fails (SQL 2005 and ICM 8.0 version)

[Deep46]

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

[david.macias]

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]

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.

[gall00004]

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.

[Deep46]

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

[Larissa Dassow]

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

[bill.king]

In the router setup.

[IPCC Support]

Cycling dbworker process worked for me. Thanks