autortoute

[tservice]

I am unable to add an autotoute rule. When I create the rule, I get error "Error adding routing entity for ANY: field 'pattern' doesn't have a default value. Version 6.5.1

I have made sure my entries was correct, however I cannot add this rule.
Thanks

[pacsone]

Can you post the criteria for the routing rule you were trying to add? e.g. , are you routing by Source AE Title, by Key Attribute, etc? Or better yet, can you post the screenshot of the Add Routing Rule window which contains all of the settings for the rule you were trying to add?

[tservice]

Here is the screen shot.
Thanks

[pacsone]

1. What's the version of MySQL running on this server?

2. Can you open a local command shell and login to the PacsOne Server database as the Administrator ("root")? e.g.,

C:\Program Files\MySQL\bin>mysql.exe -u root -p $database

where $database is the name of the MySQL database assigned to PacsOne Server.

Then run the following SQL query from the MySQL shell prompt:

Code: Select all

mysql>describe autoroute;

and post the output from the above command here.

[tservice]

1) version .7.11
2)Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\>C:\wamp64\bin\mysql\mysql5.7.11\bin\mysql.exe -u root -p VISITINGPACS
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 261
Server version: 5.7.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> describe autoroute;
+---------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| source | varchar(16) | NO | PRI | NULL | |
| keytag | int(10) unsigned | NO | PRI | 0 | |
| pattern | varchar(255) | NO | PRI | NULL | |
| destination | varchar(16) | NO | PRI | NULL | |
| schedule | smallint(6) | NO | PRI | -1 | |
| autopurge | tinyint(1) | NO | | 0 | |
| window | int(10) unsigned | NO | PRI | 0 | |
| enabled | tinyint(1) | NO | | 1 | |
| fetchmore | smallint(6) | YES | | 0 | |
| weekday | int(10) unsigned | NO | PRI | 127 | |
| delayedstudy | float | YES | | 0 | |
| delayedseries | float | YES | | 0 | |
| destfolder | varchar(255) | YES | | NULL | |
| sendingaet | varchar(16) | YES | | NULL | |
| retryinterval | tinyint(3) unsigned | YES | | 0 | |
| priority | smallint(6) | NO | | 0 | |
| xfersyntax | varchar(64) | YES | | NULL | |
+---------------+---------------------+------+-----+---------+-------+
17 rows in set (0.00 sec)

mysql>

[pacsone]

The MySQL error seems odd because the 'field' column of the AUTOROUTE table does have a default value which is NULL, according to the output of the MySQL DESCRIBE command above.

In any case, can you try running the following SQL query from the MySQL shell prompt (follow the same steps before)?

Code: Select all

mysql>alter table autoroute modify pattern VARCHAR(255) DEFAULT '';

Then try adding the same route entry in the "Auto Route" page and see if you get the same error or not.

[tservice]

That has fixed my issue. Thank you very much.