Where the configitem data stored

Moderator: crythias

Post Reply
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Where the configitem data stored

Post by yuri0001 »

Good day!

Something broke. When I try to add a new configitem an error on the screen Can't use an undefined value as a HASH reference at / opt / otrs / / Kernel / System / ITSMConfigItem.pm line 1044. and in the system log (Class not found in database!) actually it is, but the record is created.

In addition, the table configitem 28 records in OTRS can only see 25. All manipulations are carried out only through OTRS.

I'm trying to find the error and I suddenly realized that I do not see where it stores the data directly to CI?
general_catalog - contains a list of classes
configitem - units numbers, class and status -
configitem_counter - count units into classes
configitem_definition - describe the structure of storage units according to the classes and their versions
configitem_history - content changes
configitem_history_type - the types of changes
configitem_version - the current version number of units

Question-and where is the data itself? At one table? What the name jf this table and how to find data there? :(
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
ferrosti
Znuny superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
Znuny Version: 3.0
Location: Hamburg, Germany

Re: Where the configitem data stored

Post by ferrosti »

AFAIR one can find it in
xml_storage
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: Where the configitem data stored

Post by yuri0001 »

Thanks!I understood!
And as to understand how it works? There's a lot of records creates while creation of one configitem. Few records with ITSM::ConfigItem::Archiv::180 (as an example xml_type) and then Few records with ITSM::ConfigItem::180
Can I read somewhere?
I can't found an error which described in first post. OTRS not displayed 3 records of configitems from 28 and displayes the error when i try to add new configitem in any class. All classes presents in database general_catalog :(
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
ferrosti
Znuny superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
Znuny Version: 3.0
Location: Hamburg, Germany

Re: Where the configitem data stored

Post by ferrosti »

I am sorry, there is no technical documentation that I know. I had to find out by reverse enginering it.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
Post Reply