Answered

rollback not allowed - connection not found

I am trying to connect Bizagi to a MS SQL Server. My database is quite simple, however there is always the same error screen showing up when setting SQL as the replicated entitiy ...

Best Answer
photo

Dear Paul,

When setting Replication or Virtualization through the Wizard (that is, when using the default components and Classes for Replication or Virtualization provided by Bizagi), Bizagi will support the mapping of attributes to a comprehensive set of supported data types. The following information lists the supported data types when using Bizagi's native integration to external SQL Server or Oracle databases. The tables below shows the column mappings from the data source to Bizagi when using Replication or Virtualization. The first column displays the source data types, and the second column presents the equivalent data type in Bizagi, if supported. Enter to the following link to know supported data type: data_type_support.htm

Regards

photo
0

Dear Paul,

When setting Replication or Virtualization through the Wizard (that is, when using the default components and Classes for Replication or Virtualization provided by Bizagi), Bizagi will support the mapping of attributes to a comprehensive set of supported data types. The following information lists the supported data types when using Bizagi's native integration to external SQL Server or Oracle databases. The tables below shows the column mappings from the data source to Bizagi when using Replication or Virtualization. The first column displays the source data types, and the second column presents the equivalent data type in Bizagi, if supported. Enter to the following link to know supported data type: data_type_support.htm

Regards

photo
0

Hi Juan,

thanks for your answer. However, i've already used this table a couple of times and still don't understand why it is not working ...

photo
0

Dear Paul,

Please send us the structure of the remote table.

Thank you in advance

photo
0

Juan Zuluaga wrote:

Dear Paul,

Please send us the structure of the remote table.

Thank you in advance

Hi Juan,

I'm not sure if my table has a structure yet ... it has only one column with two entries, like in the picture attached

photo
0

Dear Paul,

Thank you for your feedback. We would like to know if you have enough rights to access to the table and data in both database: Local and remote.

Thank you in advance

photo
0

Juan Zuluaga wrote:

Dear Paul,

Thank you for your feedback. We would like to know if you have enough rights to access to the table and data in both database: Local and remote.

Thank you in advance

Hi,

yes, I am the owner of the whole server, so I have full access and rights for the database server (using the sa-account) and all tables

Greetings

Paul

photo
0

Dear Paul,

A member of our support team will contact you to obtain a backup of your project to reproduce it in our labs.

Regards