CMDBuild Forum

Task manager - connector and History

Old Versions
#1

Hello,

 

I'm using the connector (in the task manager). The connector (ocsinventoty to cmdbuild) update all informations on my servers.

The task is running everyday. But i just saw something. When the task start (everyday at 12pm), i have a new line on "History" for every cards. Even if the connector update nothing. (no green line in the history).

So after one year of running i will have 365 lines for... nothing at all :-)

Is-it possible to fix it ?

Thank you

 

Have a good week end

#2

This was an error found some months ago and then had been fixed.
Which CMDBuild version are you using?
CMDBuild Team

#3
Hello, 
 
i'm using the 2.2.2 (i'm waiting the 2.3.1)
 
 
 
Previously Tecnoteca wrote:
This was an error found some months ago and then had been fixed.
Which CMDBuild version are you using?
CMDBuild Team

 

#4
By the way, i just tried on my development with the version 2.3 of cmdbuild and i have the problem too.
 
Previously Tecnoteca wrote:
This was an error found some months ago and then had been fixed.
Which CMDBuild version are you using?
CMDBuild Team

 

#5

Ok, we will check.

CMDBuild Team

#6
Perfect, keep me updated :-)
 
Have a good week end
 
Previously Tecnoteca wrote:

Ok, we will check.

CMDBuild Team

 

#7
Do you have any news about this topic ?
 
Thank you.
 
Previously Quentinv wrote:
Perfect, keep me updated :-)
 
Have a good week end
 
Previously Tecnoteca wrote:

Ok, we will check.

CMDBuild Team

 

 

#8

Unfortunately we were not able to enter this fix in version 2.3.1, which will be released this week.
We had to work on lot of features and we did not have enough time.
We moved this activity among the things to do for the next release.
CMDBuild Team

#9
Hello, do you have news about this point ? I just saw that the problem is still here in the version 2.3.3.
 
Thank you
 
Previously Tecnoteca wrote:
Unfortunately we were not able to enter this fix in version 2.3.1, which will be released this week.
We had to work on lot of features and we did not have enough time.
We moved this activity among the things to do for the next release.
CMDBuild Team

 

#10
Up, any news about this point ? :-)
#11
Dear Quentinv,
 
after a fix we are no more able to reproduce the error. Could you explain better your situation? The records have reference attributes and are you using description for them? Are there lookup too?
 
Best regards.
 
-- CMDBuild Team

Previously Quentinv wrote:
Up, any news about this point ? :-)

 

#12

Hello,

 
I just created a new cmdbuild instance (version 2.3.3)
 
I created a new class (cmdbuild_forum) with just :
 
  •  Code 
  •  Description
 
I added : 
 
code               description
  1                   description_1
  2                   description_2
  3                   description_3
 
(screenshot : http://postimg.org/image/fnn0cew5h/)
 
I created a mysql database with a table cmdbuild_forum :

  • Id
  • Description
I added : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   description_3
 
(screenshot : http://postimg.org/image/ks1i04zpz)
 
Then i created in task manager a connector that will update the class in cmdbuild (the task will work every minutes).
 
(screenshot : http://postimg.org/image/y4gktbdd1)
 
Then I start my connector and I wait one minute. 
 
After this, perfect my data is updated on cmdbuild ! 
 
(screenshot : http://postimg.org/image/cmusw3f8v)

If I go on the card "2" "description_2", in the history i can see that i don't have anything because the connector didn't update it, so it's normal. ( I admit I didn't expect this at all, so i'll continue my post ;-) )
 
I tried to add a lookup, i added a new attribute type lookup in cmdbuild_forum class and i added the lookup data in my mysql database.
 
It works too.
 
But I just found the problem by doing this post :-) .

If i have an empty attribute in my mysql database, i can see in history the ligne every minute without update.
 
Example : 
 
Mysql Database : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   
 
The description for the Id "3" is empty
 
I started the connector, and then in the cards 3, in history, i have an empty line every minute even if nothing changed in the cards (I have it for every type (lookup, string input, reference, ...).)
 
 
 
Screenshot History  : http://postimg.org/image/5ts3n7p0l/
Screenshot History Details : http://postimg.org/image/zay7sti0z/
 
This is a big problem for us. For example some ligne from ocs inventory database are empty, and our connector is working every hour, so every hour we have an empty line in history even if nothing changed.
 
I hope it can help
 
 
 
 
 
#13
Dear Quentinv,
 
the bug has been fixed. The fix will be available in the upcoming release.
 
Best regards.
 
-- CMDBuild Team

Previously Quentinv wrote:
Hello,
 
I just created a new cmdbuild instance (version 2.3.3)
 
I created a new class (cmdbuild_forum) with just :
 
  •  Code 
  •  Description
 
I added : 
 
code               description
  1                   description_1
  2                   description_2
  3                   description_3
 
(screenshot : http://postimg.org/image/fnn0cew5h/)
 
I created a mysql database with a table cmdbuild_forum :

  • Id
  • Description
I added : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   description_3
 
(screenshot : http://postimg.org/image/ks1i04zpz)
 
Then i created in task manager a connector that will update the class in cmdbuild (the task will work every minutes).
 
(screenshot : http://postimg.org/image/y4gktbdd1)
 
Then I start my connector and I wait one minute. 
 
After this, perfect my data is updated on cmdbuild ! 
 
(screenshot : http://postimg.org/image/cmusw3f8v)

If I go on the card "2" "description_2", in the history i can see that i don't have anything because the connector didn't update it, so it's normal. ( I admit I didn't expect this at all, so i'll continue my post ;-) )
 
I tried to add a lookup, i added a new attribute type lookup in cmdbuild_forum class and i added the lookup data in my mysql database.
 
It works too.
 
But I just found the problem by doing this post :-) .

If i have an empty attribute in my mysql database, i can see in history the ligne every minute without update.
 
Example : 
 
Mysql Database : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   
 
The description for the Id "3" is empty
 
I started the connector, and then in the cards 3, in history, i have an empty line every minute even if nothing changed in the cards (I have it for every type (lookup, string input, reference, ...).)
 
 
 
Screenshot History  : http://postimg.org/image/5ts3n7p0l/
Screenshot History Details : http://postimg.org/image/zay7sti0z/
 
This is a big problem for us. For example some ligne from ocs inventory database are empty, and our connector is working every hour, so every hour we have an empty line in history even if nothing changed.
 
I hope it can help
 
 
 
 
 

 

#14
Perfect, thank you ! 
 
Previously Tecnoteca wrote:
Dear Quentinv,
 
the bug has been fixed. The fix will be available in the upcoming release.
 
Best regards.
 
-- CMDBuild Team

Previously Quentinv wrote:
Hello,
 
I just created a new cmdbuild instance (version 2.3.3)
 
I created a new class (cmdbuild_forum) with just :
 
  •  Code 
  •  Description
 
I added : 
 
code               description
  1                   description_1
  2                   description_2
  3                   description_3
 
 
I created a mysql database with a table cmdbuild_forum :

  • Id
  • Description
I added : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   description_3
 
 
Then i created in task manager a connector that will update the class in cmdbuild (the task will work every minutes).
 
 
Then I start my connector and I wait one minute. 
 
After this, perfect my data is updated on cmdbuild ! 
 

If I go on the card "2" "description_2", in the history i can see that i don't have anything because the connector didn't update it, so it's normal. ( I admit I didn't expect this at all, so i'll continue my post ;-) )
 
I tried to add a lookup, i added a new attribute type lookup in cmdbuild_forum class and i added the lookup data in my mysql database.
 
It works too.
 
But I just found the problem by doing this post :-) .

If i have an empty attribute in my mysql database, i can see in history the ligne every minute without update.
 
Example : 
 
Mysql Database : 
 
  Id                 description
  1                   description_new_1
  2                   description_2
  3                   
 
The description for the Id "3" is empty
 
I started the connector, and then in the cards 3, in history, i have an empty line every minute even if nothing changed in the cards (I have it for every type (lookup, string input, reference, ...).)
 
 
 
Screenshot History  : http://postimg.org/image/5ts3n7p0l/
Screenshot History Details : http://postimg.org/image/zay7sti0z/
 
This is a big problem for us. For example some ligne from ocs inventory database are empty, and our connector is working every hour, so every hour we have an empty line in history even if nothing changed.
 
I hope it can help
 
 
 
 
 

 

 

#15
Hello, 
 
I just tried the version 2.3.4 on my tests server and the problem is still here. I still have a new line on the history card even if nothing changed with the connector.
 
Do you have any informations ? 
 
Previously Quentin Varquet wrote:
Perfect, thank you ! 
 
Previously Tecnoteca wrote:
Dear Quentinv,
 
the bug has been fixed. The fix will be available in the upcoming release.
 
Best regards.
 
-- CMDBuild Team
 
#16
Dear Quentin Varquet,
 
we've tested again using a record that, excluding the key column, contains three synchronizable columns containing respectively NULL, EMPTY and WHITESPACES values. The task has been run more times but it wrote the card only once.
 
-- CMDBuild Team    

Previously Quentin Varquet wrote:
Hello, 
 
I just tried the version 2.3.4 on my tests server and the problem is still here. I still have a new line on the history card even if nothing changed with the connector.
 
Do you have any informations ? 
 
Previously Quentin Varquet wrote:
Perfect, thank you ! 
 
Previously Tecnoteca wrote:
Dear Quentinv,
 
the bug has been fixed. The fix will be available in the upcoming release.
 
Best regards.
 
-- CMDBuild Team
 

 

#17

Hello, 

 
I found the problem. 
 
Before, it was when we had an empty input.
 
Right now, ( I guess I don't have luck ) the problem is also when the type of the column is an INTEGER or DOUBLE.
 
For example in CMDBUILD I have  :
First Class in cmdbuild
 
Column          Type
Memory          Integer
 
Mysql :
 
Column          Type
Memory          Double
 
 
Second Class in cmdbuild :
 
Column          Type
Latitude          Double
 
Mysql :
 
Column          Type
Latitude          Varchar (don't ask me why, I don't remember why we put a varchar here :-))
 
The connector will create a line everytime even if we don't have any change for these two classes with columns type Integer or Double.
 
 
#18

" The connector will create a line everytime " 

 
I mean in the history tab :-)
#19
The answer is very simple: they are different data types despite their values seems the same. When the value is written the fist time on database, PostgreSQL guesses the type for memorization. Later when the values are compared, since they are of different types, they will be treated as different with no assumptions on some possible adaptations/transformations. So the solution is to make the types the same.
 
-- CMDBuild Team
 
Previously Quentin Varquet wrote:
Hello, 
 
I found the problem. 
 
Before, it was when we had an empty input.
 
Right now, ( I guess I don't have luck ) the problem is also when the type of the column is an INTEGER or DOUBLE.
 
For example in CMDBUILD I have  :
First Class in cmdbuild
 
Column          Type
Memory          Integer
 
Mysql :
 
Column          Type
Memory          Double
 
 
Second Class in cmdbuild :
 
Column          Type
Latitude          Double
 
Mysql :
 
Column          Type
Latitude          Varchar (don't ask me why, I don't remember why we put a varchar here :-))
 
The connector will create a line everytime even if we don't have any change for these two classes with columns type Integer or Double.
 
 

 

#20

"  So the solution is to make the types the same. "

 
You are totally right !
 
I even don't know why the type are not the same.
 
Thank you for your time