CMDBuild Forum

Connector issues

Old Versions
#1

Hello,

 

i am having problems with the connectors from the entities, which have Timestamp and Date attributes.

My connectors are updating every 2 minutes and everytime I get a new line, even when nothing has changed.

When the connectors are not considering the Timestamp and Date attributes then I have no problem, the entity is updated only once (as desired).

Do you have any idea what's happening here? Is regarding the format which I am using (I tried in differents formats and I still have the problem)?

Thanks in advance!!

 

 

#2
Hello,
 
For me, it also happen with Integer attribute.
 
Is there any guidance for converting data type from different data source, eg. Oracle or MySQL?
 
Thank you..
 
 
Previously tr wrote:

Hello,

 

i am having problems with the connectors from the entities, which have Timestamp and Date attributes.

My connectors are updating every 2 minutes and everytime I get a new line, even when nothing has changed.

When the connectors are not considering the Timestamp and Date attributes then I have no problem, the entity is updated only once (as desired).

Do you have any idea what's happening here? Is regarding the format which I am using (I tried in differents formats and I still have the problem)?

Thanks in advance!!

 

 

 

#3
Which version of CMDbuild are you using? Could you give us a way to try to reproduce the issue?
 
Best regards.
 
-- CMDBuild Team
 
Previously Herru Windiarto wrote:
Hello,
 
For me, it also happen with Integer attribute.
 
Is there any guidance for converting data type from different data source, eg. Oracle or MySQL?
 
Thank you..
 
 
Previously tr wrote:

Hello,

 

i am having problems with the connectors from the entities, which have Timestamp and Date attributes.

My connectors are updating every 2 minutes and everytime I get a new line, even when nothing has changed.

When the connectors are not considering the Timestamp and Date attributes then I have no problem, the entity is updated only once (as desired).

Do you have any idea what's happening here? Is regarding the format which I am using (I tried in differents formats and I still have the problem)?

Thanks in advance!!

 

 

 

 

#4
Hello,
 
I'm using 2.3.3 version with Oracle database as external source db.
 
I think the problem is when connector compare the data between CMDBuild and Oracle DB, connector always detect changes for some data type.
 
Regards,
 
Previously Tecnoteca wrote:
Which version of CMDbuild are you using? Could you give us a way to try to reproduce the issue?
 
Best regards.
 
-- CMDBuild Team
 
Previously Herru Windiarto wrote:
Hello,
 
For me, it also happen with Integer attribute.
 
Is there any guidance for converting data type from different data source, eg. Oracle or MySQL?
 
Thank you..
 
 
Previously tr wrote:

Hello,

 

i am having problems with the connectors from the entities, which have Timestamp and Date attributes.

My connectors are updating every 2 minutes and everytime I get a new line, even when nothing has changed.

When the connectors are not considering the Timestamp and Date attributes then I have no problem, the entity is updated only once (as desired).

Do you have any idea what's happening here? Is regarding the format which I am using (I tried in differents formats and I still have the problem)?

Thanks in advance!!

 

 

 

 

 

#5

Hi,

 

i am using 2.3.4 version of CMDBuild with PostgresQL.

Should I use an specific format in order that the connector does not detect changes everytime?

Thanks for your help!!

 

Previously Herru Windiarto wrote:

Hello,
 
I'm using 2.3.3 version with Oracle database as external source db.
 
I think the problem is when connector compare the data between CMDBuild and Oracle DB, connector always detect changes for some data type.
 
Regards,
 
Previously Tecnoteca wrote:
Which version of CMDbuild are you using? Could you give us a way to try to reproduce the issue?
 
Best regards.
 
-- CMDBuild Team
 
Previously Herru Windiarto wrote:
Hello,
 
For me, it also happen with Integer attribute.
 
Is there any guidance for converting data type from different data source, eg. Oracle or MySQL?
 
Thank you..
 
 
Previously tr wrote:

Hello,

 

i am having problems with the connectors from the entities, which have Timestamp and Date attributes.

My connectors are updating every 2 minutes and everytime I get a new line, even when nothing has changed.

When the connectors are not considering the Timestamp and Date attributes then I have no problem, the entity is updated only once (as desired).

Do you have any idea what's happening here? Is regarding the format which I am using (I tried in differents formats and I still have the problem)?

Thanks in advance!!

 

 

 

 

 

 

#6

We will do some tests.

CMDBuild Team

 

 

 

 

 

 

#7

Hello!

any news about this topic?

Thanks in advance

 

 

Previously Tecnoteca wrote:

We will do some tests.

CMDBuild Team

 

 

 

 

 

 

 

#8

Hello,

 
I think you have the same problem as me (solved), look this topic :  http://www.cmdbuild.org/forum/forum-in-english/221206335
#9
Hi Quentin,
 
From that post, the solution is to make the type the same. So, how you can make the type the same? I try using Oracle database as data source, only type String is the same (not creating new history record when no data change). The other type (Integer, Double, Date, etc) are always create new history record, eventhough I use typical data type in Oracle (e.g Integer to Oracle Number, Date to Oracle Date, etc).
 
Thank you.
 
Regards,
Herru
 
 
Previously Quentin Varquet wrote:
Hello,
 
I think you have the same problem as me (solved), look this topic :  http://www.cmdbuild.org/forum/forum-in-english/221206335