Database Routing

[Users2013]

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.

[Senthil Kumar Sankar · Accepted solution]

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

[Users2013]

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

[Users2013]

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.

[Senthil Kumar Sankar]

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

[Users2013]

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!