# Translator for Sybase Anywhere 12 **URL:** \ **Category:** Ignition\ **Created:** [February 6, 2013, 4:14pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810 "2013-02-06T16:14:24Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Blackcat](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@Blackcat](https://forum.inductiveautomation.com/u/Blackcat)\ **Post date:** [February 6, 2013, 4:14pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/1 "2013-02-06T16:14:24Z")
Hi All, I just made a connection between Ignition and a Sybase database. I chose “Generic” for default translator, connexion is OK but some request creates errors. I think I need to create a new database translator but I can’t find information to create correctly this translator. Someone can help me ? I use SQL Anywhere 12 and Ignition 7.5.5 Thanks ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 16, 2013, 12:59am UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/2 "2013-02-16T00:59:44Z")
Which requests are creating the errors? Are you trying to use transaction groups or the historian? Usually it is best to stay away from features that will automatically create the tables since that relies on the translator. ---
**Author:** ![Blackcat](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@Blackcat](https://forum.inductiveautomation.com/u/Blackcat)\ **Post date:** [February 18, 2013, 8:16am UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/3 "2013-02-18T08:16:34Z")
Finally I created a translator from the Generic translator, i made some modification and for the moment it works good ! But i have an another problem with alert storage, the request send to create the ALERT\_LOG table is : `create table ALERT_LOG( ALERT_LOG_ID integer not null default autoincrement, SYSTEM varchar(255) not null, PATH varchar(255) not null, DISPLAYPATH varchar(255) not null, STATE_NAME varchar(255) not null, STATE_SEVERITY integer not null, ACTIVE_VALUE double not null, ACTIVE_TIMESTAMP datetime not null, CLEARED_VALUE double not null, CLEARED_TIMESTAMP datetime not null, ACK_TIMESTAMP datetime not null, ACK_USER varchar(255) not null, primary key(ALERT_LOG_ID), )` All fields can’t be null or when alert are stored some fields are null. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 20, 2013, 1:22am UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/4 "2013-02-20T01:22:50Z")
In order to use our alert history some of the columns must be NULL. You can need to recreate the table allowing NULLs. ---
**Author:** ![Blackcat](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@Blackcat](https://forum.inductiveautomation.com/u/Blackcat)\ **Post date:** [February 20, 2013, 8:10am UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/5 "2013-02-20T08:10:00Z")
Yes, it’s not a problem to change the table in the database, I dit it and it works. However, I thought Ignition created this table correctly. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 20, 2013, 4:33pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/6 "2013-02-20T16:33:38Z")
Well it does create the table but it uses the translator to do so. You must be specifying NOT NULL in the your translator. ---
**Author:** ![Blackcat](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@Blackcat](https://forum.inductiveautomation.com/u/Blackcat)\ **Post date:** [February 21, 2013, 8:44am UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/7 "2013-02-21T08:44:54Z")
Thank you for your help Travis but I can’t find where I can specify “NOT NULL” in the translator. And how the specification of “NOT NULL” can change the way of Ignition to create the table without the property “NOT NULL” in each fields ? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 22, 2013, 5:26pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/8 "2013-02-22T17:26:24Z")
I am not sure how the NOT NULL go there then. Once you fix the table it should be good forever. ---
**Author:** ![bebel](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bebel](https://forum.inductiveautomation.com/u/bebel)\ **Post date:** [September 11, 2019, 4:58pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/9 "2019-09-11T16:58:48Z")
Is there any way to get help on creating this Translator? I created a forum post 4 weeks ago and it has no responses so I put in a ticket request 3 weeks ago and it has yet to be assigned to anyone. How does one get help for these things? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [September 11, 2019, 5:06pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810/10 "2019-09-11T17:06:48Z")
I’ll ping someone in support and see what’s going on. Might have fallen through the cracks.