500 Internal Server Error At CI Creation

Moderator: crythias

Post Reply
CesarRomario
Znuny newbie
Posts: 31
Joined: 12 Aug 2016, 17:08
Znuny Version: <5.0.6
Real Name: Cesar Romario Delgado Gonzalez
Company: Softtek
Location: Aguascalientes, México

500 Internal Server Error At CI Creation

Post by CesarRomario »

Hi evryone.

I´m using de CMDB en OTRS 5.0.22.

The problem is: when I create a Config item I get the error: 500 Internal Server Error, but if I check the overview of the CI´s the Ci is correctly uploaded.

This is the same if I use the import funtion, but only 1 CI is uploaded by time, I mean, if I have a file with 5 CI´s, i have to reload the error page 5 times, until all the file is uploaded.

Someone can help me with this?, I need to use Import funtion and reload the page everytime I need it, obviously is not an option.

Thank You.
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: 500 Internal Server Error At CI Creation

Post by root »

Hi,

There will be an entry created in the error_log of your web server, and also the OTRS log. Any detail would help.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
CesarRomario
Znuny newbie
Posts: 31
Joined: 12 Aug 2016, 17:08
Znuny Version: <5.0.6
Real Name: Cesar Romario Delgado Gonzalez
Company: Softtek
Location: Aguascalientes, México

Re: 500 Internal Server Error At CI Creation

Post by CesarRomario »

I found this on server:

These logs were created when i tried to use import.
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare][Line:243]: General catalog looku$
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave][Line:1054]: Can't import entity 1:$
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare][Line:243]: General catalog looku$
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave][Line:1054]: Can't import entity 2:$
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare][Line:243]: General catalog looku$
Oct 18 10:46:25 VBPDCDBSOT01 OTRS-CGI-08[1407]: [Error][Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave][Line:1054]: Can't import entity 3:$




Also these Logs appear sometimes

Oct 18 10:55:17 VBPDCDBSOT01 journal: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-08[28611]: [Error][Kernel::System::FetchM$
Oct 18 10:55:17 VBPDCDBSOT01 journal: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-08[28611]: [Error][Kernel::System::Daemon$
Oct 18 10:55:17 VBPDCDBSOT01 journal: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-08[28611]: [Error][Kernel::System::Email:$
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: 500 Internal Server Error At CI Creation

Post by root »

Hi,

both logs does not look like a web server error log. check /var/log/httpd or /var/log/apache2

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
CesarRomario
Znuny newbie
Posts: 31
Joined: 12 Aug 2016, 17:08
Znuny Version: <5.0.6
Real Name: Cesar Romario Delgado Gonzalez
Company: Softtek
Location: Aguascalientes, México

Re: 500 Internal Server Error At CI Creation

Post by CesarRomario »

Hi

I Thanks for your patience.

I found this:

Code: Select all

ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: General catalog lookup of'' failed!

 RemoteAddress: 10.20.253.22
 RequestURI: /otrs/index.pl

 Traceback (1407):
   Module: Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare Line: 243
   Module: Kernel::System::ITSMConfigItem::XML::XMLImportValuePrepare Line: 240
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::_ImportXMLDataMerge Line: 1629
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave Line: 1045
   Module: Kernel::System::ImportExport::Import Line: 2287
   Module: Kernel::Modules::AdminImportExport::Run Line: 1117
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1055
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32
   
ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: Can't import entity 1: Could not prepare the input!

 RemoteAddress: 10.20.253.22
 RequestURI: /otrs/index.pl

 Traceback (1407):
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave Line: 1054
   Module: Kernel::System::ImportExport::Import Line: 2287
   Module: Kernel::Modules::AdminImportExport::Run Line: 1117
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1055
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32
   
ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: General catalog lookup of'' failed!

 RemoteAddress: 10.20.253.22
 RequestURI: /otrs/index.pl

 Traceback (1407):
   Module: Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare Line: 243
   Module: Kernel::System::ITSMConfigItem::XML::XMLImportValuePrepare Line: 240
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::_ImportXMLDataMerge Line: 1629
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave Line: 1045
   Module: Kernel::System::ImportExport::Import Line: 2287
   Module: Kernel::Modules::AdminImportExport::Run Line: 1117
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1055
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32

ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: Can't import entity 2: Could not prepare the input!

 RemoteAddress: 10.20.253.22
 RequestURI: /otrs/index.pl

 Traceback (1407):
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave Line: 1054
   Module: Kernel::System::ImportExport::Import Line: 2287
   Module: Kernel::Modules::AdminImportExport::Run Line: 1117
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1055
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32

ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: General catalog lookup of'' failed!

 RemoteAddress: 10.20.253.22
 RequestURI: /otrs/index.pl

 Traceback (1407):
   Module: Kernel::System::ITSMConfigItem::XML::Type::GeneralCatalog::ImportValuePrepare Line: 243
   Module: Kernel::System::ITSMConfigItem::XML::XMLImportValuePrepare Line: 240
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::_ImportXMLDataMerge Line: 1629
   Module: Kernel::System::ImportExport::ObjectBackend::ITSMConfigItem::ImportDataSave Line: 1045
   Module: Kernel::System::ImportExport::Import Line: 2287
   Module: Kernel::Modules::AdminImportExport::Run Line: 1117
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1055
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32

ERROR: OTRS-CGI-08 Perl: 5.16.3 OS: linux Time: Wed Oct 18 10:46:25 2017

 Message: Can't import entity 3: Could not prepare the input!
Regards.
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: 500 Internal Server Error At CI Creation

Post by nedmaj »

Hi,

That message is saying you are trying to import a field value that doesn't exist in your General Catalog, or maybe a required field with no value at all.

Verify the data you are trying to import, you CI class definition and compare it to you catalog.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Post Reply