- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 12:29 PM - edited 03-14-2019 11:51 AM
I am incorporating database routing in our scripts and am getting an error "script table currently not available". Database routing is enabled so I am not sure what is causing this error. Has anyone troubleshooted this error before? If so, what was the resolution
Thanks for any feedback.
Solved! Go to Solution.
- Labels:
-
Other Contact Center
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 01:03 PM
Hi Pam,
Have you configured the Database details in the Database Explorer in the Admin workstation ?
Please cross verify the credentials as well. Post the dbworker logs from RTR
Regards,
Senthil

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 01:03 PM
Hi Pam,
Have you configured the Database details in the Database Explorer in the Admin workstation ?
Please cross verify the credentials as well. Post the dbworker logs from RTR
Regards,
Senthil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 02:18 PM
Yes. This is what I have.
Database lookup: Script Table
Name dim_rewards_phone_num
Access type SQL
Side A: \\ARMMARIOSQL2\CEIDB.dim_rewards_phone_num
Side B: \\ARMMARIOSQL2\CEIDB.dim_rewards_phone_num
Database lookup: Script table column
Column name ods_customer_id
second tab for column
Column name phone_number_txt
Here is what each stands for:
Database: CEIDB
Table: dim_rewards_phone_num
Column name: ods_customer_id
Column name: phone_number_txt
I will check on the dbworker logs as well and post what I find.
Thanks!
Pam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 02:59 PM
Here is the log.
15:55:52:334 ra-dbw Trace: Internal connect for ARMMARIOSQL2,CEIDB,dim_rewards_phone_num
15:55:52:788 ra-dbw Trace: 'id' is column 2 in sysobjects.
15:55:52:788 ra-dbw Trace: ID for table dim_rewards_phone_num is 2073058421
15:55:52:847 ra-dbw Trace: Columns for dim_rewards_phone_num:
15:55:52:847 ra-dbw Trace: Column 1: rewPhNumKey, type=38, length=4
15:55:52:847 ra-dbw Trace: Column 2: phone_number_txt, type=39, length=16
15:55:52:847 ra-dbw Trace: Column 3: ods_customer_id, type=108, length=8
15:55:52:847 ra-dbw Trace: Column 4: modDt_ts, type=111, length=8
15:55:52:867 ra-dbw Trace: No primary key for dim_rewards_phone_num found.
15:55:52:867 ra-dbw Trace: Unable to get table info for ARMMARIOSQL2,CEIDB,dim_rewards_phone_num
15:55:52:884 ra-dbw Trace: ScriptTable dim_rewards_phone_num (ID 5014) disconnected.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2013 09:06 PM
It tells there is "No Primary Key" for the table dim_rewards_phone_num.
Can you check that part from the table and if you have a primary key in the table what is the datatype you have set for that field ?
Regards,
Senthil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2013 01:28 PM
thank you so much for your help! I am successfully getting data.
I am trying to adapt variable 5 to deliver the ani and the guest loyalty number but have not been able to do this successfully.
I have been told to use a concatenate formula and have tried this.
We are already delivering the ani to CTI but need to adapt the formula to send both using variable 5.
Any thoughts?
Thanks!
